Facebook广告API 101
?
3 likes?1,952 views
1) The document provides an overview of the Facebook advertising API and how to get started using it. It discusses the different access levels for the API, how to authorize and get an access token, and examples of creating advertising campaigns, ad sets, ads and targeting audiences using the API. 2) It also covers important concepts like bidding and object specs needed to define ads, and recommends ways to familiarize yourself with targeting specs and estimating reach through the API. 3) The document aims to help developers understand how to leverage the Facebook advertising API to programmatically create and manage ad campaigns at scale.
![@route('/fblogin-cb')
def fblogin_cb():
if not request.params.code:
return 'Ooops, do not find code in callback URL, please close this.'
import urllib2
url = fblogin_at_url_tpl.format(setting['appid'], fblogin_cb_url,
setting['appsecret'], request.params.code)
resp = urllib2.urlopen(url)
respcontent = resp.read()
with open('frontend/oauth_ok.tpl', 'r') as f:
oauth_ok_page_tpl = f.read()
return template(oauth_ok_page_tpl, respcontent=respcontent)
<!DOCTYPE html>
<html><head>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>
<p>FB Auth OK, will go back soon ...</p>
<script>
setTimeout(function() {
window.opener.loginOk('{{!respcontent}}');
window.close();
}, 1000);
</script>
</body></html>
27
案例：第2-3步，获得Code后发起请求Access Token](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-27-320.jpg)
![from facebookads.api import FacebookAdsApi
from facebookads.objects import AdAccount
FacebookAdsApi.init(
app_id,
app_secret,
access_token
)
account = AdAccount('act_<ACCOUNT_ID>')
account.remote_read(fields=[
AdAccount.Field.name,
AdAccount.Field.balance
])
print(account[AdAccount.Field.name])
print(account[AdAccount.Field.balance])
35](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-35-320.jpg)
![def create_campaign(self, accountid, name):
campaign = AdCampaign(parent_id=accountid)
campaign[AdCampaign.Field.name] = name
campaign[AdCampaign.Field.objective] = (
AdCampaign.Objective.mobile_app_engagement
)
campaign.remote_create()
return campaign[AdCampaign.Field.id]
39](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-39-320.jpg)
![def create_ad_set(self, accountid, name, dailybudget, campaignid,
bidinfo, targeting, appinfo):
logger.debug('bidinfo:' + str(bidinfo))
pdata = {
AdSet.Field.name: name,
AdSet.Field.bid_type: AdSet.BidType.cpc,
AdSet.Field.bid_info: bidinfo,
AdSet.Field.status: AdSet.Status.active,
AdSet.Field.daily_budget: dailybudget,
AdSet.Field.campaign_group_id: campaignid,
AdSet.Field.promoted_object: {
'application_id': appinfo['fbapplication_id'],
'object_store_url': appinfo['appstore_link']
},
AdSet.Field.targeting: targeting,
}
adset = AdSet(parent_id=accountid)
adset.remote_create(params=pdata)
return adset[AdSet.Field.id]
40](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-40-320.jpg)
![def create_creative(self, accountid, name, imagehash, message, appinfo):
link_data = LinkData()
link_data[LinkData.Field.link] = appinfo['appstore_link']
link_data[LinkData.Field.message] = message
link_data[LinkData.Field.image_hash] = imagehash
call_to_action = {'type': 'USE_MOBILE_APP'}
call_to_action['value'] = {
'link': appinfo['appstore_link'],
'app_link': appinfo['app_deep_link'],
'application': appinfo['fbapplication_id'],
'link_title': appinfo['app_name']
}
link_data[LinkData.Field.call_to_action] = call_to_action
object_story_spec = ObjectStorySpec()
object_story_spec[ObjectStorySpec.Field.page_id] = appinfo['fbpage_id']
object_story_spec[ObjectStorySpec.Field.link_data] = link_data
creative = AdCreative(parent_id=accountid)
creative[AdCreative.Field.name] = name
creative[AdCreative.Field.object_story_spec] = object_story_spec
creative.remote_create()
return creative[AdCreative.Field.id]
41](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-41-320.jpg)
![def create_ad(self, accountid, name, adsetid, creativeid, appinfo):
adgroup = AdGroup(parent_id=accountid)
adgroup[AdGroup.Field.name] = name
adgroup[AdGroup.Field.campaign_id] = adsetid
adgroup[AdGroup.Field.creative] = {'creative_id': str(creativeid)}
adgroup[AdGroup.Field.objective] =
AdGroup.Objective.mobile_app_engagement
tracking_specs = [
{'action.type': ['mobile_app_install'],
'application': [appinfo['fbapplication_id']]},
{'action.type': ['app_custom_event'],
'application': [appinfo['fbapplication_id']]}
]
if not (appinfo['fboffsitepixel_id'].strip() == 'null'):
tracking_specs.append({
'action.type': ['offsite_conversion'],
'offsite_pixel': [appinfo['fboffsitepixel_id']]
})
adgroup[AdGroup.Field.tracking_specs] = tracking_specs
adgroup[AdGroup.Field.status] = AdGroup.Status.active
adgroup.remote_create()
return adgroup[AdGroup.Field.id]
42](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-42-320.jpg)
![Targeting Spec
https://developers.facebook.com/docs/marketing-api/targeting-specs
JSON格式
47
curl
-X POST
-F "name=My AdSet"
-F "bid_type=CPC"
-F "bid_info={'CLICKS': 150}"
-F "campaign_status=ACTIVE"
-F "daily_budget=2000"
-F "campaign_group_id=<CAMPAIGN_GROUP_ID>"
-F "targeting= {
'geo_locations': {
'countries':['US'],
},
'behaviors':[
{'id':6004386044572,'name':'Android Owners (All)'},
{'id':6007101597783,'name':'Business Travelers'},
],
}"
-F "access_token=<ACCESS_TOKEN>"
"https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/adcampaigns"](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-47-320.jpg)
![for tier in range(1, tiers + 1):
lookalike = CustomAudience(parent_id=accountid)
lookalike[LookalikeAudience.Field.name] =
'{0} LAL {1}'.format(name, tier)
lookalike[LookalikeAudience.Field.origin_audience_id] = seed_id
lookalike[LookalikeAudience.Field.lookalike_spec] = {
'ratio': '{:.2f}'.format(tier / 100.0),
LookalikeAudience.Field.LookalikeSpec.country: country,
}
lookalike.remote_create()
Create Tired LAL](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-53-320.jpg)
![for tier in range(1, tiers + 1):
ad_set = AdSet(parent_id=accountid)
ad_set[AdSet.Field.bid_info] = tiered_bidinfos[tier - 1]
audience = tiered_lookalikes[tier - 1]
exclude_audience = None
if tier != 1:
exclude_audience = tiered_lookalikes[tier - 2]
targeting = {
TargetingSpecsField.custom_audiences: [{
'id': audience[CustomAudience.Field.id],
'name': audience[CustomAudience.Field.name],
}]
}
if exclude_audience:
targeting[TargetingSpecsField.excluded_custom_audiences] = [{
'id': exclude_audience[CustomAudience.Field.id],
'name': exclude_audience[CustomAudience.Field.name],
}]
ad_set[AdSet.Field.targeting] = targeting
ad_set.remote_create()
Create Ad Set](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-54-320.jpg)
![########################## main ##########################
# get all ad campaign from an ad account
if not db_unix_socket == '':
con = mdb.connect(host='localhost', user=db_username,
db=db_name, unix_socket=db_unix_socket, charset='utf8')
else:
con = mdb.connect(host=db_host, port=db_port,
user=db_username, passwd=db_password,
db=db_name, charset='utf8')
with con:
deleteAdSetsInsight(con, report_date)
for my_ad_account_id in my_ad_account_ids:
ad_account = AdAccount(my_ad_account_id)
fields = [
'campaign_group_name',
'campaign_name',
'campaign_id',
'impressions',
'clicks',
'spend',
'reach',
'actions',
'action_values'
]
params = {
'time_range': {
'since': report_date,
'until': report_date
},
'action_attribution_windows': ['28d_click'],
'breakdowns': ['impression_device', 'placement'],
'level': 'campaign',
'limit': max_records
}
ad_insights = ad_account.get_insights(fields, params)
print('Number of insight records:' + str(len(ad_insights)))
count = 0
for idx in range(0,min(max_records,len(ad_insights))):
ad_insight = ad_insights[idx]
print('Writing record number: ' + str(idx))
writeAdInsight(ad_insight, con, report_date)
59
def writeAdInsight(ad_insight, con, report_date):
impression_device = 0
if 'impression_device' in ad_insight:
impression_device = ad_insight['impression_device']
action_device = 0
if 'action_device' in ad_insight:
action_device = ad_insight['action_device']
key_value = {
'start_date': report_date,
'end_date': report_date,
'campaign': ad_insight['campaign_group_name'],
'adset': ad_insight['campaign_name'],
'adset_id': ad_insight['campaign_id'],
'impressions': ad_insight['impressions'],
'clicks': ad_insight['clicks'],
'spend': ad_insight['spend'],
'reach': ad_insight['reach'],
'impression_device': impression_device,
#'conversion_device': action_device
}
if 'actions' in ad_insight:
actions = ad_insight['actions']
for action in actions:
t = action['action_type']
if t in action_type_columns:
key_value[action_type_columns[t]] = action['28d_click']
if 'action_values' in ad_insight:
action_values = ad_insight['action_values']
for action_value in action_values:
t = action['action_type']
if t in action_value_columns:
key_value[action_value_columns[t]] = action['28d_click']
key_str = ""
value_str = ""
count = 0
for (key, value) in key_value.items():
if count > 0:
key_str += ", "
value_str += ", "
key_str += key
value_str += """ + unicode(value) + """
count += 1
stat = "INSERT INTO ad_set_insight (" + key_str + ") VALUES (" + value_str + ")";
print stat
cur = con.cursor()
cur.execute(stat)](https://image.slidesharecdn.com/xzlefols3msxvejd3sjb-signature-49507911901d85a5fb01af356646388e8075f76b15b4063aeb17661aa581bbe5-poli-160127151540/85/Facebook-API-101-59-320.jpg)
Facebook广告API 101
- 3. 3
- 8. 广告的数据结构类似于树 Campaign x Ad Set x Ad，以ID相连 8
- 11. Facebook的策略：API优先 我们是行动优先，API优先 mobile-first, API first . 产物开发是按照如下的顺序 首先是API 然后是Power Editor 最后是Ads Manager "我可以等待Power Editor" 最终不是所有的API都有UI支持 早起的鸟儿有食吃
- 14. Facebook广告API现已开放 14 Development Access ?? d ?? e 0 e , ?? P d i Basic Access ?? ?? ?? 5 ?? e ?? P d i Standard Access ?? 1 5 ?? e d i ?? P 2 d i I 2I AI
- 15. 我们需要立刻升级到最高级么？
- 17. 准备条件 广告账户 Ad Account Facebook App Facebook个人账号 授权 Facebook个人账号至少成 为广告账户的Advertiser， Facebook App的Developer Facebook App关联广告账 户 17
- 18. 使用API之前：检查授权关系 18 Facebook App Facebook User Ad Account Authorized is developer of is advertiser of developers.facebook.com business.facebook.com www.facebook.com/ads/manager findmyfacebookid.com
- 19. 立即尝试广告API 19 ? 注意使用正确的FB账户 ? 注意选择您的FB APP ? 注意Get Token时获取Ads Manage和 Ads Read权限
- 23. Facebook Graph API的结构 Graph API是基于HTTP/HTTPS协议的API 版本号 vX.X https://developers.facebook.com/docs/apps/changelog 组成要素 节点node: http://graph.facebook.com/v2.3/<fbid> 边Edge: http://graph.facebook.com/v2.3/<fbid>/feed 域Field: http://graph.facebook.com/v2.3/<fbid>?fields=birthday 返回值 JSON文档 错误也是JSON文档形式 23
- 24. Access Token https://developers.facebook.com/docs/facebook-login/access-tokens 每一次API访问都必须提交Access Token/User Access Token 怎样获得？ 测试？使用 https://developers.facebook.com/tools/explorer/ 是最快的办法 注意选择正确的App 程序使用 通过Javascript SDK与Facebook SDK见 https://developers.facebook.com/docs/facebook-login/access- tokens#usertokens 通过http request 24
- 26. var FBLogin = React.createClass({ render: function() { return ( <div> <ButtonToolbar> <Button bsStyle='primary' bsSize='large' onClick={this.login}> Login into your Facebook Account </Button> </ButtonToolbar> </div> ); }, login: function() { window.open('https://www.facebook.com/dialog/oauth?' + 'client_id=' + this.props.appid + '&redirect_uri=' + window.location.origin + '/fblogin-cb', 'FB Login', 'width=600,height=400'); } }); 26 案例：第1步，发起请求
- 27. @route('/fblogin-cb') def fblogin_cb(): if not request.params.code: return 'Ooops, do not find code in callback URL, please close this.' import urllib2 url = fblogin_at_url_tpl.format(setting['appid'], fblogin_cb_url, setting['appsecret'], request.params.code) resp = urllib2.urlopen(url) respcontent = resp.read() with open('frontend/oauth_ok.tpl', 'r') as f: oauth_ok_page_tpl = f.read() return template(oauth_ok_page_tpl, respcontent=respcontent) <!DOCTYPE html> <html><head> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> </head> <body> <p>FB Auth OK, will go back soon ...</p> <script> setTimeout(function() { window.opener.loginOk('{{!respcontent}}'); window.close(); }, 1000); </script> </body></html> 27 案例：第2-3步，获得Code后发起请求Access Token
- 28. curl -G -d "access_token=CAAPhxzSarUcBAB42GF4y5qGMUygy2QNCGZAqMHWZBN0Y5 SUYORDKgl4wTlVOnQwnW2jsKAW8NN4npAhrkMJZAAf0IxWp4aIpzUOdBH7CX Qd8d2IMU2QufdCeG5I5sz3YZA7uqDK6YlxMRIs8Cu0cX2ZAO9NlVHlMUUi6K S1NHIlzV3XiqKFCouZBeJA93418GPOxEaOu514oCk8Vd3mmoA" -s https://graph.facebook.com/v2.3/me?fields=id,name,adaccounts 28 案例：获得Access Token之后使用Graph API
- 29. 使用广告API 29
- 31. curl -G -d "access_token=CAAPhxzSarUcBAB42GF4y5qGMUygy2QNCGZAqMHWZBN0Y5SUYORDKgl4 wTlVOnQwnW2jsKAW8NN4npAhrkMJZAAf0IxWp4aIpzUOdBH7CXQd8d2IMU2QufdCeG5I5s z3YZA7uqDK6YlxMRIs8Cu0cX2ZAO9NlVHlMUUi6KS1NHIlzV3XiqKFCouZBeJA93418GPO xEaOu514oCk8Vd3mmoA" -s https://graph.facebook.com/v2.3/act_10206805676768821 31 获得Access Token之后使用Ads API
- 33. 怎样使用SDK 33
- 34. use FacebookAdsApi; use FacebookAdsObjectAdAccount; use FacebookAdsObjectAdAccountFields; Api::init($app_id, $app_secret, $access_token); $account = new AdAccount('act_<ACCOUNT_ID>'); $fields = array( AdAccountFields::NAME, AdAccountFields::BALANCE, ); $params = array( AdCampaignFields::STATUS => array(AdCampaign::STATUS_PAUSED), ); $account->read($fields); // Output account name echo $account->{AdAccountFields::NAME}.PHP_EOL; // Output account balance echo $account->{AdAccountFields::BALANCE}.PHP_EOL; 34
- 35. from facebookads.api import FacebookAdsApi from facebookads.objects import AdAccount FacebookAdsApi.init( app_id, app_secret, access_token ) account = AdAccount('act_<ACCOUNT_ID>') account.remote_read(fields=[ AdAccount.Field.name, AdAccount.Field.balance ]) print(account[AdAccount.Field.name]) print(account[AdAccount.Field.balance]) 35
- 36. 创建广告四部曲
- 37. 1.2.3.4 1. 创建campaign https://developers.facebook.com/docs/marketing-api/adcampaign 2. 创建ad set https://developers.facebook.com/docs/marketing-api/adset 3. 创建ad creative https://developers.facebook.com/docs/marketing-api/adcreative 4. 创建ad https://developers.facebook.com/docs/marketing-api/adgroup 37
- 38. 步骤0: 上传image，创建page post，etc 例如上传image https://developers.facebook.com/docs/marketing-api/adimage 创建page post 多图广告 Carousal Ads 必须 https://developers.facebook.com/docs/marketing-api/guides/carousel-ads/ v2.3#pageFirst 38 curl -F "test.zip=@test.zip" -F "access_token=<ACCESS_TOKEN>" "https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/adimages"
- 39. def create_campaign(self, accountid, name): campaign = AdCampaign(parent_id=accountid) campaign[AdCampaign.Field.name] = name campaign[AdCampaign.Field.objective] = ( AdCampaign.Objective.mobile_app_engagement ) campaign.remote_create() return campaign[AdCampaign.Field.id] 39
- 40. def create_ad_set(self, accountid, name, dailybudget, campaignid, bidinfo, targeting, appinfo): logger.debug('bidinfo:' + str(bidinfo)) pdata = { AdSet.Field.name: name, AdSet.Field.bid_type: AdSet.BidType.cpc, AdSet.Field.bid_info: bidinfo, AdSet.Field.status: AdSet.Status.active, AdSet.Field.daily_budget: dailybudget, AdSet.Field.campaign_group_id: campaignid, AdSet.Field.promoted_object: { 'application_id': appinfo['fbapplication_id'], 'object_store_url': appinfo['appstore_link'] }, AdSet.Field.targeting: targeting, } adset = AdSet(parent_id=accountid) adset.remote_create(params=pdata) return adset[AdSet.Field.id] 40
- 41. def create_creative(self, accountid, name, imagehash, message, appinfo): link_data = LinkData() link_data[LinkData.Field.link] = appinfo['appstore_link'] link_data[LinkData.Field.message] = message link_data[LinkData.Field.image_hash] = imagehash call_to_action = {'type': 'USE_MOBILE_APP'} call_to_action['value'] = { 'link': appinfo['appstore_link'], 'app_link': appinfo['app_deep_link'], 'application': appinfo['fbapplication_id'], 'link_title': appinfo['app_name'] } link_data[LinkData.Field.call_to_action] = call_to_action object_story_spec = ObjectStorySpec() object_story_spec[ObjectStorySpec.Field.page_id] = appinfo['fbpage_id'] object_story_spec[ObjectStorySpec.Field.link_data] = link_data creative = AdCreative(parent_id=accountid) creative[AdCreative.Field.name] = name creative[AdCreative.Field.object_story_spec] = object_story_spec creative.remote_create() return creative[AdCreative.Field.id] 41
- 42. def create_ad(self, accountid, name, adsetid, creativeid, appinfo): adgroup = AdGroup(parent_id=accountid) adgroup[AdGroup.Field.name] = name adgroup[AdGroup.Field.campaign_id] = adsetid adgroup[AdGroup.Field.creative] = {'creative_id': str(creativeid)} adgroup[AdGroup.Field.objective] = AdGroup.Objective.mobile_app_engagement tracking_specs = [ {'action.type': ['mobile_app_install'], 'application': [appinfo['fbapplication_id']]}, {'action.type': ['app_custom_event'], 'application': [appinfo['fbapplication_id']]} ] if not (appinfo['fboffsitepixel_id'].strip() == 'null'): tracking_specs.append({ 'action.type': ['offsite_conversion'], 'offsite_pixel': [appinfo['fboffsitepixel_id']] }) adgroup[AdGroup.Field.tracking_specs] = tracking_specs adgroup[AdGroup.Field.status] = AdGroup.Status.active adgroup.remote_create() return adgroup[AdGroup.Field.id] 42
- 46. Facebook广告的特色功能：Targeting 不同于关键字广告，Facebook广告使用Targeting来定义受众 是人的行为而不是关键词 Facebook Targeting的能力 https://developers.facebook.com/docs/marketing-api/targeting 人口学 Demographic 用户兴趣 Interest 用户行为 Behaviour 社交联系 Connection 46
- 47. Targeting Spec https://developers.facebook.com/docs/marketing-api/targeting-specs JSON格式 47 curl -X POST -F "name=My AdSet" -F "bid_type=CPC" -F "bid_info={'CLICKS': 150}" -F "campaign_status=ACTIVE" -F "daily_budget=2000" -F "campaign_group_id=<CAMPAIGN_GROUP_ID>" -F "targeting= { 'geo_locations': { 'countries':['US'], }, 'behaviors':[ {'id':6004386044572,'name':'Android Owners (All)'}, {'id':6007101597783,'name':'Business Travelers'}, ], }" -F "access_token=<ACCESS_TOKEN>" "https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/adcampaigns"
- 48. 怎样熟悉Targeting Spec？ 练习，多加练习 创建广告时使用 adgroup_status＝PAUSED 使用reach estimate https://developers.facebook.com/docs/marketing-api/reachestimate 广告预览 https://developers.facebook.com/docs/marketing-api/ad-previews https://developers.facebook.com/docs/marketing-api/ad-preview-plugin 48 curl -G -d "currency=USD" -d "targeting_spec=___" -d "access_token=___" "https://graph.facebook.com/<API_VERSION>/act_<AD_ACCOUNT_ID>/reachestimate"
- 50. Scale While Maintaining CPI
- 51. Increasing Reach While Maintaining CPI/ROI Tiered Lookalike Strategy Entire Country Population Sorted By Descending Likeness To Seed Audience Top 1% Top 3% Top 5%
- 52. Manual Steps 1. Create a custom audience 2. Create 1% lookalike 3. Repeat for 3% and 5% 4. Create adset using 1% lookalike 5. Create adset using 3% lookalike, exclude 1% lookalike, bid lower 6. Create adset using 5% lookalike, exclude 3% lookalike, bid lower 7. Don't forget cross-device tracking! 8. Repeat 1- 7 for other seed audiences 9. Repeat 1- 8 for other countries
- 53. for tier in range(1, tiers + 1): lookalike = CustomAudience(parent_id=accountid) lookalike[LookalikeAudience.Field.name] = '{0} LAL {1}'.format(name, tier) lookalike[LookalikeAudience.Field.origin_audience_id] = seed_id lookalike[LookalikeAudience.Field.lookalike_spec] = { 'ratio': '{:.2f}'.format(tier / 100.0), LookalikeAudience.Field.LookalikeSpec.country: country, } lookalike.remote_create() Create Tired LAL
- 54. for tier in range(1, tiers + 1): ad_set = AdSet(parent_id=accountid) ad_set[AdSet.Field.bid_info] = tiered_bidinfos[tier - 1] audience = tiered_lookalikes[tier - 1] exclude_audience = None if tier != 1: exclude_audience = tiered_lookalikes[tier - 2] targeting = { TargetingSpecsField.custom_audiences: [{ 'id': audience[CustomAudience.Field.id], 'name': audience[CustomAudience.Field.name], }] } if exclude_audience: targeting[TargetingSpecsField.excluded_custom_audiences] = [{ 'id': exclude_audience[CustomAudience.Field.id], 'name': exclude_audience[CustomAudience.Field.name], }] ad_set[AdSet.Field.targeting] = targeting ad_set.remote_create() Create Ad Set
- 55. Pulling Ad Insights Into Database/Excel
- 56. Manual Steps 1.Open saved report in Facebook ads reports 2.Refresh data 3.Export to ?le 4.Open Excel 5.Import ?le 6.Save spreadsheet 7.Repeat daily 8.Everyone does this!
- 57. Not finish yet Big team will have hierarchy reporting Each team member takes care of his own Someone takes care of summary This can go up Different team in different product category takes care of its summary Someone takes care of teams' summary Then what if any one got the number wrong? (typo, copy/paste missing)
- 58. A Better Pipeline 1.Open saved report in Facebook ads reports One command to retrieve insights to mysql 2.Refresh data 3.Export to ?le 4.Open Excel 5.Import ?le 6.Save spreadsheet Hit refresh button to refresh from mysql 7.Repeat daily 8.Everyone Build a robot to does this!
- 59. ########################## main ########################## # get all ad campaign from an ad account if not db_unix_socket == '': con = mdb.connect(host='localhost', user=db_username, db=db_name, unix_socket=db_unix_socket, charset='utf8') else: con = mdb.connect(host=db_host, port=db_port, user=db_username, passwd=db_password, db=db_name, charset='utf8') with con: deleteAdSetsInsight(con, report_date) for my_ad_account_id in my_ad_account_ids: ad_account = AdAccount(my_ad_account_id) fields = [ 'campaign_group_name', 'campaign_name', 'campaign_id', 'impressions', 'clicks', 'spend', 'reach', 'actions', 'action_values' ] params = { 'time_range': { 'since': report_date, 'until': report_date }, 'action_attribution_windows': ['28d_click'], 'breakdowns': ['impression_device', 'placement'], 'level': 'campaign', 'limit': max_records } ad_insights = ad_account.get_insights(fields, params) print('Number of insight records:' + str(len(ad_insights))) count = 0 for idx in range(0,min(max_records,len(ad_insights))): ad_insight = ad_insights[idx] print('Writing record number: ' + str(idx)) writeAdInsight(ad_insight, con, report_date) 59 def writeAdInsight(ad_insight, con, report_date): impression_device = 0 if 'impression_device' in ad_insight: impression_device = ad_insight['impression_device'] action_device = 0 if 'action_device' in ad_insight: action_device = ad_insight['action_device'] key_value = { 'start_date': report_date, 'end_date': report_date, 'campaign': ad_insight['campaign_group_name'], 'adset': ad_insight['campaign_name'], 'adset_id': ad_insight['campaign_id'], 'impressions': ad_insight['impressions'], 'clicks': ad_insight['clicks'], 'spend': ad_insight['spend'], 'reach': ad_insight['reach'], 'impression_device': impression_device, #'conversion_device': action_device } if 'actions' in ad_insight: actions = ad_insight['actions'] for action in actions: t = action['action_type'] if t in action_type_columns: key_value[action_type_columns[t]] = action['28d_click'] if 'action_values' in ad_insight: action_values = ad_insight['action_values'] for action_value in action_values: t = action['action_type'] if t in action_value_columns: key_value[action_value_columns[t]] = action['28d_click'] key_str = "" value_str = "" count = 0 for (key, value) in key_value.items(): if count > 0: key_str += ", " value_str += ", " key_str += key value_str += """ + unicode(value) + """ count += 1 stat = "INSERT INTO ad_set_insight (" + key_str + ") VALUES (" + value_str + ")"; print stat cur = con.cursor() cur.execute(stat)