This page provides a guide to Establishing a Connection to Microsoft Ads in CData Cloud, as well as information on the available resources, and a reference to the available connection properties.

Connecting to Microsoft Ads

Establishing a Connection shows how to authenticate to Microsoft Ads and configure any necessary connection properties to create a database in CData Cloud

Accessing Data from CData Cloud Services

Accessing data from Microsoft Ads through the available standard services and CData Cloud administration is documented in further details in the CData Cloud Documentation.

Connect to Microsoft Ads by selecting the corresponding icon in the Database tab. Required properties are listed under Settings. The Advanced tab lists connection properties that are not typically required.

Connecting to Microsoft Ads

You need to register a Microsoft Ads account, get a developer token, and authenticate using OAuth to connect to the Microsoft Ads APIs.

Register a Bing Ads Account

Complete the following steps to sign up for a Microsoft Ads account and obtain the CustomerId and (optional) AccountId:

1. Sign up for a Microsoft Ads account in the Bing Ads Web application or at the Sandbox Site for a sandbox account.
2. Select Settings > Accounts and Billing and select a single account. The AccountId and CustomerId (cid) are displayed on the account's page and in the page's URL.

Get a Developer Token

To use the Microsoft Ads APIs, you must have a DeveloperToken in addition to the CustomerId. You must have the Super Admin role in Microsoft Ads to create a developer token, though you do not need special permissions to use the token.

1. Log in at the Bing Ads Developer Portal as a Microsoft Account user with the Microsoft Ads Super Admin role.
2. Click Request Token and take note of your developer token. You will set it in the DeveloperToken connection property.

Authenticating to Microsoft Ads

OAuth

AuthScheme must be set to OAuth in all user account flows.

Customizing the SSL Configuration

By default, the Cloud attempts to negotiate SSL/TLS by checking the server's certificate against the system's trusted certificate store.

To specify another certificate, see the SSLServerCert property for the available formats to do so.

Connecting Through a Firewall or Proxy

HTTP Proxies

To connect through the Windows system proxy, you do not need to set any additional connection properties. To connect to other proxies, set ProxyAutoDetect to false.

In addition, to authenticate to an HTTP proxy, set ProxyAuthScheme, ProxyUser, and ProxyPassword, in addition to ProxyServer and ProxyPort.

Other Proxies

Set the following properties:

• To use a proxy-based firewall, set FirewallType, FirewallServer, and FirewallPort.
• To tunnel the connection, set FirewallType to TUNNEL.
• To authenticate, specify FirewallUser and FirewallPassword.
• To authenticate to a SOCKS proxy, additionally set FirewallType to SOCKS5.

The CData Cloud models entities in the Microsoft Ads API as database views and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

The following sections provide information on executing SQL to the available API objects. The Cloud offloads as much of the SELECT statement processing as possible to Microsoft Ads and then processes the rest of the query in memory; API limitations and requirements are documented in this section.

Views

The Cloud Microsoft Ads objects as Views, including reports.

You can query Reports based on an aggregation and time period. The default time period is this year; to change the time period, see the following Time Filter section.

When retrieving only some report columns, you should select all columns marked as 'Select Requirement' and at least one of the columns marked as 'Metric' to issue a valid report request. On the other hand, if you are retrieving all columns, then the driver defaults to including the minimally required columns in the request.

Specifying a Time Filter

Date Ranges

You can specify date ranges in the WHERE clause using the "Date" field with these operators: =, <,>

These predefined date fields are supported:

• Today
• Yesterday
• LastSevenDays
• ThisWeek
• LastWeek
• LastFourWeeks
• ThisMonth
• LastMonth
• LastThreeMonths
• LastSixMonths
• ThisYear
• LastYear

The default DatePreset value is "ThisYear".

To search on a predefined date range, set the DatePreset pseudo column in the WHERE clause to one of the predefined date fields.

SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ] WHERE DatePreset = 'LastYear'

To specify a custom date range, specify the StartDate and EndDate pseudo columns in the WHERE clause.

SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ] WHERE StartDate = '2014-01-01' AND EndDate = '2017-09-19'

Aggregation

Aggregation is the process of reducing and summarizing data. You can aggregate the report data by selecting one of the following aggregation columns:

• Daily: Each row of the report identifies the month, day, and year when the transaction occurred. The report data is aggregated by each day. The report includes a column named Daily that contains the day formatted as yyyy-mm-dd.
  

  SELECT Daily, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• DayOfWeek: Each row of the report identifies the day of the week when the transaction occurred. The report data is aggregated by each of the seven days in a week. The report includes a column named DayOfWeek, and the possible values are 1 - 7 where 1 represents Sunday and 7 represents Saturday.

  If the report time spans multiple weeks, then the performance data across all weeks for a given day of the week is aggregated in one row. For example, if Campaign A has 5 impressions every Monday (day 2) throughout each of the 3 weeks included in the report time range, then the report includes one row with DayOfWeek set to 2 and impressions in that row totaling 15.
  

  SELECT DayOfWeek, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• Hourly: Each row of the report identifies the hour when the transaction occurred. The report data is aggregated by each hour of the day. The report includes a column named Hourly, and the possible values are 0 - 23.
  

  SELECT Hourly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• HourOfDay: Each row of the report identifies the hour of the day when the transaction occurred. The report data is aggregated by each of the 24 hours across all days. The report includes a column named HourOfDay, and the possible values are 0 - 23.

  If the report time spans multiple days, then the performance data across all days for a given hour is aggregated in one row. For example, if Campaign A has 5 impressions during hour 7 on each of the 3 days included in the report time range, then the report includes one row with impressions for HourOfDay totaling 15.
  

  SELECT HourOfDay, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• Monthly: Each row of the report identifies the month when the transaction occurred. The report data is aggregated by each month. The report includes a column named Monthly that contains the first day of the month formatted as yyyy-mm-dd.
  

  SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• Weekly: Each row of the report identifies the week when the transaction occurred. The report data is aggregated by each week. The report includes a column named Weekly that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
  

  SELECT Weekly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

