How to get Ad campaign performance data through api

[meghana]

Here is what I’m trying to get through twitter ads api
Time period
Placement
Campaign name
Objective
Edit url
Status
Impressions
Spend
Purchases
Cost per purchase
Purchases - sale amount
Link clicks
Cost per link click
Campaign start
Campaign end
Total budget
Results
Result Type
Result Rate
Result Rate Type
Cost Per Result
Cost Per Result Type
Daily budget
Remaining campaign budget
Campaign daily pacing
Campaign flight pacing
Purchase_Box - Purchases
Purchase_Box - Purchases - post engagement
Purchase_Box - Purchases - post view
Purchase_Box - Purchases - sale amount
Site Visit - Event Tag - Site visits
Site Visit - Event Tag - Site visits - post engagement
Site Visit - Event Tag - Site visits - post view
Site Visit - Event Tag - Site visits - sale amount
Purchase - Single Event - Purchases
Purchase - Single Event - Purchases - post engagement
Purchase - Single Event - Purchases - post view
Purchase - Single Event - Purchases - sale amount
Opt-in - Single-event - Sign ups
Opt-in - Single-event - Sign ups - post engagement
Opt-in - Single-event - Sign ups - post view
Opt-in - Single-event - Sign ups - sale amount

[juanshishido]

What have you tried doing thus far to get this information?

[meghana]

First I sent the http request to get all the list of campaigns to the below endpoint and request went through successfully both in powershell script and as well as in Postman
https://ads-api.twitter.com/4/accounts/18ce53zx1fm/campaigns
that means my logic to create the oauth signature, timestamp, nonce and other credentials provided in the script worked for getting the campaigns list
For the campaign list I used Base URL as “https://ads-api.twitter.com/4/accounts/18ce53zx1fm/campaigns” which worked fine.

Then I tried to get the Ad performance report and below is the endpoint
https://ads-api.twitter.com/4/stats/accounts/accountId?granularity=DAY&placement=ALL_ON_TWITTER&start_time=2018-11-26&end_time=2018-11-28&entity=CAMPAIGN&entity_ids=(list of campaignIds separated by “,”)&metric_groups=ENGAGEMENT,WEB_CONVERSION

But the problem is that I’m getting UNAUTHORIZED error when I tried to do it through powershell script
whereas request is successfull when I used Postman
{“errors”:[{“code”:“UNAUTHORIZED_ACCESS”,“message”:“This request is not properly authenticated”}],“request”:{“params”:{}}}
Base URL for this one is “https://ads-api.twitter.com/4/stats/accounts/18ce53zx1fm”

is that the correct base URL for the ad performance report?

[juanshishido]

Base URL for this one is “https://ads-api.twitter.com/4/stats/accounts/18ce53zx1fm”

is that the correct base URL for the ad performance report?

Yes, that’s the correct URL for our synchronous analytics endpoint.

Please see the following post for information about why you might be seeing the 401 HTTP status code even though the GET accounts/:account_id/campaigns request works.

Guidance for UNAUTHORIZED_ACCESS issues

If you’re seeing UNAUTHORIZED_ACCESS issues with the stats endpoints (e.g., GET stats/accounts/:account_id) or with any endpoints that use reserved characters within URLs or POST bodies, please see this post. Please remember to encode reserved characters. Ensure that you’re encoding reserved characters appropriately within URLs and POST bodies before preparing OAuth signature base strings. Source