Can Google Analytics Import Cost Data from Other Ad Networks?

Your Google Analytics is full of valuable conversion and revenue data, but your advertising costs are stuck on their own islands in Facebook Ads Manager, LinkedIn Campaign Manager, and TikTok Ads. To calculate your actual return on investment, you have to constantly jump between tabs and manually stitch numbers together in a spreadsheet. This article will show you exactly how to import cost data from your other ad networks directly into Google Analytics 4, allowing you to finally analyze your complete marketing ROI in one place.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Importing Cost Data into Google Analytics?

Connecting cost data to your analytics is the key to unlocking a single source of truth for your marketing performance. Without it, you’re only ever seeing half the picture. You might know a campaign on Facebook generated 50 sales, but unless you know what you spent to get those sales, you don’t know if the campaign was a home run or a total waste of money.

The main reason to import cost data is to calculate true Return on Ad Spend (ROAS) and Cost Per Acquisition (CPA) for your non-Google campaigns directly within GA4. By default, Google Analytics automatically pulls in cost data from any linked Google Ads accounts. But for any other platform - Facebook, LinkedIn, Taboola, TikTok, Bing - it has no idea how much you're spending. It only sees the traffic and conversions that result from those ads.

When you unify cost and revenue data, you can stop asking these questions:

• "Did my latest Facebook campaign actually make a profit?"
• "Is my LinkedIn lead generation campaign more cost-effective than my Google Search one?"
• "Which non-Google channel is giving me the best ROAS this quarter?"

Instead of logging into five different platforms and referencing a monstrous spreadsheet, you can build reports and dashboards in GA4 that compare the full performance of all your ad channels side-by-side. It transforms GA4 from a simple web analytics tool into a central hub for business intelligence.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What You'll Need: Anatomy of a Cost Data Upload File

To get started, you need to provide your cost data to Google Analytics in a format it can understand: a specifically structured CSV file. If your column headers or data formats are off, the import will fail, so paying close attention here is crucial.

Think of this CSV file as a translator. It takes the cost data from Facebook Ads and formats it in a language that Google Analytics can read and connect to the user sessions it's already tracking.

Your CSV file must include these columns at a minimum:

• date: The date the cost was incurred. This must be in YYYY-MM-DD format (e.g., 2024-05-28). Other date formats will fail.
• source: The source in your UTM tag (e.g., facebook).
• medium: The medium in your UTM tag (e.g., cpc).
• campaign: The name of the campaign in your UTM tag (e.g., summer-sale-2024).
• cost: The total cost for that campaign on that day. Use only numbers and a period for any decimals (e.g., 150.75). Do not include any currency symbols ($) or commas (,).

You can also include these highly recommended columns for more detailed analysis:

• clicks: The number of clicks from your ad platform.
• impressions: The number of impressions from your ad platform.

The Most Important Rule: UTM Consistency

Here’s the single most common reason why a cost data import fails to work as expected: the UTM parameters in your CSV don’t perfectly match the UTM parameters in the destination URLs of your ads.

GA4 connects the costs you upload to the sessions and conversions it has already recorded based on the utm_source, utm_medium, and utm_campaign parameters it captured from users clicking on your ads.

For example, if the URL for your Facebook ad is: https://www.yourwebsite.com/?utm_source=facebook&utm_medium=cpc&utm_campaign=spring-promo

Then the corresponding row in your CSV file must list facebook in the source column, cpc in the medium column, and spring-promo in the campaign column. If your CSV says Spring Promo instead of spring-promo (different capitalization), the data won't link up correctly. A small typo or capitalization difference will cause GA4 to see the cost as completely detached from the revenue.

Here’s what a properly formatted segment of your CSV file might look like:

date,source,medium,campaign,cost,clicks,impressions 2024-05-27,facebook,cpc,spring-promo,110.50,150,12345 2024-05-27,linkedin,cpc,new-ebook-launch,75.00,45,8765 2024-05-28,facebook,cpc,spring-promo,115.25,162,13002 2024-05-28,linkedin,cpc,new-ebook-launch,82.15,51,9104

The Manual Method: A Step-by-Step Guide to Importing Cost Data

Once you understand the format, manually uploading your cost data is a straightforward, albeit repetitive, process. Here’s how you do it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Download Your Ad Spend Data

