ROAS dashboard template
A ready ROAS dashboard template: spend, leads, revenue, and ROAS by channel in one sheet. Copy the structure into your own table.
A multi-channel ROAS dashboard template: spend from Meta Ads, Google Ads, and TikTok Ads, revenue from your CRM, and ROAS per channel. The report merges sources via UTM and GCLID attribution.
Read more
Report preview
| Channel | ROAS | Revenue share |
|---|---|---|
| Google Ads | 250% | 45% |
| Meta Ads | 180% | 35% |
| TikTok Ads | 120% | 20% |
Preview values illustrate the table structure. Real figures will come from your sources after the report is configured.
Columns
- source, campaign_name, month
- spend, impressions, clicks, cpc
- leads, deals_created, deals_won, revenue
- roas, romi, profit, cac, revenue_share
Data sources
- Meta Ads + Google Ads + TikTok Ads
- CRM: Kommo, Bitrix24, KeyCRM, LP CRM, Pipedrive, HubSpot, GoHighLevel
How to set up
- Connect your ad accounts and CRM in LightLead
- Create a multi-source report with attribution presets: Meta Ads + CRM (UTM), Google Ads + CRM (GCLID), TikTok Ads + CRM (UTM)
- Add calculated metrics: roas, romi, profit, cac, revenue_share
- Set a schedule (daily) — data and attribution refresh automatically
Formulas
- ROAS = revenue / spend × 100
- ROMI = (revenue − spend) / spend × 100
- profit = revenue − spend
- CAC = spend / deals_won
- revenue_share = revenue / total_revenue × 100
Template copy
A ready Google Sheets file to copy is not published yet. Write to [email protected] and we will send a copy link once the template is ready.
Multi-channel ROAS recipe: https://docs.lightlead.space/recipes/attribution/multi-source-roas . Calculated metric formulas: https://docs.lightlead.space/reference/calculated-metrics
Read next
Start with LightLead free
Create your first report — spend, leads, and attribution in Google Sheets.
Create your first report