Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for 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. |