Hi Ryan,
Thanks for following up on our earlier discussion via the forum. If you
were using the AdWords API directly, you could issue separate Keywords
Performance Report
<https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report>
requests
to get the *SearchImpressionShare* metric at the keyword level and at the
keyword+week level by excluding and including the *Week* column (and any
other date-related columns), respectively. However, I took a look at the
Google
Ads Report transformation page
<https://cloud.google.com/bigquery/docs/adwords-transformation#column_mapping_for_google_ads_reports>,
and I noticed that the BigQuery Data Transfer Service for Google Ads
appears to always include the *Week* column in its reporting requests. As a
result, you'll only get the keyword+week level value for
*SearchImpressionShare* in your BigQuery *KeywordStats* table.
Note that the situation is similar for other reports, not just the Keywords
Performance Report. For example, to get *SearchImpressionShare* calculated
at the ad group and ad group+week level, you'd need two API requests for
the Ad Group Performance Report
<https://developers.google.com/adwords/api/docs/appendix/reports/adgroup-performance-report>:
one without the *Week* column requested, and one with the *Week* column
requested.
The API returns "< 10%" because it mirrors what is available in the user
interface. Via the Google Ads UI, you'll see the same result if you look at
the *Keywords* view and add the *Week* segment.
I'm not familiar with all the options offered by the Transfer Service, but
is there a way for you to create another set of tables for a given API
report, where you customize the selected fields used for each table? If so,
you could add a new table where the corresponding API request does not
include *Week*, *Date, DayOfWeek*, etc.
Thanks,
Josh, Google Ads API Team
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://googleadsdeveloper.blogspot.com/search/label/adwords_api
https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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].
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/1a0mkl8000000001045nua003q8380z6cmjie1m6oo30c1g68q3ce9j%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
