Re: Why I get unexpected values from the KEYWORDS_PERFORMANCE_REPORT report

[Dannison Yao (AdWords API Team)]

Hi Yang,

Could you provide me the clientCustomerId you used so I could further check this? You may provide them to me using the reply privately to author option.

Regards,

Dannison

AdWords API Team

On Wednesday, November 21, 2018 at 5:26:01 AM UTC+8, yl...@pangeare.com wrote:

Hello All,

 

New to google adwords, now I am trying to fetch the data from keyword performance report. The following code is an example, based on the document (https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report ), I want to fetch some values from  attributes, segments and metrics altogether

report_downloader = client.GetReportDownloader(version='v201809')
columns=['AccountCurrencyCode', 'AccountDescriptiveName', 'Date', 'AbsoluteTopImpressionPercentage', 'SearchAbsoluteTopImpressionShare' ]
str=','.join(columns)
# Create report query.
report_query = (adwords.ReportQueryBuilder().Select( str).From('KEYWORDS_PERFORMANCE_REPORT').Where('CampaignStatus').In('ENABLED', 'PAUSED').During('LAST_7_DAYS').Build())

This report does return something, but the data returned is wired.

"USD"    "Pangea - Main"    "2018-11-18"   "0.00"         " "
"USD"    "Pangea - Main"    "0"            "0"            "0"
"USD"    "Pangea - Main"    "0.00%"        "0"            "0"
"USD"    "Pangea - Main"    "0"            "0"            " "
"USD"    "Pangea - Main"    "2018-11-19"   "0.00"         " "
"USD"    "Pangea - Main"    "0"            "0"            "0"
"USD"    "Pangea - Main"    "0.00"         "2018-11-16"   "0"

The third column (date) should be a date type, but as you can see, it has many wired data, same as the fourth and fifth column.

Can I really mix these three section together in one report?

Thank you

Yang

[yl...@pangeare.com]

Hi,

I think I found the reason, I parsed the returned CSV incorrectly. Sorry

Yang

[Dannison Yao (AdWords API Team)]

Hi Yang,

Glad you fixed the issue. Let me know if you have further clarifications with the AdWords API.

Regards,

Dannison

AdWords API Team