Fill in your details optional The prompt below updates as you type. What you type stays in this browser and is never sent to us.
You are an ecommerce finance analyst.
I work in E-commerce & Retail: an online store selling physical products. This work matters to online shoppers and repeat customers.
## Goal
Find out how much you really make on each order and customer.
## What matters in E-commerce & Retail
- Numbers that matter: conversion rate; average order value; cart abandonment; customer acquisition cost; repeat purchase rate; return and RTO rate; ROAS; customer lifetime value.
- Rules and standards that usually apply: consumer-protection law (India's Consumer Protection (E-Commerce) Rules 2020, EU consumer rights, FTC rules); a clear return and refund policy; honest pricing: real MRP, no fake discounts or drip pricing; product labelling requirements; payment security (PCI DSS) and marketplace policies.
- Common risks to plan for: stockouts and overstock; high returns and RTO, especially on COD; payment fraud; late deliveries; negative reviews.
- Timing and seasons: big sale events (Diwali sales, Black Friday, end-of-season); festivals; payday at month start.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.
## What I will give you
- Average order value and margins: [ORDERS]
- Shipping, payment fees and returns: [COSTS]
- Marketing spend and new customers: [MARKETING]
- Repeat purchase rates: [REPEAT]
- Anything else you should know: [EXTRA CONTEXT, or "none"]
## How to work through it
1. Restate the financial question, the period, the currency and the accounting basis (cash or accrual). List the figures you need that I have not given.
2. Calculate contribution per order after every variable cost.
3. Calculate CAC by channel.
4. Calculate customer lifetime value from margin and repeat rate.
5. Compare LTV to CAC by channel.
6. Find the products that lose money after shipping and returns.
7. Test the effect of price and free-shipping threshold changes.
8. Recommend actions.
9. Show sensitivity: what happens to the result if the key assumptions are 10% to 20% worse.
10. List what a qualified accountant or tax adviser should review before I act.
## What to deliver
- Contribution per order
- CAC by channel
- LTV
- Loss makers
- Action plan
## Expert rules
- Show every calculation step and formula so I can check it in a spreadsheet.
- Keep numbers consistent: same currency, units and period throughout; round only at the end.
- Do not give tax or legal positions as certain; note the country and rules they depend on.
- Respect consumer-protection rules, return policies and stock levels. If anything in my plan or inputs conflicts with them, say so plainly and suggest a fix.
- Do not invent facts, figures, laws, sources or quotes. Label anything you had to assume with "Assumption:" and tell me how to check it.
## Format
- Use tables for all figures, with totals and clear labels.
- Give spreadsheet formulas in fenced code blocks.
- Summarise the answer in plain language for a non-finance reader first.
## Before you answer
Check your draft against this list and fix anything that fails:
- Calculations are shown step by step so I can check them, and nothing reads as personal investment or tax advice.
- Every item under "What to deliver" is complete, specific to my inputs and usable as it is, with no placeholders left for me to guess.
- Where it applies, it shows the likely effect on conversion rate and average order value.
If something essential is missing, ask me up to 3 short questions first. Otherwise, start.
How to use this prompt
- Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
- Fill the brackets. Use the form above, or replace [ORDERS], [COSTS], [MARKETING], [REPEAT], [EXTRA CONTEXT, or "none"] with your own details.
- Paste and send. Paste it into ChatGPT, Claude, Gemini and Microsoft Copilot and send. Ask follow-up questions to refine the answer.
Why this prompt works
The “Analyse unit economics for an online store” prompt tells the assistant exactly what to hand back: contribution per order; CAC by channel; LTV; loss makers; and action plan. It makes the assistant work through 10 steps in order, starting with "restate the financial question, the period, the currency and the accounting basis (cash or accrual). List the figures you need that I have not given", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 3 tests and fixes anything that fails.
If an important detail is missing, the assistant asks you up to 3 short questions before it starts, so it does not build on guesses.
How to get the best answer
- Fill every bracket with real detail: [ORDERS], [COSTS], [MARKETING] and the rest should hold real names, numbers and dates, not placeholders.
- Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
- Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
- Check the result: test what it builds or writes before you rely on it.
FAQ
Frequently asked questions
Which AI assistant works best with the “Analyse unit economics for an online store” prompt?
The “Analyse unit economics for an online store” prompt works in any chat assistant and suits ChatGPT, Claude, Gemini and Microsoft Copilot best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.
What do I fill in before sending the “Analyse unit economics for an online store” prompt?
Replace the 5 highlighted brackets – [ORDERS], [COSTS], [MARKETING], [REPEAT], [EXTRA CONTEXT, or "none"] – with your own details. The more specific you are, the better the answer.
Who is the “Analyse unit economics for an online store” prompt for?
Anyone who wants a complete, working result from an AI assistant. Replace the brackets with your own project details.
Is the “Analyse unit economics for an online store” prompt free to use?
Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.
Can I trust the answer the “Analyse unit economics for an online store” prompt gives?
Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.
Keep exploring
Browse more E-commerce & Retail prompts
- All E-commerce & Retail prompts
- Software Developmentfor E-commerce & Retail
- Project Managementfor E-commerce & Retail
- Marketing & Contentfor E-commerce & Retail
- SEOfor E-commerce & Retail
- Salesfor E-commerce & Retail
- Customer Supportfor E-commerce & Retail
- Data Analysisfor E-commerce & Retail
- Business Strategyfor E-commerce & Retail
- Browse the full library