For PPC and SEO managers, and the agencies that run both

See which search terms you pay for that also bring you organic clicks

Your paid search terms sit in Google Ads and your organic queries sit in Search Console. Drop in a download from each, or Google's own paid and organic report, and every query lands on one line.

  • Every query listed as in both, paid only or organic only
  • Paid impressions, clicks, cost, conversions and CPC beside organic clicks, impressions and average position
  • You set an organic position; the page counts the queries in both at or below it and their paid cost
  • An optional brand pattern splits every count and total into brand and other queries
Buy Now, $19 One-time purchase. Runs in your browser.

Search Console leaves out anonymised queries, and a download holds at most 1,000 rows. The page prints how many Search Console query rows it received, so you can see what it had to work with.

Use the same date range in both downloads. The files do not carry dates this tool can check. Your files are read inside your browser. Nothing is uploaded.

Two downloads, one list. The numbers stay yours to read.

Columns are matched by name on upload, and you can choose a different column if Google names one differently in your account.

01

Plain matching

Queries are matched after lowercasing and collapsing spaces. Nothing else is merged: "crm-pricing" and "crm pricing" stay separate.

02

Match types added up

A search term that shows up under several match types, ad groups or campaigns is added into one line, and the page shows how many rows it came from.

03

Your position setting

Set a position from 1 to 100. A query meets it when its organic average position is at or below your number. The page does not say what to do with them.

04

Linked accounts too

Google's paid and organic report has no Cost column, so paid cost there is ad clicks × Ad avg. CPC, and the page says so beside the total.

Built by Mulkern AI Systems. A matching tool for your own account data, nothing more.

Google's paid and organic report needs Search Console linked to your Google Ads account. When the accounts are not linked (a client's Search Console download, for example), the search terms option covers it.

Avg. CPC in that report is rounded to the cent, so totals worked out from it can differ by a few cents from your account.

One-time purchase
$19one-time

Pay once, keep it. Runs offline once installed, on desktop or phone. No account, no sign-in, no upload.

Buy Now, $19

What's included

  • Reads a Google Ads search terms download and a Search Console Queries download (CSV or TSV)
  • Or reads Google's paid and organic report on its own
  • Column matching on upload, editable, remembered by column names only
  • Both, paid only and organic only, with a filter by class
  • A position setting you choose from 1 to 100, counted at or below your number
  • An optional brand pattern that splits counts and totals into brand and other
  • One CSV download with every query and every figure
  • Light and dark themes, installable, runs offline