Bing Ads Integration for Nodus
1. Introduction to the Bing Ads Integration
What Is This Integration?
The Bing Ads integration connects your Microsoft Advertising (formerly Bing Ads) platform data with Nodus, allowing you to extract, analyze, and transform campaign performance metrics, ad creative insights, and keyword analytics. This integration functions as a source connector, bringing your Microsoft Advertising data into the Nodus ecosystem for advanced analytics and business intelligence.
Prerequisites:
- An active Microsoft Advertising account with customer and account IDs
- Microsoft Advertising Developer Token
- Appropriate access permissions to the Microsoft Advertising account
Connection Overview:
The integration uses Microsoft Advertising's Reporting API to extract advertising data and performance metrics. Authentication is handled through OAuth 2.0 with the Microsoft identity platform, and the connector extracts data based on predefined report templates.
2. Platform Setup Documentation (Setup Form for Bing Ads)
Purpose & Scope
This section covers how to set up the initial connection between Nodus and Microsoft Advertising by providing the necessary authentication credentials and account identifiers.
Field-by-Field Breakdown:
Integration Name
- Field Name & Label: Integration Name
- Description & Purpose: A descriptive name to identify this Microsoft Advertising integration within your Nodus account.
- Validation Rules & Format: Text string, required field.
- Examples: "Bing Ads - Main Account", "Microsoft Advertising - Client X"
- Troubleshooting Tips: Use a descriptive name that clearly identifies the specific Microsoft Advertising account or purpose.
Bing Ads Customer ID
- Field Name & Label: Bing Ads Customer ID
- Description & Purpose: The unique identifier for the customer (company) that manages the Microsoft Advertising account.
- Validation Rules & Format: Numeric string, required field.
- Examples: "123456789"
- Troubleshooting Tips: You can find your Customer ID in the Microsoft Advertising web interface under Account Settings. For agencies managing multiple customers, be sure to use the correct Customer ID.
Bing Ads Account ID
- Field Name & Label: Bing Ads Account ID
- Description & Purpose: The unique identifier for your specific Microsoft Advertising account.
- Validation Rules & Format: Numeric string, required field.
- Examples: "987654321"
- Troubleshooting Tips: You can find your Account ID in the top right corner of your Microsoft Advertising dashboard.
Bing Ads Developer Token
- Field Name & Label: Bing Ads Developer Token
- Description & Purpose: A developer token from Microsoft Advertising, required for API access.
- Validation Rules & Format: Alphanumeric string, required field.
- Examples: "BBD37VB98"
- Troubleshooting Tips: Developer tokens require application approval from Microsoft. See the Microsoft Advertising documentation for information on how to obtain a token.
External Link
- Link Label: "Locate Your Account ID"
- URL: https://developers.ads.microsoft.com/Account
- Purpose: Helps users locate their Microsoft Advertising Account ID in the web interface.
Step-by-Step Guide:
- Log in to your Microsoft Advertising account
- Navigate to Account Settings to locate your Customer ID and Account ID
- Copy your Developer Token
- Enter your Customer ID, Account ID, Developer Token, and a meaningful Integration Name in the Nodus setup form
- Click Authorize to launch the Microsoft SSO authorization flow
- Grant permissions when prompted by Microsoft
- Verify connection and save the configuration
Reference Links:
3. Extraction/Query Configuration (Extraction Form for Bing Ads)
Purpose & Overview
This section explains how to configure data extraction from Microsoft Advertising. The platform offers various templates for extracting different types of advertising data and performance reports.
Template & Field Documentation:
Template Selection
- Field Name & Label: Select a template
- Description & Purpose: Defines which type of Microsoft Advertising data to extract
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- Ad Dimensions Template - Metadata about ads including titles, descriptions, and creative attributes
- Campaign Dimensions Template - Campaign configuration data including status, type, and budget settings
- Ad Performance Template - Performance metrics for ads including impressions, clicks, and conversions
- Campaign Performance Template - Performance metrics aggregated at the campaign level
- Keyword Performance Template - Performance data for individual keywords including quality scores
- Account Performance Template - High-level account performance metrics
Lookback Range
- Field Name & Label: Lookback Range
- Description & Purpose: Specifies how many days back to extract data
- Validation Rules & Format: Dropdown selection, required field
- Available Options:
- 3-day Range
- 7-day Range
- 28-day Range (recommended)
- 90-day Range (Optimal if 90-day DDA is used)
- Troubleshooting Tips: Larger date ranges may result in longer processing times. Microsoft Advertising has limits on how far back you can pull historical data depending on the report type.
Historic Date Selection
- Field Name & Label: Historic Date
- Description & Purpose: For historical data extraction, specifies a custom date range
- Validation Rules & Format: Date picker, required field
- Troubleshooting Tips: Microsoft Advertising generally retains data for 36 months, but report availability may vary.
Workflow & Examples:
- Select the appropriate template (e.g., "Ad Performance Template" for ad-level metrics)
- Choose a lookback period or specific historic date range
- Preview the query to confirm configuration
- Execute extraction
Example Use Cases:
Campaign Performance Analysis:
- Template: Campaign Performance Template
- Metrics: Impressions, clicks, spend, conversions
- Lookback: 28-day Range
Keyword Optimization:
- Template: Keyword Performance Template
- Metrics: Clicks, conversions, quality score, average position
- Lookback: 90-day Range
Ad Creative Analysis:
- Template: Ad Dimensions + Ad Performance templates (as a package)
- Metrics: Ad creative details with performance metrics
- Lookback: 28-day Range
4. Data Mapping & Underlying Models for Bing Ads
Ad Dimensions Schema
| Field | Description |
|---|---|
| AdId | The unique identifier of the ad |
| AdTitle | The headline of the ad |
| AdDescription | The primary description of the ad |
| AdDescription2 | The secondary description of the ad |
| AdGroupId | The ad group identifier |
| AdGroupName | The name of the ad group |
| CampaignId | The campaign identifier |
| CustomerId | The customer identifier |
| AdType | The type of ad (Text, Responsive, etc.) |
| DisplayUrl | The URL displayed in the ad |
| FinalUrl | The landing page URL |
| FinalMobileUrl | The mobile landing page URL |
| Path1 | The first path for the URL |
| Path2 | The second path for the URL |
| TrackingTemplate | The tracking template for the ad |
| TitlePart1 | The first part of the ad title |
| TitlePart2 | The second part of the ad title |
| TitlePart3 | The third part of the ad title |
| BusinessName | The name of the business |
| AdStatus | The status of the ad (Active, Paused, etc.) |
| AdGroupStatus | The status of the ad group |
| CampaignStatus | The status of the campaign |
| DestinationUrl | The destination URL |
Ad Performance Schema
| Field | Description |
|---|---|
| AdId | The unique identifier of the ad |
| AdTitle | The headline of the ad |
| AdGroupId | The ad group identifier |
| AdGroupName | The name of the ad group |
| CampaignId | The campaign identifier |
| CampaignName | The name of the campaign |
| CampaignType | The type of campaign |
| CustomerId | The customer identifier |
| AccountId | The account identifier |
| Network | The network where the ad was shown |
| TimePeriod | The date for the metrics |
| Impressions | Number of times the ad was shown |
| Clicks | Number of clicks received |
| Spend | Amount spent on the ad |
| Conversions | Number of conversions |
| Revenue | Revenue attributed to the ad |
| VideoViews | Number of video views |
| ViewThroughConversions | Number of view-through conversions |
| AllConversions | Total number of conversions including view-through |
| AllRevenue | Total revenue including view-through conversions |
| AveragePosition | Average position of the ad |
Campaign Performance Schema
| Field | Description |
|---|---|
| CampaignId | The unique identifier of the campaign |
| CampaignName | The name of the campaign |
| CustomerId | The customer identifier |
| Impressions | Number of impressions for the campaign |
| Clicks | Number of clicks for the campaign |
| Spend | Amount spent on the campaign |
| Conversions | Number of conversions for the campaign |
| Revenue | Revenue attributed to the campaign |
| VideoViews | Number of video views for the campaign |
| ViewThroughConversions | Number of view-through conversions |
| AbsoluteTopImpressionRatePercent | Percentage of impressions shown at the absolute top |
| AllConversions | Total number of conversions including view-through |
| AllRevenue | Total revenue including view-through conversions |
| TimePeriod | The date for the metrics |
| AveragePosition | Average position of the campaign ads |
| CompletedVideoViews | Number of completed video views |
Keyword Performance Schema
| Field | Description |
|---|---|
| AccountName | The name of the account |
| AccountNumber | The account number |
| AccountId | The account identifier |
| TimePeriod | The date for the metrics |
| CampaignName | The name of the campaign |
| CampaignId | The campaign identifier |
| AdGroupName | The name of the ad group |
| AdGroupId | The ad group identifier |
| Keyword | The keyword text |
| KeywordId | The unique identifier of the keyword |
| DeliveredMatchType | The match type (Exact, Phrase, Broad) |
| Impressions | Number of impressions for the keyword |
| Clicks | Number of clicks for the keyword |
| Ctr | Click-through rate for the keyword |
| AverageCpc | Average cost per click |
| Spend | Amount spent on the keyword |
| Conversions | Number of conversions for the keyword |
| QualityScore | The quality score of the keyword |
| DeviceType | The type of device (mobile, desktop, etc.) |
Account Performance Schema
| Field | Description |
|---|---|
| AccountId | The account identifier |
| AccountName | The name of the account |
| TimePeriod | The date for the metrics |
| Clicks | Number of clicks received |
| Spend | Amount spent |
| Impressions | Number of times ads were shown |
| extracted_at | Timestamp when data was extracted |
Campaign Dimensions Schema
| Field | Description |
|---|---|
| CampaignId | The unique identifier of the campaign |
| CampaignName | The name of the campaign |
| CampaignStatus | The status of the campaign (Active, Paused, etc.) |
| CampaignType | The type of campaign |
| CustomerId | The customer identifier |
| FinalUrlSuffix | The suffix added to final URLs |
| CampaignLabels | Labels assigned to the campaign |
| BudgetName | The name of the budget |
| BudgetStatus | The status of the budget |
| TrackingTemplate | The tracking template for the campaign |
| ImpressionSharePercent | Share of eligible impressions that were received |
| ClickSharePercent | Share of eligible clicks that were received |
| AbsoluteTopImpressionSharePercent | Share of eligible top impressions that were received |
| ExactMatchImpressionSharePercent | Share of exact match impressions |
| extracted_at | Timestamp when data was extracted |
5. Troubleshooting & FAQs for Bing Ads
Common Issues & Error Messages
Authentication Failures
- Error: "Authentication failed" or "Invalid OAuth token"
- Solution: Re-authorize the integration through Microsoft SSO. Microsoft OAuth tokens have limited lifetimes and may need to be refreshed.
Developer Token Issues
- Error: "Invalid developer token" or "Developer token not found"
- Solution: Verify your developer token is correct and still active. Developer tokens may need to be renewed or reapproved periodically.
Missing Data
- Common Causes:
- Date range outside of data retention period
- Insufficient account activity to generate data
- Solution: Adjust template filters, check date ranges, verify account has active campaigns
Contact & Support Information
- Microsoft Advertising API Support: https://advertise.bingads.microsoft.com/en-us/resources/support
- Nodus Support: support@nodus.com
Data Retention & Limitations
- Microsoft Advertising typically retains report data for 36 months
- Some report types have specific data retention policies
- Daily reporting is the most granular time period available for most report types