Is there a way I can get the promoted tweet ids which have stats for a given date range? Actually I am looking for some stats end point which can group on promoted tweets level and I get only those promoted tweets which actually have some stats in given date range.
According to documentation the current option I know of is to grab all the promoted tweets via GET accounts/:account_id/promoted_tweets for a particular account and then use the stats end point of promoted tweet to see the stats. Note that because our system is making campaigns with ads.twitter.com dashboard so I don’t have any value of line_item_id , or promoted_tweet_id in my database and due to same I can not apply any filter. All I am looking to find an efficient way to get the stats from twitter for each day and ignore the non-required promoted tweet ids. Because if I do this for all promoted_tweet_ids for everyday then my system will not remain efficient due to addition of more advertiser accounts and more campaigns on daily bases.
Actually in our system we planned to use ads.twitter.com dashboard to create the campaigns but we want the stats data in our database for each day. i.e we will have scheduled Cron-job for each day and it will grab the statistics from end point “GET stats/accounts/:account_id/promoted_tweets” and will save it in database.
The other end point as recommended in Analytic docs is line_items but this would also have same problem, this way I’ll have to grab all the line_items for an account and then do the calculation. Please suggest some appropriate solution for my scenario if there is any.