Accessing your Microsoft Ads Ad Performance data in Google Sheets helps you analyze how individual ads are performing and optimize your ad copy and creatives.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Performance data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Performance object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad performance data current automatically.
Importing your Microsoft Ads Ad Performance data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Performance Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Performance” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Performance data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Performance data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Google Sheets
Bringing your Microsoft Ads Ad Extension Detail data into Google Sheets helps you analyze the performance of your ad extensions across your account.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Extension Detail data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Extension Detail object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad extension detail data current automatically.
Importing your Microsoft Ads Ad Extension Detail data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Extension Detail Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Extension Detail” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Extension Detail data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Extension Detail data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Group Performance Data from Microsoft Ads into Google Sheets
Getting your Microsoft Ads Ad Group Performance data into Google Sheets is essential for tracking ad group effectiveness, optimizing bids, and sharing results with your team.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Group Performance data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Group Performance object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad group performance data current automatically.
Importing your Microsoft Ads Ad Group Performance data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Group Performance Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Group Performance” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Group Performance data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Group Performance data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Keyword Data from Microsoft Ads into Google Sheets
Accessing your Microsoft Ads Ad Extension By Keyword data in Google Sheets helps you analyze how ad extensions perform when triggered by specific keywords.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Extension By Keyword data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Extension By Keyword object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad extension by keyword data current automatically.
Importing your Microsoft Ads Ad Extension By Keyword data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Extension By Keyword Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Extension By Keyword” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Extension By Keyword data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Extension By Keyword data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Google Sheets
Getting your Microsoft Ads Ad Extension By Ad data into Google Sheets helps you analyze how ad extensions perform when attached to specific ads.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Extension By Ad data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Extension By Ad object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad extension by ad data current automatically.
Importing your Microsoft Ads Ad Extension By Ad data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Extension By Ad Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Extension By Ad” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Extension By Ad data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Extension By Ad data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Google Sheets
Accessing your Microsoft Ads Ad Dynamic Text Performance data in Google Sheets helps you analyze how dynamic text is performing in your ads and optimize your ad copy.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Ad Dynamic Text Performance data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Ad Dynamic Text Performance object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your ad dynamic text performance data current automatically.
Importing your Microsoft Ads Ad Dynamic Text Performance data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Ad Dynamic Text Performance Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Ad Dynamic Text Performance” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Ad Dynamic Text Performance data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Ad Dynamic Text Performance data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Google Sheets
Getting your Microsoft Ads Account Performance data into Google Sheets is essential for tracking overall account health, monitoring spend, and reporting on high-level results.
Instead of manual exports, you can set up a live connection that updates automatically.
This guide shows you how to import your Microsoft Ads Account Performance data into Google Sheets using Coefficient.
TLDR
-
Step 1:
Step 1. Install Coefficient from the Google Workspace Marketplace and connect your Microsoft Ads account.
-
Step 2:
Step 2. Select Import from… and choose the Account Performance object from Microsoft Ads.
-
Step 3:
Step 3. Configure your import settings and pull the data into your sheet.
-
Step 4:
Step 4. Set up auto-refresh to keep your account performance data current automatically.
Importing your Microsoft Ads Account Performance data into Google Sheets is simple with Coefficient. Follow these steps to get started:
Step 1: Install and Connect Coefficient
First, you need to add Coefficient to your Google Sheet.
- Open Google Sheets.
- Go to Extensions > Add-ons > Get add-ons.
- Search for “Coefficient” and install it from the Google Workspace Marketplace.
Once installed, open the Coefficient add-on from Extensions > Coefficient > Launch.
In the Coefficient sidebar, click “Import from…” and find Microsoft Ads in the list of connectors. You’ll be guided to connect your Microsoft Ads account securely.
Step 2: Import Microsoft Ads Account Performance Data
After connecting, you’ll see options for importing data from Microsoft Ads.
- Select “Objects”.
- Choose “Account Performance” from the list of available objects.
You can then select specific fields, apply filters, and sort the data before importing. Once ready, click the “Import” button.
Your Microsoft Ads Account Performance data will load directly into your Google Sheet.
Step 3: Set Up Auto-Refresh (Optional)
To keep your Account Performance data in Google Sheets always up to date, set up an automatic refresh schedule.
In the Coefficient sidebar, find your imported data.
- Click the “Refresh” button or the three-dot menu next to your import.
- Select “Schedule Refresh”.
- Choose your desired frequency (e.g., daily, hourly, weekly) and time.
Coefficient will now automatically update your sheet with the latest data from Microsoft Ads based on your schedule.
Available Microsoft Ads 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 Goals And Funnels Data from Microsoft Ads into Excel
Analyzing Goals And Funnels data from Microsoft Ads in Excel helps marketers understand their conversion paths, identify drop-off points, and optimize campaign targeting to improve goal completions and conversion rates.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your conversion funnel 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 Goals And Funnels data with conversion metrics
-
Step 4:
Set up auto-refresh to keep your goal 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 Goals And Funnels Data
After connecting your Microsoft Ads account, you can import your Goals And Funnels data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Goals And Funnels” from the list of available objects
- Choose which metrics you want to include (goal completions, conversion rates, funnel steps, 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 goals and funnels 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 Conversion Funnel Performance
With your Goals And Funnels data now in Excel, you can create detailed conversion funnel visualizations that show progression through each step of the customer journey. Identify bottlenecks where prospects drop off, and analyze which campaigns, keywords, or ad groups drive the most valuable goal completions.
Use Excel’s calculation capabilities to determine conversion rates between funnel stages, and create custom formulas to calculate the value of different conversion actions. These insights will help you optimize your Microsoft Ads campaigns to improve overall conversion performance and ROI.
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 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 Hotel Dimension Performance Data from Microsoft Ads into Excel
Analyzing Hotel Dimension Performance data from Microsoft Ads in Excel helps travel marketers understand how their hotel campaigns perform across different dimensions like hotel class, brand, and property, enabling more targeted optimizations for hotel advertising.
Instead of manually downloading reports that quickly become outdated, you can create a live connection for always-current insights into your hotel 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 Hotel Dimension Performance data with relevant metrics
-
Step 4:
Set up auto-refresh to keep your hotel dimension 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 Hotel Dimension Performance Data
After connecting your Microsoft Ads account, you can import your Hotel Dimension Performance data:
- In the Coefficient sidebar, click “Import from Microsoft Ads”
- Select “Hotel Dimension Performance” from the list of available objects
- Choose which metrics you want to include (impressions, clicks, bookings, revenue, etc.)
- Apply any filters to focus on specific hotel campaigns or dimensions
- Click “Import” to bring the data into your Excel spreadsheet
Step 3: Set Up Auto-Refresh for Your Data
Keep your Microsoft Ads hotel dimension 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 Hotel Dimension Performance
With your Hotel Dimension Performance data now in Excel, you can identify which hotel properties, brands, or classes drive the best results for your advertising investment. Create pivot tables to compare key metrics like booking rate, average booking value, and return on ad spend across different hotel dimensions.
Use Excel’s visualization tools to create charts that make performance trends immediately visible, and its sorting and filtering capabilities to quickly identify high-performing and underperforming hotel dimensions. These insights will help you optimize your hotel campaign targeting and bidding for maximum ROI.
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