Customer Revenue Field Guide
Understand offer economics, acquisition cost, customer value, recurring revenue, campaign measurement and experiment discipline.
Three practical resources. One connected workflow. Understand the numbers, make a clear decision and put the next growth action into practice.
The Field Guide explains the measures. The Workbook organizes your business inputs and selected calculations. The 30-Day Action Plan turns the analysis into a sequence of actions, reviews and decisions.
Understand offer economics, acquisition cost, customer value, recurring revenue, campaign measurement and experiment discipline.
Organize inputs and review selected calculations across ten workbook tabs.
Move from baseline to diagnosis, a focused test, a documented decision and the next 90-day plan.
All PDFs, spreadsheet files, cover previews, instructions and the ZIP package are embedded inside this HTML file. No separate image folder, script library or file host is needed. The dashboard itself works offline. Google Sheets links require an internet connection and a Google account for copying.
Your working model for organizing business inputs, reviewing offer economics, acquisition costs, customer value, recurring revenue, campaigns and experiments.
Understand offer economics, customer acquisition, customer value, recurring revenue, campaign measurement and disciplined experiments.
Follow a practical daily sequence to diagnose, improve, test, learn, implement and set the next review.
Open the copy link, confirm the correct Google account, then click Make a copy. Use the new copy saved in your own Google Drive.
Sign in to the Google or Gmail account where the copy should be saved. Google will prompt for sign-in if needed. The copy link creates a new working file. The view-only link is for inspection and should not be used as the working copy.
Open the .numbers file in Apple Numbers, then save a separate working copy.
The everyday choice for formulas, tables, charts and data entry when VBA macros are not needed.
Macro-enabled format. Use only when VBA automation is genuinely needed. The extension does not prove macros are present or required.
Set aside an initial 60 to 90 minutes to open the materials, choose an edition and gather the information already available. Perfect data is not a prerequisite. Honest labels are.
Read the opening section to understand the order and why targets and estimates are not actual evidence.
Choose Google Sheets, Numbers or Excel. Keep the supplied original unchanged.
Keep the first analysis focused. Do not blend unrelated offers or customer types.
Collect price, discounts, refunds, variable costs, campaign spend, leads, new customers and repeat-purchase evidence where available.
Review net sales, included variable costs, contribution per order and contribution margin.
Compare CAC with contribution, then model customer value using labelled assumptions and scenario ranges.
Review subscription assumptions, campaign metrics and ROAS. Revenue less ad spend is not profit.
Write a hypothesis, define control and variant, select the primary measure and set the review window.
Use daily actions and weekly reviews. Record evidence and outputs, not only completed boxes.
At Day 30, decide what to keep, revise or stop. Assign an owner, next action and review date.
Use the full PDF planner for each daily action. This is the sequence and the output to aim for at the end of each phase.
This checklist saves progress only in this browser on this device. It is not uploaded or synchronized and may not follow you to another device.
Search the questions or open the answer that applies.
Yes. To create a personal Google Sheets copy, sign in to the Google or Gmail account where the new file should be saved. If you are not signed in, Google should prompt you. Use the view-only link to inspect the workbook without making a copy.
They are designed to complement one another. Use the Field Guide to understand measures, the Workbook to organize numbers, and the 30-Day Plan to execute and review. Start with one offer and the baseline.
No. Use actual results where available, label estimates clearly and mark unknowns. Do not invent numbers to fill gaps.
Use Google Sheets for Google Drive, Numbers for Apple Numbers, and .xlsx for everyday Excel use. Use .xlsm only when trusted VBA automation is genuinely required.
Open the copy link, check the active Google account and click Make a copy. Wait for the new workbook to open and confirm it is saved in the intended Drive account. Enter data only in your copy.
The .numbers file is intended for Apple Numbers. On Windows, use the supplied .xlsx or .xlsm edition, or Google Sheets in a browser.
Choose .xlsx unless VBA macros are specifically required. .xlsm can store and run VBA macros, but the extension alone does not prove macros are present or needed. Do not enable macros just to open the workbook.
Open File Explorer with Windows key + E, choose Downloads, find the .pdf file and double-click it. It usually opens in Microsoft Edge or another installed PDF reader. If prompted, choose a trusted reader.
Open Finder, choose Downloads and double-click the .pdf file. macOS normally opens it in Preview. If needed, Control-click the file, choose Open With and select Preview.
Check that the download finished and the name ends in .pdf. Try opening from Downloads, re-download if incomplete, then use a current browser or trusted PDF reader. Use the TXT guide in Notepad on Windows or TextEdit on Mac.
The PDFs explain concepts and steps. They do not replace the editable workbook inputs and calculations.
It can help organize many service-business economics questions. Adapt the inputs to the actual delivery model and include material variable labor, commissions, support and fulfillment costs. Check whether the simplified calculations fit.
Start with one offer and one customer group so the first analysis remains interpretable. Repeat the process for other offers later. Avoid blending unlike offers into one set of assumptions.
No. Contribution reflects only the costs included in the calculation. Fixed overhead, acquisition, taxes, working capital, owner compensation and other costs may remain outside it.
Not automatically. It means the initial purchase does not recover acquisition cost under the entered assumptions. Repeat purchases may change the relationship economics, but use observed retention and purchase data and account for servicing costs and cash timing.
Not necessarily. ROAS is tracked revenue divided by tracked campaign spend. It does not deduct all product, fulfillment, processing, service, overhead and other costs.
Check lifespan, purchase frequency, gross margin and variable service cost. Run conservative, base and improved scenarios. Prefer observed cohort retention and repeat-purchase history to unsupported long-term assumptions.
No. Observed lift is descriptive arithmetic, not a statistical significance test. It does not automatically account for sample size, randomisation, seasonality or confounding variables.
Continue with the next unfinished action. Record actual dates and adjust the review window honestly. A slipped date is not a reason to abandon the process.
Check cash, fulfillment, inventory, product quality, service capacity and customer support. Positive unit contribution does not prove the business has the cash or capacity to scale.
No. Use aggregate business figures and anonymised notes. Do not enter passwords, payment card details or unnecessary personal information.
Share a working copy according to platform permissions and your organisation's policies. Give access only to people who need it and protect confidential business information.
No. It is an educational planning toolkit that helps structure inputs, analysis, experiments and follow-through. It cannot guarantee business outcomes.
Compare results with baseline and hypothesis, document reliable evidence and remaining uncertainty, decide whether to keep, revise or stop, assign the next action and owner, and set the next review date. Then create the next 90-day action plan.
The guides and workbook are educational management tools, not financial, accounting, tax, legal or investment advice. No revenue, profit, conversion, retention or business outcome is promised or guaranteed. Prepared by Awesome Indeed LLC.