The steps for exporting campaign data from advertising platforms for import into Google Analytics are different based on the specific platform being used.
This article provides the instructions and resources for the various platforms that are supported. Given that these platforms don’t necessarily supply data using the same format that is native to Analytics, it’s up to you to ensure that the data you export from these platforms is consistent with the format Analytics expects. Learn how to prepare your campaign data for import.
On this page:
To use LinkedIn’s Campaign Manager to export campaign data:
- Navigate to the Campaigns or Reporting section, which is typically your main dashboard.
- Set your date range. 12 months is recommended.
- Click Export.
- Customize the columns to include the following required and recommended dimensions and metrics:
- Date (Required)
- Campaign Name and/or Campaign ID (Recommended if used in your UTMs)
- Amount Spent (Cost)
- Clicks
- Impressions (optional, but recommended)
- Select the Daily Time Breakdown so each row represents a single day's performance for a specific campaign.
- Click the Export button to download the file.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
Related resources
Meta
To use Meta Ads Manager to export your data:
- In Ads Manager, navigate to your Ads Reporting section.
- Set your date range. 12 months is recommended.
- Add the “Breakdown” by date, ensuring this is by day.
- Select the option to customize your report to include the dimensions and metrics:
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Total Spend (Cost)
- Clicks
- Impressions (optional, but recommended)
- Click the Export icon.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
Related resource
Microsoft
To use Microsoft Advertising reports to export a CSV file of your data:
- Navigate to your Reports section.
- Click on Standard Reports.
- Select a report type that includes campaign performance data, such as “Campaign performance”.
- Set your date range. 12 months is recommended.
- Ensure the “Time Unit” or “Aggregation” setting is set to “Day”.
- Select the option to customize your report to include the dimensions and metrics:
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Total Spend (Cost)
- Clicks
- Impressions (optional, but recommended)
- Select CSV or TSV format
- Click the Download icon.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
You can also use Microsoft Reporting API to export data for campaigns.
Related resource
To use Pinterest Ads Manager to export your data:
- Navigate to the Reporting section.
- Set your date range. 12 months is recommended.
- Add the “Time Breakdown” option and ensure this is set to “Day”.
- Use the "Customize Columns" option to include the dimensions and metrics listed below:
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Spend (Cost)
- Outbound Clicks (The metric that represents clicks leading off-site)
- Impressions (optional, but recommended)
- Click the Export icon and select CSV.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
Note: Pinterest doesn’t provide built-in support for Source and Medium. You can hard code the source and medium values based on how you tagged your ads with UTM parameters for each campaign ID.
Snap
To use Snap Ads Manager to export your data:
- Navigate to the Reporting section.
- Set your date range. 12 months is recommended.
- Select the "Time Granularity" option and ensure this is set to “Daily”.
- Use the "Customize Columns" option to include the dimensions and metrics listed below:
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Spend (Cost)
- Swipes (Snap's equivalent of Clicks)
- Impressions (optional, but recommended)
- Click the Export icon and select CSV.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
Note: Snap doesn’t provide built-in support for Source and Medium. You can hard code the source and medium values based on how you tagged your ads with UTM parameters for each campaign ID.
To use Reddit Ads Manager to export your data:
- Navigate to the Dashboard.
- Set your date range. 12 months is recommended.
- Use the "Customize Columns" option to include the dimensions and metrics listed below:
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Spend (Cost)
- Swipes (Snap's equivalent of Clicks)
- Impressions (optional, but recommended)
- Select the Granularity or Group by option and ensure this is set to “Day”.
- Click the Export icon and select CSV.
- Verify the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
Note: Reddit doesn’t provide built-in support for Source and Medium. You can hard code the source and medium values based on how you tagged your ads with UTM parameters for each campaign ID
X
Use the Export option in the upper right section of your campaign dashboard to export a CSV file of your campaign data.
To use Campaign dashboard to export a CSV file of your data:
- Navigate to your Campaign dashboard
- Set your date range. 12 months is recommended.
- Click Export
- Select the daily aggregation option.
- Verify the necessary fields are included & the format of exported fields, especially Date which is expected to be ISO 8601: YYYY-MM-DD.
- Date
- Campaign Name and/or Campaign ID (if you use these in your UTMs)
- Total Spend (Cost)
- Clicks
- Impressions (optional, but recommended)
Note: X doesn’t provide built-in support for Source and Medium. You can hard code the source and medium values based on how you tagged your ads with UTM parameters for each campaign ID.