

The process involves finding a unique identifier for each ad, concatenating components of the ad, and then using the countif function in Excel to determine duplicates.

Never fear, there is a way to bulk-pause duplicate ads. Identify and Pause Duplicate Ads With or Without Tracking Parameters In order to retain this list, copy and paste these into Excel, revert the Dedupe campaign, and proceed with your normal keyword upload process. Revert the keywords that are shown in this viewĪt this point, the keywords that remain in the “New” ad group are those that do not exist in the rest of the account. Click on the “New” ad group in the campaign treeġ0.

Only select the box next to your fake Dedupe campaignĩ. Click Tools and then Find Duplicate Keywords in AdWords EditorĦ. Upload these sheets into AdWords Editorĥ. Assign them to the Dedupe campaign in an ad group called “New “Ĥ. Create a keyword upload sheet with the keywords you want to add to the account but do not know if they exist in a different order. Create a keyword upload sheet with these keywords in a fake campaign called “Dedupe” and assign them to an ad group called “Current”ģ. Copy and paste all active BMM keywords into and Excel fileĢ. This method involves creating a new campaign (that you will later revert and NOT post) and using the Find Duplicate Keywords Tool in AdWords Editor. Beyond your normal deduplication process, try this Excel/AdWords trick and avoid creating a massive number of unnecessary BMM keywords. Although, history should be considered before removing two of the variations! The best way to deal with expanding your account and excluding keyword variations that capture the same traffic is to be proactive in your new keyword expansions. There is no reason for all of them to be in the account. Well, the truth is that each of these keywords will capture the same traffic. Have you ever looked at your account and seen that you are bidding on a group of BMM keywords as listed below? Identify Broad Match Modified (BMM) duplicate keywords I’d like to share with you two processes that help complete heavy lifting cleanup tasks. Beyond Excel and the desktop tools, individually you must think outside the box and come up with new ways they can work together as you seek solutions to your everyday tasks. Accounts require constant TLC, a solid understanding of Excel, as well as desktop editing tools as accounts grow in scale. As we all know, in the world of search, our job is never done.