• Yearly: Each row of the report identifies the year when the transaction occurred. The report data is aggregated by each year. The report includes a column named Yearly that contains the year formatted as yyyy.
  

  SELECT Yearly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate FROM [ AccountPerformanceReport ]

Stored Procedures

Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.

Views are similar to tables in the way that data is represented; however, views are read-only.

Queries can be executed against a view as if it were a normal table.

CData Cloud - Microsoft Ads Views

Name	Description
AccountPerformanceReport	Use this report to observe long-term account performance and trends.
Accounts	Query the available Accounts in Bing Ads.
AdDynamicTextPerformanceReport	Use this report to identify which dynamic text strings are performing well and which strings you should consider changing.
AdExtensionByAdReport	Use this report to compare how well different versions of your ad extensions are performing with each ad.
AdExtensionByKeywordReport	Use this report to compare how well different versions of your ad extensions are performing for each keyword.
AdExtensionDetailReport	Use this report to discover the effectiveness of individual ad extension items, for example, each link of a sitelink extension.
AdGroupPerformanceReport	Use this report to more broadly compare delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level.
AdGroups	Query the available AdGroups in Bing Ads.
AdPerformanceReport	Use this report to help you determine which ads lead to clicks and conversions, and which are not performing. Having underperforming ads in your account can pull down the quality of your campaigns.
Ads	Query the available Ads in Bing Ads.
AgeGenderAudienceReport	Use this report to discover how your campaigns and ad groups are resonating with audiences of diverse age and gender.
AudiencePerformanceReport	Use this report to compare delivery performance statistics by audience, ad group, campaign, or account attributes.
Audiences	Query the available Audiences in Bing Ads.
BidOpportunities	Query the available Bid Opportunities in Bing Ads.
BudgetOpportunities	Query the available Budget Opportunities in Bing Ads.
Budgets	Query the available Budgets in Bing Ads.
BudgetSummaryReport	Use this report to discover how your campaign's budget is performing for the month. For example, the report shows your monthly budget, how much you have spent to date, and whether you are on target to spend your monthly budget.
CampaignPerformanceReport	Use this report to view high-level performance statistics and quality attributes for each campaign or account. This is also a quick way to flag any major campaign or account problems.
Campaigns	Query the available Campaigns in Bing Ads.
ConversionPerformanceReport	Use this report to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion action.
DestinationUrlPerformanceReport	Use this report to identify landing pages that met audience expectations and potentially resulted in high click-through or conversion rates.
DSAAutoTargetPerformanceReport	Use this report to find out which DSA auto targets are performing well and those that are not.
DSACategoryPerformanceReport	Use this report to find out which DSA categories are performing well and those that are not.
DSASearchQueryPerformanceReport	Use this report to find out which search terms are in demand for your DSA campaign and the performance of dynamic headlines that are being displayed.
GeographicPerformanceReport	Use this report to see which locations your traffic is coming from. You can then validate whether your location targeting strategy is successful, and identify opportunities to improve. The report also identifies either the physical location of the search user or the geographical location interest based on the user's search query.
GoalsAndFunnelsReport	Use this report to discover whether your audience completes each step through the land, browse, prospect, and conversion pages of your website. For example, you can use this report to determine the step that users leave the conversion funnel, so that you can improve or remove that step to increase the chance that the user will continue to the next step.
KeywordDemographics	Query the available Keyword Demographics in Bing Ads.
KeywordEstimatedBid	Query the available Keyword Estimated Bid in Bing Ads.
KeywordEstimatedPosition	Query the available EstimatedPosition in Bing Ads.
KeywordHistoricalSearch	Query the available Keyword Historical Search in Bing Ads.
KeywordLocations	Query the available Keyword Locations in Bing Ads.
KeywordPerformance	Query the available Keyword Performance in Bing Ads.
KeywordPerformanceReport	Use this report to find out which keywords are performing well and those that are not.
Keywords	Query the available Keywords in Bing Ads.
NegativeKeywordConflictReport	Use this report to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level. Use this list to figure out which negative keywords to delete.
ProductDimensionPerformanceReport	Use this report to find out which product dimensions are performing well and those that are not.
ProductNegativeKeywordConflictReport	Use this report to discover which keywords and negative keywords are in conflict, and whether the conflict is at the campaign or ad group level. Use this list to figure out which negative keywords to delete.
ProductPartitionPerformanceReport	You can include details in the report such as impressions, clicks, and spend that you can use to identify whether or not the product partitions are performing well.
ProductPartitionUnitPerformanceReport	Use this report to find out which product partition units are performing well and those that are not.
ProductSearchQueryPerformanceReport	Use this report to get insight into what your audience is searching for when your ads are shown as well as ensure that your product titles are relevant to search queries.
PublisherUsagePerformanceReport	Use this report to see if any website URLs aren't performing well enough for your campaign or ad group target settings. For example, if ad impressions at those URLs yield a low click-through rate, then you might decide to exclude those websites from your campaign.
SearchCampaignChangeHistoryReport	Use this report to discover when changes to an account were made, as well as which user made the changes.
SearchQueryPerformanceReport	Use this report to see what your audience is searching for when your ads are shown. You can use this information to make informed additions, removals, or edits to both your keyword and negative keyword lists.
ShareOfVoiceReport	Use this report to view impression share (%) of successful bids for each keyword, and identify opportunities to increase impression share.
Tags	Query the available Tags in Bing Ads.
UserLocationPerformanceReport	Use this report to see which locations your traffic is coming from. You can then validate whether your location targeting strategy is successful, and identify opportunities to improve. The report also identifies the physical location of the user and the intended geographical location of the user's search query, for example a user in Seattle searching for services in Portland.

