Run everything you never had time to implement. Define your process once, and keep it

running with Qore.
Qore > Skills > Trellis Managed: Brand vs Non-Brand Splitr
Report and Review

Trellis Managed: Brand vs Non-Brand Split

Tags every customer search query as branded or non-branded, then tracks spend, sales and ROAS for each side, week by week, across the window you set.
Standard
·
7 steps
Amazon
READS
Your ad data
Your search term data
LOOKS FOR
Queries carrying your brand name, and the ones that do not
PRODUCES
A weekly split of spend, sales and ROAS
YOU
Read where the money sits, and decide how to weight it
Overview

What it looks at, what it classifies, what comes back, what you can change.

What it looks at
Customer search queries, week by week
  • Search term reports across the lookback window you set
  • Spend, sales, impressions and clicks on every query
  • Trellis-managed and non-Trellis campaigns, side by side
What it classifies
Every query tagged Branded or Non-Branded
  • Queries containing your brand keyword, matched case-insensitively
  • Several brand terms at once, separated by a pipe
  • Queries below your minimum ad spend left out
What comes back
A weekly split of spend, sales and ROAS
  • One row per week, brand type, campaign source and term type
  • ROAS computed from summed spend and sales, never averaged
  • Manual and auto targeted queries kept apart
What you can change
Four settings, per run, without editing the skill
  • Lookback days and brand keyword
  • Minimum ad spend and marketplace
  • Same skill re-pointed at any Amazon account

Branded and non-branded spend, week by week

Search term report · sample

Sample figures. Your own numbers appear the first time the skill runs.

Run Settings
The four things this skill asks you to set.
Lookback days
How many days of search term data to read. The weekly series covers this window; go longer on lower-traffic accounts.
Brand keyword
The term that marks a query as branded. Enter one, or several separated by a pipe. Matching is case-insensitive.
Min ad spend
The floor a query must clear to be counted, so dormant terms stay out of the weekly totals.
Marketplace
Which Amazon marketplace the analysis runs against. Change it to repeat the same split on another account.

Frequently Asked Questions

This is some text inside of a div block.

The skill reads your Search Term Report, tags every customer query as Branded or Non-Branded on the brand keyword you set, and totals spend, sales and ROAS by week for each side.

How does it decide if a search term is branded?

A query is Branded if it contains your brand keyword. Matching is case-insensitive substring matching, and you can enter several brand terms separated by a pipe character.

Can I compare Trellis-managed campaigns against the rest of my account?

Yes. Every weekly row is broken out by campaign source, so Trellis-managed and non-Trellis spend, sales and ROAS sit next to each other for both Branded and Non-Branded queries.

Does this change my campaigns or keywords?

Does this change my campaigns or keywords?

How is ROAS calculated here?

Spend and sales are summed first for each week and segment, then ROAS is computed from those totals. Weekly ROAS figures are never averaged together.

Can I run the same brand analysis on more than one account?

Yes. Change the brand keyword and marketplace and the same skill runs against any Amazon account you have connected.

Start
Provisioned on your account at signup.
Try Qore
Often run with
Skills that pair with this one.
Report and Review
Brand vs Non-Brand Analyzer
A weekly split of spend, ad sales and ROAS between branded and non-branded search.
Standard
Amazon
Catch Problems Early
Branded Share of Voice
How much of your own branded search results you hold, and where a competitor is taking share.
Standard
Amazon
Walmart
Report and Review
SQPR Brand Share Deep Dive
A share-of-intent read on every query in your category, branded and non-branded, side by side.
Standard
Amazon
Use cases
Catch problems early
Defend your branded terms

Competitors bid on your brand, your defense CPC climbs, and you find out when the invoice does.

Ads
3 skills
Amazon
Walmart

Every one of these runs on your own account.

Sign up, connect an account, and install a skill. The first run produces a real result you can look at before you schedule anything.
Try QoreBrowse The Skill Library