Analyzing User Location Performance data from Microsoft Ads in Excel helps marketers understand how campaigns perform based on where users are physically located when they see ads, enabling more targeted geographic optimization strategies.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your user location 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 User Location Performance data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your location 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 User Location Performance Data
After connecting your Microsoft Ads account, you can import your User Location Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “User Location Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, conversions by user 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 user location 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
Optimize Your Geographic Targeting
With your User Location Performance data now in Excel, you can identify which user locations deliver the best results for your campaigns. Create pivot tables to analyze key metrics like CTR, conversion rate, and cost-per-acquisition across different geographic areas, from countries down to cities.
Use Excel’s mapping capabilities to visualize performance patterns by region, and its calculation features to determine location-specific ROI. These insights will help you refine your geographic targeting, create location-specific bid adjustments, and develop customized messaging that resonates with audiences in different locations.
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 Vendor Compliance Definitions Data from Sage Intacct into Excel
Pull live Vendor Compliance Definitions from Sage Intacct into Excel to review your compliance rules and standards. In this guide, you’ll install Coefficient, import compliance definitions, and set up auto-refresh for ongoing governance tracking.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Select “Import from Objects” > “Vendor Compliance Definitions” > 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
How to Import Vendor Compliance Records Data from Sage Intacct into Excel
Pull live Vendor Compliance Records from Sage Intacct into Excel to track vendor compliance status and history. In this guide, you’ll install Coefficient, import compliance records, and set up auto-refresh for ongoing oversight.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Select “Import from Objects” > “Vendor Compliance Records” > 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
How to Import Vendor Compliance Types Data from Sage Intacct into Excel
Pull live Vendor Compliance Types from Sage Intacct into Excel to organize your compliance rules by category. In this guide, you’ll install Coefficient, import compliance types, and configure auto-refresh for continuous clarity.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Select “Import from Objects” > “Vendor Compliance Types” > 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
How to Import Warehouse Transfers Data from Sage Intacct into Excel
Track live Warehouse Transfers from Sage Intacct in Excel to manage stock movements between locations. In this guide, you’ll install Coefficient, import transfer data, and set up automatic refresh.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Warehouse Transfers” > 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
How to Import Warehouses Data from Sage Intacct into Excel
Pull live Warehouses from Sage Intacct into Excel to view all your storage locations in one sheet. In this guide, you’ll install Coefficient, import warehouse records, and set up automatic refresh for always-current data.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Choose “Import from Objects” > “Warehouses” > 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
How to Import Google Analytics Average Engagement Time Data into Excel
Analyzing Average Engagement Time data from Google Analytics in Excel helps content and marketing teams understand how deeply users are interacting with your website and which content holds their attention longest.
Instead of manually exporting data that quickly becomes outdated, you can create a live connection that refreshes automatically with the latest engagement metrics.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Google Analytics account
-
Step 3:
Select Average Engagement Time as your primary metric
-
Step 4:
Configure dimensions to segment your engagement time 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 Average Engagement Time Data
After connecting your Google Analytics account, configure your Average Engagement Time 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 “Average Engagement Time” as your primary metric
-
- By page to see which content holds attention longest
- By source/medium to identify which channels bring engaged users
- By device category to compare engagement across platforms
- By user type to compare new vs. returning visitor engagement
- Apply filters if you want to focus on specific segments
- Preview your selection to ensure it provides the insights you need
Step 3: Import and Set Up Auto-Refresh
Once you’ve configured your Average Engagement Time data selection, import it into Excel and set up automatic refreshes:
- Click “Import” to bring the Average Engagement Time 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 engagement time 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 Average Engagement Time Data in Excel
With your Average Engagement Time data now in Excel, you can create valuable analyses like:
- Content ranking by engagement duration
- Engagement trends over time
- Comparison of engagement across different traffic sources
- Custom visualizations highlighting engagement patterns
- Automated reports that track which factors drive longer engagement
Related Resources
For more information about working with Google Analytics data in your spreadsheets:
Start importing your Google Analytics Average Engagement Time data into Excel today with Coefficient and transform how your team analyzes content engagement.
How to Import Timesheet Entries Data from Sage Intacct into Excel
Bring live Timesheet Entries from Sage Intacct into Excel to review individual time records. In this guide, you’ll install Coefficient, import entry data, and set up automatic refresh for accurate reporting.
TLDR
-
Step 1:
Install the Coefficient add-in and connect to Sage Intacct.
-
Step 2:
Select “Import from Objects” > “Timesheet Entries” > 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
How to Import Account Performance Data from Microsoft Ads into Excel
Monitoring account-level performance metrics from Microsoft Ads in Excel provides a comprehensive view of your advertising effectiveness, budget utilization, and overall ROI across all campaigns.
Instead of manually downloading reports that quickly become outdated, you can establish a live connection for always-current account insights.
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 Account Performance data with key metrics
-
Step 4:
Set up auto-refresh to maintain current account data
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 Account Performance Data
After connecting your Microsoft Ads account, you can import your Account Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Account Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, cost, conversions, etc.)
- Apply any filters to focus on specific 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 account 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
Create Account Performance Dashboards
With your Account Performance data now in Excel, you can create comprehensive dashboards that track overall advertising performance over time. Use Excel’s charting capabilities to visualize trends in impressions, clicks, conversions, and costs at the account level.
Calculate important KPIs like account-wide ROAS, CPL, or CPA to measure the overall effectiveness of your Microsoft Ads strategy. Compare performance against previous periods to identify trends and opportunities for optimization.
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 Ad Dynamic Text Performance Data from Microsoft Ads into Excel
Analyzing Ad Dynamic Text Performance from Microsoft Ads in Excel helps marketers understand how different dynamic text variations perform, enabling better customization of ad messaging and improved targeting.
Instead of manually exporting data that quickly becomes outdated, you can create a live connection for always-current insights into your dynamic ad 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 Ad Dynamic Text Performance data with custom metrics
-
Step 4:
Set up auto-refresh to keep your 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 Ad Dynamic Text Performance Data
After connecting your Microsoft Ads account, you can import your Ad Dynamic Text Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Ad Dynamic Text Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, CTR, conversions, etc.)
- 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 dynamic text performance 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 Dynamic Text Ad Performance
With your Ad Dynamic Text Performance data now in Excel, you can identify which dynamic text variations drive the best results. Create pivot tables to compare performance across different text variations, ad groups, or campaigns, and use Excel’s visualization tools to identify patterns.
Calculate custom metrics like conversion rate by dynamic text variation to understand which messaging resonates most with your audience, helping you optimize future ad copy for better performance.
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