Overview
This document provides a comprehensive guide for integrating and managing Bing Ads data imports, including connection setup, import scheduling, required user inputs, table structures, relationships, and available reporting dimensions and metrics. The configuration is designed to automate the retrieval and refresh of both performance data and metadata from the Microsoft Advertising platform, enabling robust analytics and reporting across campaign, ad group, and keyword levels.
Connection Setup / Requirements
To connect to the Bing Ads platform, the following credentials and parameters are required:
Key | Description | Required | Type |
microsoft_ads_client_id | Microsoft Ads Client ID from your application registration | No | Hidden |
microsoft_ads_client_secret | Microsoft Ads Client Secret from your application registration | No | Hidden |
microsoft_ads_developer_token | Microsoft Ads Developer Token for API access | No | Hidden |
microsoft_ads_user_id | Microsoft Ads User ID for authentication | Yes | Text |
microsoft_ads_account_ids | Comma-delimited list of account IDs | No | Text |
Note:
Ensure your application is registered with Microsoft Advertising and has the necessary permissions for data access.
The account IDs filter the data imported to only those specified. If not specified, data will be fetched for all accessible accounts.
Import Configuration
Two primary jobs are defined for data ingestion:
1. Data Import
Feed: bing_ads
Job Label: Bing Ads - Data Import
Status: Enabled (2)
Target Tables:
bing_data_campaign
bing_data_adgroup
bing_data_keyword
Target Type: Data
Update Mode: Append (new data is added)
Create Target: True (tables are created if not existing)
Date Column: TimePeriod
Lookback: 5 days
First Run Hour: 06:00 UTC
Poll Frequency: Every 24 hours
2. Meta Data Refresh
Feed: bing_ads
Job Label: Bing Ads - Meta Refresh
Status: Enabled (2)
Target Tables:
bing_meta_account
bing_meta_campaign
bing_meta_adgroup
Target Type: Lookup
Update Mode: Refresh (full table refresh)
Create Target: True
Lookback: 1 day
First Run Hour: 06:00 UTC
Poll Frequency: Every 24 hours
Import Schedule
Job Type | Frequency | Lookback Window | First Run (UTC) |
Data Import | 24 hours | 5 days | 06:00 |
Meta Refresh | 24 hours | 1 day | 06:00 |
Poll Frequency defines how often the import job runs.
Lookback specifies how many days of data are fetched on each run.
Required User Input
Before running the integration, users must provide:
Microsoft Ads User ID – for authentication.
Account IDs – comma-separated list to filter data (optional).
The User ID is mandatory and must be configured in the connection settings.
Tables Created
The integration creates and populates the following tables:
Table Name | Description | Type | Update Mode |
bing_data_campaign | Campaign Performance Data | Data | Append |
bing_data_adgroup | Ad Group Performance Data | Data | Append |
bing_data_keyword | Keyword Performance Data | Data | Append |
bing_meta_account | Account Metadata | Lookup | Refresh |
bing_meta_campaign | Campaign Metadata | Lookup | Refresh |
bing_meta_adgroup | Ad Group Metadata | Lookup | Refresh |
Table Relationships
The performance data tables are joined to metadata tables using the following keys:
Campaign Data Relationships
Source Column | Target Table | Target Column |
AccountId | bing_meta_account | bing_meta_account.Id |
CampaignId | bing_meta_campaign | bing_meta_campaign.Id |
Ad Group Data Relationships
Source Column | Target Table | Target Column |
AccountId | bing_meta_account | bing_meta_account.Id |
CampaignId | bing_meta_campaign | bing_meta_campaign.Id |
AdGroupId | bing_meta_adgroup | bing_meta_adgroup.Id |
Keyword Data Relationships
Source Column | Target Table | Target Column |
AccountId | bing_meta_account | bing_meta_account.Id |
CampaignId | bing_meta_campaign | bing_meta_campaign.Id |
AdGroupId | bing_meta_adgroup | bing_meta_adgroup.Id |
These joins enable enriched reporting and analysis by linking performance data to relevant metadata.
Available Dimensions
The following dimensions are available for reporting and analysis:
Dimension Name | Source Field(s) | Description |
Account [BingAds] | bing_meta_account.Name | The name of the account as defined in the Bing Ads platform. Used to group and filter data by account. |
Campaign [BingAds] | bing_meta_campaign.Name | The name of the campaign associated with the performance data. Enables reporting at the campaign level. |
AdGroup [BingAds] | bing_meta_adgroup.Name | The name of the ad group associated with the performance data. Allows for detailed breakdowns at the ad group level. |
Device Type [BingAds] | DeviceType (across all data tables) | The type of device where the ad was displayed (desktop, mobile, tablet). |
Ad Distribution [BingAds] | AdDistribution (across all data tables) | The distribution network where the ad was shown (search, content, etc.). |
Bid Match Type [BingAds] | BidMatchType (across all data tables) | The match type used for keyword bidding (exact, phrase, broad). |
Keyword [BingAds] | bing_data_keyword.Keyword | The specific keyword that triggered the ad display. |
Ad Type [BingAds] | bing_data_keyword.AdType | The type of ad format used in the campaign. |
Available Metrics
Base Metrics
Metric Name | Calculation Formula | Round | Prefix / Suffix | Description |
Spend [BingAds] | SUM(Spend) | 2 | £ | The total media spend in GBP (£) for the selected period, as reported by Bing Ads. |
Clicks [BingAds] | SUM(Clicks) | 0 |
| The total number of clicks on ads during the reporting period. |
Impressions [BingAds] | SUM(Impressions) | 0 |
| The total number of times ads were served (impressions) during the reporting period. |
Conversions [BingAds] | SUM(Conversions) | 0 |
| The total number of conversions attributed to the campaign. |
Revenue [BingAds] | SUM(Revenue) | 2 | £ | The total revenue generated from conversions, as reported by Bing Ads. |
Quality Score [BingAds] | AVG(QualityScore) | 1 |
| The average quality score for keywords, indicating ad relevance and expected performance. |
Composite Metrics
Metric Name | Calculation Formula | Round | Prefix /Suffix | Description |
CPC [BingAds] | {Spend [BingAds]} / {Clicks [BingAds]} | 2 | £ | Cost per click; calculated as total spend divided by the number of clicks. |
CPM [BingAds] | {Spend [BingAds]} / {Impressions [BingAds]} * 1000 | 2 | £ | Cost per thousand impressions; calculated as total spend divided by impressions, multiplied by 1,000. |
CTR [BingAds] | {Clicks [BingAds]} / {Impressions [BingAds]} * 100 | 2 | % | Click-through rate; calculated as clicks divided by impressions, expressed as a percentage. |
Click Conversion Rate [BingAds] | {Conversions [BingAds]} / {Clicks [BingAds]} * 100 | 2 | % | Conversion rate from clicks; calculated as conversions divided by clicks, expressed as a percentage. |
Cost Per Conversion [BingAds] | {Spend [BingAds]} / {Conversions [BingAds]} | 2 | £ | Cost per conversion; calculated as total spend divided by the number of conversions. |
ROAS [BingAds] | {Revenue [BingAds]} / {Spend [BingAds]} | 2 |
| Return on ad spend; calculated as revenue divided by spend. |
Additional Information
The integration is designed for daily batch imports.
All tables are automatically created if they do not exist.
Data is available at three granular levels: campaign, ad group, and keyword.
The system supports multi-account reporting when account IDs are specified.
Bing Ads Integration - Data Tables
Below you will find all the default fields that come with this integration for Bing Ads. For any additional fields please contact the team about the feasibility of adding it.
Performance Data Tables
Campaign Level Data (bing_data_campaign)
The campaign table contains high-level performance metrics aggregated at the campaign level, including core metrics like spend, impressions, clicks, and conversions. This table provides insights into overall campaign performance across different devices and distribution networks.
Field Name | Data Type | Description |
TimePeriod | date | The date for which the data is reported |
AccountId | bigint | Unique identifier for the Bing Ads account |
CampaignId | bigint | Unique identifier for the campaign |
BidMatchType | varchar(255) | The match type used for keyword bidding |
DeviceType | varchar(100) | Type of device where the ad was displayed |
AdDistribution | varchar(255) | Distribution network where the ad was shown |
Impressions | int | Number of times the ad was displayed |
Clicks | int | Number of clicks on the ad |
Spend | decimal(12,2) | Amount spent on the campaign |
QualityScore | int unsigned | Quality score for the campaign |
Conversions | int unsigned | Number of conversions attributed to the campaign |
Revenue | decimal(12,5) unsigned | Revenue generated from conversions |
Ad Group Level Data (bing_data_adgroup)
The ad group table offers more granular performance data, breaking down metrics by individual ad groups within campaigns. This level of detail enables optimization of specific ad group strategies and budget allocation decisions.
Field Name | Data Type | Description |
TimePeriod | date | The date for which the data is reported |
AccountId | bigint | Unique identifier for the Bing Ads account |
CampaignId | bigint | Unique identifier for the campaign |
AdGroupId | bigint | Unique identifier for the ad group |
BidMatchType | varchar(255) | The match type used for keyword bidding |
AdDistribution | varchar(255) | Distribution network where the ad was shown |
DeviceType | varchar(100) | Type of device where the ad was displayed |
CurrencyCode | varchar(50) | Currency code for monetary values |
Impressions | int unsigned | Number of times the ad was displayed |
Clicks | int unsigned | Number of clicks on the ad |
QualityScore | int unsigned | Quality score for the ad group |
Spend | decimal(12,5) unsigned | Amount spent on the ad group |
Conversions | int unsigned | Number of conversions attributed to the ad group |
Revenue | decimal(12,5) unsigned | Revenue generated from conversions |
Keyword Level Data (bing_data_keyword)
The keyword table provides the most detailed performance insights, showing how individual keywords perform across various match types and ad formats. This granular data is essential for keyword optimization and bid management strategies.
Field Name | Data Type | Description |
TimePeriod | date | The date for which the data is reported |
AccountId | bigint | Unique identifier for the Bing Ads account |
CampaignId | bigint | Unique identifier for the campaign |
AdGroupId | bigint | Unique identifier for the ad group |
Keyword | varchar(255) | The specific keyword that triggered the ad |
BidMatchType | varchar(255) | The match type used for keyword bidding |
AdDistribution | varchar(255) | Distribution network where the ad was shown |
DeviceType | varchar(100) | Type of device where the ad was displayed |
CurrencyCode | varchar(50) | Currency code for monetary values |
AdType | varchar(255) | Type of ad format used |
QualityScore | int unsigned | Quality score for the keyword |
Impressions | int unsigned | Number of times the ad was displayed |
Clicks | int unsigned | Number of clicks on the ad |
Spend | decimal(12,5) unsigned | Amount spent on the keyword |
Conversions | int unsigned | Number of conversions attributed to the keyword |
Revenue | decimal(12,5) unsigned | Revenue generated from conversions |
Dimensional Tables
Account Metadata (bing_meta_account)
Contains account-level information, including account names and identifiers, enabling proper attribution and organization of performance data across multiple Bing Ads accounts.
Field Name | Data Type | Description |
Id | int | Unique identifier for the account |
Name | varchar(255) | Name of the Bing Ads account |
Campaign Metadata (bing_meta_campaign)
Stores campaign names and identifiers, allowing for enriched reporting by linking performance data to human-readable campaign names and organizational structures.
Field Name | Data Type | Description |
Id | varchar(100) | Unique identifier for the campaign |
Name | varchar(255) | Name of the campaign |
AdGroup Metadata (bing_meta_adgroup)
Provides ad group names and identifiers, enabling detailed breakdowns and analysis at the ad group level with proper naming conventions for reporting purposes.
Field Name | Data Type | Description |
Id | varchar(100) | Unique identifier for the ad group |
Name | varchar(255) | Name of the ad group |
Additional Available Fields for Bing Ads Integration
Performance reporting:
Column Name | Description | Campaign | AdGroup | Keyword |
AbsoluteTopImpression RatePercent | How often your ad was in the first position of all results | Yes | Yes | Yes |
AbsoluteTopImpression ShareLostToBudgetPercent | Percentage of top impressions lost due to budget | Yes | Yes | No |
AbsoluteTopImpression ShareLostToRankPercent | Percentage of top impressions lost due to rank | Yes | Yes | No |
AbsoluteTopImpression SharePercent | Percentage of eligible first position impressions received | Yes | Yes | No |
AccountId | Microsoft Advertising assigned identifier of an account | Yes | Yes | Yes |
AccountName | The account name | Yes | Yes | Yes |
AccountNumber | Microsoft Advertising assigned number of an account | Yes | Yes | Yes |
AccountStatus | The account status | Yes | Yes | Yes |
AdDescription | The first ad description that appears below the path | No | No | No |
AdDescription2 | The second ad description that appears below the path | No | No | No |
AdDistribution | The network where you want your ads to show | Yes | Yes | Yes |
AdGroupId | Microsoft Advertising assigned identifier of an ad group | No | Yes | Yes |
AdGroupLabels | The labels applied to the ad group | No | Yes | No |
AdGroupName | The ad group name | No | Yes | Yes |
AdGroupStatus | The ad group status | No | Yes | Yes |
AdGroupType | The ad group type | No | Yes | No |
AdId | Microsoft Advertising assigned identifier of an ad | No | No | Yes |
AdLabels | The labels applied to the ad | No | No | No |
AdRelevance | How closely related your ads is to the customer's search query | Yes | Yes | Yes |
AdStatus | The ad status | No | No | No |
AdStrength | The ad strength score of responsive search ads | No | No | No |
AdStrengthActionItems | The suggestion based on ad strength of your responsive search ads | No | No | No |
AdTitle | The ad title | No | No | No |
AdType | The ad type | No | No | Yes |
AllConversionRate | The conversion rate as a percentage (all goals) | Yes | Yes | Yes |
AllConversions | The number of conversions (all goals) | Yes | Yes | Yes |
AllConversionsQualified | Qualified conversions (all goals) | Yes | Yes | Yes |
AllCostPerConversion | Cost per conversion (all goals) | Yes | Yes | Yes |
AllReturnOnAdSpend | Return on ad spend (all goals) | Yes | Yes | Yes |
AllRevenue | Revenue from conversions (all goals) | Yes | Yes | Yes |
AllRevenuePerConversion | Revenue per conversion (all goals) | Yes | Yes | Yes |
Assists | Number of conversions from other ads that were preceded by clicks | Yes | Yes | Yes |
AudienceImpression LostToBudgetPercent | Audience network impressions lost to budget | Yes | Yes | No |
AudienceImpression LostToRankPercent | Audience network impressions lost to rank | Yes | Yes | No |
AudienceImpression SharePercent | Audience network impression share | Yes | Yes | No |
AverageCpc | The average cost per click | Yes | Yes | Yes |
AverageCpm | The total advertising cost divided by impressions (in thousands) | Yes | Yes | Yes |
AverageCPV | Average total spend divided by video views | Yes | Yes | No |
AveragePosition | The average position of the ad on a webpage (deprecated) | Yes | Yes | Yes |
AverageWatchTime PerImpression | Total watch time, in milliseconds, divided by impressions | Yes | Yes | No |
AverageWatchTime PerVideoView | Total watch time divided by video views | Yes | Yes | No |
BaseCampaignId | Microsoft Advertising assigned identifier of an experiment campaign | Yes | Yes | Yes |
BidMatchType | The keyword bid match type | Yes | Yes | Yes |
BidStrategyType | The bid strategy type | No | No | Yes |
BusinessName | Your business's name that may appear in your ad | No | No | No |
CampaignId | Microsoft Advertising assigned identifier of a campaign | Yes | Yes | Yes |
CampaignLabels | Labels applied to campaign | Yes | No | No |
CampaignName | The campaign name | Yes | Yes | Yes |
CampaignStatus | The campaign status | Yes | Yes | Yes |
CampaignType | The campaign type | Yes | Yes | No |
ClickSharePercent | Percentage of available clicks received | Yes | Yes | No |
Clicks | Number of clicks on the ad | Yes | Yes | Yes |
CompletedVideoViews | Number of times a person watched the entire video | Yes | Yes | No |
ConversionRate | The conversion rate as a percentage | Yes | Yes | Yes |
Conversions | The number of conversions | Yes | Yes | Yes |
ConversionsQualified | Qualified conversions | Yes | Yes | Yes |
CostPerAssist | The cost per assist | Yes | Yes | Yes |
CostPerConversion | The cost per conversion | Yes | Yes | Yes |
CostPerDownload | Cost per app download | Yes | No | No |
CostPerInstall | Cost per app install | Yes | Yes | No |
CostPerSale | Cost per sale | Yes | Yes | No |
CPI | Cost per install | Yes | No | No |
CPP | Cost per in-app purchase | Yes | No | No |
CPS | Cost per subscription | Yes | No | No |
Ctr | The click-through rate | Yes | Yes | Yes |
CurrencyCode | The account currency type | Yes | Yes | Yes |
CurrentMaxCpc | Maximum cost per click bid in effect at report generation | No | No | Yes |
CustomerId | Microsoft Advertising customer identifier | Yes | Yes | No |
CustomerName | The customer name | Yes | Yes | No |
CustomParameters | Current custom parameter set | Yes | Yes | Yes |
DeliveredMatchType | The match type used to deliver an ad | Yes | Yes | Yes |
DestinationUrl | The destination URL attribute | No | No | Yes |
DeviceOS | The operating system of the device | Yes | Yes | Yes |
DeviceType | The device name attribute | Yes | Yes | Yes |
DisplayUrl | The ad display URL | No | No | No |
Downloads | Number of app downloads | Yes | No | No |
ExactMatchImpression SharePercent | Impression share for exact matches | Yes | Yes | No |
ExpectedCtr | How well your keyword competes against other keywords | Yes | Yes | Yes |
FinalAppUrl | Reserved for future use | No | No | Yes |
FinalMobileUrl | The Final Mobile URL | No | No | Yes |
FinalUrl | The Final URL | No | No | Yes |
FinalUrlSuffix | Parameters attached to the end of your landing page URL | Yes | Yes | Yes |
FirstPageBid | Estimated bid amount for first page placement | No | No | Yes |
Goal | The name of the goal you set for conversions | Yes | Yes | Yes |
GoalId | Microsoft Advertising assigned identifier of a conversion goal | No | No | Yes |
GoalType | The type of conversion goal | Yes | Yes | Yes |
Headline | The shorter of two possible responsive ad headlines | No | No | No |
HistoricalAdRelevance | Historical average of ad relevance scores | Yes | Yes | Yes |
HistoricalExpectedCtr | Historical average of expected click-through rate scores | Yes | Yes | Yes |
HistoricalLandingPage Experience | Historical average of landing page experience scores | Yes | Yes | Yes |
HistoricalQualityScore | Historical quality score values over time | Yes | Yes | Yes |
ImpressionLostTo BudgetPercent | Impressions lost due to budget | Yes | Yes | No |
ImpressionLostTo RankAggPercent | Impressions lost due to rank | Yes | Yes | No |
ImpressionSharePercent | Total impression share percentage | Yes | Yes | No |
Impressions | The number of times an ad has been displayed | Yes | Yes | Yes |
Installs | Total number of app installs | Yes | Yes | No |
Keyword | The keyword text | No | No | Yes |
KeywordId | Microsoft Advertising assigned identifier of a keyword | No | No | Yes |
KeywordLabels | The labels applied to the keyword | No | No | Yes |
KeywordStatus | The keyword status | No | No | Yes |
LandingPageExperience | Quality assessment of all landing pages on your site | Yes | Yes | Yes |
Language | The language of the publisher where the ad was shown | No | Yes | Yes |
LongHeadline | The longer of two possible responsive ad headlines | No | No | No |
LowQualityClicks | Number of low quality clicks | Yes | No | No |
LowQualityClicksPercent | Percentage of low quality clicks | Yes | No | No |
LowQualityConversionRate | Low quality conversion rate | Yes | No | No |
LowQualityConversions | Low quality conversions (deprecated) | Yes | No | No |
LowQualityConversions Qualified | Qualified low quality conversions | Yes | No | No |
LowQualityGeneralClicks | General low quality clicks | Yes | No | No |
LowQualityImpressions | Low quality impressions | Yes | No | No |
LowQualityImpressions Percent | Percentage of low quality impressions | Yes | No | No |
LowQualitySophisticated Clicks | Sophisticated low quality clicks | Yes | No | No |
Mainline1Bid | Estimated bid amount for top search results placement | No | No | Yes |
MainlineBid | Estimated bid amount for first page placement | No | No | Yes |
Network | The network where the ad was shown | Yes | Yes | Yes |
NewCustomerConversion Rate | New customer conversion rate (reserved) | Yes | No | No |
NewCustomerConversions | New customer conversions (reserved) | Yes | No | No |
NewCustomerCPA | New customer cost per acquisition (reserved) | Yes | No | No |
NewCustomerReturn OnAdSpend | New customer ROAS (reserved) | Yes | No | No |
NewCustomerRevenue | New customer revenue (reserved) | Yes | No | No |
Path1 | The path 1 attribute of an ad | No | No | No |
Path2 | The path 2 attribute of an ad | No | No | No |
PhoneCalls | Number of phone calls | Yes | Yes | No |
PhoneImpressions | Phone number impressions | Yes | Yes | No |
PostClickDownloadRate | Post-click download rate | Yes | No | No |
PostClickInstallRate | Post-click install rate | Yes | No | No |
PostInstallPurchaseRate | Post-install purchase rate | Yes | No | No |
PostInstallSubscriptionRate | Post-install subscription rate | Yes | No | No |
Ptr | Phone-through rate | Yes | Yes | No |
Purchases | Number of in-app purchases | Yes | No | No |
QualityImpact | Numeric score indicating possible impression increase | No | No | Yes |
QualityScore | Numeric score showing ad competitiveness | Yes | Yes | Yes |
RelativeCtr | Relative click-through rate | Yes | Yes | No |
ReturnOnAdSpend | The return on ad spend | Yes | Yes | Yes |
Revenue | Revenue from conversions | Yes | Yes | Yes |
RevenuePerAssist | The revenue per assist | Yes | Yes | Yes |
RevenuePerConversion | The revenue per conversion | Yes | Yes | Yes |
RevenuePerInstall | Revenue per install | Yes | Yes | No |
RevenuePerSale | Revenue per sale | Yes | Yes | No |
Sales | Total number of sales | Yes | Yes | No |
Spend | The cost per click summed for each click | Yes | Yes | Yes |
Status | The current ad group status | No | Yes | No |
Subscriptions | Number of app subscriptions | Yes | No | No |
TimePeriod | The time period of each report row | Yes | Yes | Yes |
TitlePart1 | The title part 1 attribute of an ad | No | No | No |
TitlePart2 | The title part 2 attribute of an ad | No | No | No |
TitlePart3 | The title part 3 attribute of an ad | No | No | No |
TopImpressionRatePercent | Percentage of times ad showed in mainline | Yes | Yes | Yes |
TopImpressionShare LostToBudgetPercent | Mainline impressions lost to budget | Yes | Yes | No |
TopImpressionShare LostToRankPercent | Mainline impressions lost to rank | Yes | Yes | No |
TopImpressionSharePercent | Mainline impression share | Yes | Yes | No |
TopVsOther | Indicates whether ad impression appeared in top position | Yes | Yes | Yes |
TotalWatchTimeInMS | Total video watch time | Yes | Yes | No |
TrackingTemplate | Current tracking template | Yes | Yes | Yes |
VideoCompletionRate | Video completion rate | Yes | Yes | No |
VideoViews | Number of video views | Yes | Yes | No |
VideoViewsAt25Percent | 25% video completion views | Yes | Yes | No |
VideoViewsAt50Percent | 50% video completion views | Yes | Yes | No |
VideoViewsAt75Percent | 75% video completion views | Yes | Yes | No |
ViewThroughConversions | View-through conversions (deprecated) | Yes | Yes | Yes |
ViewThroughConversionsQualified | Qualified view-through conversions | Yes | Yes | Yes |
ViewThroughRate | Video view-through rate | Yes | Yes | No |
ViewThroughRevenue | Revenue from view-through conversions | Yes | Yes | Yes |
Account Metadata Table (bing_meta_account)
Column Name | Description |
Id | Microsoft Advertising assigned unique identifier for the account |
Name | The display name of the advertising account |
BillToCustomerId | Identifier of the customer responsible for billing |
CurrencyCode | Three-letter currency code used for the account (e.g., USD, GBP) |
AccountFinancialStatus | Current financial status of the account (e.g., ClearFinancialStatus) |
Language | Primary language setting for the account interface |
LastModifiedByUserId | User ID of the person who last modified the account |
LastModifiedTime | Timestamp of when the account was last modified |
Number | Microsoft Advertising assigned account number |
ParentCustomerId | Identifier of the parent customer account |
PaymentMethodId | Identifier of the primary payment method |
PaymentMethodType | Type of payment method configured |
PrimaryUserId | User ID of the primary account administrator |
AccountLifeCycleStatus | Current lifecycle status of the account (e.g., Active, Paused) |
TimeStamp | System timestamp for data synchronization |
TimeZone | Time zone setting for the account |
PauseReason | Reason for account pause, if applicable |
ForwardCompatibilityMap | Reserved field for future API compatibility |
SalesHouseCustomerId | Identifier for sales house customer, if applicable |
TaxInformation_0_Key | Tax information type (e.g., VatNumber) |
TaxInformation_0_Value | Tax identification value |
BackUpPaymentInstrumentId | Backup payment method identifier |
BillingThresholdAmount | Threshold amount for billing triggers |
BusinessAddress_City | City of the business address |
BusinessAddress_CountryCode | Two-letter country code of the business address |
BusinessAddress_Id | Unique identifier for the business address |
BusinessAddress_Line1 | First line of the business address |
BusinessAddress_Line2 | Second line of the business address |
BusinessAddress_Line3 | Third line of the business address |
BusinessAddress_Line4 | Fourth line of the business address |
BusinessAddress_PostalCode | Postal or ZIP code of the business address |
BusinessAddress_StateOrProvince | State or province code of the business address |
BusinessAddress_TimeStamp | Timestamp for address last modification |
BusinessAddress_BusinessName | Official business name on the address |
AutoTagType | Auto-tagging configuration status (e.g., Inactive, Active) |
SoldToPaymentInstrumentId | Payment instrument for sold-to customer |
Note: This dimensional table provides comprehensive account-level metadata that can be joined with performance data tables to enable detailed reporting and analysis by account attributes, billing information, and business details.
Campaign Metadata Table (bing_meta_campaign)
Column Name | Description |
Id | Microsoft Advertising assigned unique identifier for the campaign |
Name | The display name of the campaign |
Status | Current status of the campaign (e.g., Active, Paused, Deleted) |
DailyBudget | Daily budget amount allocated to the campaign |
BudgetType | Type of budget configuration (e.g., DailyBudgetStandard, DailyBudgetAccelerated) |
TimeZone | Time zone setting for the campaign |
Settings | Additional campaign settings and configurations |
CampaignType | Type of campaign (e.g., Search, Shopping, DynamicSearchAds) |
SubType | Campaign subtype for additional classification |
AudienceAdsBidAdjustment | Bid adjustment percentage for audience ads |
TrackingUrlTemplate | Template URL for tracking parameters |
FinalUrlSuffix | Suffix parameters appended to final URLs |
UrlCustomParameters | Custom tracking parameters for URLs |
BiddingScheme_Type | Bidding strategy type (e.g., EnhancedCpc, ManualCpc, MaxClicks) |
BudgetId | Identifier linking to the budget entity |
Languages_0 | Primary language targeting for the campaign |
ExperimentId | Identifier for campaign experiments, if applicable |
Note: This dimensional table provides campaign-level metadata that can be joined with performance data tables using the campaign ID to enable detailed reporting and analysis by campaign attributes, budget settings, and targeting configurations.
Ad Group Metadata Table (bing_meta_adgroup)
Column Name | Description |
Id | Microsoft Advertising assigned unique identifier for the ad group |
Name | The display name of the ad group |
StartDate_Year | Year when the ad group becomes active |
StartDate_Month | Month when the ad group becomes active |
StartDate_Day | Day when the ad group becomes active |
EndDate | End date for the ad group, if applicable |
Language | Language targeting for the ad group |
Status | Current status of the ad group (e.g., Active, Paused, Deleted) |
PrivacyStatus | Privacy status setting for the ad group |
CpcBid_Amount | Default cost-per-click bid amount for the ad group |
Network | Network distribution setting (e.g., OwnedAndOperatedAndSyndicatedSearch) |
AdRotation_Type | Ad rotation optimization setting (e.g., OptimizeForClicks, OptimizeForConversions) |
AdRotation_StartDate | Start date for ad rotation settings |
AdRotation_EndDate | End date for ad rotation settings |
AudienceAdsBidAdjustment | Bid adjustment percentage for audience targeting |
TrackingUrlTemplate | Template URL for tracking parameters at ad group level |
FinalUrlSuffix | Suffix parameters appended to final URLs at ad group level |
UrlCustomParameters | Custom tracking parameters for URLs at ad group level |
BiddingScheme_Type | Bidding strategy type (e.g., InheritFromParent, ManualCpc) |
BiddingScheme_InheritedBidStrategyType | Inherited bidding strategy from parent campaign (e.g., EnhancedCpc) |
Settings | Additional ad group settings and configurations |
Note: This dimensional table provides ad group-level metadata that can be joined with performance data tables using the ad group ID to enable detailed reporting and analysis by ad group attributes, bidding configurations, and targeting settings.
Keyword Metadata Table (bing_meta_keyword)
Note: This table is not integrated by default but can be added upon request.
Column Name | Description |
Id | Microsoft Advertising assigned unique identifier for the keyword |
Bid_Amount | Specific bid amount set for the keyword |
MatchType | Keyword match type (e.g., Exact, Phrase, Broad) |
Param1 | First custom parameter for dynamic keyword insertion |
Param2 | Second custom parameter for dynamic keyword insertion |
Param3 | Third custom parameter for dynamic keyword insertion |
Text | The actual keyword text or phrase |
Status | Current status of the keyword (e.g., Active, Paused, Deleted) |
EditorialStatus | Editorial review status (e.g., Active, Disapproved, Under Review) |
DestinationUrl | Legacy destination URL for the keyword |
TrackingUrlTemplate | Template URL for tracking parameters at keyword level |
FinalUrlSuffix | Suffix parameters appended to final URLs at keyword level |
UrlCustomParameters | Custom tracking parameters for URLs at keyword level |
FinalUrls | Final landing page URLs for the keyword |
FinalMobileUrls | Mobile-specific final URLs for the keyword |
FinalAppUrls | App-specific final URLs for the keyword |
BiddingScheme_Type | Bidding strategy type (e.g., InheritFromParent, ManualCpc) |
BiddingScheme_InheritedBidStrategyType | Inherited bidding strategy from parent ad group (e.g., EnhancedCpc) |
Note: This dimensional table provides keyword-level metadata that can be joined with performance data tables using the keyword ID to enable detailed reporting and analysis by individual keyword attributes, match types, and URL configurations. Contact the team to request this table to be added to your integration.