How to Import Conversion Action Data from Google Ads into Excel

Importing your Google Ads Conversion Action data into Excel enables deeper analysis of conversion performance, attribution patterns, and value tracking beyond what Google Ads’ standard reporting provides.

With Coefficient, you can create a live connection that keeps your conversion data current in Excel without manual exports, helping you understand which actions drive the most valuable customer behaviors.

Step-by-Step Guide to Importing Google Ads Conversion Action into Excel

Step 1: Install Coefficient in Excel

First, add the Coefficient add-in to Excel:

1. Open Excel
2. Click on the “Insert” tab in the ribbon
3. Select “Get Add-ins”
4. Search for “Coefficient” in the Office Add-ins store
5. Click “Add” to install the Coefficient add-in

Step 2: Connect to Google Ads and Import Conversion Action Data

After installing Coefficient, follow these steps to import your Conversion Action data:

1. Open the Coefficient sidebar in Excel
2. Click “Import” to see available data sources
3. Select “Google Ads” from the marketing connectors list
4. Log in with your Google Ads credentials when prompted
5. From the object list, select “Conversion Action”
6. Choose which conversion metrics you want to import (e.g., conversions, conversion value, conversion rate, cost per conversion)
7. Apply any filters if needed (e.g., date range, conversion type)
8. Click “Import” to bring the data into your spreadsheet

Step 3: Set Up Auto-Refresh (Optional)

To ensure your Conversion Action data remains up-to-date:

1. Select your imported Conversion Action data in Excel
2. In the Coefficient sidebar, click “Refresh”
3. Choose “Set up auto-refresh”
4. Select your preferred refresh schedule (hourly, daily, or weekly)
5. Configure any notification settings
6. Click “Save” to enable automatic updates