Hi,
I'm running an 'Account Performance Report' API request using AWQL via
Python 3.6.
- We have basic access against a production MMC account. Seems to work
fine.
- I'm pulling for several child clients and appending the results into a
single file. Seems to work fine.
- I'm pulling for duration 'YESTERDAY' - which also seems to work fine.
The day field is coming correctly and the report header also shows the
expected values.
- Everything seems to execute correctly - I get a populated TSV file for
all the child clients but the impressions/cost are vastly overstated.
- This same thing is happening for my KEYWORDS_PERFORMANCE_REPORT.
- I've attached a CSV of what I get when pulling the same request from
the portal - which is more in line with reality. This is production data.
Here is my report builder statement:
# Initialize appropriate service.
try:
report_downloader = client.GetReportDownloader(version='v201710')
# Create report query.
report_query = (adwords.ReportQueryBuilder()
.Select( 'AccountDescriptiveName'
, 'Date'
, 'Impressions'
, 'Clicks'
, 'Cost')
.From('ACCOUNT_PERFORMANCE_REPORT')
.Where('Clicks').GreaterThan(0)
.During('YESTERDAY')
.Build())
except Exception as e:
print (e)
logger.exception(e)
sys.exit(1)
Here's what my down loader looks like:
# Download the report data
report_downloader.DownloadReportWithAwql(
report_query, 'TSV', file, skip_report_header=False,
skip_column_header=True, skip_report_summary=True,
include_zero_impressions=False)
Here is what's returning in my report TSV file. I replaced our company
name with XXX at the beginning of each header line.
- Each child account is represented as it should be.
- The dates in the report header line and day field are correct.
- The impressions, clicks, and cost are incredibly high (bold and
underlined the first example). We've never spent that much in our entire
time with Google.
- I noticed in the Keywords Performance versions (also pulled for
yesterday) that the cost measures are very odd - 30000, 100000 - very even
and large.
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX PLA 2018-02-25 *5871848 60698 25662830000*
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX Brand 2018-02-25 44766 23918 1382870000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX Product 2018-02-25 514570 5985 3358990000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX - Product - Mobile 2018-02-25 611296 7905 2354500000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX Seasonal Occasion 2018-02-25 52871 706 630970000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX - Seasonal Occasion - Mobile 2018-02-25 110549 959 275630000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX Evergreen 2018-02-25 81661 2488 2186640000
"ACCOUNT_PERFORMANCE_REPORT (Feb 25, 2018)"
XXX - Evergreen - Mobile 2018-02-25 98888 2054 1021680000
Please let me know if there's something I'm doing wrong and how I should
adjust my code.
Thank you in advance.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and Google+:
https://googleadsdeveloper.blogspot.com/
https://plus.google.com/+GoogleAdsDevelopers/posts
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API Forum" group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups
"AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/d3467636-fa0d-4c63-a18b-0bc03f2f5eb5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Name account balance report
Type Account
Frequency One time
Date range Yesterday
Dates 25-Feb-18
Account Day Clicks Impressions Cost Avg. position
xxx PLA 2/25/2018 60699 5871846 "25,663.10" 0
xxx Seasonal Occasion 2/25/2018 706 52871 630.97 2.3
xxx Evergreen 2/25/2018 2488 81661 "2,186.64" 2.4
xxx Product 2/25/2018 5985 514570 "3,358.99" 2.9
xxx Brand 2/25/2018 23918 44766 "1,382.87" 1.1
xxx - Seasonal Occasion - Mobile 2/25/2018 959 110549 275.63 2.8
xxx - Product - Mobile 2/25/2018 7905 611296 "2,354.50" 2.9
xxx - Evergreen - Mobile 2/25/2018 2054 98888 "1,021.68" 2.6