Use this report to observe long-term account performance and trends.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
AccountStatus	String				The account status.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
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.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer	True	True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
AbsoluteTopImpressionSharePercent	Double		True		The number of times your ad is shown in the top position as a percentage of the total available impressions in the market you were targeting.
Clicks	Integer		True		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).
ClickSharePercent	Double		True		The percentage of clicks that went to your ads. It is the share of the prospective customer's mindshare and buying intent you captured.
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
LowQualityClicks	Integer		True		Clicks that exhibit a low likelihood of commercial intent. You are not billed for these clicks.
LowQualityClicksPercent	Double		True		The low-quality clicks as a percentage.
LowQualityImpressions	Integer		True		The number of impressions that result from low-quality keyword searches.
LowQualityImpressionsPercent	Double		True		The low-quality impressions as a percentage.
LowQualityConversions	Integer		True		The number of conversions that originate from low-quality clicks.
LowQualityConversionRate	Double		True		The low-quality conversion rate as a percentage.
ExactMatchImpressionSharePercent	Double		True		The estimated percentage of impressions that your account received for searches that exactly matched your keyword, out of the total available exact match impressions you were eligible to receive.
ImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions in the market you were targeting. The value of this column is empty if the data is not available.
ImpressionLostToBudgetPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your daily or monthly budget. The value of this column is empty if the data is not available.
ImpressionLostToRankAggPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your ad ranking. The value of this column is empty if the data is not available.
PhoneImpressions	Integer		True		The number of times your tracked number was shown on all devices.
PhoneCalls	Integer		True		The number of total calls to the tracked phone number that showed with your ad.
Ptr	Double		True		The phone-through rate (Ptr). The formula for calculating the Ptr is (PhoneCalls / PhoneImpressions) x 100.
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).
LowQualityGeneralClicks	Integer		True		Clicks that are filtered by general methods, such as blacklists and activity-based detection, and that exhibit a low likelihood of commercial intent. You are not billed for these clicks.
LowQualitySophisticatedClicks	Integer		True		Invalid clicks that use sophisticated means to appear valid. You are not billed for these clicks.
AudienceImpressionLostToBudgetPercent	Double		True		The percentage of impression share you lost due to insufficient budget on the Microsoft Audience Network.
AudienceImpressionLostToRankPercent	Double		True		The percentage of impression share you lost due to low rank on the Microsoft Audience Network.
AudienceImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions you could have received on the Microsoft Audience Network.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Query the available Accounts in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the Cloud; the following query is processed server-side.

SELECT * FROM [ Accounts ]

The client-side execution of the query can be turned off by setting SupportEnhancedSQL to false in which case any query other than SELECT * will return an error.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The system generated identifier of the account.
Name	String				The name of the account.
Number	String				The account number.
AccountLifeCycleStatus	String				The status of the account. The allowed values are Draft, Active, Inactive, Pause, Pending, Suspended.
PauseReason	Integer				A flag value that indicates who paused the account. The following are the possible values: 1-The user paused the account. 2-The billing service paused the account. 4-The user and billing service paused the account.

