---
name: nick-revenue-plan
description: Guide an attendee through Nick Shackelford’s Smart Marketer Live companion spreadsheet using their Shopify reports, acquisition economics, cohort history and promotion results. Use for Nick’s 90-day revenue planning workflow and its calculations.
---

# Nick Shackelford’s 90-Day Revenue Plan

Teaching and framework credit: **Nick Shackelford**, “Build a 90-Day Revenue Plan for Your Brand,” Smart Marketer Live, October 21, 2026. His deck is titled “Different Seasons. Different Reasons.”

The **Smart Marketer Coach created this companion spreadsheet and skill from Nick’s teaching**. They are not Nick’s original workbook or the complete proprietary Common Thread Collective model referenced in his slides.

- [Make a private copy of the companion spreadsheet](https://docs.google.com/spreadsheets/d/1W2EwoBETRQtTzbGpmni_e6T39807jQKyFcyCzg3iZ5A/copy)
- [Session takeaways and activities](https://smlcoach.smartmarketer.com/coaches/smart-marketer/takeaways/nick-shackelford-90-day-revenue-plan.html)
- [Nick’s slides, 43-page attendee PDF](https://smlcoach.smartmarketer.com/coaches/smart-marketer/slides/nick-shackelford-90-day-revenue-plan.pdf)

References below use **PDF page numbers**, which sometimes differ from the printed slide footer.

## Start with the decision

Help the attendee diagnose a gap, set acquisition limits, build an existing-customer revenue baseline, or evaluate a promotion. Ask one focused question at a time; reuse numbers and decisions already supplied. End with one priority, owner, next action, review date and stop trigger.

In the connected Smart Marketer Coach, preserve its Offer Profile and Persona Profile approval process before tailoring the recommendation. Outside that Coach, establish the product, customer, objective and material constraints without inventing a requirement to install another tool.

Use a private copy. Never enter attendee numbers in the shared master. Inspect the attendee’s actual tab names, labels, formulas and existing inputs before edits; the map below describes version 1. If the host can read but not edit Sheets, calculate from supplied aggregate figures and give precise cells to fill. Do not claim to have changed a file without verified writeback. This skill does not authorize ad changes, financial commitments or sharing a private business model.

## Get the right reports

Suggest connecting the attendee’s AI to Shopify **if a suitable connection is available** so it can retrieve the reports with less manual work. This is optional. First check for an existing authorized Shopify connection and inspect its actual read/report/export capabilities; a product or order connector may not expose Analytics reports. Use the host’s normal connection flow if the attendee chooses it. Never ask them to paste passwords, access tokens or API keys. Request only the store access needed to read the relevant data; this workflow needs no permission to change products, orders, customers or ad spend.

If there is no connection, the attendee declines, or the connector cannot export a needed report, give the Shopify navigation and configuration below and accept private CSV uploads or aggregate figures. Continue with whichever inputs are available. **Do not require a connection, block the workbook walkthrough on installation, or claim reports were downloaded when they were not.** Confirm the store, dates and filters before retrieval and verify every returned export’s coverage.

Recommend 12–24 months of history where available, daily data for the current month, and complete before/during/after windows for relevant promotions. This is a Coach preparation recommendation, not a minimum prescribed by Nick. Use actual exports available to the attendee; do not pretend to connect to Shopify or fabricate data.

In Shopify, open **Analytics → Reports**. Record store currency, store time zone, channel filters, date range, export time and metric definitions. Keep one matching spend scope throughout. Separate Amazon, retail and DTC unless both the revenue and spending allocation support a combined analysis.

| Report | What to pull | Use |
| --- | --- | --- |
| New vs returning customers | First-time and returning customer counts by day and month | Scorecard; use customers rather than orders |
| Customer cohort analysis | First-order-month cohorts; separate exports for Net sales and Number of customers; first orders and each mature monthly interval | Cohort history and returning baseline |
| Total sales over time | Daily/monthly net sales, discounts and sales reversals; available first-time/returning dimensions or a reconciled cohort split | Revenue controls and pacing |
| Total sales by discount codes, plus relevant product/channel reports | Offer dates, code, affected products and customer mix where available | Promotion investigation; reconcile non-code offers separately |
| Gross profit by product variant | Net sales, product costs and cost coverage | COGS starting point; not complete contribution |
| Orders export, when calendar cohorts are insufficient | Private order-level history with order ID, pseudonymous stable customer key, order timestamps, first-order identity, net amounts, reversals and costs | True rolling day-30/60/90 payback |

Report names and availability can change. The [Shopify customer-report documentation](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/customers-reports), [sales-report definitions](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/sales-report), [profit-report guidance](https://help.shopify.com/en/manual/reports-and-analytics/shopify-reports/report-types/default-reports/profit-reports), and [orders-export documentation](https://help.shopify.com/en/manual/fulfillment/managing-orders/exporting-orders) were checked October 21, 2026. Verify the actual configured fields before mapping an export.

Bring **ad-platform spending** and finance/operations costs too: product costs, fulfillment, shipping subsidy, payment fees, gifts and other variable expenses. Review cash availability, obligations, inventory and receipt timing separately. Email-platform attributed revenue overlaps store revenue; never add it to Shopify revenue as another sales stream.

### Prepare without changing the meaning

- Preserve private raw exports. Map aggregate values into the workbook; this is not an automatic CSV importer.
- New revenue means **net first-order revenue**. Subsequent orders are returning revenue, even when made in the acquisition month. Shopify’s storewide AOV is not the same as this workbook’s net first-order AOV.
- Shopify’s **First orders** column is separate from **Month 0**, which contains same-calendar-month repeats. Neither is a rolling 30-day window. Turn off projections when preparing historical actuals; exclude immature cells rather than entering zero.
- Net sales and total sales differ. Reconcile discounts, sales reversals, taxes, shipping and fees. Document any shipping-income treatment consistently with the shipping-cost calculation. A sales report is not a cash-collection report.
- Cost-at-sale omissions can make Shopify profit reports incomplete. Unknown costs are not zero. Do not treat gross profit as contribution after every variable cost.
- With an orders CSV, preserve order/line-item grain and deduplicate before counting. Never sum repeated order totals across item rows. Establish first-ever orders from sufficient history; a customer’s first order in a short export may not be their first order with the brand. Resolve customer identity privately, then remove names, emails and addresses from the analysis shared with the assistant.

## Spreadsheet map and coaching sequence

Yellow cells accept inputs; formula cells should remain formulas. `n.a.` identifies missing or invalid prerequisites. A real zero is valid when evidenced. Money uses the currency entered on Scorecard. Formula outputs are scenarios and comparisons, not assurances of a result.

### 1. Diagnose the gap — Scorecard

Set **C5 period start**, **E5 period end**, **C6 currency**, and **E6 channel/spend scope**. In **C10:D14**, enter elapsed plan and actual for spend, net first-order revenue, new customers, returning net revenue and variable costs. Use the same elapsed dates and event-aware plan on both sides. Do not compare MTD actuals against a full-month goal or sum daily unique returning buyers to get a monthly unique count.

Rows 15–21 calculate total net revenue, NCAC, ACONS, aMER, net first-order AOV, and contribution before/after ads. Column E is actual minus plan; column F is relative difference, not a universal good/bad score. More spend or a larger CAC is not automatically favorable.

Diagnose whether the shortfall is new-customer count, first-order value, returning demand, delayed events, underspend or acquisition efficiency. Nick’s decision lens is on PDF pages 13–18 and 26. Do not recommend more spend merely because revenue is behind.

### 2. Set acquisition limits — Acquisition

Inputs **C8:C13**:

| Cell | Input |
| --- | --- |
| C8 | Net first-order AOV |
| C9 | Pre-media variable margin, e.g. 60% rather than 60 |
| C10 | First-order contribution target per acquired customer |
| C11 | Additional repeat contribution through the chosen horizon per **original acquired customer** |
| C12 | Contribution target per original customer through that horizon |
| C13 | 60 or 90 days |

F8 = AOV × pre-media margin. F9 = F8 − first-order target. F10 = F8 (first-order break-even). F11 = F8 + repeat contribution − horizon target. A negative ceiling means the target cannot support a positive acquisition cost under those inputs; it is not a suggested negative CAC.

PDF page 25 gives the check: 50 × 60% = 30; ceilings 25, 30 and 35 using targets 5 and 10 and repeat contribution 15. Do not mix the talk’s abbreviated repeat example with the slide’s different input breakdown.

Repeat contribution excludes the first order and includes variable costs. Divide by **all original acquired customers**, including those who never return. A revenue LTV number or a repeat-buyers-only average cannot fill C11. A calendar Month 3 cell cannot establish day-90 payback. For that, reconstruct order-age windows using mature cohorts and costs. Until available, leave the horizon ceiling unresolved while still using first-order economics.

### 3. Assess the spending curve — optional advanced section

Enter a candidate **monthly budget in C18**. Rows **26–49** accept comparable period labels in B, full-month spend in C, net first-order revenue in D, and context/exclusions in F. E computes ACONS. C52:C59 calculate the observation count, spend range, fitted slope/intercept, spending power, R² and range check. F18:F22 calculate scenario outcomes.

- NCAC = ad spend / new customers.
- ACONS = ad spend / net first-order revenue.
- aMER = net first-order revenue / ad spend = 1 / ACONS.
- NCAC = net first-order AOV × ACONS when the populations and periods match.
- Fitted ACONS = c + m × monthly spend.
- Spending power = **0.01 / m**, currency units per **one percentage point** worsening in ACONS.

Use the deck’s explicit formula on PDF page 20. Spending power is **not cash, profit, returning revenue or a budget increment the brand can afford**. Budget, AOV and spend range alone are insufficient: the fitted c and m are required.

The calculator requires three complete paired observations with varying spend to run. That is a computational guard, not evidence of statistical reliability. Examine season, pricing, product mix, attribution and channel changes; do not fit an arbitrary all-year dataset merely to get a number. A strong R² does not prove causality. A flat or negative slope does not authorize unlimited spend. The sheet withholds modeled outputs outside the observed range.

For a formula check only, synthetic c = 0.4 and m = 0.000001 at 100,000 spend and 50 AOV produce ACONS 0.5, aMER 2, new revenue 200,000, 4,000 modeled customers, CAC 25 and spending power 10,000. Those coefficients are an illustrative reconstruction, not supplied brand history.

### 4. Understand repeat behavior — Cohort history

Set **C5 to the first day of the last complete observed calendar month**. Rows **9–128** hold one row per acquisition-month/observation-month pair:

- B acquisition month; C original net first-order revenue; D original customer count.
- E observed month; F returning net revenue in that month; G unique returning buyers in that month.
- H age in calendar months; I monthly revenue lift F/C; J monthly repeat-buyer rate G/D; K input validation.

Keep the original base unchanged across every observation for a cohort. Resolve duplicates, inconsistent original bases and incomplete periods before using the result. Multiple orders by one buyer increase revenue/order frequency, but do not count as multiple unique repeat buyers.

PDF page 30: 100,000 × 2% = 2,000 in **month 3 only**. This is a revenue ratio. If the same cohort has 2,000 original customers and 20 return that month, its repeat-buyer rate is 1%. Sum monthly revenue amounts for cumulative revenue; do not sum monthly unique-buyer rates to claim cumulative retention.

### 5. Build an existing-cohort baseline — Returning plan

Set **C5** to the first day of the first forecast month, after the last complete observed month. D5/E5 supply the next two months. Enter each existing acquisition month once in **B13:B36**; C retrieves its fixed original revenue from validated Cohort history. Set the three planning-month revenue-lift assumptions in **D13:F36**. G:I multiply the original base by each month’s lift; C8:E8 sum the cohorts.

“Month 1/2/3” here means the three **planning columns**, not cohort ages 1/2/3. Select assumptions using each cohort’s age in that target month, its product/subscription cadence, and comparable mature observations. Keep a short rationale in the conversation or the attendee’s private notes. Include older cohorts; do not silently drop their tail.

This model covers only entered **existing cohorts**. It does not automatically add repeats from future acquisitions, infer every missing cohort, or estimate campaign uplift. Reconcile cohort coverage before describing a full-store forecast. Add any extension explicitly with its own evidence and avoid double-counting lifecycle campaigns already present in historical baseline rates.

Scorecard C27:E33 combine this baseline with entered new revenue, ad spend and variable-cost plans. Revenue support is not permission to spend: contribution, payment timing, cash obligations, inventory and capacity still govern the decision.

### 6. Test the whole promotion — Moments

Set offer/audience in C5:F5 and window dates in C6/E6. Rows 10–12 represent nonoverlapping **before, during and after** windows. C:J hold matched baseline/actual new revenue, returning revenue, ad spend and variable costs. K measures net revenue difference; L subtracts incremental ad spend and variable costs. Row 14 totals the selected window.

C18:C24 show event/baseline aMER, aMER lift, returning shares, returning-mix multiple and full-window revenue lift. These are diagnostic ratios, not proof of causal lift or profitability. Verify absolute customer count and returning revenue too. The sheet does not infer the counterfactual baseline.

Use an event-aware baseline, cover the next four weeks and review the rest of the 90 days. Explain seasonality, overlapping campaigns and possible pull-forward. Nick’s PDF page 40 shows 20,000 event lift minus 12,000 later dip = 8,000 net lift; against 200,000 baseline, that is **4% revenue lift**, not 4% profit margin. Do not repeat the spoken shorthand as a margin calculation.

## Verify and finish

Calculate with a tool when available. Inspect formulas and values after writes, independently recompute a representative result, and verify that changing one input updates its dependent output. In a private test copy, distinguish blank from zero, a duplicate cohort-month, immature periods, a changed budget and an out-of-range model. Restore test inputs before delivering a blank template; never test with invented numbers labeled as actuals.

Deliver the attendee’s private spreadsheet or precise fill-in instructions, the decision supported by the evidence, material missing inputs, and a short 90-day plan. Complete Scorecard’s priority/owner/action/review/stop-trigger fields. Reuse Nick’s discipline: **one lead priority, one owner, one stop trigger**. If evidence is insufficient, name the report or measurement needed next instead of manufacturing a spending recommendation.
