Brand/Non-Brand Splitter
Free, no signup. Classify GSC queries or Ads search terms with exact, substring, typo-tolerant, and common spacing variants. Optionally import reviewed labels to audit the split and discover candidate aliases. Your CSV stays in this browser.
Search Console export limit: the UI can return only about 1,000 representative rows, and privacy-anonymized queries are omitted. Treat every analysis as a view of the exported sample, not the complete query set.
Or paste CSV
Site passport Local context for this saved site
Local data
Saved targets, named lists, and recent check summaries remain only in this browser.
Rate this tool
Runs entirely in your browser — nothing you paste is uploaded or stored. Anonymous run-level outcome counters may be used for aggregate research; URLs, domains, IPs, and identifiers are never included, and no statistic is released below 100 runs.
How to use it
- Enter one brand term per line. Include the official name and genuinely distinct names people use; spacing and simple typos are handled automatically.
- Choose a GSC or Ads CSV, or paste the table. The file must contain a recognized query or search-term column. To audit classifications, add a
Reviewed classcolumn withBrandorNon-brand. - Select Split rows. Check the row totals and the exact, contains, and fuzzy match counts.
- Resolve any reviewed-label disagreements. Verify candidate aliases before adding them to the brand terms, then rerun and export.
Example output Example data
With brand terms Acme Widgets and Acme, these fictional rows demonstrate the actual matching order.
What you get
Brand rows and non-brand rows are mutually exclusive and keep the original header and columns. The method summary counts brand classifications by the first successful method: exact, then contains, then fuzzy. A review disagreement appears only when an imported human label contradicts the matcher. A candidate brand variant is repeated evidence to investigate, not a confirmed alias.
How it works
Brand terms and queries are lowercased and normalized for punctuation and spacing. For each term, the matcher also creates a compact version and adjacent-character-swap variants. It checks full-query equality first, substring containment second, and bounded edit distance against individual query tokens last. Rows are written back with CSV-safe escaping.
Features
- Reads common GSC, Ads, and keyword-tool query headers.
- Preserves every original column in two downloadable CSV files.
- Handles spacing variants, adjacent letter swaps, and limited misspellings.
- Compares optional independent reviewed labels with the automatic split.
- Suggests repeated terms from reviewed false negatives as aliases requiring approval.
Limitations
- Fuzzy matching can produce false positives for short or dictionary-word brands.
- Without an imported reviewed-class column, the tool cannot independently know that its own classification is wrong.
- Alias suggestions require at least two reviewed false negatives and still need human verification; frequent generic words can be poor aliases.
- The tool does not recognize brands semantically, translate names, or infer parent/sub-brand relationships.
- Aggregate “other search terms” rows are treated like ordinary input rows because this UI does not infer platform suppression semantics.
- Files larger than 10 MB are rejected; split them before analysis.
Frequently asked questions
What counts as a branded search query?
A row is branded when its query or search term exactly matches, contains, or closely misspells one of the brand terms you provide. Everything else is placed in the non-brand export.
Which CSV columns can the splitter read?
It recognizes a query column named Query, Top queries, Search term, Search terms, or Keyword. All other columns are preserved in the exported CSV.
How can I check the automatic classifications?
Add an optional Reviewed class, Expected class, Ground truth, or Manual class column containing Brand or Non-brand. The tool reports only rows where that independent label disagrees with its automatic classification.
Are suggested brand variants added automatically?
No. A candidate is shown only when a term repeats across at least two independently reviewed brand rows that the matcher missed. You must verify it before adding it to the brand terms.
How does typo-tolerant matching work?
The matcher creates normalized spacing and adjacent-character-swap variants, then allows a small edit distance against individual query tokens: one edit for short terms and up to two for longer terms.
Can fuzzy matching misclassify generic words as brand?
Yes, especially when a brand term is also a common word or is very short. Review the split and use the exact, contains, and fuzzy match counts as a quality-control prompt.
Does the splitter upload my search data?
No. Files up to 10 MB are read, classified, and exported locally in your browser.
Feature requests for Brand Nonbrand Splitter
Upvote what you want most. New ideas can be submitted from the floating Feedback menu; requests appear here once approved, and the most-wanted rise to the top.
You won't be emailed about that request anymore.
Loading…
➕ Request a feature
New requests are reviewed before they appear here.
Sobre a ferramenta
Grátis, sem cadastro. Classify GSC consultas ou Ads pesquisa termos com exato, substring, typo-tolerant, e comum spacing variants. Optionally importar revisado labels para auditar o split e descobrir candidate aliases. Seu CSV stays em este navegador.
Split GSC ou Google Ads consulta linhas em brand e non-brand CSVs, compare optional revisado labels, e surface aliases que precisa humano revisão.
Recursos
- Adicione um optional Revisado classe, Esperado classe, Ground truth, ou Manual classe column containing Brand ou Non-brand. O ferramenta relatórios somente linhas onde que independent rótulo disagrees com seu automatic classification.
- Reads comum GSC, Ads, e keyword-tool consulta cabeçalhos. Preserves cada original column em dois downloadable CSV files. Handles spacing variants, adjacent letter swaps, e limited misspellings. Compares optional independent revisado labels com o automatic split. Suggests repeated termos de revisado false negatives como aliases requiring approval.
- O matcher creates normalized spacing e adjacent-character-swap variants, então allows um pequeno editar distance against individual consulta tokens: um editar para short termos e up para dois para longer termos.
- Selecione Split linhas . Verificação o linha totals e o exato, contains, e fuzzy correspondência counts.
Como funciona
O matcher creates normalized spacing e adjacent-character-swap variants, então allows um pequeno editar distance against individual consulta tokens: um editar para short termos e up para dois para longer termos.
Limitações
- Fuzzy correspondente pode produzir false positives para short ou dictionary-word brands. Sem um imported reviewed-class column, o ferramenta cannot independently know que seu own classification é incorreto. Alias suggestions exigir em least dois revisado false negatives e ainda precisa humano verificação; frequent generic words pode ser poor aliases. O ferramenta faz não recognize brands semantically, translate names, ou infer parent/sub-brand relationships. Aggregate “outro pesquisa termos” linhas são treated like comum entrada linhas porque este UI faz não infer platform suppression semantics. Files larger than 10 MB são rejected; split them antes analysis.
- Sim, especially quando um brand termo é also um comum word ou é very short. Revisão o split e usar o exato, contains, e fuzzy correspondência counts como um quality-control prompt.
Perguntas frequentes
O que conta como uma consulta de pesquisa de marca?
A linha é de marca quando seu consulta ou pesquisa termo exatamente corresponde, contém, ou de perto erro de grafia um de o marca termos você fornecer. Everythndo else é placdo em o non-brand exportação.
Quais CSV colunas pode o splitter leitura?
ele recognizes a consulta coluna namdo consulta, principais consultas, pesquisa termo, pesquisa termos, ou palavra-chave. todo outro colunas are preservadas em o exportados CSV.
Como verifico como classificações automáticas?
Add um opcional revisado classe, esperado classe, referência verdade, ou manual classe coluna containndo marca ou Non-brand. o ferramenta relata apenas linhas onde que independent rótulo discorda com seu automatic classificação.
Are sugerido marca variantes adicionadas automaticamente?
não. A candidato é mostrado apenas quando a termo repeats em todo em pelo menos two independentemente revisado marca linhas que o correspondência missdo. você deve verificar ele antes adicionar ele para o marca termos.
Como typo-tolerant correspondência work?
o correspondência creates normalizada espaçamento e adjacent-character-swap variantes, então allows a pequeno edição distância contra individual consulta tokens: um edição para curto termos e up para two para mais longo termos.
pode difuso correspondência classificar incorretamente genérico palavras como marca?
Yes, especialmente quando a marca termo é também a comum palavra ou é very curto. revisão o divisão e usar o exatos, contém, e difuso corresponder contagens como a quality-control prompt.
faz o splitter enviar my pesquisa dados?
não. arquivos up para 10 MB are leitura, classificados, e exportados localmente em seu navegador.