Marketing ROAS & CAC report
One question, a complete efficiency picture: blended ROAS, CAC by channel, payback period, and where every dollar of spend is working hardest.
What this report answers
The marketing ROAS & CAC report is a generative report that measures spend efficiency: blended and per-channel ROAS, customer acquisition cost, payback period, and channel contribution to revenue. Ultra BI builds it from GA4, your ad data, and your store or billing in seconds, with the query shown so the math is transparent.
Key metrics
- Blended ROAS (all channels)
- ROAS by channel and campaign
- Customer acquisition cost (CAC)
- CAC payback period
- Spend vs revenue by channel
- New customer contribution
Works with
Ask follow-ups in plain English
FAQ
What data do I need for this report?
Connect GA4 and your ad platforms for spend and traffic, plus a revenue source like Shopify or Stripe to attribute revenue.
How is blended ROAS calculated?
Ultra BI joins total spend across channels with revenue from your store or billing system and shows the resulting blended ROAS — along with the query, so you can see exactly how the figure was produced.
Can I customize the template?
Yes. Ask follow-up questions in plain English to break ROAS or CAC down by channel, campaign, or period, then save it. It supports the marketing analytics workflow.
Generate your ROAS & CAC report
Connect GA4, your ad data, and your store, then run this report in seconds.