What this guide helps you do
Most growth problems do not start as channel problems. They start as visibility problems.
The team wants more leads, better CAC, higher ROAS, more pipeline, or faster revenue. Those may be real goals. But if the business cannot clearly see what created the last round of revenue, adding AI, budget, a new agency, or another campaign usually makes the fog move faster.
This guide helps you make the growth system legible first. The goal is not a perfect attribution model. The goal is a working operating view: what came in, where it came from, what it cost, what converted, what closed, and what decision the team should make next.
Use it before you ask AI to analyze performance, before you change budget, or before you tell a team to “scale what is working.”
The boundary to keep clear
AI can help summarize, compare, classify, and find inconsistencies. It should not decide what the business believes.
Before AI is useful, the operator has to define the source of truth. Otherwise the model will confidently explain whatever the messiest system says.
Keep these roles separate:
| Layer | Job | Owner |
|---|---|---|
| System of record | Shows what the business actually closed | Finance, CRM, ecommerce, ERP |
| Channel systems | Show what platforms claim they influenced | Marketing / media |
| Operating view | Connects spend, demand, conversion, and revenue | Operator / growth owner |
| AI assistant | Summarizes gaps, flags mismatches, prepares questions | Human-approved workflow |
If those layers collapse into one dashboard, the team may optimize against the easiest number to access instead of the number the business can trust.
Step 1: Pick the question before pulling reports
Do not start by exporting everything.
Start with one decision the business actually needs to make. Examples:
- Should we increase spend in this channel?
- Is CAC really getting worse, or is tracking getting worse?
- Which campaign created revenue, not just leads?
- Are we short on demand, conversion, sales follow-up, or fulfillment capacity?
- Which segment is growing profitably?
Write the decision at the top of the worksheet. If there is no decision, the analysis will turn into reporting theater.
A useful format:
| Decision needed | Date needed | Owner | What would change? |
|---|---|---|---|
| Should we increase Google nonbrand spend? | Friday | Growth owner | Budget moves from $500/day to $750/day, or stays flat |
This forces the work to stay practical.
Step 2: Build a one-page growth map
Map the growth system in plain language before opening the data.
Use this structure:
| Stage | What happened | Source of truth | Common proxy |
|---|---|---|---|
| Attention | Someone saw or clicked | Platform data | Impressions, clicks, sessions |
| Demand | Someone raised a hand | CRM / form / cart / call tracking | Leads, carts, trials, quote requests |
| Conversion | Someone became a customer | CRM closed-won, Shopify order, Stripe, ERP | Platform conversion |
| Value | The customer produced revenue or margin | Finance / order system | ROAS, reported revenue |
| Retention | The customer stayed or bought again | CRM / subscription / ecommerce | Repeat purchase rate, renewal |
Then mark which source you trust for each stage.
The important move is to stop treating platform conversions as the same thing as business outcomes. They may be useful. They are not automatically the truth.
Step 3: Pull the minimum viable data set
For the first pass, use one period and one business line. A 30-day or 90-day window is usually enough.
Pull only what you need:
| Data | Required fields |
|---|---|
| Spend | date, platform, campaign, spend |
| Platform conversions | date, platform, campaign, conversion name, reported conversions, reported value |
| Business outcomes | date, customer/order/deal ID, revenue, margin if available, source if available |
| Lead or demand records | date, lead/order/cart ID, source/medium, campaign if available, status |
| Sales or fulfillment status | closed, lost, refunded, canceled, delayed, won |
Do not wait for perfect data. Missing fields are part of the diagnosis. If campaign is blank in the CRM, that is not an annoyance. It is a growth legibility issue.
Step 4: Reconcile at the level the business can trust
Create a simple reconciliation table.
| Metric | Platform-reported | System-of-record | Gap | Owner to inspect |
|---|---|---|---|---|
| Leads | 420 | 388 | -32 | Marketing ops |
| Customers | 51 | 38 | -13 | Sales ops / CRM |
| Revenue | $84,000 | $63,500 | -$20,500 | Finance / ecommerce |
| CAC | $290 | $389 | +$99 | Growth owner |
The exact numbers are less important than the relationship between them. You are trying to see whether the business is making decisions from the same reality.
If the gap is small and stable, the proxy may be usable. If the gap is large, changing, or different by channel, do not scale from the proxy.
Step 5: Classify the break
Most teams stop at “the numbers do not match.” That is not enough. Classify why.
Use these buckets:
| Break type | What it means | Next move |
|---|---|---|
| Tracking break | Events are missing, duplicated, or firing at the wrong time | Fix instrumentation before budget decisions |
| Attribution break | Platform credit differs from the actual buying path | Compare paths and adjust decision rules |
| CRM break | Source, campaign, stage, or close data is incomplete | Fix required fields and handoff rules |
| Finance break | Revenue, refunds, discounts, or margin are not tied back | Add finance reconciliation before scaling |
| Segment break | Averages hide different economics by offer, market, or customer type | Split the view by segment |
| Timing break | The sale happens outside the platform window | Extend the review period and inspect assisted paths |
This is where AI can help. Give it the table and ask it to classify mismatches, generate questions for each owner, and identify which decision is unsafe until the gap is resolved.
Do not ask it to pick the budget yet.
Step 6: Turn the analysis into an operating rule
A report is not finished until it changes how the business will decide next time.
Examples of useful rules:
- Do not increase spend on a campaign unless platform revenue is reconciled to closed revenue within 15%.
- Use CRM closed-won as the source of truth for service revenue, not platform-reported conversions.
- Review CAC fully loaded: media spend, sales labor, tools, and agency fees.
- Separate branded search from nonbrand before deciding whether Google is growing demand or harvesting it.
- Segment new customers and returning customers before evaluating ROAS.
The rule should be simple enough for the next weekly meeting.
Step 7: Use AI on the cleaned operating view
Once the source of truth and gaps are clear, AI becomes useful.
Good prompts:
textYou are reviewing this growth reconciliation table. Identify which metrics are safe for budget decisions, which are proxies, and which require owner review before action.
textClassify each mismatch as tracking, attribution, CRM, finance, segment, or timing. Return a table with owner, risk, and first question to ask.
textSummarize the decision we can make this week and the decisions we should protect until the data is repaired.
Bad prompts:
textTell me which campaigns to scale.
That skips the operating work. AI should make the analysis easier to inspect, not make an unclear system look decisive.
The first version you can run this week
- Pick one decision.
- Pull spend, platform conversions, and actual closed revenue for one period.
- Build the reconciliation table.
- Classify every material gap.
- Assign one owner per gap.
- Write one decision rule for the next budget conversation.
- Ask AI to summarize the unresolved risks, not to make the decision.
Keep the first pass small. One channel, one offer, one time period is enough.
What good looks like
A good growth view lets the operator say:
- Here is what the business actually closed.
- Here is what each platform claimed.
- Here is the gap between those numbers.
- Here is which gap is acceptable, which is dangerous, and who owns each one.
- Here is the decision we can make now.
- Here is the decision we are not allowed to make yet.
That is legibility.
Once the business can see clearly, the next growth move gets easier. Not because the work becomes simple, but because the team stops debating which version of reality to believe.