Consolidate live expense report data from Sage Intacct into Excel to review submissions and approvals in one place. In this guide, you’ll install Coefficient, import expense reports, and set up automatic refresh.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Expense Reports” > Import.
-
Step 3:
Apply filters if needed, then confirm.
-
Step 4:
Enable auto-refresh to keep data updated automatically.
Step-by-Step Guide
What Sage Intacct Data Is Imported?
Rate Table Timesheet Entries
- Rate Table Credit Card Entries
- Rate Table Employee Expense Entries
- Rate Table Accounts Payable Entries
- Rate Table General Ledger Entries
- Standard Tasks
- Contract Expenses
- Contracts
- Employees
- Expense Adjustments
- Adjustment Lines
- Expense Payment Types
- Expense Reports
Bring live reimbursement records from Sage Intacct into Excel to track refunds and approvals in one sheet. This tutorial covers installing Coefficient, importing reimbursements, and setting up auto-refresh.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Expense Reports” > Import.
-
Step 3:
Apply filters if needed, then confirm.
-
Step 4:
Enable auto-refresh to keep data updated automatically.
Step-by-Step Guide
What Sage Intacct Data Is Imported?
Rate Table Timesheet Entries
- Rate Table Credit Card Entries
- Rate Table Employee Expense Entries
- Rate Table Accounts Payable Entries
- Rate Table General Ledger Entries
- Standard Tasks
- Contract Expenses
- Contracts
- Employees
- Expense Adjustments
- Adjustment Lines
- Expense Payment Types
- Expense Reports
| Rate Table Timesheet Entries |
| Rate Table Purchase Order Entries |
| Rate Table Credit Card Entries |
| Rate Table Employee Expense Entries |
| Rate Table Accounts Payable Entries |
| Rate Table General Ledger Entries |
| Standard Tasks |
| Contract Expenses |
| Contracts |
| Employees |
| Expense Adjustments |
| Adjustment Lines |
| Expense Payment Types |
| Expense Reports |
| Reimbursements |
| Reimbursement Requests |
| GENERAL LEDGER |
| Raw Account Balances |
| Budgets |
| Budget Details |
| Journal Entries |
| Journal Entry Lines |
| Available Inventory |
| Cost of Goods Sold Adjustments |
| Inventory Price Lists |
| Inventory Total Details |
| Inventory Transactions |
| Item GL Groups |
| Items |
| Warehouse Transfers |
| Warehouses |
| Order Entry Transactions |
| Order Entry Transaction Lines |
| Order Entry Transaction Subtotals |
| Order Entry Price Lists |
| Object Audit Trail Logs |
| Positions and Skills |
| Project Group |
| Observed Percent Completed Entries |
| Projects |
| Task Resources |
| Tasks |
| Timesheets |
| Timesheet Entries |
| Timesheet Approval History |
| Transaction Rules |
| Transaction Rule Details |
| Purchasing Price Lists |
| Purchasing Transactions |
| Purchasing Transaction Subtotals |
| Vendor Compliance Definitions |
| Vendor Compliance Records |
| Vendor Compliance Types |
| Tax Details |
| Tax Records |
| Tax Solutions |
| How do I import Reimbursements into Excel? |
|
| Can I filter reimbursements by approval date? |
|
| How do I update reimbursements back to Sage Intacct? |
|
| Is auto-refresh available for reimbursements? |
|
| Where can I find more on Sage Intacct objects? |
|
Track reimbursement requests in real time by importing them from Sage Intacct into Excel. This guide shows you how to install Coefficient, import requests, and schedule automatic refresh.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Expense Reports” > Import.
-
Step 3:
Apply filters if needed, then confirm.
-
Step 4:
Enable auto-refresh to keep data updated automatically.
Step-by-Step Guide
What Sage Intacct Data Is Imported?
Rate Table Timesheet Entries
- Rate Table Credit Card Entries
- Rate Table Employee Expense Entries
- Rate Table Accounts Payable Entries
- Rate Table General Ledger Entries
- Standard Tasks
- Contract Expenses
- Contracts
- Employees
- Expense Adjustments
- Adjustment Lines
- Expense Payment Types
- Expense Reports
| Rate Table Timesheet Entries |
| Rate Table Purchase Order Entries |
| Rate Table Credit Card Entries |
| Rate Table Employee Expense Entries |
| Rate Table Accounts Payable Entries |
| Rate Table General Ledger Entries |
| Standard Tasks |
| Contract Expenses |
| Contracts |
| Employees |
| Expense Adjustments |
| Adjustment Lines |
| Expense Payment Types |
| Expense Reports |
| Reimbursements |
| Reimbursement Requests |
| GENERAL LEDGER |
| Raw Account Balances |
| Budgets |
| Budget Details |
| Journal Entries |
| Journal Entry Lines |
| Available Inventory |
| Cost of Goods Sold Adjustments |
| Inventory Price Lists |
| Inventory Total Details |
| Inventory Transactions |
| Item GL Groups |
| Items |
| Warehouse Transfers |
| Warehouses |
| Order Entry Transactions |
| Order Entry Transaction Lines |
| Order Entry Transaction Subtotals |
| Order Entry Price Lists |
| Object Audit Trail Logs |
| Positions and Skills |
| Project Group |
| Observed Percent Completed Entries |
| Projects |
| Task Resources |
| Tasks |
| Timesheets |
| Timesheet Entries |
| Timesheet Approval History |
| Transaction Rules |
| Transaction Rule Details |
| Purchasing Price Lists |
| Purchasing Transactions |
| Purchasing Transaction Subtotals |
| Vendor Compliance Definitions |
| Vendor Compliance Records |
| Vendor Compliance Types |
| Tax Details |
| Tax Records |
| Tax Solutions |
| How do I import Reimbursement Requests into Excel? |
|
| Can I filter requests by employee? |
|
| How do I update requests back to Sage Intacct? |
|
| Is auto-refresh available for requests? |
|
| Where can I find more on Sage Intacct objects? |
|
Import live GENERAL LEDGER entries from Sage Intacct into Excel to monitor transactions as they occur. This guide covers installing Coefficient, importing ledger entries, and automating refresh.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Expense Reports” > Import.
-
Step 3:
Apply filters if needed, then confirm.
-
Step 4:
Enable auto-refresh to keep data updated automatically.
Step-by-Step Guide
What Sage Intacct Data Is Imported?
Rate Table Timesheet Entries
- Rate Table Credit Card Entries
- Rate Table Employee Expense Entries
- Rate Table Accounts Payable Entries
- Rate Table General Ledger Entries
- Standard Tasks
- Contract Expenses
- Contracts
- Employees
- Expense Adjustments
- Adjustment Lines
- Expense Payment Types
- Expense Reports
| Rate Table Timesheet Entries |
| Rate Table Purchase Order Entries |
| Rate Table Credit Card Entries |
| Rate Table Employee Expense Entries |
| Rate Table Accounts Payable Entries |
| Rate Table General Ledger Entries |
| Standard Tasks |
| Contract Expenses |
| Contracts |
| Employees |
| Expense Adjustments |
| Adjustment Lines |
| Expense Payment Types |
| Expense Reports |
| Reimbursements |
| Reimbursement Requests |
| GENERAL LEDGER |
| Raw Account Balances |
| Budgets |
| Budget Details |
| Journal Entries |
| Journal Entry Lines |
| Available Inventory |
| Cost of Goods Sold Adjustments |
| Inventory Price Lists |
| Inventory Total Details |
| Inventory Transactions |
| Item GL Groups |
| Items |
| Warehouse Transfers |
| Warehouses |
| Order Entry Transactions |
| Order Entry Transaction Lines |
| Order Entry Transaction Subtotals |
| Order Entry Price Lists |
| Object Audit Trail Logs |
| Positions and Skills |
| Project Group |
| Observed Percent Completed Entries |
| Projects |
| Task Resources |
| Tasks |
| Timesheets |
| Timesheet Entries |
| Timesheet Approval History |
| Transaction Rules |
| Transaction Rule Details |
| Purchasing Price Lists |
| Purchasing Transactions |
| Purchasing Transaction Subtotals |
| Vendor Compliance Definitions |
| Vendor Compliance Records |
| Vendor Compliance Types |
| Tax Details |
| Tax Records |
| Tax Solutions |
| How do I import GENERAL LEDGER entries into Excel? |
|
| Can I filter ledger entries by date or account? |
|
| How do I export ledger edits back to Sage Intacct? |
|
| Is auto-refresh available for ledger entries? |
|
| Where can I learn more about Sage Intacct objects? |
|
How to Import Google Analytics Engaged Sessions Data into Excel
Analyzing Engaged Sessions data from Google Analytics in Excel helps marketing teams understand which visitors are meaningfully interacting with your site beyond just page visits.
Instead of manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Engaged Sessions as your primary metric
-
Step 4:
Configure dimensions to segment your engagement data
-
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 Engaged Sessions Data
After connecting your Google Analytics account, configure your Engaged Sessions 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 “Engaged Sessions” as your primary metric
-
- By date to track trends over time
- By source/medium to identify which channels bring engaged users
- By landing page to see which content drives engagement
- By device category to understand platform-based engagement differences
- Apply filters if you want to focus on specific segments of your engagement data
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Engaged Sessions data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Engaged Sessions 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 Engaged Sessions data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in engagement metrics
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 Engaged Sessions Data in Excel
With your Engaged Sessions data now in Excel, you can create valuable analyses like:
- Engagement rate trends over time
- Comparison of engaged sessions across different traffic sources
- Correlation between content types and engagement levels
- Custom visualizations that show engagement alongside other metrics
- Automated reports that refresh with the latest engagement data
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Engaged Sessions data into Excel today with Coefficient and transform how your team analyzes quality user interactions.
How to Import Geographic Performance Data from Microsoft Ads into Excel
Analyzing Geographic Performance data from Microsoft Ads in Excel helps marketers understand how campaigns perform across different locations, enabling more targeted budget allocation and bid adjustments based on regional performance.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your geographic performance.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store in Excel
-
Step 2:
Connect your Microsoft Ads account to Coefficient
-
Step 3:
Import Geographic Performance data with location metrics
-
Step 4:
Set up auto-refresh to keep your geo data current
Step 1: Install Coefficient and Connect Your Microsoft Ads Account
Start by installing the Coefficient add-in in your Excel workbook and connecting to your Microsoft Ads account.
- Open Excel and navigate to the Insert tab
- Click Get Add-ins and search for “Coefficient”
- Install the Coefficient add-in from the Office Add-ins store
- Once installed, open the Coefficient sidebar and click “Import”
- Select “Microsoft Ads” from the list of available connectors
- Follow the authentication prompts to connect your Microsoft Ads account
Step 2: Import Geographic Performance Data
After connecting your Microsoft Ads account, you can import your Geographic Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Geographic Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, conversions by location)
- Apply any filters to focus on specific campaigns or date ranges
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh for Your Data
Keep your Microsoft Ads geographic data fresh by setting up automatic refreshes:
- Select any cell in your imported data range
- Open the Coefficient sidebar and click “Refresh”
- Click “Schedule Refresh” to set up automated updates
- Choose your preferred refresh frequency (hourly, daily, or weekly)
- Confirm your settings to activate the auto-refresh schedule
Analyze Your Geographic Performance
With your Geographic Performance data now in Excel, you can identify top-performing and underperforming regions for your Microsoft Ads campaigns. Create pivot tables to compare metrics like CTR, conversion rate, and cost-per-conversion across different locations, from countries down to cities.
Use Excel’s visualization tools to create heat maps or geo charts that make regional performance trends immediately visible. These insights will help you make location-specific optimizations, such as adjusting bids for high-performing regions or creating location-specific campaigns with tailored messaging.
Microsoft Ads Data Available in Coefficient
Available Objects
- Campaign Performance
- Conversion Performance
- Keyword Performance
- Search Query Performance
- Account Performance
- Ad Dynamic Text Performance
- Ad Extension By Ad
- Ad Extension By Keyword
- Ad Extension Detail
- Ad Performance
- Age Gender Audience
- Audience Performance
How to Import Google Analytics Conversions (Key Events) Data into Excel
Analyzing Conversions (Key Events) data from Google Analytics in Excel helps marketing and revenue teams understand which actions users are taking on your site and how effectively your funnels are performing.
Instead of manually exporting data that quickly becomes outdated, you can establish 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 Conversions (Key Events) as your primary metric
-
Step 4:
Configure dimensions to segment your conversion data
-
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 Conversions Data
After connecting your Google Analytics account, configure your Conversions 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 “Conversions” or specific conversion events as your primary metrics
-
- By event name to track different conversion types
- By date to monitor trends over time
- By source/medium to identify which channels drive conversions
- By user demographics to understand who converts best
- Apply filters if you want to focus on specific segments of your conversion data
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Conversions data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Conversions 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 Conversions data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in conversion metrics
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 Conversions Data in Excel
With your Conversions data now in Excel, you can create valuable analyses like:
- Conversion rate trends over time
- Comparison of conversion performance across different channels
- Correlation between marketing campaigns and conversion spikes
- Custom visualizations that show conversion funnels and drop-off points
- ROI calculations based on conversion value and marketing spend
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Conversions data into Excel today with Coefficient and transform how your team tracks and optimizes conversion performance.
How to Import Google Analytics Campaign Data into Excel
Analyzing Campaign data from Google Analytics in Excel helps marketing teams understand which promotional efforts are driving traffic, engagement, and conversions to your website.
Rather than manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest campaign metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Campaign as your primary dimension
-
Step 4:
Choose metrics to analyze by campaign
-
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 Campaign Data
After connecting your Google Analytics account, configure your Campaign 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 “Campaign” as your primary dimension
-
- Sessions to measure traffic volume
- Conversions to track goal completions
- Revenue to assess monetary impact
- Engagement metrics to evaluate quality of traffic
- Apply filters if you want to focus on specific campaigns
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Campaign data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Campaign 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 campaign data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in campaign performance
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 Campaign Data in Excel
With your Campaign data now in Excel, you can create valuable analyses like:
- Campaign performance comparison across key metrics
- ROI calculations for different marketing initiatives
- Performance trends over time for ongoing campaigns
- Custom visualizations highlighting your most effective campaigns
- Automated reports that track campaign effectiveness in real-time
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Campaign data into Excel today with Coefficient and transform how your team analyzes marketing effectiveness.
How to Import Google Analytics Event Count Data into Excel
Analyzing Event Count data from Google Analytics in Excel helps marketing teams understand how users interact with your website and which actions they take most frequently.
Instead of manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest event metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Event Count as your primary metric
-
Step 4:
Configure dimensions to segment your event data
-
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 Event Count Data
After connecting your Google Analytics account, configure your Event Count 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 “Event Count” as your primary metric
-
- By event name to see which actions occur most frequently
- By date to track trends over time
- By page to understand where events happen
- By user type to compare new vs. returning users
- Apply filters if you want to focus on specific types of events
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Event Count data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Event Count 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 event data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in event metrics
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 Event Count Data in Excel
With your Event Count data now in Excel, you can create valuable analyses like:
- Most frequent user interactions ranked by volume
- Event trends over time to identify changing user behaviors
- Funnel analysis showing progression through key events
- Custom visualizations highlighting user engagement patterns
- Automated reports that track event performance across your site
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Event Count data into Excel today with Coefficient and transform how your team analyzes user interactions.
How to Import Google Analytics Landing Page Data into Excel
Analyzing Landing Page data from Google Analytics in Excel helps content and marketing teams understand which entry points are most effective at attracting visitors and driving conversions.
Rather than manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest landing page metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Landing Page as your primary dimension
-
Step 4:
Choose metrics to analyze by landing page
-
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 Landing Page Data
After connecting your Google Analytics account, configure your Landing Page 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 “Landing Page” as your primary dimension
-
- Sessions to see traffic volume
- Bounce rate to measure initial engagement
- Conversion rate to assess effectiveness
- Revenue to understand value generation
- Apply filters if you want to focus on specific landing pages
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Landing Page data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Landing Page 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 landing page data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in landing page performance
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 Landing Page Data in Excel
With your Landing Page data now in Excel, you can create valuable analyses like:
- Performance rankings of your top landing pages
- Conversion funnel analysis from entry point to goal completion
- Content effectiveness comparison across different page types
- Custom visualizations showing landing page metrics over time
- Automated reports that highlight your highest and lowest performing entry points
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Landing Page data into Excel today with Coefficient and transform how your team analyzes entry point performance.
How to Import Google Analytics Pageviews Data into Excel
Analyzing Pageviews data from Google Analytics in Excel helps content and marketing teams understand which pages drive engagement and how visitors navigate your site.
Rather than relying on manual exports that quickly become 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 Pageviews as your primary metric
-
Step 4:
Configure dimensions to segment your Pageviews data
-
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 Pageviews Data
After connecting your Google Analytics account, configure your Pageviews 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 “Pageviews” as your primary metric
-
- By page title/URL to see which content performs best
- By date to track trends over time
- By source/medium to identify which channels drive page traffic
- By device category to understand viewing platforms
- Apply filters if you want to focus on specific segments of your Pageviews data
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Pageviews data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Pageviews 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 Pageviews data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in Pageviews metrics
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 Pageviews Data in Excel
With your Pageviews data now in Excel, you can create valuable analyses like:
- Top performing content by Pageviews
- Trends in content popularity over time
- Comparison of Pageviews across different traffic sources
- Custom visualizations that show Pageviews alongside other engagement metrics
- Automated reports that refresh with the latest Pageviews data
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Pageviews data into Excel today with Coefficient and transform how your team analyzes content performance.
How to Import Google Analytics New Users Data into Excel
Analyzing New Users data from Google Analytics in Excel helps marketing teams understand audience growth, acquisition effectiveness, and how first-time visitors interact with your website.
Rather than manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest new user metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select New Users as your primary metric
-
Step 4:
Configure dimensions to segment your new user data
-
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 New Users Data
After connecting your Google Analytics account, configure your New Users 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 “New Users” as your primary metric
-
- By date to track acquisition trends over time
- By source/medium to identify which channels bring new visitors
- By campaign to measure acquisition efforts
- By geography to understand regional growth
- Apply filters if you want to focus on specific segments of new users
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your New Users data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the New Users 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 new users data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in new user acquisition
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 New Users Data in Excel
With your New Users data now in Excel, you can create valuable analyses like:
- Audience growth trends over time
- New vs. returning users comparison
- Channel effectiveness for acquiring new visitors
- Custom visualizations showing acquisition by source
- Automated reports that highlight changes in new user patterns
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics New Users data into Excel today with Coefficient and transform how your team analyzes audience growth.
How to Import Google Analytics Session Conversion Rate Data into Excel
Analyzing Session Conversion Rate data from Google Analytics in Excel helps marketing and revenue teams understand how effectively your site turns visitors into customers, leads, or other valuable conversions.
Rather than manually exporting data that quickly becomes outdated, you can establish 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 Session Conversion Rate as your primary metric
-
Step 4:
Configure dimensions to segment your conversion rate data
-
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 Session Conversion Rate Data
After connecting your Google Analytics account, configure your Session Conversion Rate 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 “Session Conversion Rate” as your primary metric
-
- By date to track trends over time
- By source/medium to identify best-converting channels
- By landing page to see which entry points convert best
- By device category to understand platform-based conversion differences
- Apply filters if you want to focus on specific segments of your conversion rate data
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Session Conversion Rate data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Session Conversion Rate 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 conversion rate data
- Choose your preferred refresh frequency (hourly, daily, weekly)
- Optionally, set up alerts for significant changes in conversion rate metrics
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 Session Conversion Rate Data in Excel
With your Session Conversion Rate data now in Excel, you can create valuable analyses like:
- Conversion rate trends over time
- Comparison of conversion rates across different traffic sources
- Landing page performance ranked by conversion effectiveness
- Custom visualizations that highlight conversion rate patterns
- Automated reports that refresh with the latest conversion rate data
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Session Conversion Rate data into Excel today with Coefficient and transform how your team optimizes conversion performance.