Blank CPC Bid from KEYWORDS_PERFORMANCE_REPORT

[Daniel King]

Hello, 

I am trying to recreate a report from Google Ads using the API. The report that was created in the GUI has a field called 'Keyword max CPC' which as far as I can tell corresponds to the 'CpcBid' in the keyword performance report. The problem I am running into is that almost 40% of the CpcBid values are blank ('--") when I pull data from the API, when none of those values are blank in the report download from the GUI. 

I am using Python for the query and here is the AWQL.

    # Create report query.

    report_query = (adwords.ReportQueryBuilder()

                    .Select('AccountDescriptiveName',

                            'Device', 

                            'Week', 

                            'CampaignName', 

                            'Criteria',

                            'AdGroupName', 

                            'KeywordMatchType',

                            'CpcBid', 

                            'AccountCurrencyCode',

                            'CampaignStatus', 

                            'AdGroupStatus', 

                            'Status', 

                            'QualityScore',

                            'Impressions', 

                            'Clicks',

                            'Ctr', 

                            'Cost',

                            'AverageCpc', 

                            'Conversions', 

                            'SearchImpressionShare')

                    .From('KEYWORDS_PERFORMANCE_REPORT')

                    .Where('Status').In('ENABLED','REMOVED','PAUSED')

                    .Where('CampaignName').DoesNotContainIgnoreCase('metro')

                    .Where('Cost').GreaterThan(0)

                    .During('LAST_WEEK')

                    .Build())

    report_downloader.DownloadReportWithAwql(   

          report_query, 

          'CSV', 

          output,

          skip_report_header=False,

          skip_column_header=False, 

          skip_report_summary=False,

          include_zero_impressions=True)

    output.seek(0)

    google_campaigns = pd.read_csv(output,

                                   sep=',',

                                   encoding='utf-8-sig',

                                   header=1,

                                   error_bad_lines=False,

                                   warn_bad_lines=False

                                   )

Attached you will find images of the problem with a screen shot of data retrieved from the api "api_bid_results' and from the gui 'gui_bid_results'. 

This is the only field causing this problem. Also, the CpcBid's that are populating occur in all campaigns and ad groups regardless of cpc source and regardless of account. 

Thanks, 

Danny

[Daniel King]

Just a heads up, there is this post. But I assume that individual solved the problem in a private message with the respondent. 

[Google Ads API Forum Advisor Prod]

Hi Daniel,

Thank you for reaching out. What is your client customer ID?

Regards,
Mitchell
Google Ads API Team

ref:_00D1U1174p._5001USx4K8:ref