Back to Cookbook
IntegrationPro

True E-commerce ROAS Calculator

Calculate real ROAS including refunds, COGS, and shipping.

1 hour
Advanced
Level:
6h/month

Platforms

Best For

Prerequisites

  • Shopify with detailed order data

Tools Used

meta_get_insightsAd spend and revenue
google_ads_run_gaqlAd spend and revenue

Prompts

Copy these prompts and paste them into Claude, ChatGPT, or any connected AI assistant with Ad Superpowers.

True ROAS Calculation

Help me calculate true ROAS, not just ad platform reported ROAS. I need to factor in: 1) Actual Shopify revenue (not estimated), 2) Refunds and chargebacks, 3) COGS for margin, 4) Shipping costs. Show me the formula and calculation.

Expected output: True ROAS calculation methodology with numbers