Hello,
Thanks for reaching out. From what I see, you did a POST API call to retrieve a job_id. However, after getting the job_id, you would need to perform a GET API to retrieve a gunzip file which will contain the relevant information in .json format.
I managed to retrieve the details based on the information you have given. These are the steps I have done for ALL_ON_TWITTER:
- Perform a POST API call to retrieve the job_id
twurl -H ads-api.twitter.com "/11/stats/jobs/accounts/18ce55cg0tc?entity=CAMPAIGN&entity_ids=hgzni&start_time=2022-04-05&end_time=2022-04-30&placement=ALL_ON_TWITTER&metric_groups=ENGAGEMENT,BILLING,VIDEO,MEDIA,WEB_CONVERSION,MOBILE_CONVERSION,LIFE_TIME_VALUE_MOBILE_CONVERSION&granularity=DAY" -X POST | jq .
This will result in job_id=1516222552422555650
- Perform a GET API call to retrieve the content of the job_id that has been generated
twurl -H ads-api.twitter.com "/11/stats/jobs/accounts/18ce55cg0tc?job_ids=1516222552422555650"| jq .
This return a url which consist of a gunzip file.
Once unzipped, you can view the contents of your campaign details in json format. Attaching the json file here as well
{
"data_type": "stats",
"time_series_length": 25,
"data": [
{
"id": "hgzni",
"id_data": [
{
"segment": null,
"metrics": {
"video_views_50": null,
"impressions": [
3860,
3466,
3257,
2882,
2536,
2670,
3155,
4078,
3266,
2622,
80,
2,
0,
1946,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_spent_credits": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_installs": {
"skan": {
"post_view": null,
"post_engagement": null
},
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_content_views": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_tutorials_completed": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"mobile_conversion_add_to_wishlists": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_checkouts_initiated": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_add_to_wishlists": {
"sale_amount": null,
"order_quantity": null,
"metric": null
},
"mobile_conversion_lifetime_value_logins": {
"metric": null,
"order_quantity": null,
"sale_amount": null
},
"mobile_conversion_checkouts_initiated": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"tweets_send": null,
"conversion_purchases": {
"order_quantity_engagement": null,
"sale_amount_engagement": null,
"sale_amount_view": null,
"post_view": [
0,
0,
3,
1,
5,
2,
4,
3,
0,
0,
0,
1,
4,
2,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity": null,
"assisted": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
2,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null,
"metric": [
0,
0,
3,
2,
5,
2,
4,
3,
0,
0,
0,
1,
6,
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity_view": null
},
"mobile_conversion_reservations": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_tutorials_completed": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"billed_charge_local_micro": [
16271522,
16520000,
16360000,
16240000,
12886875,
12985904,
12699630,
15285689,
13586848,
10851910,
506819,
4803,
0,
8556705,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"qualified_impressions": null,
"video_views_75": null,
"conversion_sign_ups": {
"order_quantity_engagement": null,
"sale_amount_engagement": null,
"sale_amount_view": null,
"post_view": [
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
],
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null,
"metric": [
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
],
"order_quantity_view": null
},
"media_engagements": [
116,
77,
80,
79,
49,
73,
64,
93,
80,
41,
0,
0,
0,
53,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"follows": null,
"mobile_conversion_achievements_unlocked": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_add_to_carts": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"video_3s100pct_views": null,
"app_clicks": null,
"mobile_conversion_lifetime_value_sign_ups": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"mobile_conversion_searches": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_spent_credits": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"mobile_conversion_site_visits": {
"order_quantity": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
3,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"post_view": [
0,
0,
0,
1,
3,
2,
4,
3,
1,
0,
0,
1,
2,
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null
},
"retweets": null,
"mobile_conversion_key_page_views": {
"post_view": null,
"post_engagement": null
},
"video_cta_clicks": null,
"unfollows": null,
"mobile_conversion_lifetime_value_achievements_unlocked": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"likes": [
1,
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_add_to_carts": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_payment_info_additions": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_re_engages": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"video_content_starts": null,
"mobile_conversion_lifetime_value_updates": {
"order_quantity": null,
"sale_amount": null,
"metric": null
},
"video_views_25": null,
"mobile_conversion_shares": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"conversion_site_visits": {
"order_quantity_engagement": null,
"sale_amount_engagement": null,
"sale_amount_view": null,
"post_view": [
0,
0,
0,
1,
3,
2,
4,
3,
1,
0,
0,
1,
2,
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
3,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null,
"metric": [
0,
0,
0,
2,
3,
2,
4,
3,
1,
0,
0,
1,
5,
4,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity_view": null
},
"mobile_conversion_lifetime_value_content_views": {
"sale_amount": null,
"metric": null,
"order_quantity": null
},
"mobile_conversion_lifetime_value_invites": {
"sale_amount": null,
"metric": null,
"order_quantity": null
},
"engagements": [
145,
101,
104,
109,
73,
91,
79,
118,
97,
65,
0,
0,
0,
63,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_lifetime_value_shares": {
"order_quantity": null,
"sale_amount": null,
"metric": null
},
"conversion_custom": {
"order_quantity_engagement": null,
"sale_amount_engagement": null,
"sale_amount_view": null,
"post_view": [
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
],
"order_quantity": null,
"post_engagement": null,
"sale_amount": null,
"metric": [
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
],
"order_quantity_view": null
},
"video_views_100": null,
"mobile_conversion_lifetime_value_searches": {
"order_quantity": null,
"sale_amount": null,
"metric": null
},
"mobile_conversion_lifetime_value_purchases": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"clicks": [
29,
24,
24,
30,
24,
18,
15,
25,
17,
24,
0,
0,
0,
10,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_sign_ups": {
"post_view": [
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
],
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"media_views": null,
"card_engagements": null,
"video_6s_views": null,
"poll_card_vote": null,
"mobile_conversion_lifetime_value_reservations": {
"order_quantity": null,
"sale_amount": null,
"metric": null
},
"mobile_conversion_lifetime_value_rates": {
"metric": null,
"order_quantity": null,
"sale_amount": null
},
"replies": null,
"mobile_conversion_lifetime_value_levels_achieved": {
"order_quantity": null,
"metric": null,
"sale_amount": null
},
"video_15s_views": null,
"url_clicks": [
8,
12,
8,
10,
11,
7,
5,
7,
4,
6,
0,
0,
0,
5,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_purchases": {
"skan": {
"post_view": null,
"post_engagement": null
},
"post_view": [
0,
0,
3,
1,
5,
2,
4,
3,
0,
0,
0,
1,
4,
2,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity": null,
"assisted": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
2,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null
},
"mobile_conversion_rates": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_logins": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"billed_engagements": [
3856,
3409,
3205,
2858,
2536,
2670,
3155,
4078,
3266,
2623,
80,
2,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"mobile_conversion_updates": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_lifetime_value_payment_info_additions": {
"sale_amount": null,
"order_quantity": null,
"metric": null
},
"conversion_downloads": {
"order_quantity_engagement": null,
"sale_amount_engagement": null,
"sale_amount_view": null,
"post_view": [
0,
0,
3,
1,
5,
2,
4,
3,
1,
0,
0,
1,
4,
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
3,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null,
"metric": [
0,
0,
3,
2,
5,
2,
4,
3,
1,
0,
0,
1,
7,
4,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity_view": null
},
"mobile_conversion_levels_achieved": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"mobile_conversion_downloads": {
"post_view": [
0,
0,
3,
1,
5,
2,
4,
3,
1,
0,
0,
1,
4,
3,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"sale_amount": null,
"post_engagement": [
0,
0,
0,
1,
0,
0,
0,
0,
0,
0,
0,
0,
3,
1,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
],
"order_quantity": null
},
"video_total_views": null,
"mobile_conversion_invites": {
"post_view": null,
"order_quantity": null,
"assisted": null,
"post_engagement": null,
"sale_amount": null
},
"carousel_swipes": [
116,
77,
80,
79,
49,
73,
64,
93,
80,
41,
0,
0,
0,
53,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0,
0
]
}
}
]
}
],
"request": {
"params": {
"start_time": "2022-04-05T06:00:00Z",
"segmentation_type": null,
"entity_ids": [
"hgzni"
],
"end_time": "2022-04-30T06:00:00Z",
"country": null,
"placement": "ALL_ON_TWITTER",
"granularity": "DAY",
"entity": "CAMPAIGN",
"platform": null,
"metric_groups": [
"ENGAGEMENT",
"BILLING",
"VIDEO",
"MEDIA",
"WEB_CONVERSION",
"MOBILE_CONVERSION",
"LIFE_TIME_VALUE_MOBILE_CONVERSION"
]
}
}
}
This method should work similarly for PUBLISHER_NETWORK as well.
Hope this clarifies.