Use this report to identify which dynamic text strings are performing well and which strings you should consider changing.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
AccountName	String				The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
Keyword	String				The keyword text.
AdId	Long				Ad Id
AdTitle	String	True			The ad title.
AdType	String				The ad type.
AdLabels	String				The labels applied to the ad.
DestinationUrl	String	True			The destination URL attribute of the ad, keyword, or ad group criterion.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
Param1	String	True			The first dynamic substitution parameter (Param1) of a keyword or biddable ad group criterion.
Param2	String	True			The second dynamic substitution parameter (Param2) of a keyword or biddable ad group criterion.
Param3	String	True			The third dynamic substitution parameter (Param3) of a keyword or biddable ad group criterion.
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.
Language	String				The ad group language.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad status.
KeywordStatus	String				The keyword status.
TitlePart1	String				The title part 1 attribute of an ad.
TitlePart2	String				The title part 2 attribute of an ad.
TitlePart3	String				The title part 3 attribute of an ad.
Path1	String				The path 1 attribute of an ad.
Path2	String				The path 2 attribute of an ad.
FinalUrl	String				The Final URL of the ad, keyword, or criterion.
FinalMobileUrl	String				The Final Mobile URL of the ad, keyword, or criterion.
FinalAppUrl	String				Reserved for future use.
AdDescription	String				The text attribute of an ad.
AdDescription2	String				The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to compare how well different versions of your ad extensions are performing with each ad.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String				The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdGroupName	String				The ad group name.
AdGroupId	Long	True			The Bing Ads assigned identifier of an ad group.
AdTitle	String	True			The ad title.
AdExtensionType	String	True			The type name that corresponds to the AdExtensionTypeId column.
AdExtensionVersion	String				The version attribute of an ad extension.
AdExtensionId	Long				The identifier of the ad extension.
AdId	Long				Ad Id
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad status.
CampaignStatus	String				The campaign status.
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.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
ClickType	String				Click type refers to each component of an ad that a customer can click.
TitlePart1	String				The title part 1 attribute of an ad.
TitlePart2	String				The title part 2 attribute of an ad.
TitlePart3	String				The title part 3 attribute of an ad.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
TotalClicks	Integer		True		The number of billable and non-billable times that the ad extension was clicked.
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to compare how well different versions of your ad extensions are performing for each keyword.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String				The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdExtensionType	String	True			The Bing Ads assigned identifier of an ad extension.
AdExtensionId	Long				The version attribute of an ad extension.
AdExtensionVersion	String				The version attribute of an ad extension.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
CampaignStatus	String				The campaign status.
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.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
ClickType	String				Click type refers to each component of an ad that a customer can click.
Keyword	String	True			The keyword text.
KeywordId	String				The Bing Ads assigned identifier of a keyword.
KeywordStatus	String				The keyword status.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
TotalClicks	Integer		True		The number of billable and non-billable times that the ad extension was clicked.
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to discover the effectiveness of individual ad extension items, for example, each link of a sitelink extension.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String				The account name.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdTitle	String				The ad title.
AdId	String				The Bing Ads assigned identifier of an ad.
AdExtensionType	String	True			The Bing Ads assigned identifier of an ad extension.
AdExtensionTypeId	String	True			The system identifier that corresponds to the AdExtensionType column. The supported identifiers are 10, 11, and 12.
AdExtensionId	Long	True			The version attribute of an ad extension.
AdExtensionVersion	String				The version attribute of an ad extension.
AdExtensionPropertyValue	String	True			The human readable ad extension property value. For this report only one property is available for each type of ad extension.
AdStatus	String				The ad status.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
CampaignStatus	String				The campaign status.
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.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer	True	True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer	True	True		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).
Ctr	Double	True	True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to more broadly compare delivery performance statistics by ad group, campaign, or account attributes rather than at the keyword level.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
Status	String				The ad distribution attribute of an ad group.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
AdGroupName	String				The ad group name.
AdGroupLabels	String				The labels applied to the ad group.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
TrackingTemplate	String				The current tracking template for the ad group.
CustomParameters	String				The current custom parameters set for the ad group.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
Language	String				The ad group language.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
AbsoluteTopImpressionSharePercent	Double		True		The number of times your ad is shown in the top position as a percentage of the total available impressions in the market you were targeting.
Clicks	Integer		True		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).
ClickSharePercent	Double		True		The percentage of clicks that went to your ads. It is the share of the prospective customer's mindshare and buying intent you captured.
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
ExactMatchImpressionSharePercent	Double		True		The estimated percentage of impressions that your account received for searches that exactly matched your keyword, out of the total available exact match impressions you were eligible to receive.
ImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions in the market you were targeting. The value of this column is empty if the data is not available.
ImpressionLostToBudgetPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your daily or monthly budget. The value of this column is empty if the data is not available.
ImpressionLostToRankAggPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your ad ranking. The value of this column is empty if the data is not available.
QualityScore	Integer		True		The numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms.
ExpectedCtr	Integer		True		How well your keyword competes against other keywords targeting the same traffic. Ads that are relevant to searchers' queries or other input are more likely to have a higher click-through rate. This metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes or remove ads altogether.
AdRelevance	Integer		True		How closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers.
LandingPageExperience	Integer		True		An aggregate quality assessment of all landing pages on your site. The landing page experience score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.
HistoricalQualityScore	Integer		True		The historic quality score of the keyword. The historic quality score for each row is the value that was calculated for quality score on that date.
HistoricalExpectedCtr	Integer		True		Historical average of expected click-through rate scores going back as far as 18 months from the current date. This score may vary from the score in the ExpectedCtr column, which is the current score and same value for each day in the time period.
HistoricalAdRelevance	Integer		True		Historical average of ad relevance scores back as far as 18 months from the current date.
HistoricalLandingPageExperience	Integer		True		Historical average of landing page experience scores back as far as 18 months from the current date.
PhoneImpressions	Integer		True		The number of times your tracked number was shown on all devices.
PhoneCalls	Integer		True		The number of total calls to the tracked phone number that showed with your ad. The formula for calculating the phone calls is ManualCalls + ClickCalls.
Ptr	Double		True		The phone-through rate (Ptr).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).
AudienceImpressionLostToBudgetPercent	Double		True		The percentage of impression share you lost due to insufficient budget on the Microsoft Audience Network.
AudienceImpressionLostToRankPercent	Double		True		The percentage of impression share you lost due to low rank on the Microsoft Audience Network.
AudienceImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions you could have received on the Microsoft Audience Network.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Query the available AdGroups in Bing Ads.

Table Specific Information

Select

You must specify the CampaignId column in the WHERE clause to query this table. The Cloud will use the Microsoft Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the Cloud.

For example, the following query is processed server side:

SELECT * FROM [AdGroups] WHERE CampaignId = '234505536'

The client-side execution of the query can be turned off by setting SupportEnhancedSQL to false in which case any search criteria with columns in the WHERE clause other than CampaignId will cause an error.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The system generated identifier of the ad group.
CampaignId	Long				The system generated identifier of the campaign.
Name	String				The name of the ad group.
AdRotationType	String				Determines how often you'd like the ads in your ad group to show in relation to one another. If you have multiple ads within an ad group, your ads will rotate because no more than one ad from your account can show at a time.
StartDate	Date				The date that the ads in the ad group can begin serving; otherwise, the service can begin serving the ads in the ad group the day that the ad group becomes active.
EndDate	Date				The date that the ads in the ad group will expire.
Language	String				The language of the ads and keywords in the ad group.
CpcBidAmount	Double				The default bid to use when the user's query and the ad group's keywords match by using either a broad, exact, or phrase match comparison..
AudienceAdsBidAdjustment	String				The percent amount by which to adjust your bid for native ads above or below the base ad group or keyword bid.
BiddingSchemeType	String				The bid strategy type for how you want to manage your bids.
ForwardCompatibilityMap	String				The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases.
Network	String				The search networks where you want your ads to display.
Status	String				The status of the ad group.
TrackingUrlTemplate	String				The tracking template to use as a default for all URLs in your ad group.
UrlCustomParameters	String				Your custom collection of key and value parameters for URL tracking.
AccountId	Long				The Bing Ads assigned identifier of an account.

