I’m showing metrics per-creative (card) for a couple of accounts, in order to show consistent metrics I need to query the promoted_tweets endpoint with the “with_deleted” flag set to true (and later querying the metrics stats on those ids…).
The problem with that is that for some accounts this process does not scale since the promoted_tweets endpoint (with_deleted=1) returns the promoted tweets since the beginning of time. we have some accounts with more than 25k promoted_tweets at this point and with the rate-limits those queries are never-ending.
Ideally I would like to be able to query only for those promoted_tweets (including deleted) that had any stats in the specified time-range, but afaik there is no such endpoint.
Alternatively, adding a deleted_at flag to the promoted_tweets endpoint (and allowing to sort on it) could also potentially solve this problem - is it possible for you to expose this field via the api?
Do you guys have any other ideas for a solution?