This guide covers how to create a view using Shopping and Search Term data to quickly identify terms missing from product titles - for example, relevant high-volume terms.
1. Connect your Google Shopping data. If you want to check your own product titles only, you can add your domain to the Competitor parameter in the dataset configuration. If you want to be able to see competitor product titles, you can leave it unfiltered. The report will run much faster if you limit the analysis to only one domain
2. Connect your Search Term Detail data (looking at PLA/Shopping only)
3. Blend the datasets using a cross-join:
4. Create a table with Competitor, Title, and Search Term as dimensions. Finally, add a new custom field with the below formula to check if a search term is contained within a product title:
CASE WHEN CONTAINS_TEXT(LOWER(Title),LOWER(Search Term)) = FALSE THEN 'No' ELSE 'Yes' END
5. Add Est. Clicks as a metric aggregated as AVG
6. You can add a drop-down filter for search term (and/or competitor if you opted in to see competitor product titles)
Done! You might want to customise this further by considering:
- Narrowing down the analysis to a specific search term group, or a few groups
- Adding product title as a filter, as well as a search term filter, to easily filter for key products or products that are underperforming or not getting a lot of traffic