Why does my upload lose its header row or look shifted?

Both tools skip the first two rows of the file on read, because a raw Google Ads report export begins with two report-title lines before the real header. Upload the export exactly as Google Ads produces it; if you pre-clean the CSV so the header is on row 1, the header gets consumed as a skipped row.

What columns does the Bid Calculator require?

Two columns with the exact Google Ads export names 'Cost / conv.' and 'Bid adj.' (it stops with a message if either is missing). It also relies on the report's 'Total:' row to establish the campaign-average cost per conversion used as the benchmark, so do not delete the totals before uploading.

Why are some segments missing from the bid recommendations?

The output is a stacked adjustment: the new value is the existing bid adjustment plus the existing adjustment multiplied by the calculated percentage. Segments whose current bid adjustment is 0 or '--' therefore compute to no change and are dropped, as are segments already at their recommended value. The tool refines existing adjustments rather than proposing first-time ones.

How does the MPN Extractor decide something is a part number?

Any token containing at least one digit is treated as a model number, then unique tokens longer than the minimum length slider (default 4 characters, strictly greater) are kept. With 'Remove Sizes' enabled, tokens ending in mm, cm or ft (like 10mm or 6ft) are filtered out, and non-ASCII characters are stripped before processing.

Are keyphrases extracted per search term?

No. All search terms are joined into one text corpus and RAKUN2 runs once over the whole thing, so num_keywords (default 10) is the total number of keyphrases returned for the entire report, not per row. Raise it if the Key Phrases sheet feels thin.

Back to Tools

AdWords Tool Set

Use cases

Extracting product codes from search queries Finding brand mentions in search terms Optimising bids by device, location, or time PPC campaign optimisation

Multi-tool Streamlit framework with sidebar navigation between two Google Ads utilities.

MPN Extractor identifies manufacturer part numbers, brand names, and keyphrases from Search Term Reports.

Bid Calculator computes optimal adjustments across device types, geographic regions, and time periods based on cost per conversion data.

Streamlit App

Platform

Browser-based (no installation required)

Input

Google Ads Search Term Report (CSV) for MPN Extractor

Device/Location/Time report with Cost/conv and Bid adj columns for Bid Calculator

Output

MPN Extractor: Excel with extracted part numbers, unique words, keyphrases. Bid Calculator: CSV with recommended bid adjustments for devices, locations, and time periods.

Launch App View Source

Features

MPN extraction: digit-containing tokens above a minimum length (default 4)
Unique word list plus RAKUN2 keyphrase extraction across the whole report
Optional size token filter (mm, cm, ft)
Bid adjustment calculator for device, location, and time reports
Stacks recommended changes on existing bid adjustments only
Sidebar navigation between tools

How to use

1 Select a tool from the sidebar navigation
2 Upload the raw Google Ads export; the first two report-title rows are expected and skipped
3 MPN Extractor: select the search term column, then review MPNs, unique words, and keyphrases
4 Bid Calculator: include the exact Cost / conv. and Bid adj. columns and keep the Total row
5 Review the recommended bid adjustments
6 Download the results

Frequently asked questions

Why does my upload lose its header row or look shifted?: Both tools skip the first two rows of the file on read, because a raw Google Ads report export begins with two report-title lines before the real header. Upload the export exactly as Google Ads produces it; if you pre-clean the CSV so the header is on row 1, the header gets consumed as a skipped row.
What columns does the Bid Calculator require?: Two columns with the exact Google Ads export names 'Cost / conv.' and 'Bid adj.' (it stops with a message if either is missing). It also relies on the report's 'Total:' row to establish the campaign-average cost per conversion used as the benchmark, so do not delete the totals before uploading.
Why are some segments missing from the bid recommendations?: The output is a stacked adjustment: the new value is the existing bid adjustment plus the existing adjustment multiplied by the calculated percentage. Segments whose current bid adjustment is 0 or '--' therefore compute to no change and are dropped, as are segments already at their recommended value. The tool refines existing adjustments rather than proposing first-time ones.
How does the MPN Extractor decide something is a part number?: Any token containing at least one digit is treated as a model number, then unique tokens longer than the minimum length slider (default 4 characters, strictly greater) are kept. With 'Remove Sizes' enabled, tokens ending in mm, cm or ft (like 10mm or 6ft) are filtered out, and non-ASCII characters are stripped before processing.
Are keyphrases extracted per search term?: No. All search terms are joined into one text corpus and RAKUN2 runs once over the whole thing, so num_keywords (default 10) is the total number of keyphrases returned for the entire report, not per row. Raise it if the Key Phrases sheet feels thin.

Want me to run this for you?

I run this tool as a managed service, or build something custom around your data. You get the insights without touching the code.

Tell Me What You Need

Keyword GrouperAppKeyword Research

Group similar keywords using PolyFuzz TF-IDF fuzzy matching at scale.

Category Keyword FinderAppKeyword Research

Discover new category opportunities by extracting n-grams from product titles.

Keyword Trends AnalyserAppKeyword Research

Analyse keyword trends using Google Trends to find rising and declining topics.

Topical Map GeneratorAppKeyword Research

Use AI (GPT-4o) to organise keywords into hierarchical topical maps.

DataForSEO Keyword SuggestionsAppKeyword Research

Get keyword suggestions with search volumes from DataForSEO API.

Hreflang Tag GeneratorBrowserTechnical SEO

Generate correct hreflang tags for international SEO.

Need something built for your business?

This tool started as bespoke client work. I build custom scripts, data pipelines, and full apps for SEO and product data problems that off-the-shelf tools don't solve.