Hi,
I'm trying to use the KEYWORDS_PERFORMANCE_REPORT table to gather metrics
(most importantly cost). When I download the report the totals for cost do
not match the totals from the portal. It appears that the cost contributed
from each campaign in the downloaded report is consistently lower than what
is reported in the portal. I've downloaded reports using the API for every
day since 2017-01-01 and all reports seem to have this problem. Here is
the code I'm using to download the report using Python:
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 returned in the downloaded report for 2018-05-01 is
7031.94. The total cost reported by the portal for the same date is
7258.45.
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/6fd91334-9e14-47b6-86ad-ed319e6aaa06%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
