Microsoft adCenter Add-in for Excel (Ad Intelligence)

The Microsoft adCenter Add-in for Excel, also known as Ad Intelligence, was a keyword research tool released by Microsoft in early 2008. Designed as an Excel 2007 plug-in, the add-in aimed to assist digital marketers in performing advanced keyword analysis using search and advertising data from Microsoft’s platforms.

Overview

Ad Intelligence integrated directly into Microsoft Excel 2007 as an additional ribbon tab. This integration provided users with access to several keyword research tools without leaving the Excel environment. These tools offered keyword suggestions, search volume data, cost-per-click estimates, campaign-related associations, and semantic analysis.

The tool was part of Microsoft’s broader initiative to enhance transparency in keyword research methodology. Unlike many other tools at the time, Ad Intelligence provided exact match data and did not aggregate or paraphrase user input. It delivered results using structured data sourced from Microsoft’s Live.com search engine and adCenter advertising platform.

Key Features

1. Keyword Wizard

The add-in featured a step-by-step wizard to guide users through keyword research processes. Users could enter a list of keywords, URLs, or choose a vertical category to generate keyword suggestions and corresponding metrics like average cost and search trends.

2. Keyword Extraction

This tool analyzed specific URLs and extracted keywords that Microsoft’s algorithm deemed relevant. It allowed for up to 100 keywords per URL and could process queries for as many as 200 URLs. The feature was designed to support landing page optimization and content planning.

3. Keyword Suggestions

Ad Intelligence provided three main types of keyword suggestion tools:

Campaign Association: Suggested keywords based on other terms that appeared in historical adCenter campaigns.

Contained Terms: Generated keywords that included a specific core term.

Similarity: Used semantic analysis to suggest conceptually related keywords, leveraging Microsoft’s semantic index developed by AdLabs.

Each of these suggestion tools returned up to 50 results per core term by default, with adjustable filters like confidence level to fine-tune the relevancy of returned data.

Technology and Data Sources

The backend infrastructure for Ad Intelligence was built on Microsoft’s Keyword Services Platform (KSP), a server platform offering keyword-related web services. KSP supported both the add-in and third-party applications through API access.

Data used by Ad Intelligence came from two main sources:

Live.com Index: The search index that powered Microsoft’s search engine at the time.

Microsoft adCenter: The company’s advertising platform, which provided anonymized advertiser data for campaign analysis.

Keyword data was updated quarterly, ensuring users received relatively fresh insights for their campaigns. The tool returned search volume data in actual numbers (both daily and monthly), a notable feature compared to many tools that provided only relative or indexed values.

Discontinuation and Legacy

While Microsoft Ad Intelligence was notable for its transparency and tight integration with Excel, the tool was eventually phased out as Microsoft transitioned from adCenter to Bing Ads (later Microsoft Advertising) and as newer keyword tools became available.

Despite its discontinuation, Ad Intelligence remains an example of early efforts by major tech companies to offer comprehensive, data-driven keyword research capabilities within widely-used productivity software.