-
Using excel, how do I find out if I have duplicate keywords or keywords that would bid against eachother?
Hello all,
I’m trying to do some mass edits, and add some keywords into a specific adgroup on my account.
I have a really big account that I’m managing and wondering if anyone has used excel to find duplicate keywords, EXACT dupes, and PARTIAL dupes.
Exact dupes is easy to find using Conditional Formatting, but the partial dupes that may bid against eachother is much harder to find on a mass scale.
Thanks!
-
4 Replies
-
Are these/Have these keywords been live?
If so – you can pull a search term report segmented by keyword and see whats overlapping
Unfortunately due to how Google “matches” terms to keywords, even removing the same words from different keywords won’t guarantee no overlap – so worth pulling that report after you go live as well if you haven’t yet!
-
Make a column with keyword&match type and check the duplicates.
Or use editor – it has a tool for this. -
Quick note besides this, keywords within account will never bid against each other.
The way how it is determined which keyword joins the auction is based on which one has the highest quality score.
Removing duplicates helps reducing cluster but your cpc’s won’t decrease because of this. When you are on more broad match types and they are in the right ad groups, no need to remove duplicates either.
-
https://support.google.com/google-ads/answer/7502501?hl=en-GB&ref_topic=3119131
Here there is more information on this, what they possibly mean there is that they will compete with each other for which one is entering the auction
Log in to reply.