I’m new to the advertiser API from Twitter. But I want to know what the best way is to get all the stats (grouped by ad) for a specified day (with the fields campaign_id, campaign_name, ad_id, ad_name, cost, impressions and clicks). In the dashboard of Twitter I can make an export with all those fields, but in the API it looks like I have to do a lot of calls to the API. First I have to get all our campaign, then get all our line_items (groups) (for every call I can use 200 campaign_ids), then all our promoted_tweets (ads) (for every call I can use 200 line_item_ids) en for every tweet I can get the stats (with https://ads-api.twitter.com/2/stats/accounts/:account_id and for every call I can use up to 20 entity_ids) for a specified day. And every call for the stats I have to it twice, one for placement ALL_ON_TWITTER and one for placement PUBLISHER_NETWORK. Isn’t there a better way to get this information? Maybe I’m missing something.
We already use the API from Facebook and Google, but there you can get with 1 call all the results with campaign_id, campaign_name, ad_id, ad_name, cost, impressions and clicks. For Twitter I have to do more then 100 calls to the API to get the information we need, because we have more then 1000 campaigns with more then 10 promoted tweet for every campaign.