CreateJob (c3t4li, awd56)
twurl -H ads-api.twitter.com “/3/stats/jobs/accounts/c3t4li” -d “entity=CAMPAIGN&entity_ids=awd56&start_time=2018-04-04T04:00:00Z&end_time=2018-07-03T04:00:00Z&granularity=DAY&metric_groups=ENGAGEMENT,BILLING&placement=ALL_ON_TWITTER”
{“request”:{“params”:{“start_time”:“2018-04-04T04:00:00Z”,“entity_ids”:[“awd56”],“end_time”:“2018-07-03T04:00:00Z”,“placement”:“ALL_ON_TWITTER”,“granularity”:“DAY”,“entity”:“CAMPAIGN”,“metric_groups”:[“ENGAGEMENT”,“BILLING”]}},“data”:{“start_time”:“2018-04-04T04:00:00Z”,“segmentation_type”:null,“url”:null,“id_str”:“1013980286189785088”,“entity_ids”:“awd56”],“end_time”:“2018-07-03T04:00:00Z”,“country”:null,“placement”:“ALL_ON_TWITTER”,“id”:1013980286189785088,“expires_at”:null,“account_id”:“c3t4li”,“status”:“PROCESSING”,“granularity”:“DAY”,“entity”:“CAMPAIGN”,“created_at”:“2018-07-03T02:58:33Z”,“platform”:null,“updated_at”:“2018-07-03T02:58:33Z”,“metric_groups”:[“ENGAGEMENT”,“BILLING”]}}
GetUrl
twurl -H ads-api.twitter.com “/3/stats/jobs/accounts/c3t4li?job_id=1013980286189785088&count=1&cursor=1013980286189785088”
{“request”:{“params”:“count”:1,“cursor”:“1013980286189785088”}},“next_cursor”:“1013980235409379333”,“data”:[{“start_time”:“2018-04-04T04:00:00Z”,“segmentation_type”:null,“url”:“https://ton.twimg.com/advertiser-api-async-analytics/APUcY-ku09BCF1RVHH1tAY221zgRbyAOjVGD38GAngIi8ozuDMkon5fP1Fc6_WuunThTy7Smy-IUc4AC0z-kotqFabf2usv9p5klykuAAfBK5hpCgWeXto4pyruWUxJR.json.gz",“id_str”:“1013980286189785088”,“entity_ids”:[“awd56”],“end_time”:“2018-07-03T04:00:00Z”,“country”:null,“placement”:“ALL_ON_TWITTER”,“id”:1013980286189785088,“expires_at”:“2018-07-05T02:58:36Z”,“account_id”:“c3t4li”,“status”:“SUCCESS”,“granularity”:“DAY”,“entity”:“CAMPAIGN”,“created_at”:“2018-07-03T02:58:33Z”,“platform”:null,"updated_
at”:“2018-07-03T02:58:36Z”,“metric_groups”:[“ENGAGEMENT”,“BILLING”]}]}
From the gzip file I will get
{
"data_type": "stats",
"time_series_length": 90,
"data": [
{
"id": "awd56",
"id_data": [
{
"segment": null,
"metrics": {
"impressions": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10282, 0, 0, 38, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"tweets_send": null,
"billed_charge_local_micro": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16735705, 0, 0, 14295, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"qualified_impressions": null,
"follows": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"app_clicks": null,
"retweets": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"unfollows": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"likes": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"engagements": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 66, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"clicks": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 63, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"card_engagements": null,
"poll_card_vote": null,
"replies": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"url_clicks": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 23, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"billed_engagements": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"carousel_swipes": null
}
}
]
}
],
"request": {
"params": {
"start_time": "2018-04-04T04:00:00Z",
"segmentation_type": null,
"entity_ids": [ "awd56" ],
"end_time": "2018-07-03T04:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "CAMPAIGN",
"platform": null,
"metric_groups": [ "ENGAGEMENT", "BILLING" ]
}
}
}
LineItem
{
"BidAmountLocalMicro": 670000,
"BidUnit": "LINK_CLICK",
"ChargeBy": "LINK_CLICK",
"TotalBudgetAmountLocalMicro": null,
"AccountId": "c3t4li",
"PrimaryWebEventTag": null,
"Name": "Untitled",
"CampaignId": "awd56",
"Currency": "USD",
"IncludeSentiment": "POSITIVE_ONLY",
"bid_type": "MAX",
"ProductType": "PROMOTED_TWEETS",
"Placements": [
"ALL_ON_TWITTER"
],
"Objective": "WEBSITE_CLICKS",
"Optimization": "DEFAULT",
"created_at": "2018-05-23T20:21:50Z",
"deleted": true,
"entity_status": "ACTIVE",
"Id": "bq9ke",
"updated_at": "2018-06-07T19:30:01Z",
"RawSource": "{\r\n \"bid_type\": \"MAX\",\r\n \"advertiser_user_id\": 731991942,\r\n \"name\": \"Untitled\",\r\n \"placements\": [\r\n \"ALL_ON_TWITTER\"\r\n ],\r\n \"start_time\": null,\r\n \"bid_amount_local_micro\": 670000,\r\n \"automatically_select_bid\": false,\r\n \"advertiser_domain\": \"monster.com\",\r\n \"target_cpa_local_micro\": null,\r\n \"primary_web_event_tag\": null,\r\n \"charge_by\": \"LINK_CLICK\",\r\n \"product_type\": \"PROMOTED_TWEETS\",\r\n \"end_time\": null,\r\n \"bid_unit\": \"LINK_CLICK\",\r\n \"total_budget_amount_local_micro\": null,\r\n \"objective\": \"WEBSITE_CLICKS\",\r\n \"id\": \"bq9ke\",\r\n \"entity_status\": \"ACTIVE\",\r\n \"account_id\": \"c3t4li\",\r\n \"optimization\": \"DEFAULT\",\r\n \"categories\": [\r\n \"IAB4-4\",\r\n \"IAB4-5\"\r\n ],\r\n \"currency\": \"USD\",\r\n \"created_at\": \"2018-05-23T20:21:50Z\",\r\n \"tracking_tags\": [],\r\n \"updated_at\": \"2018-06-07T19:30:01Z\",\r\n \"include_sentiment\": \"POSITIVE_ONLY\",\r\n \"campaign_id\": \"awd56\",\r\n \"creative_source\": \"MANUAL\",\r\n \"deleted\": true\r\n}"
}
From above data, as can be shown, we set the lineitem max bid as 670000.
But on one of the account stats data as can be seen the data show on 5/23@5/24, the billed_charged_local_micro as 16735705 for 23 clicks. If we divide it we will get 16735705/23 = 727639.347826087 (which is more than 670000).
My question is why, does on that particular date that even though we set the BidAmountLocalMicro as 670000 does it goes to 727639?
We had do the same analysis for the other campaign mentioned above, I will just cut short to the gzip file.
{
"data_type": "stats",
"time_series_length": 90,
"data": [
{
"id": "awdlb",
"id_data": [
{
"segment": null,
"metrics": {
"impressions": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8805, 3359, 489, 424, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"tweets_send": null,
"billed_charge_local_micro": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9380000, 5360000, 670000, 1340000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"qualified_impressions": null,
"follows": null,
"app_clicks": null,
"retweets": null,
"unfollows": null,
"likes": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"engagements": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57, 24, 6, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"clicks": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57, 24, 6, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"card_engagements": null,
"poll_card_vote": null,
"replies": null,
"url_clicks": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 13, 8, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"billed_engagements": [ 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14, 8, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 ],
"carousel_swipes": null
}
}
]
}
],
"request": {
"params": {
"start_time": "2018-04-04T04:00:00Z",
"segmentation_type": null,
"entity_ids": [ "awdlb" ],
"end_time": "2018-07-03T04:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "CAMPAIGN",
"platform": null,
"metric_groups": [ "ENGAGEMENT", "BILLING" ]
}
}
}
LineItem
{
"BidAmountLocalMicro": 670000,
"BidUnit": "LINK_CLICK",
"ChargeBy": "LINK_CLICK",
"TotalBudgetAmountLocalMicro": null,
"AccountId": "8ab0np",
"PrimaryWebEventTag": null,
"Name": "Untitled",
"CampaignId": "awdlb",
"Currency": "USD",
"IncludeSentiment": "POSITIVE_ONLY",
"bid_type": "MAX",
"ProductType": "PROMOTED_TWEETS",
"Placements": [
"ALL_ON_TWITTER"
],
"Objective": "WEBSITE_CLICKS",
"Optimization": "DEFAULT",
"created_at": "2018-05-23T21:48:53Z",
"deleted": true,
"entity_status": "ACTIVE",
"Id": "bqa4c",
"updated_at": "2018-06-07T19:17:00Z",
"RawSource": "{\r\n \"bid_type\": \"MAX\",\r\n \"advertiser_user_id\": 501039637,\r\n \"name\": \"Untitled\",\r\n \"placements\": [\r\n \"ALL_ON_TWITTER\"\r\n ],\r\n \"start_time\": null,\r\n \"bid_amount_local_micro\": 670000,\r\n \"automatically_select_bid\": false,\r\n \"advertiser_domain\": \"monster.com\",\r\n \"target_cpa_local_micro\": null,\r\n \"primary_web_event_tag\": null,\r\n \"charge_by\": \"LINK_CLICK\",\r\n \"product_type\": \"PROMOTED_TWEETS\",\r\n \"end_time\": null,\r\n \"bid_unit\": \"LINK_CLICK\",\r\n \"total_budget_amount_local_micro\": null,\r\n \"objective\": \"WEBSITE_CLICKS\",\r\n \"id\": \"bqa4c\",\r\n \"entity_status\": \"ACTIVE\",\r\n \"account_id\": \"8ab0np\",\r\n \"optimization\": \"DEFAULT\",\r\n \"categories\": [\r\n \"IAB4-4\",\r\n \"IAB4-5\"\r\n ],\r\n \"currency\": \"USD\",\r\n \"created_at\": \"2018-05-23T21:48:53Z\",\r\n \"tracking_tags\": [],\r\n \"updated_at\": \"2018-06-07T19:17:00Z\",\r\n \"include_sentiment\": \"POSITIVE_ONLY\",\r\n \"campaign_id\": \"awdlb\",\r\n \"creative_source\": \"MANUAL\",\r\n \"deleted\": true\r\n}"
}
As per shown above on 5/23@5/24, the stats show as 9380000 billed_charge_local_micro for url_clicks 13.
Doing the same calculation, 9380000/13 = 721538.4615384615 (which is more than 670000).
To conclude:
- AccountID: c3t4li, Campaign EntityID: awd56, LineItem BidAmountLocalMicro: 670000 (MAX). stats on 5/23@5/24 show bidding as 16735705/23 = 727639.347826087 (which is more than 670000),
- AccountID: 8ab0np, Campaign EntityID: awdlb, LineItem BidAmountLocalMicro: 670000 (MAX). stats on 5/23@5/24 show bidding as 9380000/13 = 721538.4615384615 (which is more than 670000)
Our question on above 1),2), is why even though we set the line item limit per day as 670000 that the stats showing that Twitter spending more than what we set it to be?