def set_adset_id(custom_audience_id, ad_set_id):
conn = engine.connect()
conn.execute(campaigns.update().where(
campaigns.c.custom_audience_id.match(custom_audience_id)).values(
ad_set_id=ad_set_id))
def set_video_id(custom_audience_id, video_id):
conn = engine.connect()
return conn.execute(campaigns.update().where(
campaigns.c.custom_audience_id.match(custom_audience_id)).values(
video_id=str(video_id)))
def set_audience_mk(custom_audience_id):
conn = engine.connect()
conn.execute(campaigns.update().where(
campaigns.c.custom_audience_id.match(custom_audience_id)).values(
add_users_mk=True))
def set_audience_id(audience_name, custom_audience_id):
conn = engine.connect()
return conn.execute(campaigns.update().where(
campaigns.c.adgroup.match(audience_name)).values(
custom_audience_id=custom_audience_id))
def set_creative_group_id(ad_creative_id, creative_group_id):
conn = engine.connect()
conn.execute(campaigns.update().where(
campaigns.c.video_creation_id.match(ad_creative_id)).values(
creative_group_id=str(creative_group_id)))
def set_campaign_id(camp_name, camp_id):
conn = engine.connect()
return conn.execute(campaigns.update().where(
campaigns.c.campaign_name.match(camp_name)).values(
campaign_id=camp_id))
def set_video_creation_id(video_id, video_creation_id):
conn = engine.connect()
return conn.execute(campaigns.update().where(
campaigns.c.video_id.match(video_id)).values(
video_creation_id=str(video_creation_id)))