Close Variant Analyzer

Paste up to 100.000 Query/Keyword pairs with related KPIs

Analyze how googles close variant matchings perform in your account

  • FREE ONLINE TOOL for analyzing googles keyword matching
  • Paste up to 100.000 Query/Keyword combinations together with related KPIs (optional)
  • Get for each Query/Keyword combination a score for their similarity (how it is done)
  • Use results for e.g. adding negative keywords or understanding why your performance gets worse
See your results like this – click image to enlarge:

How does the Close Variant Analyzer work?

1) Paste your data

The first 2 Columns should contain keyword and query. You can add some additional metrics if you like. If you only want to focus on close variant matching you have to filter your input data. Of course you also use it for analyzing phrase, broad or modified broad keyword matches.

2) Download File

After some seconds the report should be ready and you can download it. Your provided data will have one new column. This column will have values from 0 to 100 and describes the similarity between the keyword and the matched query. The higher the score the closer the match.

How to use the data for further analysis?

How do the worst matches look like?

This was the first thing I was looking at. What is the worst example of a query to keyword match I can find? You will find it right away when you sort by the matching score in ascending order.

How does the matching change over time?

If you add a time period like month to your input data you can group by that and look at the average matching quality over time. Feel free to weight the matching scores with impression or clicks. This perspective is very interesting for understanding how they force the close variant matches. The end of the exact match keywords seems to be coming.

Matching Quality vs. Conversion Rate

What does the matching similarity means for your conversion rate? To get answers based on big numbers you can group your performance metrics (if you provided them in your data input) by the matching similarity. If you like you can create bigger buckets like 0-10, 11-20, …, 91-100 to get even bigger numbers per bucket.
Based on your performance numbers you can then use the matching score to derive negative keywords. Extra tip: score also the “not significant” queries that are hidden in google ads but still available in google analytics.

Worst Matches of Close Variants
Worst Matches of Close Variants
I was quite surprised what google is matching to exact keywords.
Matching Quality over time
Matching Quality over time
Close Variants get more fuzzy over time. Google is forcing this heavily.
Matching Quality vs. Conversion Rate
Matching Quality vs. Conversion Rate
Poor Close Variant Matches do not convert that well.

Read more about close variant matches in google ads