Use this report to help you determine which ads lead to clicks and conversions, and which are not performing. Having underperforming ads in your account can pull down the quality of your campaigns.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdLabels	String				The labels applied to the ad.
AdGroupName	String				The ad group name.
AdId	Long				The Bing Ads Ad identifier
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdTitle	String				The ad title.
AdDescription	String				The text attribute of an ad.
AdDescription2	String				The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad.
AdType	String				The ad type.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
TrackingTemplate	String				The current tracking template of the ad, keyword, or criterion.
CustomParameters	String				The current custom parameters set of the ad, keyword, or criterion.
FinalUrl	String				The Final URL of the ad, keyword, or criterion.
FinalMobileUrl	String				The Final Mobile URL of the ad, keyword, or criterion.
FinalAppUrl	String				Reserved for future use.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad status.
Headline	String				The shorter of two possible responsive ad headlines for Audience campaigns.
LongHeadline	String				The longer of two possible responsive ad headlines for Audience campaigns.
TitlePart1	String				The title part 1 attribute of an ad.
TitlePart2	String				The title part 2 attribute of an ad.
TitlePart3	String				The title part 3 attribute of an ad.
Path1	String				The path 1 attribute of an ad.
Path2	String				The path 2 attribute of an ad.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
Language	String				The ad group language.
DisplayUrl	String				The ad display URL.
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.
DeviceOS	String				The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows.
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.
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. The possible values are Broad, Exact, Phrase, and Unknown.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Query the available Ads in Bing Ads.

Table Specific Information

Select

You must specify the AdGroupId and Type columns in the WHERE clause to query this table. The Cloud uses the Microsoft Ads API to filter the results by AdGroup and Type, while the rest of the filter is executed client side within the Cloud.

For example, the following query is processed server side:

SELECT * FROM [Ads] WHERE AdGroupId = '5179946006' AND Type = 'Text'
SELECT * FROM Ads WHERE AdGroupId = '1297424037031698' AND Type = 'DynamicSearch' AND AccountId = '135093022'
SELECT * FROM Ads WHERE AdGroupId = '1302921473177959' AND Type = 'Text' AND AccountId IN ('2562405', '141163457', '180394748')

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The unique Bing Ads identifier for the ad.
AdGroupId	Long				The system generated identifier of the ad group.
Type	String				The ad type. One of Text,Image,Product,AppInstall,ExpandedText,DynamicSearch
Title	String				The title of the ad. The title must contain at least one word. The ad's copy and title combined must total at least three words.
TitlePart1	String				The first title part of the ad.
TitlePart2	String				The second title part of the ad.
Text	String				The ad copy. The copy must contain at least one word. The ad's copy and title combined must total at least three words.
Domain	String				The URL to display in the ad.
DestinationUrl	String				The URL of the webpage to take the user to when they click the ad.
UrlCustomParameters	String				Your custom collection of key and value parameters for URL tracking.
TrackingUrlTemplate	String				The tracking template to use as a default for all landing page URLs.
Status	String				The status of the ad.
ForwardCompatibilityMap	String				The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases.
FinalUrls	String				The last or final URL where a user is ultimately taken, whether or not the click to final URL path included any redirects.
FinalMobileUrls	String				The mobile landing page URL.
FinalAppUrls	String				Reserved for future use.
EditorialStatus	String				The editorial review status of the ad, which indicates whether the ad is pending review, has been approved, or has been disapproved.
DevicePreference	Integer				Determines the device preference for showing the ad.
AdFormatPreference	String				The Ad Format Preference is used to indicate whether or not you prefer the ad copy to be shown to users as a search or native ad. Search ads tend to be written as a call to action, whereas native ads should be written in more of an informational style.
AccountId	Long				The Bing Ads assigned identifier of an account.

Use this report to discover how your campaigns and ad groups are resonating with audiences of diverse age and gender.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
AccountName	String	True			The account name.
AccountNumber	String				The Microsoft Advertising assigned number of an account.
AccountId	Long				The Microsoft Advertising assigned identifier of an account.
AdGroupId	Long				The Microsoft Advertising assigned identifier of an ad group.
CampaignId	Long				The Microsoft Advertising assigned identifier of a campaign.
AdGroupName	String	True			The ad group name.
CampaignName	String				The campaign name.
AdDistribution	String				The network where you want your ads to show.
Gender	String	True			The gender (male or female) of the search users to whom the ad was delivered..
AgeGroup	String	True			The age group of the audience who viewed the ad. The possible values are 13-17, 18-24, 25-34, 35-49, 50-64, and 65+.
Language	String				This is the language of the country the ad is served in.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
AllConversions	Double				The number of conversions. A conversion is the completion of an action by a customer after viewing your ad.
AllRevenue	Decimal				The revenue optionally reported by the advertiser as a result of conversions.
Assists	Integer				The number of times an entity (an account, campaign, ad group, or keyword, for example) contributed to a conversion that is associated with a different entity.
BaseCampaignId	Long				The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment.
Impressions	Long	True			The number of times an ad has been displayed on search results pages or other sites on the Audience Network.
Clicks	Integer				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.
Conversions	Integer				The number of conversions. A conversion is the completion of an action by a customer after viewing your ad.
ExtendedCost	Decimal				Cost information that is optionally provided by advertisers, including non-advertising costs, taxes, and shipping.
Revenue	Decimal				The revenue optionally reported by the advertiser as a result of conversions.
Spend	Decimal				The sum of your cost-per-click (CPC) charges for your ads and keywords. Spend helps you keep track of your budget.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to compare delivery performance statistics by audience, ad group, campaign, or account attributes.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String				The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long	True			The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AudienceId	Long	True			The Bing Ads assigned identifier of the audience, for example the remarketing list ID.
AudienceName	String				The audienc name.
AudienceType	String				The audience type.
AssociationStatus	String				The status of the association between the ad group and remarketing list, which indicates whether ads are eligible to display. The possible values are Active, Paused, and Deleted.
BidAdjustment	String				This attribute reflects the current value of your ad group's audience bid adjustment, even if a different bid adjustment value was used when the ad was shown. This value is the requested percentage to increase or decrease the bid amount for the remarketing list.
TargetingSetting	String				This attribute reflects the current value of your ad group's audience targeting setting. The possible values are Target and bid or Bid only.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Query the available Audiences in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the Cloud; the following query is executed server-side.

