Use Nick’s three lenses—acquisition economics, returning-customer cohorts and marketing moments—to choose a realistic 90-day priority. Work through a companion Google Sheet with your own numbers, identify the Shopify reports to pull, and check contribution, payback and the full effect of a promotion before deciding what to spend.
Use Nick’s three lenses—acquisition economics, returning-customer cohorts and marketing moments—to choose a realistic 90-day priority. Work through a companion Google Sheet with your own numbers, identify the Shopify reports to pull, and check contribution, payback and the full effect of a promotion before deciding what to spend.
Nick’s session helps you decide whether the next move should be acquisition, returning-customer activation or a marketing moment. Start with a gap diagnosis, work through the companion spreadsheet, or review a promotion’s full effect.
Your brand’s season determines the priority; contribution, cohort timing and cash determine what the plan can support.
01
Name the gap before choosing the play
Separate new-customer revenue, new-customer count and returning revenue against the same elapsed, event-aware plan. Determine whether the constraint is underspend, efficiency, customer mix, cohort cadence or a delayed marketing event before increasing the budget.
02
Set CAC ceilings from contribution and the chosen payback horizon
Start with net first-order revenue after variable costs. Subtract the desired first-order contribution for a profit-oriented CAC ceiling; use first-order contribution itself for break-even. A longer-horizon ceiling can add credible additional repeat contribution per original customer and subtract the horizon profit target. Cash and capacity still limit spending.
03
Compare cohorts at the same age with a fixed starting base
Group customers by first-purchase month. Monthly revenue lift is that cohort’s returning revenue in one month divided by its original first-order revenue. It is distinct from repeat-buyer rate and cumulative LTV. Sum cohort contributions for the same calendar month to estimate the returning baseline.
04
Measure a promotion through its aftereffect
Identify whether the offer brought new customers or activated existing buyers. Compare the event, the following weeks and the full planning window with an appropriate baseline. A peak day may borrow from later purchases. Track net revenue and contribution separately, and do not infer causality from a before/after comparison alone.
Would you like to choose your 90-day priority, work through Nick’s companion spreadsheet, or measure a promotion?
Open a choice to see the first question and what you’ll create. Continue the work in your connected Coach.
Choose your next 90-day revenue priorityA focused 90-day operating brief with evidence, guardrails, an owner and a first test.
Separate acquisition and returning-revenue gaps before choosing where to act.
Useful inputs
Approved Offer and Persona profiles
Same-period plan and actual new revenue, customer count and returning revenue
Ad spend, contribution, cash and capacity constraints
Upcoming events and product/offer calendar
Work through it
Reuse approved Offer and Persona profiles or complete the shared approval process before personalizing. Ask one focused question at a time and resume the chosen activity with known answers.
Compare the same elapsed period and definitions for new revenue, new-customer count and returning revenue. Check event timing before calling a shortfall.
Diagnose spend deployment, efficiency, first-order value and cohort cadence. Separate evidence from assumptions and name the information needed to resolve an ambiguous gap.
Use the companion Scorecard if useful. Check contribution, credible payback, cash and capacity before considering more spend.
Choose one lead priority, owner and first test. Translate it into monthly expectations, weekly reviews and daily checks with an explicit stop trigger.
If inputs are missing: Build a report request and provisional diagnosis if the baseline or costs are unavailable. Do not invent a growth target or recommend more spend to fill a revenue gap.
Your working document
Current season and gap
Evidence and unresolved inputs
One 90-day priority
Monthly expectations
Contribution, payback, cash and capacity limits
First test and owner
Review cadence and stop trigger
Complete when: A documented priority or a specific diagnostic test, supporting evidence, constraints, owner, next action, review date and stop trigger.
Work through Nick’s spreadsheet with your numbersA private, checked companion workbook or precise fill-in instructions, with an explained decision and data gaps.
Gather the right Shopify reports, check acquisition and cohort math, and build a practical revenue plan.
Useful inputs
Approved Offer and Persona profiles
Private copy of the companion Google Sheet
Shopify aggregate exports or authorized connection; manual data is supported
Ad spend, variable costs and cash/capacity constraints
Chosen planning period and mature cohort history
Work through it
Reuse approved Offer and Persona profiles or complete the shared approval process before personalizing. Ask one focused question at a time and resume the chosen activity with known answers.
Open the Nick Shackelford companion spreadsheet and offer its downloadable SKILL.md. Credit Nick for the teaching and Smart Marketer Coach for the companion implementation; it is not Nick’s original workbook or the full CTC model. Create or use the attendee’s private copy, never write their data into the public master.
Suggest an existing authorized Shopify connection to retrieve reports if its capabilities support them. Connecting is optional. If unavailable or declined, guide manual CSV exports or accept aggregate figures. Never require installation, request credentials or pretend the connector can export unavailable reports.
Read Reports and guide and establish currency, store time zone, channel/spend scope, dates and freshness. Request New vs returning customers, Customer cohort analysis in net sales and customer-count views, Total sales over time, relevant discount/product reports and Gross profit by product variant. Add actual ad spend and complete variable costs from finance/operations.
Map the actual exports. New revenue means net first orders; subsequent orders include same-month repeats. Keep Shopify First orders separate from Month 0. Deduplicate order/line-item rows, handle reversals and verify first-ever order history. Keep raw customer identities private. Do not add ESP-attributed revenue to store sales.
Fill Scorecard C5/E5/C6/E6 and C10:D14 with matching elapsed plan/actual inputs. Recalculate rows 15–21 and explain NCAC, ACONS, aMER, first-order AOV and contribution. Identify whether new-customer count, new revenue or returning revenue is behind. Unknown is not zero.
Use Acquisition C8:C13 for first-order AOV, pre-media variable margin, first-order profit target, additional repeat contribution per ORIGINAL customer, horizon target and 60/90-day horizon. Verify F8:F11. Revenue LTV and a repeat-buyers-only average cannot substitute for contribution per original customer. Calendar Month 3 does not prove day-90 payback.
If credible comparable full-month history exists, fill Acquisition B26:F49 and candidate spend C18. Review slope/intercept, sample size, R², confounders and observed range before interpreting F18:F22. Spending power is 0.01/m, not available cash. Three observations enable calculation but do not establish reliability. Withhold a spend recommendation from an unsupported fit.
Fill Cohort history C5 and B9:G128 from mature actual calendar cohorts. Check H:K for age, revenue lift, unique-buyer rate, duplicate pairs and consistent original bases. Reconcile the first-order revenue and customer counts. For true rolling-day payback, obtain dated orders/costs rather than relabeling calendar months.
Set Returning plan C5 and B13:B36, review the original bases retrieved in C, and choose target-month lift assumptions D:F from comparable cohort ages and cadence. Verify G:I and totals C8:E8. Include older cohorts. State that this template excludes future-acquisition repeats and does not auto-detect omitted cohorts; extend explicitly if a full-store forecast needs them.
Complete the three-month Scorecard plan in C28:E33 using the returning baseline, new-revenue targets, ad spend and variable costs. Review revenue versus contribution and separate cash obligations/receipt timing, inventory and capacity before any push/hold/pull-back decision.
If a promotion is relevant, use Moments C10:J12 with nonoverlapping before/during/after windows, matched baselines and actuals. Verify K/L differences and C18:C24 ratios. Measure the next four weeks and 90 days; neither revenue lift nor aMER proves profit or causal incremental demand.
Run independent arithmetic checks, inspect the actual formulas after edits, and perturb one input in a private test copy or restore it afterward. Explain unresolved inputs and limitations. Produce the private workbook or precise fill-in instructions plus one priority, owner, action, review date and stop trigger. Do not claim a sheet was updated without readback.
If inputs are missing: A Shopify connection is optional. Continue with manual exports or aggregate figures. Leave unsupported results unavailable, explain the exact missing report/cost/period, and never fill actual cells with synthetic examples. If the host cannot edit Sheets, provide cell-by-cell instructions and independently checked calculations.
Your working document
Private workbook and SKILL.md
Data sources, dates, scope and reconciliation
Scorecard diagnosis
Contribution-based CAC limits
Optional spending-curve assessment
Cohort history and returning baseline
Three-month plan and its coverage
Checks and missing inputs
Priority, owner, review and stop trigger
Complete when: The attendee has a private workbook or fill-in map, reconciled definitions, verified applicable formulas, identified data gaps and model limits, and one owned next decision. Do not claim completion of the full forecast if future-cohort repeats or cohort coverage are unresolved.
Find out what your promotion really addedA promotion review or test design with a baseline, whole-window result, customer mix and next decision.
Compare new and returning response, contribution and the weeks after the sales spike.
Useful inputs
Approved Offer and Persona profiles
Offer, eligibility, products, pricing and dates
Comparable before/during/after new and returning net revenue
Ad spend and full variable costs
Customer counts, repeat cadence and overlapping events
Work through it
Reuse approved Offer and Persona profiles or complete the shared approval process before personalizing. Ask one focused question at a time and resume the chosen activity with known answers.
Name the promotion objective: acquiring new customers, activating existing buyers, inventory movement or another explicit job. Record structure, audience, product, incentive, quantity and eligibility.
Choose a credible event-aware baseline and nonoverlapping before/during/after windows. Use the next four weeks and the rest of the 90 days where available; label an unfinished window.
Use Moments C10:J12 to compare new and returning net revenue, spend and variable costs. Calculate revenue difference and contribution difference separately. Review customer count, CAC, aMER lift, returning share and absolute returning revenue together.
Investigate timing shifts, replenishment, seasonality and overlapping offers. A baseline comparison is observational; do not label it causal proof. A strong weekend may or may not pull future demand forward.
Decide whether to continue, change, shorten or stop the offer. Set an owner and trigger based on the desired customer response, contribution and cash, rather than top-line volume alone.
If inputs are missing: If the after-period or costs are incomplete, report an interim revenue view and a follow-up measurement plan, not final incremental profit. If no credible baseline exists, design one and keep lift provisional.
Your working document
Offer objective and design
Baseline and matched windows
New versus returning response
Net revenue and contribution differences
Possible pull-forward and confounders
Decision or next test
Owner, review date and stop trigger
Complete when: A completed review or specified test with clear scope, baseline, customer response, revenue/contribution distinction, unresolved causal assumptions, owner, review window and stop trigger.
Credit Nick Shackelford for the framework and Smart Marketer Coach for the companion tools. Keep delivered teaching, explicit prepared-slide formulas and Coach-designed recommendations distinct. Follow approved Offer/Persona context, use private attendee data only in the host, and offer Shopify connection as optional with a manual-export path. Coaching paths and output templates are Coach-designed applications. This guide does not submit or store answers.
No. In the deck it is 0.01/m, a fitted sensitivity: spend associated with one percentage point of ACONS deterioration. Returning contribution and cash timing are separate analyses.
Can I use Shopify’s repeat-customer percentage as the revenue-lift input?
No. Monthly revenue lift divides one month’s repeat revenue by original first-order revenue. Repeat-buyer rate divides unique repeat buyers by original customers. They answer different questions.
No. The Coach recommends an authorized connection when it can retrieve the needed reports, but manual exports and aggregate figures are supported. This is a Coach workflow recommendation; the session’s method depends on verified data, not a particular integration.
Should I increase spend when new-customer revenue is behind?
Only after diagnosing deployment, efficiency and mix and reviewing contribution, credible payback, cash and capacity. Nick’s branches include holding or pulling back.
No. It is a companion created by Smart Marketer Coach from Nick’s teaching and credits him. It implements selected formulas and guided inputs; it does not reproduce the full CTC model.
PDF page numbers, not printed footer labels. The complete deck is indexed below; selected mainstage transcript passages support the delivered teaching. No attendee Q&A is published.
Separate new-customer revenue, new-customer count and returning revenue against the same elapsed, event-aware plan. Determine whether the constraint is underspend, efficiency, customer mix, cohort cadence or a delayed marketing event before increasing the budget.
NCAC is ad spend divided by new customers. ACONS is ad spend divided by net first-order revenue; aMER is its reciprocal. With the same population and period, NCAC equals net first-order AOV times ACONS. These ratios do not show profit or cash by themselves.
Treat spending power as a fitted efficiency measure
The slide model is ACONS = c + m × monthly spend. Spending power is 0.01 / m: the extra monthly spend associated with a one-percentage-point increase in ACONS. Use comparable seasonal history and stay inside the observed spend range. It is not additional cash or an affordable budget allowance.
Set CAC ceilings from contribution and the chosen payback horizon
Start with net first-order revenue after variable costs. Subtract the desired first-order contribution for a profit-oriented CAC ceiling; use first-order contribution itself for break-even. A longer-horizon ceiling can add credible additional repeat contribution per original customer and subtract the horizon profit target. Cash and capacity still limit spending.
Compare cohorts at the same age with a fixed starting base
Group customers by first-purchase month. Monthly revenue lift is that cohort’s returning revenue in one month divided by its original first-order revenue. It is distinct from repeat-buyer rate and cumulative LTV. Sum cohort contributions for the same calendar month to estimate the returning baseline.
Avoid double-counting the revenue already in the baseline
Natural replenishment, lifecycle programs and calendar moments all influence returning behavior. Historical cohort rates may already include those campaigns. Treat incremental campaign lift separately and evaluate contribution and cash timing before using it to support acquisition.
Identify whether the offer brought new customers or activated existing buyers. Compare the event, the following weeks and the full planning window with an appropriate baseline. A peak day may borrow from later purchases. Track net revenue and contribution separately, and do not infer causality from a before/after comparison alone.
Design the offer for the customer response you want
Bundle structure, minimum spend, gift, discount depth, quantity and eligibility change who buys and what they may buy later. Set an owner, a window and a stop trigger. Test shipping or incentive changes against your own conversion and contribution; the speaker’s confidence is not a universal outcome.
Choose a quarterly lead outcome, monthly expectations, weekly adjustments and daily reads. Diagnose the next gap and decide whether to push, hold or pull back within contribution, payback, cash and operational limits.
Nick Shackelford — 90-Day Revenue Plan companion Google Sheet
Six tabs cover the scoreboard, acquisition limits and optional spending curve, existing-cohort returning baseline, historical cohorts, promotion aftereffects, and Shopify reports.
Why use it: Translate the session into calculations with your own verified numbers.
Get started: Start with Reports and guide, then use the matching Coach activity or downloadable SKILL.md. A Shopify connection is optional; manual CSV exports work. The master is a blank template.
Why use it: Give your AI assistant enough context to guide you through the sheet accurately.
Get started: Download the SKILL.md and load it as a skill where your AI supports skills, or attach it to the conversation with your private sheet. It does not itself connect Shopify or grant store access.
Official documentation checked October 21, 2026. The workbook’s Reports and guide and SKILL.md explain the full recommended export set.
Examples from the session
Prepared-slide example: at 100,000 planned spend, modeled ACONS 0.50 and net first-order AOV 50, new revenue is 200,000, modeled customers are 4,000 and CAC is 25. The 10,000 spending-power output additionally requires a fitted slope of 0.000001; the deck does not supply the underlying history. These are scenario calculations, not actual brand results or a complete forecast. Slides
Prepared CAC worksheet: 50 AOV × 60% pre-media margin = 30 contribution. A 5 first-order contribution target gives a 25 CAC ceiling; break-even is 30. Adding 15 of additional repeat contribution and subtracting a 10 horizon target gives a 35 horizon ceiling. Slides
Prepared cohort example: 100,000 original first-order revenue × 2% month-3 revenue lift = 2,000 returning revenue in month 3 only. The percentage is not a repeat-customer rate, contribution margin or cumulative 90-day return. Slides
Prepared promotion example: 20,000 of event uplift minus a 12,000 later dip leaves 8,000 net monthly lift. A 200,000 baseline becomes 208,000, a 4% revenue lift. This calculation does not establish a 4% profit margin. Slides
Context to keep in mind
The supplied transcript spans 0:00–49:38. Mainstage teaching runs approximately 5:00–35:54. Public excerpts exclude opening logistics, personal material and all attendee Q&A exchanges.
The 43-page PDF is preserved as supplied; references use PDF pages because printed footer numbering skips or duplicates some labels. It has no attached source files or notes pages. Speaker-presented figures are teaching material, not independently audited financial results.
The explicit spending-power definition on PDF page 20 is 0.01 divided by slope. Spoken shorthand mixes repeat cash with this concept; the Coach keeps those separate. The example’s history and fitted coefficients are not supplied, so its curve cannot be independently reproduced from the deck alone.
The scoreboard CPA on PDF page 5 does not equal its displayed ad spend divided by displayed new-customer count. The underlying scope is unspecified; do not use it as a reconciled formula example or infer an accounting error.
The live CAC-cap discussion abbreviates repeat contribution; the companion uses the explicit page-25 breakdown. The page-40 4% calculation is revenue lift, not profit margin. Claims that shipping changes will not reduce conversion are speaker opinion and require testing.
The companion workbook and SKILL.md are Coach-created applications crediting Nick, not his original file or the full CTC model. It contains blank inputs and an existing-cohort baseline; future-acquisition repeats, missing cohort coverage and cash timing require additional work. Shopify access is optional.
Calendar-month cohorts are not rolling day-30/60/90 windows. True payback needs mature order-age and variable-cost data. Three data points only enable the optional curve calculation; they do not prove a reliable, causal relationship.