Hello.

Currently, I'm trying to reproduce a report that was created in the Google 
Ads interface using the Google Ads API. This is not my ultimately goal, but 
it's necessary in order to check that I get the data that I see in the UI 
using the API.

In particular, I've been trying to map the columns

1. search keyword
2. quality score
3. landing page experience
4. exp. CTR 

to resources, metrics or segments in the API. However, I couldn't find the 
mappings. 

In this conversation, let me focus on the "Search Keyword" UI column. Then 
I will create other conversations for the other columns.

I thought that "search keyword" would correspond to e.g. "
*ad_group_criterion.keyword.text*". However, if I try to get the keyword by 
selecting them from the ad_group_criterion resource (like 
here https://developers.google.com/google-ads/api/docs/samples/get-keywords), 
the results do not match what I see in the UI. Specifically, if I create a 
report in the UI with the columns "Search Keyword" and "Ad Group ID", there 
are "82,230" results. However, if I execute the following query





*SELECTad_group.id,ad_group_criterion.keyword.textFROM 
ad_group_criterionWHERE ad_group_criterion.type = KEYWORD*

I get 98153 results. So, there's a clear discrepancy. Even if I add the 
condition: 

*ad_group_criterion.status != REMOVED*

to the WHERE part, I get 92637 results, which still doesn't match the ones 
from the UI. If I use the condition 

*ad_group_criterion.status = ENABLED*

I get 82081 results, which are closer to the 82,230 results, but still not 
the same. 
Here 
https://developers.google.com/google-ads/api/reference/rpc/v12/AdGroupCriterionStatusEnum.AdGroupCriterionStatus
 
are all the available status, apparently.

I even tried to get this data from the keyword_view with






*SELECT ad_group_criterion.keyword.text, ad_group.idFROM keyword_viewWHERE 
ad_group_criterion.status = 'ENABLED' AND ad_group_criterion.type = 
'KEYWORD'*

I still get the 82081 results.

So, my question is: *how can I match these 82,230 results using the API? 
What query should I run?*

Thank you for all the help.

-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/9e9ae68c-b7ba-44dd-8d89-99a8a8220ac2n%40googlegroups.com.

Reply via email to