SELECT * FROM [Audiences]
SELECT * FROM Audiences WHERE AccountId = '65098547' AND Type = 'RemarketingList'

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The Bing Ads identifier of the audience.
ParentId	Long				The Bing Ads identifier of the account or customer.
Name	String				The name of the audience. The name can contain a maximum of 128 characters.
Type	String				The type of the audience. The allowed values are RemarketingList, Custom, InMarket.
Description	String				The description of the audience. Use a description to help you remember what audience you are targeting.
MembershipDuration	Integer				When you create an audience, you can specify how far back in time Bing Ads should look for actions that match your audience definition.
ForwardCompatibilityMap	String				The list of key and value strings for forward compatibility. This element can be used to avoid otherwise breaking changes when new elements are added in future releases.
Scope	String				Scope defines what accounts can use this audience. The allowed values are Account, Customer.
TagId	Long				The unique Bing Ads identifier of the tag.
AudienceNetworkSize	Long				The total number of people who are active members of this audience in the Audience network.
SearchSize	Long				The total number of people who are active members of this audience in the Search network.
SupportedCampaignTypes	String				The list of campaign types that support this audience.
CustomerShareAggregate	String			True	Contains information about CustomerAccountShares and OwnerCustomerId.
AccountId	Long				The Bing Ads assigned identifier of an account.

Query the available Bid Opportunities in Bing Ads.

Table Specific Information

Select

You must specify the OpportunityType column in the WHERE clause to query this table. You can specify the following values for OpportunityType: FirstPage, MainLine, and MainLine1.

The Cloud will use the Microsoft Ads API to filter the results by OpportunityType while the rest of the filter is executed client side within the Cloud. For example, the following query is processed server side.

SELECT * FROM [ BidOpportunities ] WHERE OpportunityType = 'FirstPage'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to columns other than OpportunityType will cause an error.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
OpportunityKey	String				An identifier that uniquely identifies the opportunity.
AdGroupId	Long				The identifier of the ad group that owns the keyword.
CampaignId	Long				The identifier of the campaign for the ad group that owns the keyword.
OpportunityType	String				Defines the possible bid opportunity types you can request when calling GetBidOpportunities. Avaiable values are: FirstPage,MainLine and MainLine1. The default value is FirstPage.
CurrentBid	Double				The current keyword bid amount specified for the match type in the MatchType element.
EstimatedIncreaseInClicks	Double				The estimated clicks opportunities corresponding to the suggested bid.
EstimatedIncreaseInCost	Double				The estimated increase in spend corresponding to the suggested bid.
EstimatedIncreaseInImpressions	Long				The estimated impressions opportunities corresponding to the suggested bid.
KeywordId	Long				The identifier of the keyword to which the bid opportunity applies.
MatchType	String				The match type to which the suggested bid value applies. The possible values are BroadMatch, ExactMatch, and PhraseMatch.
SuggestedBid	Double				The suggested bid based on the last 7 days of performance history for the corresponding ad group.
AccountId	Long				The Bing Ads assigned identifier of an account.

Query the available Budget Opportunities in Bing Ads.

Table Specific Information

Select

You must specify the CampaignId column in the WHERE clause to query this table. The Cloud will use the Microsoft Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the Cloud.

For example, the following query is processed server side:

SELECT * FROM [ BudgetOpportunities ] WHERE CampaignId = '234505536'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria in the WHERE clause that refers to columns other than CampaignId will cause an error.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
OpportunityKey	String				An identifier that uniquely identifies the opportunity.
BudgetAmount	Double				A potential new budget.
BudgetPointType	String				The type of budget relative to a list of budget points. For example, if the budget point type is Current then this object's BudgetAmount element would be equal to the corresponding campaign's daily budget.
EstimatedWeeklyClicks	Double				The estimated weekly clicks for the given budget amount.
EstimatedWeeklyCost	Double				The estimated weekly cost for the given budget amount.
EstimatedWeeklyImpressions	Double				The estimated weekly impressions for the given budget amount.
BudgetType	String				The type of budget that the campaign uses.
CampaignId	Long				The identifier of the campaign to which the suggested budget applies
CurrentBudget	Double				The campaign's current budget.
IncreaseInClicks	Double				The estimated clicks opportunities corresponding to the suggested budget.
IncreaseInImpressions	Double				The estimated impressions opportunities corresponding to the suggested budget.
PercentageIncreaseInClicks	Integer				The estimated percentage increase in clicks corresponding to the suggested budget.
PercentageIncreaseInImpressions	Integer				The estimated percentage increase in impressions corresponding to the suggested budget.
RecommendedBudget	Double				The suggested budget based on the last 15 days of performance history for the corresponding campaign.
AccountId	Long				The Bing Ads assigned identifier of an account.

Query the available Budgets in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the Cloud; the following query is processed server-side:

SELECT * FROM [Budgets]
SELECT * FROM Budgets WHERE CampaignId = '431046229' AND AccountId = '65098547'

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The unique Bing Ads identifier of the budget.
CampaignId	Long				The system generated identifier of the campaign.
Name	String				The name of the budget. The name must be unique among all budgets within the account. The name can contain a maximum of 255 characters.
Amount	Double				The amount to spend daily across all campaigns that share the budget.
AssociationCount	Integer				The number of Campaign objects that currently share this budget.
BudgetType	String				The budget type determines the pace at which the budget is spent throughout the day.
AccountId	Long				The Bing Ads assigned identifier of an account.

