English Español Deutsch Français Italiano Português (Brasil) Русский 中文 日本語 한국어 Tiếng Việt

Weekly Wisdom with Joel Bondorowsky: Prevent Ad Keyword Cannibalization in a Few Simple Steps

Weekly Wisdom with Joel Bondorowsky: Prevent Ad Keyword Cannibalization in a Few Simple Steps

Joel Bondorowsky

Modified Transcript


Hello to all the amazing internet marketers out there.As you know, advertisers that have keywords which are triggered by the same search term compete with one another in what is called the Ad Auction. But you may be surprised to find that before this happens, there is an internal auction inside of your own Google ads account, where you could be essentially competing with yourself!

That is right, different keywords in your own campaign compete with each other in an internal auction, when they match with the same search term. The winning keyword will be the one with the highest ad rank. This leads to a loss of control of the traffic that your campaign brings. An ad group with tailor-made ads for particular terms may lose its traffic to another group. And if it becomes necessary to lower bids on a particular word, the traffic that the keyword was bringing may hop to another keyword in another group.

Which is why today I am going to explain to you how to run a report to identify if and where this is happening and then explain to you what you need to do in order to fix the problem, which we will do on the ad group level.

Extracting The Data

We need to run and download a search term report for all campaigns that are targeting overlaps.There are several ways to do this, but for today’s lesson, I will show how to do it from the reporting section in Google Ads.

Extracting the data

  • After logging into your account, click on the reports icon.

  • Click "Custom" to create a custom report.

  • Select "Table".

  • Next, you will want to filter the campaigns groups you would like to analyze for this report. It is important that you only choose campaigns which can compete with themselves due to similar settings, such as geography and device. To enable the filter, click the filter icon, then choose campaign from the dropdown. Next, choose the relevant campaigns and apply.

  • Now you will want to set the appropriate date range.

  • And we are ready to create the table:

    • For rows

      • Campaign

      • Ad group

      • Search keyword

      • Search term

    • For columns

      • Just impressions.

  • Next, click on the download icon.

  • Select Excel .csv.

  • The report will automatically download when ready.

  • Google gives you the option to save this report to easily create it again in the future. As well as scheduling the report.

Creating the Report

Now that the report has downloaded, go ahead and open it up in Excel.

Creating the report

  • First, you will want to save your report as an Excel workbook file or .XLSX

  • Next, we will need to concatenate campaign names and ad groups; this is to distinguish from ad groups in different campaigns that have the same name.

    • First, add a column before column A.

    • In the cell to the left of the “campaign name” column, concatenate column b of that row, with column c of that row, separated by a ^ symbol.

    • Next drag down the formula all the way down column A.

  • Now we will create a pivot table which is where we will run our analysis.

  • To do this, click on "insert" and choose pivot table.

  • Select the appropriate table range.

  • Place “search term” as the first row and “campaign^ad group” right under it.

  • And impressions as values.

  • Collapse rows so that only the search terms are shown.

  • Then sort impressions from largest to smallest.

  • Now you are looking at what is essentially a search term report. If you expand one of the rows, you will see which ad groups brought in the traffic.

  • Next, let’s make it easier to see which search terms are falling into more than one ad group by adding “count of ad group” to values.

There are two ways to prevent search terms falling into more than one ad group. The first is to remove the keyword that is triggering the term, but sometimes removing the word is not an option. When this happens, you will need to use negative keywords to channel traffic into the right groups.

Say, for example, you have are advertising mobile phone chargers. You built your campaign into multiple ad groups. One ad group has the keyword “phone chargers” in phrase match, and another has the keyword “android phone chargers”. Both of these keywords can match with the term, android phone charger, thus they are both competing for the same term in the internal ad auction. You can eliminate this by putting the negative word, -Android in the phone chargers group. Now the ‘phone charger’ won’t serve for any search with the word Android in it. Those words will thus get a bid for the traffic that they are designated for, as will the words in the Android group. Each group will also have more targetted ads for the traffic they are serving to.

This concludes my Weekly Wisdom session. I hope you found it useful.

SEMrush Academy PPC Course

Joel Bondorowsky


Joel Bondorowsky can be described as a true PPC addict. The last thing he does before bed is check his stats, which is also the first thing he does after waking up. It is his love for the job that feeds this addiction. He dabbled with his first small campaigns back in 2000, when PPC was at its infancy. However, it wasn’t until 2010, when he started working at Wix.com, when he got into more extreme PPC. After leaving Wix, Joel started a boutique ad agency called Quality Score where he managed some of the largest PPC campaigns in history. Today, he serves as the SEMrush Academy PPC professor s well as founder of PPCDesigns, a new boutique agency providing tailor made marketing solutions for large, mass market activities.
您的反馈必须包含至少 3 个单词(10 个字符)。

我们只会使用您的电子邮件,以回答您的反馈。 隐私政策