Hey there,

I have an account set up in Columbia and I was able to pull in the spend data in COP (rather than USD) that matches the UI spend data 100% until 10/22.

Here are some observations:

  1. All of the campaigns are set to use COP for the spend data, except for one that uses USD and the campaign start date is 10/22.
  2. The spend data for the USD campaign is 100% accurate. However, for the remaining COP campaigns, I am unable to extract any spend data under “billed_charge_local_micro”

I am wondering if 1) would interfere the extraction of COP spend data or if the community has any insights to why.

Best,
Eric

Could you provide a sample API request for one campaign and the URL to Ads Manager for that campaign?

Hi @osowskit1,

The API base URL: 9/stats/jobs/accounts/18ce53xfdth/
The API parameters: {‘entity’: ‘PROMOTED_TWEET’, ‘entity_ids’: ‘7t9ab9,7tdse0,7ury8n,7ury8o,7vhkjc,7vhlu2’, ‘start_time’: ‘2021-10-21’, ‘end_time’: ‘2021-11-01’, ‘granularity’: ‘DAY’, ‘placement’: ‘ALL_ON_TWITTER’, ‘metric_groups’: ‘ENGAGEMENT,BILLING,MEDIA,WEB_CONVERSION,VIDEO,MOBILE_CONVERSION’}

UI campaign link: https://ads.twitter.com/ads_manager/18ce53xfdth/fundingsources/66118898/campaigns/27437073/adgroups/?endDate=2021-10-31&startDate=2021-10-22

Please let me know if this is what you are looking for and I am happy to furnish any additional details. Thank you!

Best,
Eric

Hi @osowskit1,

I am wondering if you would have any update to this?

Best,
Eric

I was able to confirm that some of the Promoted Tweets had no spend on ALL_ON_TWITTER as a placement but did on the PUBLISHER_NETWORK.

Your application will need to make requests for both placements, ALL_ON_TWITTER and PUBLISHER_NETWORK, separately and sum up the results to match the UI.

Hi @osowskit1,

Thank you so much for looking into this and this will give me a good starting point to locate the date. Would you know if this is a set up difference that cause the data switch to PUBLISHER_NETWORK instead of ALL_ON_TWITTER?

Best,
Eric

Advertisers can choose where their Ads appear on Twitter or on the Twitter Audience Platform. You platform could check the placements for the line item or always fetch both.