Use this report to discover how your campaign's budget is performing for the month. For example, the report shows your monthly budget, how much you have spent to date, and whether you are on target to spend your monthly budget.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
AccountName	String	True			The account name.
AccountNumber	String	True			The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String	True			The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
Date	String	True			The date for the downloaded report records. The date will be in the time zone of the campaign.
CurrencyCode	String	True			The account currency type.
MonthlyBudget	String				The average amount of campaign budget spent during a calendar month.
DailySpend	String	True			The average amount of campaign budget spent per day.
MonthToDateSpend	String				The amount of money spent to date for the month.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisMonth, LastMonth.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to view high-level performance statistics and quality attributes for each campaign or account. This is also a quick way to flag any major campaign or account problems.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Hourly	String			True	Each row of the report identifies the hour when the transaction occurred. The report data will be aggregated by each hour of the day.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
AccountStatus	String				The account status.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
CampaignLabels	String				The labels applied to the campaign.
CampaignStatus	String				The campaign status.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
BudgetName	String				The name of the budget.
BudgetStatus	String				The budget status. The possible values are Active and Deleted.
BudgetAssociationStatus	String				Indicates whether or not the campaign is currently spending from the budget mentioned in the BudgetName column. The possible values are Current and Ended.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
TrackingTemplate	String				The current tracking template for the ad group.
CustomParameters	String				The current set of custom parameters for the campaign.
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.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
AbsoluteTopImpressionSharePercent	Double		True		The number of times your ad is shown in the top position as a percentage of the total available impressions in the market you were targeting.
Clicks	Integer		True		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).
ClickSharePercent	Double		True		The percentage of clicks that went to your ads.It is the share of the prospective customer's mindshare and buying intent you captured.
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
LowQualityClicks	Integer		True		Clicks that exhibit a low likelihood of commercial intent. You are not billed for these clicks.
LowQualityClicksPercent	Double		True		The low-quality clicks as a percentage.
LowQualityImpressions	Integer		True		The number of impressions that result from low-quality keyword searches.
LowQualityImpressionsPercent	Double		True		The low-quality impressions as a percentage.
LowQualityConversions	Integer		True		The number of conversions that originate from low-quality clicks.
LowQualityConversionRate	Double		True		The low-quality conversion rate as a percentage.
ExactMatchImpressionSharePercent	Double		True		The estimated percentage of impressions that your account received for searches that exactly matched your keyword, out of the total available exact match impressions you were eligible to receive.
ImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions in the market you were targeting. The value of this column is empty if the data is not available.
ImpressionLostToBudgetPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your daily or monthly budget. The value of this column is empty if the data is not available.
ImpressionLostToRankAggPercent	Double		True		The estimated percentage of impressions your ad did not receive due to issues with your ad ranking. The value of this column is empty if the data is not available.
QualityScore	Integer		True		The numeric score shows you how competitive your ads are in the marketplace by measuring how relevant your keywords and landing pages are to customers' search terms.
ExpectedCtr	Integer		True		How well your keyword competes against other keywords targeting the same traffic. Ads that are relevant to searchers' queries or other input are more likely to have a higher click-through rate. This metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes or remove ads altogether.
AdRelevance	Integer		True		How closely related your ads is to the customer's search query or other input. It tells you how relevant your ad and landing page are to potential customers.
LandingPageExperience	Integer		True		An aggregate quality assessment of all landing pages on your site. The landing page experience score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.
HistoricalQualityScore	Integer		True		The historic quality score of the keyword. The historic quality score for each row is the value that was calculated for quality score on that date.
HistoricalExpectedCtr	Integer		True		Historical average of expected click-through rate scores going back as far as 18 months from the current date. This score may vary from the score in the ExpectedCtr column, which is the current score and same value for each day in the time period.
HistoricalAdRelevance	Integer		True		Historical average of ad relevance scores back as far as 18 months from the current date.
HistoricalLandingPageExperience	Integer		True		Historical average of landing page experience scores back as far as 18 months from the current date.
PhoneImpressions	Integer		True		The number of times your tracked number was shown on all devices.
PhoneCalls	Integer		True		The number of total calls to the tracked phone number that showed with your ad. The formula for calculating the phone calls is ManualCalls + ClickCalls.
Ptr	Double		True		The phone-through rate (Ptr).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).
LowQualityGeneralClicks	Double		True		Clicks that are filtered by general methods, such as blacklists and activity-based detection, and that exhibit a low likelihood of commercial intent. You are not billed for these clicks.
LowQualitySophisticatedClicks	Double		True		Invalid clicks that use sophisticated means to appear valid. You are not billed for these clicks. For more information, see Bing Ads click measurement: description of methodology.
AudienceImpressionLostToBudgetPercent	Double		True		The percentage of impression share you lost due to insufficient budget on the Microsoft Audience Network.
AudienceImpressionLostToRankPercent	Double		True		The percentage of impression share you lost due to low rank on the Microsoft Audience Network.
AudienceImpressionSharePercent	Double		True		The estimated percentage of impressions, out of the total available impressions you could have received on the Microsoft Audience Network.
TopImpressionSharePercent	Double		True		The percentage of impressions for your ad in the mainline, the top ad placements above the search results, out of the estimated number of mainline impressions you were eligible to receive.
TopImpressionRatePercent	Double		True		The percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Query the available Campaigns in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the Cloud; the following query is processed server-side:

SELECT * FROM [ Campaigns ]

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The unique Bing Ads identifier of the campaign.
AccountId	String				The unique Bing Ads identifier of the account associated with this campaign.
CampaignType	String				The campaign type determines whether the campaign is an Audience, Dynamic Search Ads, Search, Shopping or Search & Content campaign. The allowed values are Search, Shopping, DynamicSearchAds, Audience.
Name	String				The name of the campaign. The name must be unique among all active or paused campaigns within the account.
Status	String				The status of the campaign. The allowed values are Active, Paused.
SubType	String				The campaign sub type. This element is only applicable for campaigns of type Shopping, and will be nil for all other campaign types.
BiddingSchemeType	String				The bid strategy type for how you want to manage your bids. The allowed values are EnhancedCpc, InheritFromParent, ManualCpc, MaxClicks, MaxConversions, TargetCpa.
BudgetType	String				The budget type determines how the budget is spent. The allowed values are DailyBudgetAccelerated, DailyBudgetStandard.
DailyBudget	Double				The amount to spend daily on the campaign. You must set the daily budget amount if BudgetId is not set.
ExperimentId	Long				The system generated identifier of the Experiment.
TimeZone	String				The time zone where the campaign operates.
TrackingUrlTemplate	String				The tracking template to use as a default for all URLs in your campaign.
UrlCustomParameters	String				Your custom collection of key and value parameters for URL tracking.
BudgetId	Long				The unique Bing Ads identifier of the Budget that this campaign shares with other campaigns in the account.
AudienceAdsBidAdjustment	Integer				The percent amount by which to adjust your bid for audience ads above or below the base ad group or keyword bid.
Languages	String				The languages of the ads and keywords in the campaign.

