Re: search terms report for performance max

[Moshe Shechter]

Hello,

The query you provided relates to the search term categories, not the 
search terms.  In order to get the search terms (denoted as a segment in 
the campaign_search_term_insight view) you require a further selection of a 
single search term insight ID as follows:

SELECT campaign_search_term_insight.campaign_id, 
campaign_search_term_insight.id, 
campaign_search_term_insight.category_label, 
campaign_search_term_insight.resource_name, 
segments.search_term, metrics.impressions, metrics.conversions, 
metrics.conversions_value FROM campaign_search_term_insight WHERE 
campaign_search_term_insight.campaign_id = 123456789 AND 
campaign_search_term_insight.id = 987654321 AND segments.date BETWEEN 
'2024-01-01' AND '2024-01-31'

In order to get all serach terms for a single campaign, it is first 
necessary to extract all search term categories via the query you provided, 
and then iterate over those IDs to extract the individual search terms. 

Some PMax campaigns have more than 10,000 search categories, requiring 
thousands of calls to Google Ads for a single campaign. That is a real 
problem

Moshik



On Monday, May 6, 2024 at 1:39:56 PM UTC+3 Google Ads API Forum Advisor 
wrote:

> Hi Moshik,
>
> Kindly note that it is not possible to retrieve all the search terms at 
> once from the Performance Max campaigns from the Google Ads API. However, 
> it is possible to retrieve the search terms data individually from each of 
> the Performance Max campaigns. If you try to retrieve the search terms data 
> for all the campaigns, it will result in a "
> REQUIRES_FILTER_BY_SINGLE_RESOURCE 
> "
>  error. 
> Please find the sample GAQL query for the same: 
>
>
> SELECT campaign_search_term_insight.campaign_id, 
> campaign_search_term_insight.category_label, campaign_search_term_insight.id, 
>  metrics.clicks, 
> metrics.impressions, metrics.conversions, metrics.conversions_value FROM 
> campaign_search_term_insight WHERE segments.date BETWEEN '2024-04-20' AND 
> '2024-05-06' 
> AND campaign_search_term_insight.campaign_id = '***'"
>
> Additionally, you can utilize the Google Ads Query Builder 
> 
>  
> and Query Validator 
>  
> to build and validate the queries for retrieving the data from the Google 
> Ads API.
>   
> This message is in relation to case 
> "ref:!00D1U01174p.!5004Q02rzHLQ:ref" (ADR-00224131)
>
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>  
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/d9eeb563-e328-49f2-9713-64e757b4d711n%40googlegroups.com.

Re: search terms report for performance max

['Google Ads API Forum Advisor' via Google Ads API and AdWords API Forum]

Hi Moshik,

Kindly note that it is not possible to retrieve all the search terms at once 
from the Performance Max campaigns from the Google Ads API. However, it is 
possible to retrieve the search terms data individually from each of the 
Performance Max campaigns. If you try to retrieve the search terms data for all 
the campaigns, it will result in a "REQUIRES_FILTER_BY_SINGLE_RESOURCE" error. 
Please find the sample GAQL query for the same:

SELECT campaign_search_term_insight.campaign_id, 
campaign_search_term_insight.category_label, campaign_search_term_insight.id,  
metrics.clicks, 
metrics.impressions, metrics.conversions, metrics.conversions_value FROM 
campaign_search_term_insight WHERE segments.date BETWEEN '2024-04-20' AND 
'2024-05-06' 
AND campaign_search_term_insight.campaign_id = '***'"

Additionally, you can utilize the Google Ads Query Builder and Query Validator 
to build and validate the queries for retrieving the data from the Google Ads 
API.
This message is in relation to case "ref:!00D1U01174p.!5004Q02rzHLQ:ref" 
(ADR-00224131)

Thanks,

Google Ads API Team

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/dQr8Q0SD289M009qvl6dHwQBS7-nkTWcvbDg%40sfdc.net.

Re: search terms report for performance max

[Moshe Shechter]

Hi,

The search terms are NOT available on the search_term_view for Performance 
Max campaigns. Search terms can be found by accessing a single campaign 
(filter by campaign ID) and a single campaign_search_term_insight 
(campaign_search_term_insight.id) in the campaign_search_term_insight view 

 
.  In order to get all search terms you would need to iterate over the list 
of search term insights (these are the search categories you see in the UI) 
for a particular campaign. Please be aware that similarly to the PMAX 
search term report in the UI - the data is quite confusing, and is cannot 
be aggregated. 

My follow up question is - is there a way to avoid the iteration? This 
process becomes almost impossible for campaigns with large numbers of 
categories. Has anybody been able to find a smarter way of doing this?

Moshik

On Tuesday, February 20, 2024 at 11:30:55 PM UTC+2 Google Ads API Forum 
Advisor wrote:

> Hi,
>
> Thank you for reaching out to the Google Ads API support team.
>
> After reviewing your concern, I understand that you want to retrieve 
> search term data via the Google Ads API. I would recommend you check the 
> search_term_view 
>  
> resource to get a search term view with metrics aggregated by search term. 
> Since campaign 
>  is one 
> of the attributed resources, you can get PERFORMANCE_MAX data by using the 
> proposed resource.
>
> Also, please go through Performance Max reporting 
>  
> to get the information, specifically campaign category is PERFORMANCE_MAX.
>
> I hope this helps. If the above proposed resources are not able to provide 
> your required information, please get back to us with an uncropped UI 
> screenshot with clear visibility of the customer ID, where you are able to 
> see the expected data that you want to retrieve via the Google Ads API, so 
> that we can assist you accordingly. 
> This message is in relation to case "ref:!00D1U01174p.!5004Q02rzHLQ:ref"
>
> Thanks,
>   
> [image: Google Logo] Google Ads API Team 
>
>
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/f986809f-d67b-4273-8f6e-141213a2249bn%40googlegroups.com.

Re: Search Terms report for Performance Max

[Bill Kimutai]

Hey Pere,

Did you succeed on this?

Regards, 
Bill

On Friday, November 24, 2023 at 1:42:55 PM UTC+3 Pere Munar wrote:

> Hi!
>
> I am interested in getting Search Term data for Performance Max campaigns. 
> Is there a report in the Google Ads API that allows for that? I tried to 
> use "Campaign search term" report but it does not return data for PMAX.
>
> Thanks a lot.
>
> Pere
>

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 
"Google Ads API and AdWords 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/52360caa-bed2-440d-8974-cb9353ecf5a3n%40googlegroups.com.