Key word table

[Sanjana Jose]

Hi ,

I would like full query to fetch complete search term table. I was able to fetch search terms using below query but couldn't map it to the corresponding keyword. Help me please.

 SELECT

          search_term_view.search_term,

          search_term_view.resource_name,

          metrics.impressions,

          metrics.clicks,

          metrics.cost_micros,

          metrics.all_conversions,

          segments.date

        FROM search_term_view

        WHERE campaign.id = {platform_campaign_id}

          AND segments.date BETWEEN '{start_date}' AND '{end_date}'

Regards,

Sanjana

[Google Ads API Forum Advisor]

Hi Sanjana,

Thank you for reaching out to the Google Ads API support team. 

Based on the information provided, I understand that you are trying to retrieve the data from the search_term_view report but finding difficulty to map the corresponding keyword and you are looking for guidance. As you are trying to retrieve the data from the search_term_view report the equivalent page in the Google Ads UI can be find under your Google Ads account > Campaigns Tab > Insights and reports > Search terms. From the results you have obtained from the search_term_view report in the API, I would recommend you to filter the same thing in your Google Ads account under the search terms page then try to match the data.

Kindly note that you haven't provided the customer ID and the campaign ID using which you are trying to retrieve the data. In order to further investigate from our end, I would request you to share the customer ID, campaign ID, date ranges of what you are using the GAQL query and the uncropped UI screenshot of your Google Ads account (with visible customer ID) by highlighting the fields and metrics of what you are trying to retrieve using the Google Ads API. 

You can send the details via Reply privately to the author option, or direct private reply to this email.
 

Thanks,
 

Google Ads API Team

Feedback
How was our support today?

               
[2025-05-22 16:55:07Z GMT] This message is in relation to case "ref:!00D1U01174p.!500Ht01qXvad:ref" (ADR-00307619)