Understanding your Traffic Source / Medium data from Google Analytics in Excel helps marketing teams identify which channels drive visitors to your site and allocate resources effectively.
Rather than manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Traffic Source / Medium as your primary dimension
-
Step 4:
Choose metrics to analyze by traffic source
-
Step 5:
Import into Excel and set up auto-refresh
Step 1: Install Coefficient and Connect to Google Analytics
Begin by installing the Coefficient add-in and connecting it to your Google Analytics account:
- Open Excel and navigate to the Insert tab
- Click on Get Add-ins
- Search for “Coefficient” in the Office Add-ins store
- Click Add to install the Coefficient add-in
- Once installed, the Coefficient sidebar will appear
- Click “Import” to begin connecting data sources
- Select “Google Analytics” from the marketing integrations
- Log in with your Google account and authorize Coefficient to access your data

Step 2: Select and Configure Traffic Source / Medium Data
After connecting your Google Analytics account, configure your Traffic Source / Medium data import:
- Choose your Google Analytics 4 property from the dropdown menu
- Set your desired date range (last 7 days, last 30 days, custom range, etc.)
- Select “Traffic Source / Medium” as your primary dimension
-
- Users to see visitor volume by source
- Sessions to track engagement by source
- Conversions to measure effectiveness
- Revenue to understand value by channel
- Apply filters if you want to focus on specific traffic sources
- Preview your selection to ensure it provides the insights you need

Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Traffic Source / Medium data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Traffic Source / Medium data into your Excel worksheet
- Choose where you want the data to be placed in your spreadsheet
-
- Navigate to the “Automations” tab in the Coefficient sidebar
- Select “Schedule Refresh” for your imported traffic data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in traffic patterns

Available Google Analytics Data
Metrics & Dimensions
- Sessions
- Pageviews
- Conversions (Key Events)
- Traffic Source / Medium
- Engaged Sessions
- Session Conversion Rate
- Total Revenue
- Landing Page
- Event Count
- Campaign
- Device Category
- New Users
Analyzing Traffic Source / Medium Data in Excel
With your Traffic Source / Medium data now in Excel, you can create valuable analyses like:
- Channel performance comparison across key metrics
- Trend analysis showing how traffic sources evolve over time
- ROI calculations for different marketing channels
- Custom visualizations that highlight your most valuable traffic sources
- Automated channel mix reports that refresh with the latest data
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Traffic Source / Medium data into Excel today with Coefficient and transform how your team analyzes marketing channel performance.
Frequently Asked Questions
Trusted By Over 50,000 Companies