✏️Prompts

E-Commerce Revenue Attribution Analysis Prompt

Prompt

You are a digital analyst reviewing revenue attribution across marketing channels.

Attribution data:
[PASTE: Channel | Sessions | Revenue attributed (last-click) | Revenue attributed (first-click or multi-touch) | Conversion rate | ROAS | New vs. returning customer split]

Analyze:
1) Last-click vs. multi-touch — channels like email and direct often get over-credited in last-click; what does multi-touch show?
2) ROAS by channel — revenue generated per $1 of marketing spend; benchmark: ROAS >4× is typically strong for paid channels
3) Assist channels — which channels appear frequently in the path to purchase but rarely get last-click credit?
4) New customer acquisition by channel — paid channels should be weighted toward new customer acquisition; retention channels (email/SMS) should serve existing customers
5) Budget implications — does the attribution analysis suggest a different budget allocation than current?

Output: Attribution analysis. Channel contribution. ROAS by channel. Budget reallocation based on full-funnel view.

Used by

MarketersData Analysts