Conditions when the data of ’Dynamic Search Ads’ is missing in search_term_view.

[M.T]

Hello

I have a question regarding the output of 'Dynamic Search Ads' in the search_term_view.

1.

I wonder if selecting certain fields at the time of request would prevent  'Dynamic Search Ads' data from being output.

I know that the 'Dynamic Search Ads' data is missing when the following fields were selected.

segments.keyword.info.text
segments.keyword.info.match_type
segments.keyword.ad_group_criterion

Please let me know if there are any fields other than the above that can be conditions.

2.

In SEARCH_QUERY_PERFORMANCE_REPORT of Adwords API, I think that ’Dynamic Search Ads' data was output even if fields such as'KeywordId'and'KeywordTextMatchingQuery' selected.

For example,

・The following query in AWQL will output the DSA records.

SELECT
 CampaignId,
 CampaignName,
 Query,
 QueryMatchTypeWithVariant,
 KeywordId,
 KeywordTextMatchingQuery,
 Impressions,
 Clicks,
 Cost,
 Conversions
FROM SEARCH_QUERY_PERFORMANCE_REPORT

・On the other hand, when the following query, which is equivalent to the above specification, is executed in GAQL, the DSA record is missing.

SELECT
 campaign.id,
 campaign.name,
 search_term_view.search_term,
 segments.search_term_match_type,
 segments.keyword.ad_group_criterion,
 segments.keyword.info.text,
 metrics.impressions,
 metrics.clicks, 
 metrics.cost_micros,
 metrics.conversions
FROM search_term_view

Is this change a specification in the Ads API?

If I am missing something, I am sorry, but I could not find any mention of this change in the Ads API documentation, which is why I asked the question.

I kindly ask for your confirmation.

Thanks,

[Google Ads API Forum Advisor]

Hi there,

Thanks for reaching out to the Google Ads API Forum.

I can see that you’re having concerns regarding the output of 'Dynamic Search Ads' in the search_term_view using Google Ads API.

Since you mentioned that you observed missing DSA records using search_term_view via Google Ads API as compared with SEARCH_QUERY_PERFORMANCE_REPORT of Adwords API, then for us to investigate further, could you please provide us with the following details below?

• Provide complete AWQL containing date filters
• As for Google Ads API, provide complete GAQL with date filters for search_term_view
• Sample comparison of the Ads API and AdWords API where we can see the discrepancies
• Provide the customer ID

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias by referring to this thread.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2Yqxw6:ref

[M.T]

Hi,

Thank you for your reply.

>  Since you mentioned that you observed missing DSA records using search_term_view via Google Ads API as compared with SEARCH_QUERY_PERFORMANCE_REPORT of Adwords API,

>then for us to investigate further, could you please provide us with the following details below?

I sent you a sample with "Reply privately to author" earlier, so please check it.

And hopefully,

・Like the output in the Adwords API

・To be equivalent to the output at https://ads.google.com/aw/keywords/searchterms

I hope that DSA query data will be output even if keyword fields are specified in the Ads API.

I kindly ask for your confirmation.

Thanks,

2022年3月24日木曜日 23:29:39 UTC+9 adsapi:

[Google Ads API Forum Advisor]

Hi there,

Thanks for getting back to us with the requested information.

I took a look into your account for the search_term_view report, and I can see that segment fields are added in your query. I’ve replicated your issue of missing Ads API report data for Campaign ID 13660449816. Upon checking your GAQL, I found that segment fields such as Segments.search_term_match_type, segments.keyword.ad_group_criterion and  segments.keyword.info.text were added in your select clause causing this behavior. I was able to get the exact metrics count for Google Ads API as compared with your AdWords API report results. 

Kindly note that the added segments field returns empty or less data since it tells the query to retrieve only the rows of data that have said segment fields and remove any row that is not associated with those segments. The closest document I can share is from the segmentation guide I mentioned above, and in it, this section (When adding some segments, the metrics in the summary row may decrease) where it says :

"When <segments field> is added to a query with FROM <resource>, that segment is telling the query to only get the rows of data that have <segment field>, and remove any row that is not associated..." 

When you remove those segments from your query, then rows come back again. This is how segments work in the Google Ads API. Here’s the GAQL below:

SELECT

    segments.month,

    campaign.id,

    campaign.name,

    ad_group.id,

    ad_group.name,

    search_term_view.search_term,

    metrics.impressions,

    metrics.clicks,

    metrics.cost_micros,

    metrics.conversions

FROM search_term_view

WHERE  campaign.id = '13660449816' AND segments.date between '20220201' and '20220228'

Google Ads API metrics results:

"metrics": {

      "conversions": 247.62276,

      "impressions": "78985",

      "costMicros": "113091000000",

      "clicks": "11949"

    }

You may see below metrics retrieved for AdWords API:

"SEARCH_QUERY_PERFORMANCE_REPORT (Feb 1, 2022-Feb 28, 2022)"

Month,Campaign ID,Campaign,Ad group ID,Ad group,Search term,Match type,Keyword ID,Keyword,Impressions,Clicks,Cost,Conversions



Total, --, --, --, --, --, --, --, --,78985,11949,113091000000,247.62

As you can see, after removing segments from Google Ads API, the records match with the AdWords API.

Hope this clarifies. 

Regards,

[M.T]

Hi,

Thank you for your reply.

>When <segments field> is added to a query with FROM <resource>,

>that segment is telling the query to only get the rows of data that have <segment field>, and remove any row that is not associated...

In short, the situation is as follows?

・In the Adwords API, when a request was made including KeywordTextMatchingQuery, the value of this field was set to "--" but the DSA data was returned.

・On the other hand, in the Ads API, if a request includes segments.keyword.info.text, the DSA data is missing because there is no corresponding Segment.

・This change exists as a specification in the Ads API, and this point is mentioned in the ’ Selectability between segments and metrics'.

In that case, am I correct in interpreting that only the following three fields are subject to missing DSA?

>segments.keyword.info.text
>segments.keyword.info.match_type
>segments.keyword.ad_group_criterion

I think you are probably correct, but let me check just to be sure.

Sorry to bother you again.

Thanks,

2022年3月26日土曜日 0:04:48 UTC+9 adsapi:

[Google Ads API Forum Advisor]

Hi Mokoto,

Thank you for providing further details to your concern. I can say that your understanding is correct.

I would like to discuss that the keywords are not utilized in ad group dynamic search ads. With this, if you will add keyword related fields such as the following in the search_term_view with the specific filter for campaign, then you will encounter what is discussed here:
-segments.keyword.info.text
-segments.keyword.info.match_type
-segments.keyword.ad_group_criterion

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2Yqxw6:ref