Discard
GuidesAPI ReferenceChangelogDiscussions
GuidesAPI ReferenceChangelogDiscussionsLog In

Discussions

Ask a Question
Back to All

Statistics Report - Show Cost in local (billing) currency & USD

Hi,

I am building an automated report to pull cost data for numerous markets into a Gsheet - refreshing each day with the previous 7 days' worth of data. I have been able to get all the relevant data in USD using the following request snippet:

url = "https://api.criteo.com/2022-04/statistics/report"

payload = "{"dimensions":["Advertiser","Day"],"metrics":["Displays","Clicks","AdvertiserCost"],"timezone":"UTC","format":"CSV","currency":"USD"," + f""startDate":"{start_date}","endDate":"{end_date}"" + "}"

headers = {
"Accept": "text/plain",
"Content-Type": "application/*+json",
"Authorization": f"Bearer {token}"
}

However, I need to pull in cost in the local currency in addition to USD (two separate columns). Do you know if there is a simple way to do this without creating a new request for each individual account and relevant currency?

Thanks