Bing | Search Query Standard Dataset
Below are the measures and dimensions Alight Analytics considers standard for Bing - Search Query dataset. There is a one day lag on Bing and data is pulled for the previous 31 days.
This dataset can be automatically activated without a ticket through Dataset Activation.
| Field Name | Type | Description |
| Report Date | Date | The date the activity occurred |
| Account | Dimension | The account name |
| Account Number | Dimension | The Bing Ads assigned number of an account |
| Account ID | Dimension | The Bing Ads assigned identifier of an account |
| Campaign | Dimension | The campaign name |
| Campaign ID | Dimension | The ID of the campaign |
| Ad Group | Dimension | The ad group name |
| Ad Group ID | Dimension | The ID of the ad group |
| Keyword | Dimension | The keyword text |
| Search Query | Dimension | The search term used by your potential audience |
| Delivered Match Type | Dimension | The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match |
| Device | Dimension | The device name attribute of a device OS target bid |
| Network | Dimension | The network type |
| Impressions | Whole Number | The number of times an ad has been displayed on search results pages. Without impressions, there are no clicks or conversions |
| Clicks | Whole Number | The number of times that the ads in the account were clicked |
| Conversions | Whole Number | The number of action completions by a customer after viewing your ad |
| Average Position | Decimal Fraction | The average position of the ad on a webpage |
| Cost | Currency | The cost per click (CPC) summed for each click |
| Revenue | Currency | The revenue optionally reported by the advertiser as a result of conversions |
| All Conversions | Whole Number | The number of conversions. The AllConversions column will include data for all conversion goals regardless of their ExcludeFromBidding setting |
| All Revenue | Currency | The revenue optionally reported by the advertiser as a result of conversions. The AllRevenue column will include data for all conversion goals regardless of their ExcludeFromBidding setting |
| Insert Date | Dimension | Internal use: when the row was inserted in the table |
| ChannelMix Profile | Dimension | When needed, distinguishes between Bing accounts – Contents defined by Alight |