Re: Google Ads script and Adwords API results are different for the same account
Hi Bharani
I am attaching the python logs with the includeZeroImpressions param is set
to True.
Still not getting any result for clientCustomerId': '3366472162'.
And here is the report query:
cols = ['Date', 'CampaignId', 'CampaignName', 'AdGroupId', 'AdGroupName',
'Clicks', 'Cost', 'Conversions',
'AccountCurrencyCode', 'Id', 'Criteria', 'KeywordMatchType',
'AccountTimeZone', 'AllConversions',
'Impressions']
report_query = (adwords.ReportQueryBuilder()
.Select(",".join(cols))
.From('KEYWORDS_PERFORMANCE_REPORT')
.Where('Cost').GreaterThan(0)
.During('LAST_7_DAYS')
.Build())
Thank you
ilkin
On Wed, Jun 19, 2019 at 4:54 PM Google Ads API Forum Advisor Prod <
adsapiforumadvi...@gmail.com> wrote:
> Hello,
>
> The shared Python logs indicate that the includeZeroImpressions field is
> set to false. Could you please set this to true and share the report
> definition if you are still having an issue?
>
> Thanks,
> Bharani, Google Ads API Team
>
> ref:_00D1U1174p._5001UBnYB7:ref
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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 a topic in the
> Google Groups "AdWords API and Google Ads API Forum" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/adwords-api/Av8IWfDVKsw/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> adwords-api+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/adwords-api/zi9DX0PTCMM700mXZHblceTuSNUqM6hLtbTA%40sfdc.net
>
> .
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/CA%2BJUqpoV%2BpkXdY%3DrqUw_ZEdv-LCQrDXZHqfXt0PXDSJT1PKaKQ%40mail.gmail.com.
[2019-06-19 17:36:56,544 - bipy - DEBUG] Running adwords import.
[2019-06-19 17:36:56,544 - zeep.xsd.schema - DEBUG] Init schema document for
None
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}string',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}boolean',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}decimal',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}float',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}double',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}duration',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}dateTime',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}time',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}date',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}gYearMonth',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}gYear',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}gMonthDay',
)
[2019-06-19 17:36:56,545 - zeep.xsd.schema - DEBUG]
register_type(u'{http://www.w3.org/2001/XMLSchema}gDay',
)
[2019-06-19
Re: Google Ads script and Adwords API results are different for the same account
Hello, The shared Python logs indicate that the includeZeroImpressions field is set to false. Could you please set this to true and share the report definition if you are still having an issue? Thanks, Bharani, Google Ads API Team ref:_00D1U1174p._5001UBnYB7:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/zi9DX0PTCMM700mXZHblceTuSNUqM6hLtbTA%40sfdc.net.
Re: Google Ads script and Adwords API results are different for the same account
Hi Bharani
Thank you very much for your reply
My concern here is, google ads script returns Keyword performance reports
but python api does not.
What I am trying to do is reimplementing google ads scripts in python. Here
is the ads script that I use for testing:
As I said in my previous email, this script is named as "
adwords_test_ilkin"
https://ads.google.com/aw/bulk/scripts/edit?ocid=76814069=3402497&__u=4058262925&__c=1284189581=2.
When I run this ads script I can see in the logs that the query "SELECT
FROM KEYWORD_PERFORMANCE_REPORT ." returns results.
You can check the script history logs here :
https://ads.google.com/aw/bulk/scripts/logs?ocid=76814069=3896788069912395287&__u=4058262925&__c=1284189581=2
function main() {
var accountIterator =
AdsManagerApp.accounts().withIds(['336-647-2162']).get();
while (accountIterator.hasNext()) {
var account = accountIterator.next();
AdsManagerApp.select(account);
var accountName = account.getName() ? account.getName() : '(Unknown)';
var client_id = account.getCustomerId();
Logger.log("Starting report for " + accountName + " " + client_id);
var report = AdWordsApp.report(
'SELECT Date, CampaignId, CampaignName, AdGroupId, AdGroupName,
Clicks, Cost, Conversions, AccountCurrencyCode, Id, Criteria,
KeywordMatchType, AccountTimeZone, AllConversions, Impressions ' +
'FROM KEYWORDS_PERFORMANCE_REPORT ' +
'WHERE Cost > 0 ' +
'DURING LAST_7_DAYS');
var rows = report.rows();
while (rows.hasNext()) {
var row = rows.next();
Logger.log(row['Date'] + '\t' + row['CampaignId'] + '\t' +
row['Criteria'] + '\t' + row['KeywordMatchType'] + '\t' + row['Clicks'] +
'\t' + row['Cost']);
}
Logger.log("Ended report");
}
}
But when I try to run the same query "SELECT FROM
KEYWORD_PERFORMANCE_REPORT ." with the python sdk, the API does not
return anything. (includeZeroImpressions is set to True) I have already
attached python sdk logs, soap messages in the previous messages. Do you
need any other information for further debugging this issue?
Best regards.
On Tue, Jun 18, 2019 at 5:33 PM Google Ads API Forum Advisor Prod <
adsapiforumadvi...@gmail.com> wrote:
> Hi,
>
> I'm Ejay's colleague addressing your concern on his behalf. I was able to
> check the shared details. Could you please confirm if your concern is about
> the Keywords Performance Report not returning the details? If so, it looks
> like you are generating the report for LAST_7_DAYS. Please note that the
> account currently has Search, Display, Video and Universal App Campaigns.
> The Universal App Campaigns
>
> currently does not support Keywords Performance Report so this data will
> not returned. The last 7 days metrics for the other campaigns are zeros.
> You could set the includeZeroImpressions field to true to get the keywords
> data for other campaigns.
>
> Let me know if you have any other questions.
>
> Thanks,
> Bharani, Google Ads API Team
>
>
> ref:_00D1U1174p._5001UBnYB7:ref
>
> --
> --
> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
> 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 a topic in the
> Google Groups "AdWords API and Google Ads API Forum" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/adwords-api/Av8IWfDVKsw/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> adwords-api+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/adwords-api/L9eWL0PTATRA00s2GxXRykRAq7OHhk-Ic7FA%40sfdc.net
>
> .
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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
RE: Google Ads script and Adwords API results are different for the same account
Hi, I'm Ejay's colleague addressing your concern on his behalf. I was able to check the shared details. Could you please confirm if your concern is about the Keywords Performance Report not returning the details? If so, it looks like you are generating the report for LAST_7_DAYS. Please note that the account currently has Search, Display, Video and Universal App Campaigns. The Universal App Campaigns currently does not support Keywords Performance Report so this data will not returned. The last 7 days metrics for the other campaigns are zeros. You could set the includeZeroImpressions field to true to get the keywords data for other campaigns. Let me know if you have any other questions. Thanks, Bharani, Google Ads API Team ref:_00D1U1174p._5001UBnYB7:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/L9eWL0PTATRA00s2GxXRykRAq7OHhk-Ic7FA%40sfdc.net.
RE: Google Ads script and Adwords API results are different for the same account
Hi, Thanks for reaching out. To further investigate the issue, would you mind providing the complete SOAP request and response logs together with customer ID via Reply privately to author? If you haven't enabled the SOAP logging yet, you can enable it by following this guide for Python client library. Also, would you be able to provide the result that has been generated through Google Ads scripts and the name of the script so I can check it as well? Regards, Ejay Google Ads API Team ref:_00D1U1174p._5001UBnYB7:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/Uiyaq0PT82B90052ykJWkyTIWxXVCuDbaJUg%40sfdc.net.
