# Microsoft Advertising

> Microsoft Advertising (formerly known as Bing Ads) is a service that provides pay-per-click advertising for both the Bing and Yahoo search engines. To get an overview of Microsoft Advertising, see its entity hierarchy and limits documentation.

Microsoft Advertising tracks your campaign performance and keyword data, but understanding which search campaigns drive actual revenue or how Bing traffic compares to other channels requires connecting to your CRM, analytics, and payment platforms.

Filament links Microsoft Advertising to your other tools and answers questions about attribution, customer value, and cross-channel performance in plain English.

## Data we sync

- **Campaign Performance**: Track campaign budgets, spend, and performance metrics with daily impressions, clicks, conversions, cost per click, and budget pacing data. (`campaign_id`, `daily_budget`, `impressions`, `clicks`, `conversions`, `spend`, `cost_per_conversion`)
- **Ad Groups**: Monitor ad group structures and bidding with ad group names, bid strategies, target CPA, search bid adjustments, and quality scores. (`ad_group_id`, `ad_group_name`, `bid_strategy_type`, `cpc_bid`, `target_cpa`, `quality_score`)
- **Ads and Extensions**: Analyze ad creative performance with ad copy, headlines, descriptions, ad extensions, click-through rates, and impression share. (`ad_id`, `ad_title`, `ad_description`, `ad_type`, `extension_type`, `click_through_rate`)
- **Keywords**: Review keyword performance with match types, bid amounts, search terms, keyword status, average position, and cost per click. (`keyword_id`, `keyword_text`, `match_type`, `bid_amount`, `average_position`, `keyword_status`)
- **Search Terms**: Discover actual search queries triggering your ads with search term text, matched keywords, impressions, clicks, and conversion rates. (`search_term`, `matched_keyword`, `impressions`, `clicks`, `conversions`, `conversion_rate`)
- **Negative Keywords**: Manage negative keyword lists with keyword text, match type, campaign associations, and exclusion status across ad groups. (`negative_keyword_text`, `match_type`, `campaign_id`, `ad_group_id`, `status`)
- **Conversion Tracking**: Measure conversion actions with conversion names, conversion values, conversion time, attribution models, and revenue per conversion. (`conversion_name`, `conversion_value`, `conversion_time`, `conversion_count`, `revenue`)
- **Audience Performance**: Analyze audience targeting with audience names, demographic data, device types, location targeting, and audience bid adjustments. (`audience_id`, `audience_name`, `age_range`, `gender`, `device_type`, `location`, `bid_adjustment`)
- **Budget and Billing**: Track account spending with monthly budgets, daily spend, billing thresholds, payment methods, and account balance. (`account_id`, `monthly_budget`, `daily_spend`, `billing_threshold`, `account_balance`, `payment_status`)

## How do I connect Microsoft Advertising?

You need a Microsoft Advertising account with access to the advertising accounts you want to sync.

1. Open [Apps](https://filamentanalytics.com/apps) in Filament and add **Microsoft Advertising**.
2. Select **Authorize** and sign in. If the same email has personal and work accounts, choose the type used for Microsoft Advertising. The wrong type can cause an `AADSTS650052` error.
3. Choose your **Sync Mode**. For **Sync Specific Accounts**, select the accounts to include.
4. Set the number of months of reporting history to import. Review the optional rollback window, which controls how far back recent reporting data is refreshed.
5. Select **Save & Test**, then return to Filament and complete setup.
