Missing Search Terms

[Lukas St]

I am trying to retrieve all Search Terms via the Google Ads PHP API.

However, I noticed that a lot of them are missing. After investigation I found out that API  returns only those terms that belong to the type SEARCH campaigns. Others types are ignored. I don't understand why it works like this since when I click in Google Ads UI, the table containing these search terms has all of them in it.

My GAGL query that returns search terms that belong to SEARCH campaigns looks as follows:

SELECT
search_term_view.resource_name,
ad_group.id,
ad_group.status,
campaign.id,
search_term_view.ad_group,
search_term_view.resource_name,
search_term_view.search_term,
search_term_view.status,
segments.keyword.info.match_type,
segments.date,
metrics.clicks,
metrics.impressions,
metrics.ctr,
metrics.average_cpc
FROM search_term_view
WHERE segments.date DURING LAST_7_DAYS AND

When I try to specify other campaign types, I get 0 results, despite in the UI these search terms exist:

...FROM search_term_view
WHERE segments.date DURING LAST_7_DAYS AND campaign.advertising_channel_type IN ('DISPLAY', 'SHOPPING')

How can I get all Search terms?

Best,
Lukas.

[Google Ads API Forum Advisor Prod]

Hi Lukas,

Thanks for reaching out. The Ads API should mirror the Ads UI, although the Ads API only includes a subset of features and capabilities found in the UI. Please allow me to submit a feature request on your behalf to include other advertising channels. 

Regards,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2HBQJH:ref

[Lukas St]

Hello Matt,

Thanks for the reply. It seems a bit weird that such a basic feature - getting all search terms - using the search_term_view does not work as intended.
In some paid Google Ads tools I saw that they are getting all search terms, so I reckon it has to be possible, do you perhaps have an idea about direction how to get all search terms?

Best,
Lukas.

[Lukas St]

Hello Matt,

I managed to get shopping campaigns by just removing attributes from my GAQL, but I have no idea why it works like that:

This GAQL will return 0 results:

SELECT
            search_term_view.resource_name,
            ad_group.id,

            campaign.id,
            search_term_view.ad_group,
            search_term_view.resource_name,
            search_term_view.search_term,
            search_term_view.status,
            segments.keyword.info.match_type,
            segments.date,

            ad_group_ad.ad.name,
            metrics.clicks,
            metrics.impressions,
            metrics.ctr,
            metrics.average_cpc,
            metrics.average_cost,
            metrics.all_conversions_value,
            metrics.all_conversions_value_per_cost,
            metrics.conversions,
            metrics.all_conversions
            FROM search_term_view
            WHERE segments.date during LAST_30_DAYS AND campaign.advertising_channel_type = 'SHOPPING'

But when I remove some attributes from it, I will get shopping campaigns:

SELECT
            search_term_view.resource_name,
            ad_group.id,
            ad_group.status,
            campaign.id,
            search_term_view.ad_group,
            search_term_view.resource_name,
            search_term_view.search_term,
            search_term_view.status,

            ad_group_ad.ad.name
            FROM search_term_view
            WHERE segments.date during LAST_30_DAYS AND campaign.advertising_channel_type = 'SHOPPING'

This doesn't make sense because according to the query builder in documentation of the search_term_view, I should be able to use all of the attributes no matter what the campaign type is..

Best,

Lukas.

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@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/OE4UDPJLmpM/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/8a2c1d8a-c47c-41d0-b190-f02f20c10fe2n%40googlegroups.com.

[Lukas Everads]

It was this column that prevented showing the shopping search terms "segments.keyword.info.match_type"

Best,
Lukas.

[Google Ads API Forum Advisor Prod]

Hi Lukas,

Glad to see that the shopping terms are showing. You mentioned earlier that you were unable to unable to get display campaigns as well -- has removing the match type segment allowed you to get terms from display campaigns?

Thanks,