Bing Ads
The table below gives information about all the data fields that you can import from Bing Ads.
To see the fields you can collect from another data source, go back to the Available fields in Adverity overview.
|
Field UI name |
Field API name |
Data Type |
Description |
Use in Adverity |
Docs |
|---|---|---|---|---|---|
|
|
AccountId |
string |
The Bing Ads assigned identifier of an account. |
dimension |
|
|
|
AccountName |
string |
The account name. |
dimension |
|
|
|
AccountNumber |
string |
The Bing Ads assigned number of an account. |
dimension |
|
|
|
AccountStatus |
string |
The account status. |
dimension |
|
|
|
AdDescription |
string |
The first ad description that appears below the path in your ad. |
dimension |
|
|
|
AdDistribution |
string |
The network where you want your ads to show. |
dimension |
|
|
|
AdGroupId |
string |
The Bing Ads assigned identifier of an ad group. |
dimension |
|
|
|
AdGroupName |
string |
The ad group name. |
dimension |
|
|
|
AdGroupStatus |
string |
The ad group status. |
dimension |
|
|
|
AdId |
string |
The Bing Ads assigned identifier of an ad. |
dimension |
|
|
|
AdLabels |
|
The labels applied to the ad. |
|
|
|
|
AdStatus |
string |
The ad status. |
dimension |
|
|
|
AdTitle |
string |
The ad title. |
dimension |
|
|
|
AdType |
string |
The ad type. |
dimension |
|
|
|
Assists |
long |
The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad. An ad is considered to have assisted the conversion if it was clicked before the most recently clicked ad that was credited with the conversion. Additionally; the click corresponding to the assist must occur within the conversion period of the goal. |
metric |
|
|
|
AverageCpc |
currency |
The average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked. For example; if you paid a total of 48.35 for 300 clicks; your average CPC is 0.16. The formula for calculating the average CPC is (Spend /Clicks). |
metric |
|
|
|
AveragePosition |
float |
The average position of the ad on a webpage. |
metric |
|
|
|
BidMatchType |
string |
The keyword bid match type. This can be different from the DeliveredMatchType column; for example if you bid on a broad match and the search term was an exact match. For more information; see Budget and Bid Strategies. The possible values are Broad; Exact; Phrase; and Unknown. |
dimension |
|
|
|
BusinessName |
string |
Depending on your responsive ad's placement; your business's name may appear in your ad. This column only applies to Audience campaigns. |
dimension |
|
|
|
CampaignId |
string |
The Bing Ads assigned identifier of a campaign. |
dimension |
|
|
|
CampaignName |
string |
The campaign name. |
dimension |
|
|
|
CampaignStatus |
string |
The campaign status. |
dimension |
|
|
|
Clicks |
long |
Clicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example; spiders; robots; and test servers). For more information; see Bing Ads click measurement: description of methodology. |
metric |
|
|
|
ConversionRate |
percentage |
The conversion rate as a percentage. The number of conversions; divided by the total number of clicks. For example; if the ads in your campaign got 300 clicks and four conversions; the conversion rate is 1.33 (%). The formula for calculating the conversion rate is (Conversions / Clicks) x 100. |
metric |
|
|
|
Conversions |
long |
The number of conversions. A conversion is the completion of an action by a customer after viewing your ad. The action could be purchasing your product; registering for your webinar; joining an organization; or whatever you consider your goal and best measure of the ad's success. |
metric |
|
|
|
CostPerAssist |
currency |
The cost per assist. The formula for calculating the cost per assist is (Spend / Assists). |
metric |
|
|
|
CostPerConversion |
currency |
The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number; so unless all campaigns in the account enable conversion tracking; the number will not be accurate. |
metric |
|
|
|
Ctr |
percentage |
The click-through rate (CTR) is the number of times an ad was clicked; divided by the number of times the ad was shown (impressions). For example; if your ads got 50 clicks given 2;348 impressions; your CTR is 2.13 (%). The formula for calculating CTR is (Clicks / Impressions) x 100. |
metric |
|
|
|
CurrencyCode |
string |
The account currency type. For possible values; see Currencies. |
dimension |
|
|
|
CustomParameters |
string |
The current custom parameters set of the ad; keyword; or criterion.Each custom parameter is a key and value pair. The list of custom parameters is semicolon-delimited and each key is enclosed by braces and a leading underscore; for example {_key1}=value1;{_key2}=value2. |
dimension |
|
|
|
CustomerId |
string |
The Bing Ads assigned identifier of a customer. |
dimension |
|
|
|
CustomerName |
string |
The customer name. |
dimension |
|
|
|
DeliveredMatchType |
string |
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. For more information; see Budget and Bid Strategies. The possible values are Broad; Exact; Phrase; and Unknown. |
dimension |
|
|
|
DestinationUrl |
string |
The destination URL attribute of the ad; keyword; or ad group criterion. If the destination URL contains dynamic text substitution parameters (for example; {param1}); the report will contain the URL after substitution occurs. |
dimension |
|
|
|
DeviceOS |
string |
The operating system of the device reported in the DeviceType column. The possible values include Android; Blackberry; iOS; Other; Unknown; and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target; the value in this column will be Unknown. |
dimension |
|
|
|
DeviceType |
string |
The device name attribute of a device OS target bid. The type of device which showed ads. The possible values include Computer; Smartphone; Tablet; and Unknown. |
dimension |
|
|
|
DisplayUrl |
string |
The ad display URL. |
dimension |
|
|
|
FinalAppUrl |
string |
Reserved for future use. |
dimension |
|
|
|
FinalMobileUrl |
string |
The Final Mobile URL of the ad; keyword; or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example; {param1}); the report will contain the URL before substitution. |
dimension |
|
|
|
FinalUrl |
string |
The Final URL of the ad; keyword; or criterion. Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example; {param1}); the report will contain the URL before substitution. |
dimension |
|
|
|
Headline |
string |
The shorter of two possible responsive ad headlines for Audience campaigns. |
dimension |
|
|
|
Impressions |
long |
The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. |
metric |
|
|
|
Labels are delimited by a semicolon (;) in the report download. |
|
dimension |
string |
|
|
|
Language |
string |
The language of the country the ad is served in. For possible values; see the Language column of Ad Languages. The language display name will be provided in the report e.g. English. |
dimension |
|
|
|
LongHeadline |
string |
The longer of two possible responsive ad headlines for Audience campaigns. |
dimension |
|
|
|
Network |
string |
The current network setting of an ad group. The possible values include AOL search; Bing and Yahoo! search; Content; and Syndicated search partners. |
dimension |
|
|
|
Path1 |
string |
The path 1 attribute of an ad. |
dimension |
|
|
|
Path2 |
string |
The path 2 attribute of an ad. |
dimension |
|
|
|
ReturnOnAdSpend |
currency |
The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend). |
metric |
|
|
|
Revenue |
currency |
The revenue optionally reported by the advertiser as a result of conversions. Corresponds to the optional revenue parameter of a Bing Ads campaign analytics tracking script. |
metric |
|
|
|
RevenuePerAssist |
currency |
The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists). |
metric |
|
|
|
RevenuePerConversion |
currency |
The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions). |
metric |
|
|
|
Spend |
currency |
The cost per click (CPC) summed for each click. |
metric |
|
|
|
TimePeriod |
string |
The time period of each report row. You may not include this column if the Aggregation element of the request object is set to Summary. For more information; see Time Period Column. |
dimension |
|
|
|
TitlePart1 |
string |
The title part 1 attribute of an ad. |
dimension |
|
|
|
TitlePart2 |
string |
The title part 2 attribute of an ad. |
dimension |
|
|
|
TopVsOther |
string |
The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere. The possible values include AOL search - Top; AOL search - Other; Bing and Yahoo! search - Top; Bing and Yahoo! search - Other; Syndicated search partners - Top; Syndicated search partners - Other; Content network; and Unknown. |
dimension |
|
|
|
TrackingTemplate |
string |
The current tracking template of the ad; keyword; or criterion. |
dimension |
|