Skip to main content
Question

Displaying Non-Added AND Non-Excluded Search Terms into Pivot Table within the Looker Studio

  • June 10, 2025
  • 2 replies
  • 71 views

Aaron

Currently, I always create the following manually: 
I download all keywords that are neither excluded nor added to an ad group and then create a pivot table to display all search terms with more than X clicks. The pivot table is therefore relevant because search terms are only displayed once - Google usually displays them more than once.

Can I do this automatically via Supermetrics in looker studio? So far, I have only found “Matched Search Terms” in Supermetrics, which are exactly the search terms I don't want.

 

2 replies

Micah
Forum|alt.badge.img
  • June 18, 2025

Hi Aaron,
Could you please clarify where in the Google Ads UI you see the keywords that are neither excluded nor added to an ad group - and how/where you download these? Screenshots would be useful.
We can then review and check if the data source can support this.
Thank you

 


  • June 24, 2025

@Aaron 👀
Have you had a chance to see ​@Micahs question?