RSG Analytics — Help

This app joins ad spend, CrewOS outcomes, and (later) first-party website tracking into one view of CPL, CAC, ROAS, and deal value — by channel, campaign, ad set, and ad, for the whole group or one operating company.

Metric definitions

  • CPL — spend / leads
  • Qualified CPL — spend / qualified leads (excludes bad_lead)
  • CAC — spend / won new customers (won = deposit paid, wonAt set)
  • ROAS (booked) — booked revenue / spend (job total at won)
  • ROAS (realized) — cash received net of fees (and refunds when Stripe is wired) / spend
  • Average deal value — booked revenue / won jobs
  • Completion rate — completed / won

Time bases

  • Cohort (default) — outcomes credited to the lead created date. Best for judging ads; recent periods are immature.
  • Cash — spend in the period against sales closed in the period. Matches the books; weaker for judging a specific ad.

Confidence tiers

TierEvidence
AFirst-party click record with platform ad ID and click ID (Phase 2)
BAd ID from UTMs / CrewOS leadAdId (Phase 1 path)
CChannel known, ad unknown
DNo evidence — unattributed

Unattributed and unmapped rows

Unattributed leads and unmapped spend are always shown as their own rows. They are never spread across channels.

Company vs group views

  • Admin / group viewer — all companies and the group roll-up
  • Company viewer — only assigned companies; no group totals. Scoping is enforced in the data layer.

Data freshness

CrewOS sync runs hourly (full pull). Interim Meta spend comes from CrewOS ads windows and/or Ads Manager CSV until the Meta token arrives. TikTok uses CSV until app approval. Check the Data quality panel on the dashboard for last successful sync times.

Request access

Ask an admin to invite your Google email on the Admin screen and assign a role plus companies. The first admin is carlton@reawakencap.com.

← Back to dashboard

Sign in