Using excel, how do I find out if I have duplicate keywords or keywords that would bid against eachother?

Forum White Hat SEO PPC Using excel, how do I find out if I have duplicate keywords or keywords that would bid against eachother?

  • This topic has 4 replies, 1 voice, and was last updated 1 month ago by SSearGG.
Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #10381
    seohelper
    Keymaster

    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!

    #10383
    greg-asquith

    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!

    #10382
    Moty_M

    Make a column with keyword&match type and check the duplicates.
    Or use editor – it has a tool for this.

    #10384
    SSearGG

    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.

    #10385
    SSearGG

    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

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Scroll to Top