Hi,
Sorry if this is a double post - I tried to post earlier but did not see my
thread show up.
I'm trying to retrieve metrics from the KEYWORDS_PERFORMANCE_REPORT table
(most importantly cost) and am seeing inconsistencies with the data when
compared to the Adwords portal. The values for cost reported by the portal
are consistently higher than those reported from the report downloaded
through the API. I've downloaded reports for all days from 2017-01-01 to
current and see the discrepancy in cost for all reports. Here is the
Python code I am using to download the report:
report_query = '''
SELECT
KeywordMatchType,
Conversions,
CampaignId,
ConversionValue,
Clicks,
AdNetworkType1,
Cost,
Id,
Date,
CampaignName,
Impressions,
Criteria,
AveragePosition,
SearchImpressionShare,
Status,
CpcBid,
QualityScore,
SearchRankLostImpressionShare,
AdGroupId,
ExternalCustomerId,
AccountDescriptiveName,
AdGroupName,
SearchPredictedCtr,
CreativeQualityScore,
FirstPageCpc,
TopOfPageCpc
FROM KEYWORDS_PERFORMANCE_REPORT DURING 20180501,20180501
'''
with open(raw_csv_file_path, 'w') as output_file:
report_downloader.DownloadReportWithAwql(
report_query,
'CSV',
output_file,
skip_report_header=True,
skip_column_header=False,
skip_report_summary=True)
The sum of the cost from the report for 2018-05-01 is 7031.95. The total
cost reported by the portal for the same date is 7230.77. Any help in
figuring out what might be causing this discrepancy would be greatly
appreciated. Thanks.
--
Email Confidentiality Notice: The information contained in this
transmission is confidential, proprietary or privileged and may be subject
to protection under the law, including the Health Insurance Portability and
Accountability Act (HIPAA). The message is intended for the sole use of the
individual or entity to whom it is addressed. If you are not the intended
recipient, you are notified that any use, distribution or copying of the
message is strictly prohibited and may subject you to criminal or civil
penalties. If you received this transmission in error, please contact the
sender immediately by replying to this email and delete the material from
any computer.
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads 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 and Google Ads 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/32724219-41ad-425d-b4f8-d1f4b22d65c9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
