ROAS decides where your budget goes, so it has to be up to date whenever you check. But why rebuild it by hand in a spreadsheet every week? Coupler.io calculates it once and keeps it live, so ten minutes from now you’ll have a ROAS report that updates itself. Let’s set it up.
Step1: Connect your Facebook Ads account
Use the form below to point Coupler.io at Facebook Ads. You’ll be offered to create a free account with no credit card required. The connection is read-only, so Coupler.io reads your campaign data without changing anything in your ad account.
Sign in to your Facebook Ads account when prompted, choose the campaign performance data, and pick the date range you want to track.
Step 2: Turn spend and revenue into ROAS
Spend and revenue arrive in separate columns, so here you do the division once, and ROAS becomes its own column from then on, recalculated every time fresh data comes in. To get there, keep the columns that matter and add your calculations:
- Campaign name, Amount spent, Purchases, and Purchase conversion value (the revenue Facebook attributes to your campaigns via the pixel, so make sure your conversion tracking is set up for the numbers to be accurate)
- Formula fields to add a ROAS column (Purchase conversion value ÷ Amount spent) and, if you watch cost per result, a CPA column (Amount spent ÷ Purchases). They appear as native columns in your destination.
Planning to hand this data to an AI tool like Claude or ChatGPT for analysis? Add context so the tool reads it correctly.
Step 3: Send the data where your team already looks
Pick where you want the numbers to land and sign in to that account. You can send the same data to more than one place at once, so your ROAS shows up in the Google Sheet your team lives in, your AI chat, the dashboard your client checks, and more, all from one setup.
Step 4: Make the numbers update themselves
Choose how often the numbers should refresh, then hit Save and Run. Your report fills in within a minute, and ROAS recalculates every time.
Here’s what the result looks like in Google Sheets:
That’s it. Your ROAS keeps itself up to date in every place you sent it, so whenever you check, the number’s already right.
Set your Facebook Ads ROAS tracking on autopilot.
Get started for freeAlready working in Claude or ChatGPT every day? You can set this whole thing up right from the chat. Describe the report in one sentence and let AI build the data flow for you.