I read somewhere using IN results in exact match of the keyword and if I
segments.keyword.info.text LIKE '%best video creator% like this, i can get
contains result of this keyword. Can you suggest how can i get the
"Contains" result. My goal here is to get the potential search terms which
can be used as search keywords. To filter the search terms i want to search
with added search keywords so that i can take the necessary results.
On Wednesday, January 29, 2025 at 3:37:46 PM UTC+5:30 Google Ads API Forum
Advisor wrote:
> Hi,
>
> Thank you for reaching out to the Google Ads API support team.
>
> To fetch the search term based on multiple keywords, you may try the below
> query:
>
>
> SELECT search_term_view.search_term, metrics.impressions, metrics.clicks,
> metrics.cost_micros, metrics.conversions, metrics.interactions,
> segments.date, segments.keyword.info.text FROM search_term_view WHERE
> ad_group.id = ##### AND campaign.id = ##### AND search_term_view.status !=
> 'EXCLUDED' AND metrics.impressions > 1 AND metrics.clicks > 1 AND
> segments.date BETWEEN '2024-11-01' AND '2024-11-30' AND
> segments.keyword.info.text IN ('keyword 1', 'keyword 2')
>
> Additionally, you can utilize the Query Builder
> <https://developers.google.com/google-ads/api/fields/v18/overview_query_builder>
> and Query Validator
> <https://developers.google.com/google-ads/api/fields/v18/query_validator> to
> build and validate your queries. To retrieve Google Ads API entities and
> reporting data, you can use one of these methods like
> GoogleAdsService.SearchStream
> <https://developers.google.com/google-ads/api/reference/rpc/v18/GoogleAdsService#searchstream>
> or GoogleAdsService.Search
> <https://developers.google.com/google-ads/api/reference/rpc/v18/GoogleAdsService#search>
> .
>
> If you face any issue while retrieving the above data for the above query,
> please share the complete API logs (request
> <https://developers.google.com/google-ads/api/docs/concepts/field-service#request>
> and response
> <https://developers.google.com/google-ads/api/docs/concepts/field-service#response>
> with request-id
> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id>
> and request header
> <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>)
>
> generated at your end.
>
> 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
> <https://developers.google.com/google-ads/api/docs/client-libs/java/logging>
> , .Net
> <https://developers.google.com/google-ads/api/docs/client-libs/dotnet/logging>
> , PHP
> <https://developers.google.com/google-ads/api/docs/client-libs/php/logging>
> , Python
> <https://developers.google.com/google-ads/api/docs/client-libs/python/logging>
> , Ruby
> <https://developers.google.com/google-ads/api/docs/client-libs/ruby/logging>
> or Perl
> <https://developers.google.com/google-ads/api/docs/client-libs/perl/logging>
> 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.!5004Q02vGyup:ref" (ADR-00286240)
>
> Thanks,
>
> [image: Google Logo] Google Ads API Team
> Feedback
> How was our support today?
>
> [image: rating1]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=5004Q00002vGyupQAC>
>
> [image: rating2]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=5004Q00002vGyupQAC>
>
> [image: rating3]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=5004Q00002vGyupQAC>
>
> [image: rating4]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=4&entry.295079254=5004Q00002vGyupQAC>
>
> [image: rating5]
> <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/formResponse?usp=pp_url&entry.141427034=5&entry.295079254=5004Q00002vGyupQAC>
>
>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 visit
https://groups.google.com/d/msgid/adwords-api/868b76b9-9916-4d71-a491-656a8c3a7689n%40googlegroups.com.
