import pandas as pd
import requests
import arrow
from collections import deque
import jsoncampaign_name_deq = deque([''],2)
ad_name_deq = deque([''],2)Today = arrow.now().format("YYYY-MM-DD")headers = {
xxx
}def get_excel_data():
data = pd.read_excel('./multi_xx.xlsx')
user_id = data['xxD'].tolist()
campaign_name = data['计xx'].tolist()
ad_name = data['xxx'].tolist()
creative_name = data['创xx'].tolist()
creative_title = data['xx'].tolist()
creative_desc = data['xx'].tolist()
creative_ldpUrl = data['xxxurl'].tolist()
return [user_id,campaign_name,ad_name,creative_name,creative_title,creative_desc,creative_ldpUrl]def get_productId(userId):
url = f'hxxxx={userId}'
res = requests.get(url, headers=headers)
data = res.json()['result'][0]['id']
return datadef add_new_campaign(userId, campaignName):
url = 'hxxxxx'
data = {
xxx
}
res = requests.post(url, headers=headers, data=json.dumps(data))
campaign_id = res.json()['id']
print(campaignName,campaign_id)
status = res.json()["status"]
return campaign_id, statusdef add_new_ad(campaignId, adName):
url = 'hxxxxx'
data = {
x
"appInstall": None,
x
}, }
res = requests.post(url, headers=headers, data=json.dumps(data))
adId = res.json()['id']
status = res.json()["status"]
print(adName, adId,status)
return adId, statusdef add_new_creative_word(adId, name, title, desc, ldpUrl):
url = 'htxxxxxx'
data = {
"xx
}
res = requests.post(url, headers=headers, data=json.dumps(data))
status = res.json()["status"]
print(adId,name, status)adId, ad_status = 0,''def gen_creative(userid, campaign_name, ad_name, creative_name, creative_title, creative_desc, creative_ldpUrl):
campaign_name_deq.append(campaign_name)
last_campaign_name = campaign_name_deq.popleft() ad_name_deq.append(ad_name)
last_ad_name = ad_name_deq.popleft() campaign_id, campaign_status = 0,'' if campaign_name != last_campaign_name:
campaign_id, campaign_status = add_new_campaign(userid, campaign_name) if campaign_status == 'ok' and ad_name != last_ad_name:
global adId, ad_status
adId, ad_status = add_new_ad(campaign_id, ad_name)
if ad_status == 'ok':
add_new_creative_word(adId, creative_name, creative_title, creative_desc, creative_ldpUrl)
else:
print(adId,ad_status)def mulit_upload():
l = get_excel_data()
a = list(map(gen_creative,*l))if __name__ == '__main__':
mulit_upload()