Keywords in UI do not match with keywords in keyword_view endpoint

36 views
Skip to first unread message

Adrián Alfaro

unread,
Dec 22, 2023, 7:46:50 AM12/22/23
to Google Ads API and AdWords API Forum
Hi,
I am triying to obtain the keywords used in a specific ad group with this query:

SELECT ad_group.id, ad_group_criterion.keyword.text, ad_group_criterion.keyword.match_type, metrics.clicks FROM keyword_view where ad_group.id = XXXXXXXXXX"

With this query, I am obtaining 25 results, 7 keywords are match_type = BROAD and 18 keywords are match_type = EXACT. That last type of keywords are the ones generated from the BROAD keywords (also, the sum of clicks from EXACT keywords is the same as the sum of clicks from BROAD keywords).

Up to this point, everything is correct, the thing is, when I check in the UI it just appears the 7 BROAD keywords that are the ones that I originally put when I created the adgroup (I am just using the filter for the adgroup_id).

I want to get the same results as in the UI so I tried to filter them. However, I would like to bring data from multiple adgroups at the same time, so I can't filter all the keywords with match_type = EXACT, because I can lose keywords from other agroups where the keywords were orignally added as EXACT.

My questions with all this long explanation is:
Is there any way to identify this "generated" keywords so I can filter them?
Is there any way to link the original BROAD keyword with the generated keyword?

Maybe I am also misunderstanding how BROAD keywords work, in that case I would also appreciate if you correct me.
Thank you in advance!

Google Ads API Forum Advisor

unread,
Dec 22, 2023, 12:54:01 PM12/22/23
to adrian...@manifiesto.biz, adwor...@googlegroups.com
Hi,

Thank you for contacting the Google Ads API support team.

By reviewing your concern, I understand that you are facing the data discrepancy between the UI and API in the reports. In order to investigate your issue further, kindly provide us with the complete API logs (request and response with request-id and request header) generated at your end and uncropped UI screenshot of where you are facing the discrepancies.

If you are using a client library and haven't enabled the logging yet, I would request you to enable logging for the specific client library that you are using. You can refer to the guides Java, .Net, PHP, Python, Ruby or Perl to enable logging at your end. For REST interface requests, you can enable logging via the curl command by using the -i flag.

You can send the details via Reply privately to the author option, or direct private reply to this email.
 
This message is in relation to case "ref:!00D1U01174p.!5004Q02r3Hkr:ref"

Thanks,
 
Google Logo Google Ads API Team


Reply all
Reply to author
Forward
0 new messages