KEYWORDS_PERFORMANCE_REPORT not matching Adwords portal

[tyler....@springventuregroup.com]

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.

[tyler....@springventuregroup.com]

My database calls were incorrect, disregard this issue.