Analyzing Publisher Usage Performance data from Microsoft Ads in Excel helps marketers understand how their ads perform across different publisher websites in the Microsoft Advertising Network, enabling more effective publisher exclusions and bidding optimizations.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your publisher 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 Publisher Usage Performance data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your publisher 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 Publisher Usage Performance Data
After connecting your Microsoft Ads account, you can import your Publisher Usage Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Publisher Usage 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 publisher usage 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 Publisher Performance
With your Publisher Usage Performance data now in Excel, you can identify which publisher websites deliver the best results for your campaigns and which ones are underperforming. Create pivot tables to compare key metrics like CTR, conversion rate, and cost-per-acquisition across different publishers.
Use Excel’s sorting and filtering capabilities to quickly identify low-quality publishers for exclusion, and its calculation features to determine publisher-specific ROI. These insights will help you refine your publisher targeting strategy, allocate budget more effectively across the Microsoft Advertising Network, and improve overall campaign 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
How to Import Search Campaign Change History Data from Microsoft Ads into Excel
Analyzing Search Campaign Change History data from Microsoft Ads in Excel helps marketers track and audit all modifications made to their campaigns, enabling better accountability, performance correlation with changes, and troubleshooting of unexpected results.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your campaign change history.
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 Search Campaign Change History data with relevant details
-
Step 4:
Set up auto-refresh to keep your change history 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 Search Campaign Change History Data
After connecting your Microsoft Ads account, you can import your Search Campaign Change History data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Search Campaign Change History” from the list of available objects
- Choose which details you want to include (change type, user, date, old value, new value, 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 change history 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
Track and Analyze Campaign Changes
With your Search Campaign Change History data now in Excel, you can create a comprehensive audit trail of all modifications made to your campaigns. Use Excel’s filtering capabilities to identify changes by specific users, campaigns, or change types, and its timeline functions to visualize when major changes occurred.
Create pivot tables to analyze change frequency by campaign, change type, or user, and correlate performance fluctuations with specific campaign modifications. These insights will help you maintain better campaign governance, identify successful optimization patterns, and troubleshoot performance issues by pinpointing relevant changes.
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 Share Of Voice Data from Microsoft Ads into Excel
Analyzing Share Of Voice data from Microsoft Ads in Excel helps marketers understand their competitive position in ad auctions, enabling better bidding strategies and budget allocation based on impression share and rank metrics.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your share of voice 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 Share Of Voice data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your competitive 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 Share Of Voice Data
After connecting your Microsoft Ads account, you can import your Share Of Voice data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Share Of Voice” from the list of available objects
- Choose which metrics you want to include (impression share, rank, lost impression share due to budget/rank)
- 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 share of voice 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 Competitive Position
With your Share Of Voice data now in Excel, you can gain valuable insights into your market position and auction performance. Create pivot tables to analyze impression share metrics across different campaigns, ad groups, or keywords, and use Excel’s visualization tools to spot trends over time.
Calculate the impact of budget limitations versus rank issues to determine whether you should focus on increasing budgets or improving quality scores. Use these competitive insights to fine-tune your bidding strategy, identify opportunities to increase visibility, and maximize your market share in the Microsoft Advertising ecosystem.
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 Search Query Performance Data from Microsoft Ads into Excel
Analyzing search query performance from Microsoft Ads in Excel reveals exactly which user searches trigger your ads, helping you refine keywords, identify negative keyword opportunities, and discover new terms to target.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current search query 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 Search Query Performance data with customizable metrics
-
Step 4:
Set up auto-refresh to keep your search query 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 Search Query Performance Data
After connecting your Microsoft Ads account, you can import your Search Query Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Search Query Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, 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 search query 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 Search Query Data
With your Search Query Performance data now in Excel, you can identify high-performing search terms that should be added as keywords, and low-value queries that should be excluded with negative keywords. Excel’s sorting and filtering capabilities make it easy to spot patterns in how users are finding your ads.
Create custom columns to calculate metrics like cost-per-conversion for each search query, or use pivot tables to analyze performance by match type, campaign, or other dimensions to optimize your Microsoft Ads campaigns.
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 User Location Performance Data from Microsoft Ads into Excel
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 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
How to Import Ad Extension By Ad Data from Microsoft Ads into Excel
Analyzing Ad Extension By Ad data from Microsoft Ads in Excel helps marketers understand how different extensions impact ad performance, allowing for more strategic decisions about which extensions to use with which ads.
Instead of manually exporting reports that quickly become outdated, you can create a live connection for always-current insights into your ad extension 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 Extension By Ad data with customizable metrics
-
Step 4:
Set up auto-refresh to keep your extension 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 Extension By Ad Data
After connecting your Microsoft Ads account, you can import your Ad Extension By Ad data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Ad Extension By Ad” 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 ads or extension types
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh for Your Data
Keep your Microsoft Ads extension 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 Ad Extension Performance
With your Ad Extension By Ad data now in Excel, you can identify which extension types drive the best performance for different ads. Create pivot tables to compare metrics like CTR and conversion rates across extension types, and use Excel’s visualization tools to spot patterns.
Develop insights on which extensions work best with specific ad content or for different campaign objectives, helping you optimize your Microsoft Ads strategy for better results and more efficient spending.
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 Extension Detail Data from Microsoft Ads into Excel
Analyzing Ad Extension Detail data from Microsoft Ads in Excel provides marketers with insights into the configuration and performance of different extension types, helping optimize ad enhancements for better visibility and results.
Instead of manually exporting data that quickly becomes outdated, you can create a live connection for always-current insights into your extension details.
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 Extension Detail data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your extension 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 Extension Detail Data
After connecting your Microsoft Ads account, you can import your Ad Extension Detail data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Ad Extension Detail” from the list of available objects
- Choose which metrics and dimensions you want to include (extension type, version, status, etc.)
- Apply any filters to focus on specific extension types or statuses
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh for Your Data
Keep your Microsoft Ads extension detail 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 Ad Extension Details
With your Ad Extension Detail data now in Excel, you can create a comprehensive inventory of all your extensions across campaigns and ad groups. Identify extensions that need updating or are disapproved, and ensure consistent extension usage across your account.
Use Excel’s filtering capabilities to organize extensions by type, status, or campaign association, making it easier to manage your extension strategy and ensure your ads have the enhancements they need to stand out in search results.
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 DSA Auto Target Performance Data from Microsoft Ads into Excel
Analyzing DSA Auto Target Performance data from Microsoft Ads in Excel helps marketers understand how their Dynamic Search Ads are performing across different website targets, enabling more effective optimization of DSA campaigns.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current DSA performance 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 DSA Auto Target Performance data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your DSA 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 DSA Auto Target Performance Data
After connecting your Microsoft Ads account, you can import your DSA Auto Target Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “DSA Auto Target 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 DSA 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 DSA 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 DSA Auto Target Performance
With your DSA Auto Target Performance data now in Excel, you can identify which website content and URL patterns are driving the best performance for your Dynamic Search Ads. Create pivot tables to compare metrics like CTR, conversion rate, and cost-per-conversion across different auto targets.
Use Excel’s sorting and filtering capabilities to quickly identify high-performing targets that deserve more budget and underperforming targets that need optimization or exclusion. Develop insights about which parts of your website generate the most valuable ad traffic through DSA campaigns.
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