We are experiencing a similar issue where API impressions don’t match the Ads UI impressions.
We have tried using the calculations specified in derived metrics.
For example, we used the following for impressions:
promoted_tweet_search_impressions + promoted_tweet_timeline_impressions + promoted_tweet_profile_impressions
Promoted_tweet_search_impressions and promoted_tweet_timeline_impressions return, but promoted_tweet_profile_impressions is missing as a column altogether.
Any insight onto what could be causing this?