How to Export CSV Data from Microsoft Advertising and Import It into clariBI

Microsoft Advertising (formerly Bing Ads) serves ads across the Microsoft Search Network including Bing, Yahoo, and AOL. Exporting your ad data into clariBI enables you to analyze performance, compare with other ad platforms, and optimize your multi-channel advertising strategy.

What You Can Export from Microsoft Advertising

• Campaign, ad group, and ad performance metrics (impressions, clicks, CTR, spend)
• Keyword performance data with quality scores and bid information
• Search terms report (actual user queries triggering your ads)
• Audience targeting performance (demographics, remarketing, in-market audiences)
• Device and location performance breakdowns
• Conversion tracking data (actions, revenue, conversion rate, CPA)
• Change history logs (bid changes, budget adjustments, campaign modifications)
• Ad extension performance (sitelinks, callouts, structured snippets)

Export CSV Data from Microsoft Advertising

Method 1: Export from Campaign Views

1. Log in to your Microsoft Advertising account at ads.microsoft.com
2. Navigate to the view you want to export — Campaigns, Ad groups, Ads & extensions, or Keywords
3. Set your desired date range using the date picker at the top right
4. Customize your columns by clicking Columns > Modify columns to add the metrics you need
5. Apply any filters (e.g., active campaigns only, minimum spend threshold)
6. Click the Download button (download icon in the toolbar above the data table)
7. Select CSV as the format
8. The file will download with all visible data from the current view

Method 2: Export from Reports

1. Click Reports in the top navigation menu
2. Select a report type — common options include:
   - Account performance for high-level metrics
   - Campaign performance for campaign-level detail
   - Keyword performance for keyword-level data
   - Search term for actual query data
   - Audience for targeting performance
3. Configure the report: select columns, date range, and filters
4. Click Download and choose CSV as the format
5. For recurring needs, click Schedule to automate report generation and email delivery

Method 3: Export Change History

1. Navigate to Tools > Change History in the top navigation
2. Set the date range and filter by change type if needed
3. Click Export to download a CSV of all account changes
4. Useful for auditing bid adjustments and campaign modifications

Tips for Clean Exports

• Microsoft Advertising report formatting is very similar to Google Ads — if you export from both platforms, you can combine and compare them in clariBI
• Use the Search Term report to find new keyword opportunities and identify wasted spend on irrelevant queries
• Schedule weekly report exports so you always have fresh data ready to import into clariBI

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Microsoft Ads - Keyword Performance Jan 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "How does my Microsoft Advertising CPC compare to my Google Ads CPC for the same keywords?"
- "Which keywords have the highest conversion rate on Bing Search?"
- "What is my cost per acquisition trend on Microsoft Advertising over the last 6 months?"

clariBI's AI will automatically analyze your data and suggest relevant insights.