How to Use Coupler.io to Merge Ad Spend From Three Platforms
By Joris van Huët
Enterprise Interim CMO & Marketing Leader · 15+ years · 50+ orgs
Published
2026-10-26
The short answer: for one brand with one account each on Google Ads, Facebook Ads and LinkedIn Ads, Coupler.io's Starter plan at $24 a month billed annually holds this job, with three accounts, one destination and a daily refresh (pricing page, checked on 26 October 2026). Add the three sources to one data flow, rename the cost and conversion columns so they match, Append them, send the result to Data Studio, schedule a daily run, and check one day's spend per platform against each ad manager before anyone reads a blended total.
Disclosure: I may earn a commission through some links on this site. It does not change what this page says.
Three ad platforms, three exports, three sets of column names: the weekly spend table is usually a copy-paste job that breaks when someone renames a campaign. A Coupler.io data flow does the stacking for you and reruns it every day. For plans and limits, see the Coupler.io glossary entry.
Before you build:
- Rows per source, per run. Starter pulls up to 5,000 rows from each source per run, counted before any filter (features and limits). For example, 25 campaigns over 120 days is 25 x 120 = 3,000 daily rows per platform, which fits; 50 campaigns over the same window is 6,000, which gets cut off.
- The column names you already use. Write down what your current report calls cost, clicks and conversions. Append matches columns by name, so these become the names every platform is renamed to.
- One day you can check. Pick a recent day and note each platform's spend from its own ad manager. That is the test the finished table has to pass.
What you need
- A Coupler.io account; sign-up includes seven days with Pro limits (pricing FAQ).
- Logins for the Google Ads, Facebook Ads and LinkedIn Ads accounts, and a Google account for Data Studio, which Google renamed from Looker Studio in April 2026 (Data Studio release notes).
Step 1: Create the data flow
From the home screen, click Create Data Flow and choose Set up from scratch; a prebuilt data set template, with its source preselected, is the alternative (first data flow guide). Name the flow after the report it feeds.
Step 2: Add the three sources
Add Google Ads first: connect the account, pick the campaign report, set the date range and split the data by day. Then add Facebook Ads and LinkedIn Ads as further sources in the same flow (combining data guide). Use the same date range and the same daily split on all three, or the stacked table compares unlike periods.
Step 3: Make the columns match
Open the Data sets step and work through each source in the left panel. Hide the columns you do not need, rename the rest to the names from your checklist (Date, Campaign, Cost, Clicks, Conversions), and set Cost as a currency and Date as a date. Add a custom column called Platform with a fixed value per source, so the merged table still says where each row came from; formula columns work on every plan (first data flow guide).
Step 4: Append the three sources
Choose Add transformation, then Append, and select the three sources. Coupler.io builds the list of unique column names across them and stacks every row underneath, so a column that is called Spend in one source and Cost in another becomes two half-empty columns (Append guide). Read the appended preview before you go on: one Cost column, filled on every row, is the sign the renaming worked.
Step 5: Send it to Data Studio and schedule it
In Destinations, pick Data Studio and choose the appended data set as the one to load. On Starter this is your one destination for every future flow, so choose with that in mind. In Flow settings, set a daily run at an hour after the platforms have settled the previous day, save, and run the flow once by hand. Use the green View results button after the run to open the right destination, as the mismatch guide recommends.
Step 6: Let the AI agent answer, and check its work
Coupler.io's AI Agent, still in beta, can query any data set with a successful run and answer in plain English; Starter includes 900 credits a month (AI Agent guide, features and limits). Open the agent on this flow and ask: "Which platform had the lowest cost per conversion last week, and how much did each spend?" The agent can also build flows from a description, and the AI setup guide says it summarises an ambiguous request and asks you to confirm before creating anything, and never runs the new flow on its own.
The agent answers; a person checks. Compare its spend figures with the day you noted from the ad managers, and ask it which columns and dates it used when a number looks off.
What Coupler.io's docs warn about
- Columns that do not match. Append stacks by name; mismatched names give you separate columns instead of one table, per the Append guide.
- Truncated data. Past the row limit, the import still lands but cut short, and the flow's automatic refresh pauses until you reduce the data or upgrade (features and limits).
- Numbers that differ from the platform. Check dates, report level, the daily split and filters first, and remember the Data sets preview shows only the first 500 rows (mismatch guide).
- The same account counted twice. One login added twice as separate credentials counts as two accounts (accounts limit calculation).
Do it by hand first, then decide
The free version is a spreadsheet: export last week from each ad manager as a CSV, rename the headers to your checklist names, and paste the three under each other with a Platform column. Do it twice. If the renaming is the part that takes the time, Coupler.io removes exactly that; if the exports are rarely needed, the free plan's one account and 100 rows a run let you automate the smallest of the three and keep the rest manual (pricing FAQ).
Plan the destination before the first flow, not after. Starter binds every flow to the destination of the first one, so on the day the board wants the table in Data Studio and the team wants it in Sheets, the remedy on the pricing page is Active at $99 with three destinations. That upgrade is what the single-destination default is built to produce; decide which tool is the record before you build, and $24 can stay $24.
FAQ
Can I add a fourth platform later?
Yes, as long as the plan's accounts allow it. Starter counts 3 accounts across all sources, so a fourth ad account means Active, which allows 15, or extra accounts bought through support (features and limits).
Why does the merged table have two cost columns?
Because the sources used different names for cost. Append matches columns by name, so rename them to one name in each source's Data sets step and run the flow again (Append guide).
Does filtering in Data sets keep me under the row limit?
No. The limit counts the rows the source returns before the Data sets step, so a filter there does not help; narrow the date range or the report at the source instead (features and limits).
ABOUT THE AUTHOR
I am Joris van Huët, an enterprise interim CMO. 15+ years, 50+ organizations, including ING, P&G, Nestlé, BNP Paribas, WeTransfer and Vinted. I take on innovation projects (venture building, design sprints), agentic marketing (setting up and running AI agents) and hands-on multi-channel work. See the track record.
I wrote and published this with AI assistance, and I answer for it. Claims about my own experience are limited to the track record above, and a statistic links to its source or is labelled as an example. I sell interim and fractional CMO work, which is why this site exists. How this site is written.
A senior operator doing the work: campaigns, channels, CRM and AI agents, live from day one.