Portal revenue proof

Scale Phase 2 Portal Revenue Proof Guide

Scale Phase 2 Portal Revenue Proof Guide for connecting ZartsAlgo source data, leads, booked jobs, QuickBooks records, payments, ROI, lifetime value, and client-safe proof reporting.

Attribution contract

What this proof must protect before it reaches a client.

Use this guide before connecting Search Console, QuickBooks, Thumbtack, Angi, call tracking, CRM, campaign spend, booked jobs, invoices, or payment records.

Owner

One owner signs off the proof

Operations owns the source match, reconciliation state, portal boundary, and client-safe summary.

Risk

Make attribution uncertainty visible

The main risk is hiding attribution uncertainty and making ROI look more precise than the data supports.

Privacy

Summarize accounting data

Raw invoices, payment rows, customer details, and provider payloads stay internal unless a summary is explicitly approved.

Scale

Use rollups before raw tables

Large client volume should read period rollups, attribution summaries, confidence scores, and approved proof notes first.

Baseline controls

Checks that apply to every attribution workflow.

  • Confirm source label, client, service, market, campaign, period, and owner before linking revenue.
  • Separate lead volume, qualified opportunities, booked jobs, invoiced revenue, and collected revenue.
  • Use QuickBooks or payment data only after customer matching, invoice matching, and duplicate checks pass.
  • Store confidence score, reconciliation status, source freshness, and known caveats with every proof item.
  • Keep raw accounting payloads, CRM payloads, and provider rows out of the client portal.
  • Compare current results with the baseline period before writing a since-joining improvement note.
  • Pause publication when source, invoice, payment, or booked-job attribution is disputed.
  • Use prepared MySQL reads for runtime reports and summarized fields for portal proof.
  • Attach each ROI claim to an internal audit trail, report period, and approval state.
  • Retest admin, portal, mobile, and generated report pages after attribution changes.

Topic checks

Specific checks for this reporting topic.

  • Retest admin, portal, mobile, and public pages after report changes.
  • Match lead source, client, service, market, campaign, and report period before calculating revenue.
  • Separate booked value, invoiced value, paid value, and projected value in every report.
  • Confirm provider freshness and source coverage before publishing an ROI claim.
  • Use confidence scores for manual overrides, fuzzy matches, and missing-source records.
  • Reconcile QuickBooks, CRM, call tracking, marketplace, and admin states before portal proof.
  • Keep raw accounting payloads and payment details out of client-facing cards.
  • Attach every metric to a baseline period, current period, owner, and approval state.
  • Pause proof when a source, invoice, payment, or attribution link is disputed.

Checkpoints

Turn the topic into an admin review checklist.

Each checkpoint can become a QA step, reconciliation task, report approval rule, or portal proof gate.

Check 1

Attribution checkpoint

Retest admin, portal, mobile, and public pages after report changes.

Check 2

Attribution checkpoint

Match lead source, client, service, market, campaign, and report period before calculating revenue.

Check 3

Attribution checkpoint

Separate booked value, invoiced value, paid value, and projected value in every report.

Check 4

Attribution checkpoint

Confirm provider freshness and source coverage before publishing an ROI claim.

Check 5

Attribution checkpoint

Use confidence scores for manual overrides, fuzzy matches, and missing-source records.

Check 6

Attribution checkpoint

Reconcile QuickBooks, CRM, call tracking, marketplace, and admin states before portal proof.

Check 7

Attribution checkpoint

Keep raw accounting payloads and payment details out of client-facing cards.

Check 8

Attribution checkpoint

Attach every metric to a baseline period, current period, owner, and approval state.

Check 9

Attribution checkpoint

Pause proof when a source, invoice, payment, or attribution link is disputed.

Data hooks

Tables and runtime sources to connect later.

Public pages remain static; admin and portal runtime should use prepared reads, rollups, and approved summaries.

Runtime 1

payments

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 2

quickbooks_payments

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 3

stripe_payments

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 4

revenue_attribution

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 5

report_periods

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 6

report_metrics

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 7

metric_snapshots

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Runtime 8

lifetime_value_snapshots

Use this source for summarized admin and portal runtime only after reconciliation and privacy review.

Client proof

What can become a clear, safe ROI story.

The strongest client reporting shows what changed since joining while preserving attribution confidence and privacy boundaries.

Proof 1

Lead source volume

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 2

Qualified rate

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 3

Booked job count

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 4

Booked revenue

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 5

Collected revenue

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 6

ROI

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 7

LTV

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.

Proof 8

Since-joining delta

Publish this proof only with a period, source, confidence status, owner approval, and short client-safe explanation.