I'm a self-confessed control freak about how search Real Estate Photo Editing queries match my campaign. Some things always slip through, but just looking at the search query report makes it easy to miss a query that consistently matches the wrong ad group. advertisement Continue reading below I found it much more useful to pull the data into Excel to create a quick pivot table. This visually reveals the matching problem. The first thing I want to do is display the search query. 4 important tips for auditing your Google Ads account I usually do this at the account level. Also, make Real Estate Photo Editing sure there are columns for campaigns and ad groups so that you can interact with them in the PivotTable . advertisement Continue reading below Download the terms and open .csv in Excel .
A long sheet is created with rows for your search Real Estate Photo Editing query and columns showing your campaigns and ad groups . This report is extremely useful because you may see duplicate search queries. Search queries that match many different ad groups can be very difficult to view or understand in the Google Ads Search Query Report view. Instead, create a pivot table from these rows of data. For the field, select Search Term for the row, and for the value, select Ad Group. This should be left aDoing this creates a table that looks like thvot This will quickly show you the search terms and the number of ad groups that match them, so you can quick groups. In Real Estate Photo Editing this particular example, it is the account structure that is replicated across many regions, so there are many ad groups with the same name. I expect it to match multiple times, but certainly not so many. Be careful if you find a term that matches multiple locations.
To do the short task of focusing on matching locations Real Estate Photo Editing in multiple locations within each campaign, tweak the pivot table a bit. Focus on matching criminals Drop in the Rows field below the existing search term area, in the order Campaignups . Make sure you also keep the number of ad groups in the Value field . You can then sort the number of ad groups from high to low to create a roadmap for one matching query and easily find the location of your campaigns and ad groups . advertisement Continue reading below This is how it renders when you do Real Estate Photo Editing this for a search query that matches in 32 places. I now know exactly where to add it as a negative: