The Microsoft Advertising Intelligence Excel tool is a free downloadable add-in that integrates advanced keyword research and performance data directly into Microsoft Excel. This powerful tool acts as a bridge between your local spreadsheets and the live Microsoft Search Network, allowing search marketers to build, expand, and analyze keyword lists seamlessly without flipping back and forth between a web browser interface.
Whether you are seeking to scale your Search Engine Optimization (SEO) mapping or build hyper-targeted pay-per-click (PPC) ad groups, this comprehensive guide will walk you through downloading, installing, and mastering this tool. Step 1: System Requirements & Prerequisites
Before downloading the tool, make sure your computer meets the necessary baseline configuration criteria:
Operating System: Windows (Mac environments are generally not natively supported for this add-in).
Software: Desktop version of Microsoft Excel (Excel 2007 or newer). Active Account: An active Microsoft Advertising Account.
Application State: Close all active instances of Microsoft Excel before initializing the installer to prevent deployment conflicts. Step 2: Download and Install the Add-In
To bring live network intelligence into your offline spreadsheets, follow these installation procedures:
Locate the Installer: Log into your dashboard and navigate to the tools menu, or go to the official Microsoft Advertising Planning Tools hub to locate the download package.
Execute Setup: Double-click the downloaded executable file (typically named setup.exe or MicrosoftAdvertisingIntelligence.msi).
Follow Prompts: Click Install through the setup wizard dialogue prompts.
Verify Excel Integration: Relaunch Microsoft Excel. You will observe a dedicated Microsoft Advertising Intelligence tab integrated directly into your top main navigation ribbon. Step 3: Connect to Your Advertising Account
Once the plugin is installed, you must link it to the live network database:
Click on the Microsoft Advertising Intelligence tab in Excel.
Select any operational icon on the ribbon, such as Keyword Performance.
Sign in using your standard Microsoft Ads credentials or your associated Microsoft Account email.
Choose the specific client account, active campaign, or targeted ad group you intend to evaluate from the account selector window. Step 4: Key Features and How to Use Them
The core utility of this tool stems from its capability to process up to 200,000 keywords simultaneously inside a native grid format. Key feature metrics can be executed through these distinct approaches: 1. Keyword Expansion and Suggestions
If you have a foundational seed list of search phrases, you can expand it instantly:
Action: Highlight your list of root words directly inside your spreadsheet columns. Execution: Click Keyword Suggestions on the ribbon.
Result: The system will populate adjacent rows with relative match types, associated KPI forecasts, and target variations. 2. Competitor URL Scraping
You can easily reverse-engineer what keywords your high-ranking competition is targeting:
Action: Copy the exact domain or page URL of a prominent competitor from Bing search results.
Execution: Choose the web-scraping extraction tool options from your Excel ribbon.
Result: The add-in strips text assets from that URL and returns an indexed list of contextual keywords alongside a clear relevancy score. 3. Live Traffic and Performance Estimation
Assess the historical viability and cost projections of your terms before allocating media spend: Action: Select your compiled target phrases.
Execution: Click Traffic or Keyword Performance and select parameters like date range, device type (Mobile vs. Desktop), and localized geography.
Result: Excel populates live search volume trends, average Click-Through Rate (CTR), estimated Cost-Per-Click (CPC), and structural bid thresholds required to capture the absolute top position on the first page. Step 5: Creating and Uploading Bulk Sheets
Once your data-driven list is clean and structured, you do not need to copy and paste elements manually into the online web interface.
Simply select your completed rows and click Create Bulksheet on the ribbon. The add-on instantly formats your spreadsheet into a valid, system-recognized bulk sheet structure. You can then directly upload this optimized file into your live web dashboard or pipe it straight into the offline Microsoft Advertising Editor desktop client to push updates instantly. Microsoft Advertising Intelligence Keyword Planner Tool
Leave a Reply