Just a heads up, there is this post
<https://groups.google.com/forum/#!searchin/adwords-api/CpCBid|sort:date/adwords-api/1ngfymJy3ww/r7ITM0YIAwAJ>.
But I assume that individual solved the problem in a private message with
the respondent.
On Wednesday, January 29, 2020 at 9:03:34 AM UTC-5, Daniel King wrote:
>
> 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
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/1f03fdb7-621e-40cd-9925-7e2ec67cee23%40googlegroups.com.
