Trend intelligence

Turn Google Keyword Planner exports into theme-level search trend analysis for any category: growth, velocity, seasonality and top searches. You supply the category searches and the keyword buckets; Open Trends reports what is moving. Free, open source and runs entirely in your browser.

About FAQ
^

Drop a Google Keyword Planner export

XLSX, XLS or CSV. The tool looks for a keyword column, an AMS / average monthly searches column, and monthly date columns.

Category definitions

Upload your keyword buckets as a dictionary (.json, .xlsx, .xls or .csv): one row per theme, with a boolean query or a list of terms. The example file shows the expected columns (Theme, Query).

Example data

A small Google Keyword Planner export with the expected columns (keyword, AMS, 48 monthly columns) to try the tool.

Category definitions

Each key is a theme (your keyword bucket); each value is either a boolean query or a plain list of terms. Queries support OR, AND, NOT, NEAR/3, parentheses, "quoted phrases", */? wildcards and #hashtags, and are matched against the words of each search term - so (vanilla OR caramel) NEAR/3 (perfume OR candle) NOT (recipe) behaves as written. Term lists keep the older forgiving substring matching (whole words for terms of 4 characters or fewer).

These options keep bare ingredient searches inside a theme. The first also accepts a product word, so "sandalwood candle" counts as Woody even though the definition only lists scent, fragrance, perfume, aroma, smell, bouquet and note. The second also accepts a search that is only notes and filler words, so "sandalwood" counts too - while "vanilla extract" and "rose garden" stay out. They only matter for queries written as term near context; plain term lists are unaffected.

Brand & product dictionary

Brands and formats are optional. Each key is a brand or a product type, and the value is a list of aliases matched against keywords the same way as terms. The bundled lists are a fragrance starter set; replace them with your own. Signature product names are included as aliases, so "santal 33" counts as Le Labo. Product types classify the format being searched for (candle, perfume, air freshener, wax melt).

When on, an unmatched search is attributed to a brand if one of its aliases is within one edit of a search word, and only when exactly one brand matches. Use it for messy exports; leave it off for clean data to avoid false positives.