How to fetch spend data accurately (or as per local timezone)?

Balraj Singh

unread,

Sep 30, 2020, 3:17:53 PM9/30/20

to AdWords API and Google Ads API Forum

I am using `ACCOUNT_PERFORMANCE` Report Type to fetch Spend amount of few CustomerIDs. I'm using Adwords' ReportQueryBuilder to

Select ('ExternalCustomerId ', 'Cost' )

From ('ACCOUNT_PERFORMANCE_REPORT')

During(start_date=start_dt, end_date=end_dt)

However the `cost` value of report output is different from that of platform (Google Ads UI).

For eg.

I have a customer Id XXX-XXX-XXXX that has 3 Account Budgets (Status: 1 Active and 2 Ended) :

BudgetOrderId: 0005-8146-XXXX

Start Date: Nov 1,

End Date: 2019Jul 31, 2020

BudgetAmount: CA$1,227,971.38

Spend: CA$1,226,444.23

Status: Ended

However, the report output is:

Cost: 1228818.07

I'm trying to understand the discrepancy. Thanks in advance.

Google Ads API Forum Advisor Prod

unread,

Sep 30, 2020, 3:57:55 PM9/30/20

to bal...@stackpros.com, adwor...@googlegroups.com

Hi Balraj,

Thanks for reaching out. With regards to your concern, can you please provide complete report defination and screenshot of the UI along with customer id so that i can further investigate the issue.

Thanks,

Nirmitabahen Gaurav Patel
Google Ads API Team

ref:_00D1U1174p._5004Q25YBq4:ref

Balraj Singh

unread,

Sep 30, 2020, 4:31:33 PM9/30/20

to AdWords API and Google Ads API Forum

Thanks for quick reply Gaurav, I couldn't turn on `reply to author` option. Would you mind providing an alternate email address where I can send the requested information?

Thanks