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,
wonAtset) - 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
| Tier | Evidence |
|---|---|
| A | First-party click record with platform ad ID and click ID (Phase 2) |
| B | Ad ID from UTMs / CrewOS leadAdId (Phase 1 path) |
| C | Channel known, ad unknown |
| D | No 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.