📢 Marketing

Marketing Analytics Readout: Channel Performance From Export

Turn a pasted channel export into a marketing analytics readout: what changed, reasons to verify, budget questions, and a test plan, with no invented numbers.

0.0
0Reviews
P
October 10, 2026

Prompt

Act as a marketing analyst who writes weekly and monthly channel readouts for a marketing lead: what changed, how sure we can be, and what to do next, using only the numbers in the export.

Inputs:
- The export, pasted as CSV or a table (channel or campaign rows, spend, sessions, conversions, revenue, or whatever columns exist): [ChannelExport]
- The two periods being compared and their dates: [ComparePeriods]
- The business goal and the one metric that matters most (for example qualified leads, trial starts, first orders): [NorthStarMetric]
- Known events in the period (launches, price changes, tracking changes, outages, holidays, budget shifts): [KnownEvents]
- Attribution model or source of the numbers (GA4 default channel group, ad platform reported, CRM): [AttributionSource]
- Output format: [Format]

Generate:
1. A data check: columns found, periods found, rows with missing or zero values, and any sign of a tracking break (a channel at zero, conversions without sessions). If the export cannot answer the question, say what column is missing.
2. A headline summary in three sentences: the change in NorthStarMetric between ComparePeriods, the biggest mover, and the one thing the lead should decide.
3. A channel table computed from ChannelExport: channel, metric for each period, absolute change, percent change, and cost per NorthStarMetric where spend exists. Show the arithmetic basis so it can be checked.
4. Mix versus rate: for the biggest mover, say whether the change came from more volume (sessions, clicks) or a better or worse conversion rate, using the columns available.
5. Likely explanations to verify: link moves to KnownEvents where the timing fits. Label each as "fits the data" or "needs checking", never as proven cause.
6. Attribution caveats specific to AttributionSource, for example platform reported conversions that overlap, or direct traffic absorbing untagged links.
7. Three actions ranked by expected impact and effort: one budget question, one fix (tracking or landing page), and one test.
8. A test plan for the top test: hypothesis, metric, audience or channel, run length rule of thumb stated as an assumption, and what result would change the decision.
9. Questions for the lead that the data cannot answer.

Constraints:
- Use only numbers in ChannelExport or arithmetic on them. Never invent benchmarks, industry averages, or totals.
- Round percentages to one decimal and say when a base is too small to trust (for example fewer than about 30 conversions), stated as a judgment call.
- Correlation is not cause. Write "consistent with", not "caused by".
- Plain language for a non analyst reader.

Instructions

Paste a real export (CSV text or a table) into [ChannelExport]. Works on ChatGPT, Claude, and Gemini; for large files use ChatGPT data analysis or Claude with file upload. Check every number the model reports against your source.

Generated Output

This image was generated using the prompt above.

Marketing Analytics Readout: Channel Performance From Export - Result

Examples

Example Input

ChannelExport:
channel,period,spend,sessions,trial_starts
Paid Search,Sep,4200,6100,183
Paid Search,Aug,4000,5900,177
Paid Social,Sep,3000,7400,62
Paid Social,Aug,3000,5200,78
Organic Search,Sep,0,9800,140
Organic Search,Aug,0,9600,138
Email,Sep,0,1900,71
Email,Aug,0,2300,96
ComparePeriods: August vs September 2026
NorthStarMetric: trial starts
KnownEvents: New Paid Social creative launched Sep 3. Email newsletter skipped one send in September.
AttributionSource: GA4 default channel group, last click
Format: sections with a table

Example Output

1. DATA CHECK
Columns: channel, period, spend, sessions, trial_starts. Two periods, four channels, no missing values. No tracking break visible.

2. HEADLINE
Trial starts went from 489 in August to 456 in September, down 33 (6.7%). The biggest drop was Paid Social, which got more sessions but fewer trials after the new creative. Decide whether to roll back or iterate the Sep 3 creative.

3. CHANNEL TABLE
| Channel | Aug | Sep | Change | % | Cost per trial Aug / Sep |
| Paid Search | 177 | 183 | +6 | +3.4% | 22.60 / 22.95 |
| Paid Social | 78 | 62 | -16 | -20.5% | 38.46 / 48.39 |
| Organic Search | 138 | 140 | +2 | +1.4% | n/a |
| Email | 96 | 71 | -25 | -26.0% | n/a |
Basis: cost per trial = spend / trial_starts.

4. MIX VS RATE (Paid Social)
Sessions rose from 5,200 to 7,400 (+42.3%) while the session to trial rate fell from 1.50% to 0.84%. The drop is a rate problem, not a volume problem: the new creative brings more clicks that convert less.

5. LIKELY EXPLANATIONS
- Paid Social: consistent with the Sep 3 creative attracting lower intent clicks. Fits the data.
- Email: consistent with one skipped send (sessions down 17.4%). Fits the data; confirm send count.
- Paid Search and Organic: flat within normal noise. No action.

6. ATTRIBUTION CAVEATS
Last click in GA4 gives Paid Social little credit for people who later return through Organic or Direct. Check the platform report before cutting spend, but do not add the two together.

7. ACTIONS
1 Budget question: hold Paid Social spend flat until the creative test reads out. 2 Fix: restore the missed email send. 3 Test: old vs new creative.

8. TEST PLAN
Hypothesis: the August creative converts sessions to trials at a higher rate. Metric: session to trial rate. Split budget 50/50 for two weeks (assumption; extend if either arm has under about 30 trials).

9. QUESTIONS THE DATA CANNOT ANSWER
Are September trials converting to paid at the same rate? Did the landing page change on Sep 3 too?

Reviews (0)

Please login to leave a review.
Loading reviews...