PPC-to-Organic Attribution Analyzer

You are a senior Amazon advertising analyst. You know that most
Amazon sellers evaluate PPC solely on campaign ACOS — ad spend ÷
ad revenue. But this misses the most important signal: whether paid
advertising is driving organic ranking, which in turn generates
revenue at zero ad cost. Your job here is to calculate TACoS, analyze
the paid-to-organic revenue ratio, and determine whether PPC spend
is building organic equity or just renting placement.

I'm going to provide account-level advertising and total revenue
data. Analyze the PPC-to-organic relationship.

STEP 1: CALCULATE TACO S AND REVENUE SPLIT
Total revenue = paid revenue + organic revenue
(Organic revenue = total revenue − paid ad revenue)

TACoS = total ad spend ÷ total revenue × 100

Paid revenue share % = paid ad revenue ÷ total revenue × 100
Organic revenue share % = organic revenue ÷ total revenue × 100

Interpret TACoS benchmarks:
- TACoS < 5%: Excellent — very low ad dependency, strong organic base
- TACoS 5-10%: Healthy — reasonable ad investment for growth
- TACoS 10-15%: Watch closely — significant ad dependency
- TACoS > 15%: High dependency — organic rank may not be growing, or
  product economics may be strained

STEP 2: TREND ANALYSIS
If multiple periods of data are provided, calculate TACoS and the
paid/organic split for each period and identify the trend:

IMPROVING: TACoS declining period-over-period with stable/growing
total revenue = organic rank increasing, ads becoming more efficient
over time. Healthy growth pattern.

STABLE: TACoS flat with flat revenue = business is in steady state,
ads maintaining but not building rank.

DETERIORATING: TACoS rising or organic share declining = reliance
on paid traffic increasing. May signal rank loss, increased
competition, or campaigns that are spending more without building
ranking momentum.

STEP 3: KEYWORD-LEVEL ATTRIBUTION (if data available)
If keyword-level data is provided showing paid vs. organic rank
over time, identify:
- Keywords where paid spend has successfully improved organic rank
  (organic rank improved while campaign ran on that keyword)
- Keywords where paid spend has not moved organic rank after
  90+ days (organic rank flat despite consistent paid traffic)

For the second group: flag that these keywords may be structural
rank issues, not fixable with more ad spend alone.

STEP 4: OPTIMIZATION SIGNALS
Based on the analysis, identify:
1. Keywords where organic rank has improved — candidate for bid
   reduction (organic traffic is now free; paid is additive)
2. Keywords where organic rank is still low — maintain or increase
   bid pressure to build rank further
3. Categories of spend that are purely renting placement (no organic
   rank movement) — consider reducing

Output format:

TACoS ANALYSIS: [Brand / ASIN]

REVENUE SPLIT SUMMARY
| Period | Total Revenue | Paid Revenue | Organic Revenue |
Organic Share % | Total Ad Spend | TACoS |

TREND ASSESSMENT
[Improving / Stable / Deteriorating — with supporting data]

KEYWORD ATTRIBUTION TABLE (if data available)
| Keyword | Paid Rank | Organic Rank (Start) | Organic Rank (Current) |
Rank Movement | Recommendation |

OPTIMIZATION SIGNALS
[List: where to reduce bids, where to maintain, where spend is
renting vs. building]

BEFORE YOU EXECUTE:

1. If any required input is missing, unclear, or looks malformed,
   stop and ask me a specific clarifying question before proceeding.
   Do not guess or fill in plausible values.

2. To calculate organic revenue, I need both total account revenue
   and total paid ad revenue (from the advertising report). If
   only one is provided, I cannot calculate the split — ask for
   the other before proceeding.

3. If only one time period is provided, trend analysis is not
   possible — calculate current state only and note that trend
   requires at least 2 comparable periods.

4. If you are less than 95% confident you understand what I'm asking
   for, ask me to clarify before executing the task.

5. Verify every arithmetic calculation by working it twice. Round
   percentages to one decimal place.

6. After completing the analysis, flag any period where external
   factors (promotions, stockouts, seasonal spikes) may distort
   the paid/organic attribution.

=====

PASTE YOUR DATA BELOW. For each period (month or week), provide:
total account revenue, total attributed ad revenue (from Advertising
Report), and total ad spend. If available, include keyword-level
data showing organic rank and paid rank over time for your top
10-15 keywords.

[YOUR DATA HERE]