Log in to the ad platform you want to pull data from (e.g., Facebook Ads Manager, LinkedIn Campaign Manager). Navigate to your reporting section and generate a report showing campaign performance broken down by day. Make sure to include the metrics you need: Spend (Cost), Clicks, and Impressions, along with the Campaign Name.

Export this data as a CSV file.

Step 2: Prepare and Format Your CSV File

Open the exported CSV in a spreadsheet program like Google Sheets or Microsoft Excel. Your goal is to reformat the data to match GA4's required structure.

• Rename the header columns to match GA4's required names: date, source, medium, campaign, cost, clicks, impressions.
• Add columns for source and medium and fill them in with an appropriate static value (e.g., 'facebook' and 'cpc'). The value will be based on the UTMs you're using.
• Format the date column to be YYYY-MM-DD.
• Ensure the cost column contains only numbers.
• Double-check that your campaign names match your utm_campaign tags perfectly.
• Save or export the final cleaned file as a new CSV.

Step 3: Access Data Import in Google Analytics 4

Now, head over to your GA4 property.

• Click on the Admin gear icon in the bottom-left corner.
• In the Property column, find the section called Data Collection and Modification and click on Data Import.

Step 4: Create a New Data Source

This is where you tell GA4 what kind of data you're uploading.

• Click the blue Create data source button.
• Give your data source a descriptive name, like "Facebook Ads Cost Data."
• For the Data type, select Cost Data.
• Click Next.

Step 5: Define the Data Schema and Mapping

Here, you tell GA4 how to interpret the columns in your CSV file. Google will show you a list of "GA4 fields" and a set of dropdowns to map them to your "Import file headers."

Map them as follows:

• GA4 Field: Date → Your Column Header: date
• GA4 Field: Cost → Your Column Header: cost
• GA4 Field: Impressions → Your Column Header: impressions
• GA4 Field: Clicks → Your Column Header: clicks

Next, under Map traffic source dimensions to the imported data columns, you'll map the dimensions that connect this cost data to the user sessions.

• GA4 Field Session campaign → Your Column Header: campaign
• GA4 Field Session medium → Your Column Header: medium
• GA4 Field Session source → Your Column Header: source

This tells GA4, "When you see a session in your data where utm_source was 'facebook' and utm_campaign was 'spring-promo', apply the cost data from the corresponding row in my uploaded file."

Then click Next.

Step 6: Upload Your CSV File

The last screen will ask you to choose an Import behavior. "Overwrite" is the default and is usually what you want, as it lets you re-upload a corrected file for a specific day if you find an error. Finally, click the link to "manual upload (once)" and upload the CSV file you prepared earlier.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 7: Check and Verify

Data processing can take anywhere from a few minutes to 24 hours. After a day, you can check that it worked by going to a standard acquisition report. Navigate to Reports > Acquisition > Traffic acquisition. Customize the report to add Cost and ROAS as metrics, and you should now see those values populated for your non-Google traffic sources and campaigns.

The Challenge with the Manual Approach: Is There a Better Way?

You can see the problem with the manual process: it's incredibly tedious. Logging in, downloading a file, cleaning it up in a spreadsheet, re-checking your formatting, and re-uploading - every single day for every single ad platform - is a monumental time sink. A single mistake in formatting or a misplaced comma can break the entire upload.

This busywork is exactly the kind of task that eats into valuable analysis time. Instead of spending your week gathering data, you should be acting on it. It’s what keeps so many businesses stuck looking at disconnected platform metrics instead of a holistic view of performance. For most teams, a smarter, automated approach is needed to do this sustainably.

Final Thoughts

Pulling cost data from platforms like Facebook into Google Analytics unlocks a far more powerful and complete view of your marketing performance. The process requires creating a carefully formatted CSV file - with perfectly aligned UTM parameters and data fields - and uploading it via GA4’s Data Import feature. While possible to do manually, it requires strict diligence to avoid errors and can quickly consume hours of your week.

We built Graphed to solve this exact problem. Instead of manually exporting CSVs and wrestling with schemas, we automatically connect to all your marketing platforms - Google Analytics, Facebook Ads, Shopify, and dozens more - to pull your cost, revenue, and conversion data into one place. You can build a real-time ROI dashboard by just describing what you want to see, getting back hours of your week without ever touching another CSV file.