Use this report to understand which campaigns and keywords are leading an audience to complete a purchase or other conversion action.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
AdGroupId	Long				The Bing Ads assigned identifier of an account.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
AdGroupName	String				The ad group name.
CampaignName	String				The campaign name.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
KeywordStatus	String				The keyword status.
KeywordId	Long				The Bing Ads assigned identifier of a keyword.
Keyword	String				The keyword text.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
Spend	Double		True		The cost per click (CPC) summed for each click.
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to identify landing pages that met audience expectations and potentially resulted in high click-through or conversion rates.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String	True			The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign..
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdId	Long				Ad Id
DestinationUrl	String	True			The destination URL attribute of the ad, keyword, or ad group criterion.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
FinalUrl	String				The Final URL of the ad, keyword, or criterion.
FinalMobileUrl	String				The Final Mobile URL of the ad, keyword, or criterion.
FinalAppUrl	String				Reserved for future use.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad status.
CampaignStatus	String				The campaign status.
TrackingTemplate	String				The current tracking template for the ad group.
CustomParameters	String				The current set of custom parameters for the campaign.
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.
Language	String				The ad group language.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.

Use this report to find out which DSA auto targets are performing well and those that are not.

Columns

Name	Type	Select requirement	Metric	Aggregate	Description
Summary	String			True	The report data will be aggregated by the entire specified report time. The report will not include a time period column.
Daily	Date			True	Each row of the report identifies the month, day, and year when the transaction occurred. The report data will be aggregated by each day. Each row of the report identifies the month, day, and year when the transaction occurred. The report will include a column named GregorianDate that contains the day formatted as yyyy-mm-dd.
Weekly	Date			True	Each row of the report identifies the week when the transaction occurred. The report data will be aggregated by each week. The report will include a column named WeekStartDate that contains the date of the Sunday for each week formatted as yyyy-mm-dd.
Monthly	Date			True	Each row of the report identifies the month when the transaction occurred. The report data will be aggregated by each month. The report will include a column named MonthStartDate that contains the first day of the month formatted as yyyy-mm-dd.
Yearly	Integer			True	Each row of the report identifies the year when the transaction occurred. The report data will be aggregated by each year. The report will include a column named Year that contains the year formatted as yyyy.
HourOfDay	Integer			True	Each row of the report identifies the hour of the day when the transaction occurred. The report data will be aggregated by each of the 24 hours across all days
DayOfWeek	Integer			True	Each row of the report identifies the day of the week when the transaction occurred. The report data will be aggregated by each of the seven days in a week.
AccountName	String				The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountId	Long				The Bing Ads assigned identifier of an account.
CampaignName	String				The campaign name.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
CampaignStatus	String				The campaign status.
DynamicAdTarget	String	True			The dynamic ad target or webpage condition that Bing matched to your website. For example the condition could be returned in the report as URL contains xyz.
DynamicAdTargetStatus	String				The current status of the dynamic ad target.
DynamicAdTargetId	Long				The Bing Ads assigned identifier of the dynamic ad target, also known in Campaign Management and Bulk API as the ad group criterion ID.
AdGroupId	Long				The Bing Ads assigned identifier of an account.
AdDistribution	String				The ad distribution attribute of an ad group.
AccountStatus	String				The account status.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
Network	String				The current network setting of an ad group.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
AdGroupName	String				The ad group name.
AdGroupStatus	String				The ad group status.
Language	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
BidStrategyType	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
TrackingTemplate	String				The current tracking template of the ad.
CustomParameters	String				The current custom parameters of the ad.
WebsiteCoverage	String				A score from 0.0 to 1.0 that indicates the percentage of pages in the requested language that belong to a particular domain out of all the pages that Bing has indexed for the same language your website's domain.
Goal	String				The goal name.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
Impressions	Integer		True		The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
Clicks	Integer		True		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).
Ctr	Double		True		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 (%).
AverageCpc	Double		True		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.
Spend	Double		True		The cost per click (CPC) summed for each click.
AveragePosition	Double		True		The average position of the ad on a webpage.
Conversions	Integer		True		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
ConversionRate	Double		True		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 (%).
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
RevenuePerConversion	Double		True		The revenue per conversion. The formula for calculating the revenue per conversion is (Revenue / Conversions).
Assists	Integer		True		The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad.
Revenue	Double		True		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.
ReturnOnAdSpend	Double		True		The return on ad spend (ROAS). The formula for calculating the ROAS is (Revenue / Spend).
CostPerAssist	Double		True		The cost per assist. The formula for calculating the cost per assist is (Spend / Assists).
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
DatePreset	String	The time period to use for the report. You can specify a custom date range or select a predefined date range, for example, Today or ThisWeek. The allowed values are Today, Yesterday, LastSevenDays, ThisWeek, LastWeek, LastFourWeeks, ThisMonth, LastMonth, LastThreeMonths, LastSixMonths, ThisYear, LastYear.
EndDate	String	The end date of the custom date range. The end date cannot be later than today's date.
StartDate	String	The start date of the custom date range. The start date must be earlier than or the same as the end date.