My database calls were incorrect, disregard this issue. On Friday, May 4, 2018 at 12:41:27 AM UTC-5, tyler....@springventuregroup.com wrote: > > 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.
-- 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/40ae7ee2-8968-42ab-9fa1-8cd1402e7d53%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
