I think I found the answer at the following link
<https://support.google.com/google-ads/answer/2472708>.
It appears that the segments.keyword.info.text field is not available on
the search_term_view for shopping campaigns.
Although, the text says that a keyword will not be returned, it should
probably read, no shopping campaign data will be returned at all if this
field is selected. Or is this a bug?[image: Screen Shot 2021-09-02 at
16.21.20.png]
Is there any way around this?
On Thursday, 2 September 2021 at 3:34:39 pm UTC+1 Todd de Quincey wrote:
> Hi all,
>
> Like many, we are in the process of migrating from Adwords to Ads, but we
> have hit a snag with one of the reports.
>
> In Adwords, we generated a SEARCH_QUERY_PERFORMANCE_REPORT with the
> following Adwords Query Language statement (excl. WHERE clause).
>
> SELECT
> Date,
> Device,
> ExternalCustomerId,
> AdGroupId,
> CampaignId,
> CampaignName,
> KeywordTextMatchingQuery,
> Query,
> Clicks,
> Cost,
> Impressions
> FROM
> SEARCH_QUERY_PERFORMANCE_REPORT
>
> In the above, we received shopping campaign data (which is what we are
> most interested in).
>
> However, when I port this query to the Ads API, we do NOT get any shopping
> campaign data at all. The Ads query which we are using is below. Note, this
> is the query automatically generated by the Google Adwords to Ads migration
> tool.
>
> SELECT
> segments.date,
> segments.device,
> customer.id,
> ad_group.id,
> campaign.id,
> campaign.name,
> segments.keyword.info.text,
> search_term_view.search_term,
> metrics.clicks,
> metrics.cost_micros,
> metrics.impressions
> FROM
> search_term_view
>
> I have not been able to find any documentation which states that shopping
> campaign data is not available from the search_term_view.
>
> With that background in mind, I have three specific questions:
>
>1. Is shopping campaign data available at all in the Ads
>search_term_view?
>2. Presuming it is not available, can someone point me to some
>documentation for this?
>3. Again presuming is it not available, is there a way of getting the
>search terms for shopping campaigns?
>
>
> Hopefully that paints the full picture, but if not, please let me know and
> happy to provide more details.
>
> Many thanks in advance
>
> Todd
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/a5a33d47-94e1-4904-9412-b982b1100f91n%40googlegroups.com.