接続の確立

Sync App アプリケーションの接続ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Microsoft Ads への接続を作成します。Microsoft Ads アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからMicrosoft Ads コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Microsoft Ads への接続

Microsoft Ads API に接続するには、Microsoft Ads アカウントを登録し、開発者トークンを取得し、OAuth を使って認証する必要があります。

Bing Ads アカウントの登録

Microsoft Ads アカウントにサインアップし、CustomerId およびAccountId（オプション）を取得するには、次の手順を実行してください。

次のURL からMicrosoft Ads アカウントにサインアップするか、 Bing Ads Web application あるいは、Sandbox Site からサンドボックスアカウントにサインアップします。
［Settings］->［Accounts and Billing］を選択し、1つのアカウントを選択します。AccountId とCustomerId (cid) がアカウントページおよびページのURL に表示されます。

開発者トークンの取得

Microsoft Ads API を使用するには、CustomerId に加えてDeveloperToken が必要です。開発者トークンを作成するには、Microsoft Ads のスーパー管理者ロールが必要ですが、トークンを使用するための特別な権利は必要ありません。

Microsoft Ads スーパー管理者ロールを持つMicrosoft アカウントユーザーとしてBing Ads Developer Portalにログインします。
［Request Token］をクリックして開発者トークンを書き留めます。これをDeveloperToken 接続プロパティに設定します。

Microsoft Ads への認証

OAuth

AuthScheme は、すべてのユーザーアカウントフローでOAuth に設定する必要があります。

Web アプリケーション

Web アプリケーション経由で接続する場合は、Microsoft Ads にカスタムOAuth アプリケーションを登録する必要があります。詳しくは、カスタムOAuth アプリの作成を参照してください。その後、ドライバーを使用してOAuth トークンの値を取得および管理します。

初めに、次の接続プロパティを設定してOAuthAccessToken を取得します。

OAuthClientId：アプリケーション設定のクライアントId に設定。
OAuthClientSecret：アプリケーション設定のクライアントシークレットに設定。

続いてストアドプロシージャを呼び出し、OAuth 交換を完了します。

GetOAuthAuthorizationURL ストアドプロシージャを呼び出します。CallbackURL インプットをアプリケーション設定で指定したコールバックURL に設定します。必要に応じて、Scope パラメータを設定してカスタム権限をリクエストします。ストアドプロシージャがOAuth エンドポイントのURL を返します。
URL を開き、ログインして、アプリケーションを認可します。コールバックURL にリダイレクトされます。
GetOAuthAccessToken ストアドプロシージャを呼び出します。AuthMode インプットをWEB に設定します。Verifier インプットを、コールバックURL のクエリ文字列の"code" パラメータに設定します。必要に応じて、Scope パラメータを設定してカスタム権限をリクエストします。

アクセストークンとリフレッシュトークンを取得した後、データに接続し、OAuth アクセストークンを自動または手動でリフレッシュすることが可能です。

OAuth アクセストークンの自動リフレッシュ

ドライバーがOAuth アクセストークンを自動的にリフレッシュするようにするには、最初のデータ接続で次のように設定します。

InitiateOAuth：REFRESH に設定。
OAuthClientId：アプリケーション設定のクライアントId に設定。
OAuthClientSecret：アプリケーション設定のクライアントシークレットに設定。
OAuthAccessToken：GetOAuthAccessToken によって返されたアクセストークンに設定。
OAuthRefreshToken：GetOAuthAccessToken によって返されたリフレッシュトークンに設定。
OAuthSettingsLocation：Sync App がOAuth トークン値を保存する場所のパスを設定。これは接続間で維持されます。

次回のデータ接続では、OAuthAccessToken およびOAuthRefreshToken の値は、OAuthSettingsLocation から取得されます。

OAuth アクセストークンの手動リフレッシュ

データ接続時に手動でOAuth アクセストークンをリフレッシュするために必要な値は、OAuth リフレッシュトークンのみです。

GetOAuthAccessToken によって返されたExpiresIn パラメータ値が経過した後に、RefreshOAuthAccessToken ストアドプロシージャを使用し、手動でOAuthAccessToken をリフレッシュします。次の接続プロパティを設定します。

OAuthClientId：アプリケーション設定のクライアントId に設定。
OAuthClientSecret：アプリケーション設定のクライアントシークレットに設定。

次に、RefreshOAuthAccessToken を呼び出し、OAuthRefreshToken にGetOAuthAccessToken によって返されたOAuth リフレッシュトークンを指定します。新しいトークンが取得できたら、OAuthAccessToken プロパティにRefreshOAuthAccessToken によって返された値を設定し、新しい接続をオープンします。

最後に、OAuth リフレッシュトークンを保存し、OAuth アクセストークンの有効期限が切れた後に手動でリフレッシュできるようにします。

高度な機能

このセクションでは、Microsoft Ads Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App を使用すると、事前設定されたクエリによって内容が決定されるユーザー定義ビューと呼ばれる仮想テーブルを定義できます。このビューは、ドライバーに発行されるクエリを直接制御できない場合に有効です。カスタムビューの作成と設定の概要については、ユーザー定義ビューを参照してください。

SSL の設定

SSL の設定を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。詳しくは、接続文字列オプションにあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシに合致するようSync App を設定します。トンネル接続を設定することもできます。

クエリ処理

Sync App は、Microsoft Ads にできるだけ多くのSELECT ステートメント処理をオフロードし、残りのクエリをクライアント側のインメモリで処理します。

詳しくはクエリ処理を参照してください。

ログ

CData ログを調整するために使用可能な設定の概要については、ログを参照してください。基本的なロギングでは、次の2つの接続プロパティを設定するだけです。LogModules 接続プロパティを使用してログに記録する情報のサブセットを選択できる、より洗練されたロギングをサポートする多数の機能があります。

SSL の設定

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
接続をトンネルするには、FirewallType をTUNNEL に設定します。
認証するには、FirewallUser とFirewallPassword を設定します。
SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

データモデル

CData Sync App は、Microsoft Ads API のエンティティをデータベースのビューおよびストアドプロシージャにモデル化します。これらは、簡単なテキストベースのコンフィギュレーションファイルであるスキーマファイルにて定義されます。

次のセクションでは、使用可能なAPI オブジェクトへのSQL の実行について説明します。Sync App は、Microsoft Ads にできるだけ多くのSELECT 構文処理をオフロードし、残りのクエリをインメモリで処理します。API の制限事項および要件については、このセクションで説明します。

Sync App がクライアントサイドのインメモリ処理でAPI 制限を回避する方法の詳細については、SupportEnhancedSQL を参照してください。

ビュー

レポートを含む、ビューとしてのSync App Microsoft Ads オブジェクト。

集計および期間に基づいてReports をクエリできます。デフォルトの期間は今年です。期間を変更するには、以下のTime Filter セクションを参照してください。

一部のレポートカラムのみを取得する場合、'Select Requirement' としてマークされたすべてのカラム、および'Metric' としてマークされているカラムのうち少なくとも1つが、有効なレポート要求を発行するために選択されます。一方、すべてのカラムを取得する場合、ドライバーはデフォルトで必要最小限のカラムを要求に含めます。

レポート集計のクエリ

デフォルトでは、レポートデータは指定されたレポート期間全体で集計され、レポートには期間のカラムは含まれません。デフォルトでは、データは先月のみ取得されます。この動作を変更したい場合は、以下の'Time Filter の指定' セクションを参照してください。

さらに、次の集計カラムのいずれかを選択して、レポートデータを集計できます。

Daily：レポートの各行は、トランザクションが発生した月、日、および年を示します。レポートデータは毎日集計されます。レポートには、Daily という名前のカラムが含まれ、このカラムにはyyyy-mm-dd 形式の日付が含まれます。
```
SELECT Daily, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
DayOfWeek：レポートの各行は、トランザクションが発生した曜日を示します。レポートデータは週7日ごとに集計されます。レポートにはDayOfWeek というカラムが含まれます。利用可能な値は1 - 7で、1が日曜日、7が土曜日を表します。

レポートの期間が数週間に及ぶ場合、すべての週の特定の曜日のパフォーマンスデータが、1つの行に集計されます。例えば、レポート期間の3週間にわたってキャンペーンA のインプレッションが毎週月曜日（day 2）に5回発生した場合、レポートにはDayOfWeek が2に設定された行と、その行に合計15のインプレッションが含まれます。
```
SELECT DayOfWeek, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
Hourly：レポートの各行は、トランザクションが発生した時間を示します。レポートデータは1時間ごとに集計されます。レポートにはHourly というカラムが含まれます。利用可能な値は0 - 23です。
```
SELECT Hourly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
HourOfDay：レポートの各行は、トランザクションが発生した時刻を示します。レポートデータはすべての日にわたって24時間ごとに集計されます。レポートにはHourOfDay というカラムが含まれます。利用可能な値は0 - 23です。

レポートの期間が数日に及ぶ場合、すべての日の特定の時間のパフォーマンスデータが、1つの行に集計されます。例えば、レポート期間の3日間にわたってキャンペーンA のインプレッションが7時に5回発生した場合、レポートにはHourOfDay に合計15のインプレッションが含まれます。
```
SELECT HourOfDay, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
Monthly：
レポートの各行は、トランザクションが発生した月を示します。レポートデータは毎月集計されます。レポートには、Monthly という名前のカラムが含まれ、このカラムには月の初日がyyyy-mm-dd 形式で含まれます。
```
SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
Weekly：
レポートの各行は、トランザクションが発生した週を示します。レポートデータは毎週集計されます。レポートには、Weekly という名前のカラムが含まれ、このカラムには各週の日曜日の日付がyyyy-mm-dd 形式で含まれます。
```
SELECT Weekly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```
Yearly：
レポートの各行は、トランザクションが発生した年を示します。レポートデータは1年ごとに集計されます。レポートには、Yearly という名前のカラムが含まれ、このカラムにはyyyy 形式の年が含まれます。
```
SELECT Yearly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ]
```

Time Filter の指定

カスタム日付範囲を指定するか、定義済みの日付範囲を指定できます。

定義済みの日付範囲を検索するには、WHERE 句のDatePreset 疑似カラムを次のいずれかの値に設定します：Today、Yesterday、LastSevenDays、ThisWeek、LastWeek、LastFourWeeks、ThisMonth、LastMonth、LastThreeMonths、LastSixMonths、ThisYear、またはLastYear。DatePreset のデフォルト値は"ThisYear" です。
```
SELECT Monthly, AccountName, AccountStatus, Impressions, Clicks, ConversionRate  FROM [ AccountPerformanceReport ] WHERE DatePreset = 'LastYear'
```

カスタム日付範囲を指定するには、WHERE 句にStartDate およびEndDate 疑似カラムを指定します。

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

ストアドプロシージャ

ストアドプロシージャは、データソースのファンクションライクなインターフェースです。これらを使用して、データソース内の情報を検索、更新、および変更できます。

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Bing Ads Connector for CData Sync ビュー


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.

AccountPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

Accounts

Query the available Accounts in Bing Ads.

Table Specific Information

Select

Searches on this table are processed client-side by the Sync App; 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. 使用できる値は次のとおりです。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.

AdDynamicTextPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AdExtensionByAdReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AdExtensionByKeywordReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AdExtensionDetailReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AdGroupPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AdGroups

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 Sync App will use the Microsoft Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the Sync App.

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.

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.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

Ads

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 Sync App 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 Sync App.

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.

AgeGenderAudienceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

AudiencePerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

Audiences

Query the available Audiences in Bing Ads.

Table Specific Information

Select

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

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

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

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. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。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.

BidOpportunities

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 Sync App will use the Microsoft Ads API to filter the results by OpportunityType while the rest of the filter is executed client side within the Sync App. 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. デフォルト値は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.

BudgetOpportunities

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 Sync App will use the Microsoft Ads API to filter the results by CampaignId while the rest of the filter is executed client side within the Sync App.

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.

Budgets

Query the available Budgets in Bing Ads.

Table Specific Information

Select

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

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

The client-side execution of the query can be turned off by setting SupportEnhancedSQL to false, in which case any search query returns an error.

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.

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.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

Campaigns

Query the available Campaigns in Bing Ads.

Table Specific Information

Select

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

SELECT * FROM [ Campaigns ]

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search query will return an error.

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. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。EnhancedCpc, InheritFromParent, ManualCpc, MaxClicks, MaxConversions, TargetCpa
BudgetType	String				The budget type determines how the budget is spent. 使用できる値は次のとおりです。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.

ConversionPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

DestinationUrlPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

DSAAutoTargetPerformanceReport

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

DSACategoryPerformanceReport

Use this report to find out which DSA categories 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.
AdGroupId	Long				The Bing Ads assigned identifier of an account.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
AdId	Long				The Bing Ads assigned identifier of an ad.
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.
CampaignStatus	String				The campaign status.
AdGroupName	String				The ad group name.
Language	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
Category0	String	True			The top level category that Bing matched to your website. For example if the category is US/CA/SFO, the Category0 value will be US.
Category1	String	True			The mid level category that Bing matched to your website. For example if the category is US/CA/SFO, the Category0 value will be US.
Category2	String	True			The low level category that Bing matched to your website. For example if the category is US/CA/SFO, the Category0 value will be US.
CampaignName	String				The campaign name.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad 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).
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.
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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.
AdGroupId	Long				The Bing Ads assigned identifier of an account.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
AdId	Long				The Bing Ads assigned identifier of an ad.
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.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
CampaignStatus	String				The campaign status.
AdGroupName	String				The ad group name.
Language	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
CampaignName	String				The campaign name.
AdGroupStatus	String				The ad group status.
AdStatus	String				The ad status.
SearchQuery	String	True			The search term used by your potential audience.
Headline	String				The Dynamic Search Ad headline that was dynamically generated by Bing Ads.
CategoryList	String				The list of categories that Bing matched to your website. Up to three category levels can be returned per category list item.
LandingPageTitle	String				The title of your webpage where the search user landed.
FeedUrl	String				The feed URL will appear either as
FinalUrl	String				The URL address of the page on your website that people reach when they click your ad from a desktop or laptop.
DynamicAdTarget	String				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.
DynamicAdTargetId	String				The Bing Ads assigned identifier of the dynamic ad target, also known in Campaign Management and Bulk API as the ad group criterion ID.
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.
RevenuePerAssist	Double		True		The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists).

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
AdGroupName	String				The ad group name.
CampaignName	String				The campaign name.
Language	String				The ad group language.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
Country	String				The country where the user was physically located when they clicked the ad.
State	String				The state where the user was physically located when they clicked the ad.
MetroArea	String				The metro area where the user was physically located when they clicked the ad.
City	String				The city where the user was physically located when they clicked the ad.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
ProximityTargetLocation	String				The radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad.
Radius	String				The radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad.
BidMatchType	String				The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies.
DeliveredMatchType	String				The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies.
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.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
LocationType	String				The location type used to deliver ads. For example to distinguish between people in versus searching for or viewing pages about the corresponding location of interest.
MostSpecificLocation	String				The most specific location used to deliver ads. For example if the city and country are both identified, this column will include the same value as the City column. If postal code information is available, then it will be included in the report instead of city or country.
County	String				The county where the user was physically located when they clicked the ad.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
LocationId	Long				The Bing Ads identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes.
PostalCode	String				The postal code where the user was physically located when they clicked the 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.
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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.
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.
Keyword	String				The keyword text.
KeywordStatus	String				The keyword status.
KeywordId	String				The Bing Ads assigned identifier of a keyword.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
Goal	String	True			The name of your event tracking or campaign analytics goal.
GoalId	String				The Bing Ads assigned identifier of a goal.
GoalType	String				The goal type. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
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.
AllConversions	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
AllRevenue	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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

KeywordDemographics

Query the available Keyword Demographics in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, Language, and PublisherCountry columns in the WHERE clause to query this table. You can search on multiple keywords by setting the Keywords column value to a comma-separated list in the WHERE clause.

The Sync App will use the Microsoft Ads API to filter the results by Keywords, Language, and PublisherCountry while the rest of the filter is executed client side within the Sync App. For example, the following query is processed server side.

SELECT * FROM [ KeywordDemographics ] WHERE Keywords = 'Gmail Excel,PowerShell Excel' AND Language = 'English' AND PublisherCountry = 'US'

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 Keywords, Language, and PublisherCountry will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Keywords	String				List of Keywords. Use to filter the table.
Language	String				The language in which the keywords are written.
PublisherCountry	String				The country code of the country/region to use as the source of the demographics data. The country/region that you specify must support the language specified in the Language element.
Device	String				The device of the user who entered the search query. Default value is 'Computers'. 使用できる値は次のとおりです。Computers, NonSmartphones, Smartphones, Tablets
Keyword	String				The keyword.
Age18to24	Double				The percentage of time that users 18 through 24 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age25to34	Double				The percentage of time that users 25 through 34 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age35to49	Double				The percentage of time that users 35 through 49 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age50to64	Double				The percentage of time that users 50 through 64 years of age searched for the keyword. The value is specified in the range 0.0 through 1.0.
Age65Plus	Double				The percentage of time that users 65 years of age or older searched for the keyword. The value is specified in the range 0.0 through 1.0.
AgeUnknown	Double				Not used.
Female	Double				The percentage of time that female users searched for the keyword. The value is specified in the range 0.0 through 1.0.
Male	Double				The percentage of time that male users searched for the keyword. The value is specified in the range 0.0 through 1.0.
GenderUnknown	Double				Not Used.
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordEstimatedBid

Query the available Keyword Estimated Bid in Bing Ads.

Table Specific Information

Select

You must set the KeywordText and MatchType columns in the WHERE clause to query this table. Set the MatchType column to one of the following values in the WHERE clause: Exact, Phrase, Broad, Content, or Aggregate.

The Sync App will use the Microsoft Ads API to filter the results by KeywordText and MatchType while the rest of the filter is executed client side within the Sync App.

For example, the following query is processed server side.

SELECT * FROM [ KeywordEstimatedBid ] WHERE KeywordText = 'SAP R/3 Developers' AND MatchType = 'Exact'

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 KeywordText and MatchType will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
KeywordText	String				The keyword text.
MatchType	String				The keyword match type used to determine the estimates. Can be one of Exact, Phrase, Broad, Aggregate.
CurrencyCode	String				The monetary unit of the cost values, such as AverageCPC.
CampaignId	Long				The system generated identifier of the campaign.
AdGroupId	Long				The system generated identifier of the ad group.
MinClicksPerWeek	Double				The estimated minimum number of clicks per week.
MaxClicksPerWeek	Double				The estimated maximum number of clicks per week.
AverageCPC	Double				The estimated average CPC.
MinImpressionsPerWeek	Long				The estimated minimum number of impressions per week.
MaxImpressionsPerWeek	Long				The estimated maximum number of impressions per week.
ClickThroughRate	Double				The estimated CTR.
MinTotalCostPerWeek	Double				The estimated minimum cost per week.
MaxTotalCostPerWeek	Double				The estimated maximum cost per week.
EstimatedMinBid	Double				The position in the search results given the specified bid.
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordEstimatedPosition

Query the available EstimatedPosition in Bing Ads.

Table Specific Information

Select

You must specify the Keywords and MatchType columns in the WHERE clause to query this table. Set MatchType to one of the following values: Exact, Phrase, Broad, Content and Aggregate. You can search on multiple keywords by setting the Keywords column value to a comma-separated list in the WHERE clause.

The Sync App will use the Microsoft Ads API to filter the results by KeywordText and MatchType while the rest of the filter is executed client side within the Sync App. For example, the following query is processed server side.

SELECT * FROM [KeywordEstimatedPosition] WHERE Keywords = 'SAP development,PowerShell Excel' AND MatchType = 'Exact'
SELECT * FROM KeywordEstimatedPosition WHERE Keywords='ssh transfer' AND MatchType='Exact' AND AccountId='135093022' AND MaxBid=50

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 Keywords and MatchType will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Keywords	String				List of Keywords. Use to filter the table.
MaxBid	Long				The maximum bid value to use to determine the estimated position in the search results.
MatchType	String				The keyword match type used to determine the estimates. Can be one of Exact, Phrase, Broad, Aggregate.
CurrencyCode	String				The monetary unit of the cost values, such as AverageCPC.
CampaignId	Long				The system generated identifier of the campaign.
AdGroupId	Long				The system generated identifier of the ad group.
Keyword	String				The keyword.
MinClicksPerWeek	Double				The estimated minimum number of clicks per week.
MaxClicksPerWeek	Double				The estimated maximum number of clicks per week.
AverageCPC	Double				The estimated average CPC.
MinImpressionsPerWeek	Long				The estimated minimum number of impressions per week.
MaxImpressionsPerWeek	Long				The estimated maximum number of impressions per week.
ClickThroughRate	Double				The estimated CTR.
MinTotalCostPerWeek	Double				The estimated minimum cost per week.
MaxTotalCostPerWeek	Double				The estimated maximum cost per week.
EstimatedAdPosition	Double				The position in the search results given the specified bid.
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordHistoricalSearch

Query the available Keyword Historical Search in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, Language, StartDate, and EndDate columns to query this table. You can search on multiple keywords by setting the Keywords column value to a comma-separated list in the WHERE clause.

The Sync App will use the Microsoft Ads API to filter the results by Keywords, Language, StartDate, and EndDate while the rest of the filter is executed client side within the Sync App. For example,

SELECT * FROM [ KeywordHistoricalSearch ] WHERE Keywords = 'SAP development' AND Language = 'English' AND StartDate = '2014-01-01' AND EndDate = '2017-01-01'

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 Keywords, Language, StartDate, and EndDate will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Keywords	String				List of Keywords. Use to filter the table.
Language	String				The language in which the keywords are written.
StartDate	Date				The start date of the date range that identifies the data that you want to use to determine the historical search count.
EndDate	Date				The end date of the date range that identifies the data that you want to use to determine the historical search count.
Keyword	String				The keyword.
SearchCount	Long				The number of times that the keyword was used in a search query on the specified device type during the time period. The count aggregates data from all specified countries.
SearchDate	Date				The time period in which the count was captured.
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordLocations

Query the available Keyword Locations in Bing Ads.

Table Specific Information

Select

You must specify the Keywords and Language columns in the WHERE clause to query this table. You can search on multiple keywords by setting the Keywords column value to a comma-separated list.

The Sync App will use the Microsoft Ads API to filter the results by Keywords and Language while the rest of the filter is executed client side within the Sync App. For example, the following query is processed server side.

SELECT * FROM [ KeywordLocations ] WHERE Keywords = 'SAP development,PowerShell Excel' AND Language = 'English'

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 Keywords and Language will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Keywords	String				List of Keywords. Use to filter the table.
Language	String				The language in which the keywords are written.
Device	String				The device of the user who entered the search query.
Keyword	String				The keyword.
Location	String				The country, state, metropolitan area, or city where users entered the search query.
Percentage	Double				The percentage of time that users searched for the keyword from the location. The value is specified in the range 0.0 through 100.0
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordPerformance

Query the available Keyword Performance in Bing Ads.

Table Specific Information

Select

You must specify the Keywords, MatchType, Language, and PublisherCountry columns in the WHERE clause to query this table. Set the MatchType column to one of the following in the WHERE clause: Exact, Phrase, Broad, Content, or Aggregate.

The Sync App will use the Microsoft Ads API to filter the results by Keywords, MatchType, Language, and PublisherCountry while the rest of the filter is executed client side within the Sync App. For example, the preceding query is processed on the server.

SELECT * FROM [ KeywordPerformance ] WHERE Keywords = 'SAP development,PowerShell Excel' AND Language = 'English' AND PublisherCountry = 'US' AND MatchType = 'Exact'

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 Keywords, Language, PublisherCountry, and MatchType will cause an error.

Filtering by accountid

You can filter by accountid using the IN condition. For example,

SELECT * FROM KeywordEstimatedBid 
WHERE KeywordText IN ('Text', 'Gmail') 
AND MatchType = 'Exact' 
AND AccountId IN ('141163452', '2562405', '141163453', '141163454', '141163455', '141163456', '141163457')

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Keywords	String				List of Keywords. Use to filter the table.
AdPosition	String				The position in the search results in which the ad appeared.
MatchType	String				The match type that you specified in the request.
Language	String				The language in which the keywords are written.
PublisherCountry	String				The country code of the country/region to use as the source of the demographics data. The country/region that you specify must support the language specified in the Language element.
Device	String				The device of the user who entered the search query. Default value is 'Computers'. 使用できる値は次のとおりです。Computers, NonSmartphones, Smartphones, Tablets
Keyword	String				The keyword.
Clicks	Integer				The number of clicks that the keyword and match type generated during the specified time interval.
Impressions	Long				The number of impressions that the keyword and match type generated during the specified time interval.
AverageCPC	Double				The average cost per click (CPC). The average CPC is calculated by dividing the cost of all clicks by the number of clicks.
ClickThroughRate	Double				The click-through rate (CTR) as a percentage. The CTR is calculated by dividing the number of clicks by the number of impressions and multiplying the result by 100.
TotalCost	Double				The cost of using the specified keyword and match type during the specified time interval.
AverageBid	Double				The average bid of the keyword.
AccountId	Long				The Bing Ads assigned identifier of an account.

KeywordPerformanceReport

Use this report to find out which keywords 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.
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..
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
Keyword	String				The keyword text.
KeywordId	Long				The Bing Ads assigned identifier of a keyword.
KeywordLabels	String				The labels applied to the keyword.
AdId	Long				Ad Id
AdType	String				The ad type.
DestinationUrl	String				The destination URL attribute of the ad, keyword, or ad group criterion.
CurrentMaxCpc	String				The maximum cost per click bid that was in effect at the time the report was generated. It is not a moving historical bid throughout the report time period.
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.
FirstPageBid	Decimal				Based on your campaign performance and marketplace dynamics, this estimate is the bid amount that Bing Ads calculates for your ad to be placed on the first page in the search results.
Mainline1Bid	Decimal				Based on your campaign performance and marketplace dynamics, this estimate is the bid amount that Bing Ads calculates will place your ad at the top of search results.
MainlineBid	Decimal				Based on your campaign performance and marketplace dynamics, this estimate is the bid amount that Bing Ads calculates for your ad to be placed on the first page in the search results.
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.
BidStrategyType	String				The bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpa. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g., one of the supported values listed above.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group 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.
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.
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).
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).
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. If available, the quality score can range from a low of 1 to a high of 10.
ExpectedCtr	Integer		True		How well your keyword competes against other keywords targeting the same traffic. A score of 3 is Above Average; a score of 2 is Average; and a score of 1 is considered Below Average.
AdRelevance	Integer		True		How closely related your ads is to the search query or other input. It tells you how relevant your ad and landing page are to potential customers. A score of 3 is Above Average; a score of 2 is Average; and a score of 1 is considered Below Average.
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. A score of 3 is Above Average; a score of 2 is Average; and a score of 1 is considered Below Average.
QualityImpact	Double		True		The numeric score that indicates the possible increase in the number of impressions that the keyword could receive if the corresponding QualityScore column would rise above underperforming: 0 (not available), 1 (low impact), 2 (medium impact), or 3 (high impact).

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

Keywords

Query the available Keywords in Bing Ads.

Table Specific Information

Select

You must specify the AdGroupId column in the WHERE clause to query this table. The Sync App uses the Microsoft Ads API to filter the results by AdGroupId while the rest of the filter is executed client side within the Sync App.

For example, the following query is processed on the server.

SELECT * FROM [Keywords] WHERE AdGroupId = '5179946000'
SELECT * FROM Keywords WHERE AdGroupId='1311717627185807' AND AccountId='135096904'

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 AdGroupId in the WHERE clause causes an error.

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
Id [KEY]	Long				The system-generated identifier of the keyword.
AdGroupId	Long				The system generated identifier of the ad group.
Text	String				The keyword text. The text can contain a maximum of 100 characters. You should specify the keyword in the locale of the Language value that you specified for the ad group to which the keyword belongs.
Status	String				The keyword's status. By default, the status is set to Active.
BidAmount	Double				The bid to use when the user's search term and the keyword match.
DestinationUrl	String				The URL of the webpage to take the user to when they click the ad. The keyword's destination URL is used if specified; otherwise, the ad's destination URL is used.
BiddingSchemeType	String				The bid strategy type for how you want to manage your bids.
MatchType	String				The type of match to compare the keyword and the user's search term.
TrackingUrlTemplate	String				The tracking template to use as a default for all FinalUrls and FinalMobileUrls.
UrlCustomParameters	String				Your custom collection of key and value parameters for URL tracking.
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 landing page URL. The keyword's final URL is used if specified; otherwise, the ad's final URL is used.
FinalMobileUrls	String				The mobile landing page URL. The keyword's final mobile URL is used if specified; otherwise, the ad's final mobile URL is used.
FinalAppUrls	String				Reserved for future use.
EditorialStatus	String				The editorial review status of the keyword, which indicates whether the keyword is pending review, has been approved, or has been disapproved.
Param1	String				The string to use as the substitution value in an ad if the ad's title, text, display URL, or destination URL contains the {Param1} dynamic substitution string
Param2	String				The string to use as the substitution value in an ad if the ad's title, text, display URL, or destination URL contains the {Param2} dynamic substitution string
Param3	String				The string to use as the substitution value in an ad if the ad's title, text, display URL, or destination URL contains the {Param3} dynamic substitution string
AccountId	Long				The Bing Ads assigned identifier of an account.

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.

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
AccountName	String	True			The account name.
AccountNumber	String				The Bing Ads assigned number of an account.
AccountStatus	String				The account status.
AccountId	Long				The Bing Ads assigned identifier of an account.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdGroupName	String				The ad group name.
AdGroupStatus	String				The ad group status.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
CampaignName	String				The campaign name.
CampaignStatus	String				The campaign status.
Keyword	String	True			The keyword text.
KeywordId	Long				The Bing Ads assigned identifier of a keyword.
KeywordStatus	String				The keyword status.
NegativeKeyword	String	True			The negative keyword text.
ConflictLevel	String				The entity level where the keyword and negative keyword conflict occurs. The possible values are AdGroup and Campaign.
ConflictType	String				The type of negative keyword conflict encountered.The possible values are Possibly intentional conflict and True conflict.
BidMatchType	String				The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies.
NegativeKeywordListId	Long				The Bing Ads assigned identifier of a negative keyword list.
NegativeKeywordList	String				The name of the negative keyword list.
NegativeKeywordId	Long				The Bing Ads assigned identifier of a negative keyword.
NegativeKeywordMatchType	String				The type of match to compare the negative keyword and the user's search term. The possible values for a negative keyword are Exact and Phrase.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

ProductDimensionPerformanceReport

Use this report to find out which product dimensions 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.
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.
AdGroupName	String				The ad group name.
AdGroupId	String				The Bing Ads assigned identifier of an ad group.
AdId	String				The Bing Ads assigned identifier of an ad.
CampaignName	String				The campaign name.
CurrencyCode	String				The account currency type.
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.
MerchantProductId	String	True			The report will include a column that contains the unique identifier provided by a merchant for each product offer.
Title	String				The product item name. For example the title of a book, DVD, or game.
Condition	String				The condition of a product item.
Brand	String				The product item's manufacturer, brand, or publisher.
CustomLabel0	String				The value of the Custom_label_0 field in your Bing Merchant Center catalog.
CustomLabel1	String				The value of the Custom_label_1 field in your Bing Merchant Center catalog.
CustomLabel2	String				The value of the Custom_label_2 field in your Bing Merchant Center catalog.
CustomLabel3	String				The value of the Custom_label_3 field in your Bing Merchant Center catalog.
CustomLabel4	String				The value of the Custom_label_4 field in your Bing Merchant Center catalog.
ProductType1	String				The first level value of the Product_type field in your Bing Merchant Center catalog.
ProductType2	String				The second level value of the Product_type field in your Bing Merchant Center catalog.
ProductType3	String				The third level value of the Product_type field in your Bing Merchant Center catalog.
ProductType4	String				The fourth level value of the Product_type field in your Bing Merchant Center catalog.
ProductType5	String				The fifth level value of the Product_type field in your Bing Merchant Center catalog.
ProductCategory1	String				The first level value of the Product_category field in your Bing Merchant Center catalog.
ProductCategory2	String				The second level value of the Product_category field in your Bing Merchant Center catalog.
ProductCategory3	String				The third level value of the Product_category field in your Bing Merchant Center catalog.
ProductCategory4	String				The fourth level value of the Product_category field in your Bing Merchant Center catalog.
ProductCategory5	String				The fifth level value of the Product_category field in your Bing Merchant Center catalog.
AccountStatus	String				The account status.
AssistedClicks	String				Clicks on your ads that have received co-bids from your manufacturer partners. Clicks are what you pay for.
AssistedImpressions	String				The number of times an ad that is being co-bid by your manufacturer partners has been displayed on search results pages or other sites on the Bing Network.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
CampaignId	String				The Bing Ads assigned identifier of a campaign.
Network	String				The current network setting of an ad group.
Price	String				The different price for products in your catalog.
SellerName	String				The report will include a column that contains the merchant or store name that offers the product.
OfferLanguage	String				The report will include a column that contains the language for the product offer.
CountryOfSale	String				The report will include a column that contains the country of sale for the product catalog.
AdStatus	String				The ad status.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
AdDistribution	String				The ad distribution attribute of an ad group.
ClickTypeId	Long				The click type ID.
StoreId	Long				The unique identifier for the Bing Merchant Center store.
BidStrategyType	String				The bid strategy type. Possible values include EnhancedCpc and ManualCpc. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g. one of the supported values listed above.
ClickType	String				Click type refers to each component of an ad that a customer can click.
LocalStoreCode	String				An alphanumeric identifier defined by the merchant to uniquely identify each local store.
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.
Conversions	Integer		True		The cost per click (CPC) summed for each click.
ConversionRate	Double		True		The cost per click (CPC) summed for each click.
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).
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.
ImpressionLostToRankPercent	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.
BenchmarkBid	Double		True		Shows you how much other advertisers are bidding on average on similar products as your current target.
BenchmarkCtr	Double		True		Shows you how other product ads for similar products are performing on average based on how often people who see the ad end up clicking on it.
TotalClicksOnAdElements	Integer		True		The number of clicks when this ad element was present in the ad copy, whether this or another ad element was clicked on.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
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.
CampaignStatus	String				The campaign status.
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdGroupStatus	String				The ad group status.
ConflictLevel	String				The entity level where the keyword and negative keyword conflict occurs. The possible values are AdGroup and Campaign.
NegativeKeywordListId	Long				The Bing Ads assigned identifier of a negative keyword list.
NegativeKeyword	String	True			The negative keyword text.
NegativeKeywordId	Long				The Bing Ads assigned identifier of a negative keyword.
NegativeKeywordMatchType	String				The type of match to compare the negative keyword and the user's search term. The possible values for a negative keyword are Exact and Phrase.
Title	String				The type of match to compare the negative keyword and the user's search term. The possible values for a negative keyword are Exact and Phrase.
MerchantProductId	String	True			The report will include a column that contains the unique identifier provided by a merchant for each product offer.
AdGroupCriterionId	Long				The Bing Ads assigned identifier of an ad group criterion, or product group in the context of a Bing Shopping campaign.
ProductGroup	String	True			The forward slash ('/') delimited list of product conditions, reported as Operand=

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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 report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
AdId	Long				The Bing Ads assigned identifier of an ad.
AssistedClicks	String				Clicks on your ads that have received co-bids from your manufacturer partners. Clicks are what you pay for.
AssistedImpressions	String				The number of times an ad that is being co-bid by your manufacturer partners has been displayed on search results pages or other sites on the Bing Network.
CampaignName	String				The campaign name.
CurrencyCode	String				The account currency type.
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.
AccountStatus	String				The account status.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
Network	String				The current network setting of an ad group.
OfferLanguage	String				The report will include a column that contains the language for the product offer.
CountryOfSale	String				The report will include a column that contains the country of sale for the product catalog.
AdStatus	String				The ad status.
PartitionType	String	True			The product partition type.
ProductGroup	String	True			The forward slash ('/') delimited list of product conditions, reported as Operand=
AdGroupCriterionId	Long				The Bing Ads assigned identifier of an ad group criterion, or product group in the context of a Bing Shopping campaign.
CurrentMaxCpc	String				The maximum cost per click bid that was in effect at the time the report was generated. It is not a moving historical bid throughout the report time period.
DestinationUrl	String				The destination URL attribute of the ad, keyword, or ad group criterion.
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.
TrackingTemplate	String				The current tracking template of the criterion.
CustomParameters	String				The current custom parameter set of the criterion.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
AdDistribution	String				The ad distribution attribute of an ad group.
ClickType	String				Click type refers to each component of an ad that a customer can click.
BidStrategyType	String				The bid strategy type. Possible values include EnhancedCpc and ManualCpc. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g. one of the supported values listed above.
LocalStoreCode	String				An alphanumeric identifier defined by the merchant to uniquely identify each local store.
ClickTypeId	Long				The click type ID.
CostPerConversion	Double				The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
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.
Conversions	Integer		True		The cost per click (CPC) summed for each click.
ConversionRate	Double		True		The cost per click (CPC) summed for each click.
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).
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.
ImpressionLostToRankPercent	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.
BenchmarkBid	Double		True		Shows you how much other advertisers are bidding on average on similar products as your current target.
BenchmarkCtr	Double		True		Shows you how other product ads for similar products are performing on average based on how often people who see the ad end up clicking on it.
TotalClicksOnAdElements	Integer		True		The number of clicks when this ad element was present in the ad copy, whether this or another ad element was clicked on.
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.
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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

ProductPartitionUnitPerformanceReport

Use this report to find out which product partition units 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.
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 report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
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.
AdId	Long				The Bing Ads assigned identifier of an ad.
CampaignName	String				The campaign name.
CurrencyCode	String				The account currency type.
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.
AccountStatus	String				The account status.
AssistedClicks	String				Clicks on your ads that have received co-bids from your manufacturer partners. Clicks are what you pay for.
AssistedImpressions	String				The number of times an ad that is being co-bid by your manufacturer partners has been displayed on search results pages or other sites on the Bing Network.
CampaignStatus	String				The campaign status.
AdGroupStatus	String				The ad group status.
CampaignId	Long				The Bing Ads assigned identifier of a campaign.
Network	String				The current network setting of an ad group.
AdStatus	String				The ad status.
ProductGroup	String	True			The forward slash ('/') delimited list of product conditions, reported as Operand=
AdGroupCriterionId	Long	True			The Bing Ads assigned identifier of an ad group criterion, or product group in the context of a Bing Shopping campaign.
CurrentMaxCpc	String				The maximum cost per click bid that was in effect at the time the report was generated. It is not a moving historical bid throughout the report time period.
DestinationUrl	String				The destination URL attribute of the ad, keyword, or ad group criterion.
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.
TrackingTemplate	String				The current tracking template of the criterion.
CustomParameters	String				The current custom parameter set of the criterion.
TopVsOther	String				The report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
BidStrategyType	String				The bid strategy type. Possible values include EnhancedCpc and ManualCpc. If the InheritFromParent strategy type is used, the report will include the inherited bid strategy type e.g. one of the supported values listed above.
LocalStoreCode	String				An alphanumeric identifier defined by the merchant to uniquely identify each local store.
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.
Conversions	Integer		True		The cost per click (CPC) summed for each click.
ConversionRate	Double		True		The cost per click (CPC) summed for each click.
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).
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.
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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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 report will include a column that indicates whether the ad impression appeared in a top position or elsewhere.
AccountNumber	String				The Bing Ads assigned number of an account.
AdGroupName	String				The ad group name.
AdGroupId	Long				The Bing Ads assigned identifier of an ad group.
AdId	Long				The Bing Ads assigned identifier of an ad.
AccountId	Long				The Bing Ads assigned identifier of an ad.
AssistedClicks	String				Clicks on your ads that have received co-bids from your manufacturer partners. Clicks are what you pay for.
AssistedImpressions	String				The number of times an ad that is being co-bid by your manufacturer partners has been displayed on search results pages or other sites on the Bing Network.
CampaignName	String	True			The campaign name.
CustomerId	String				The Bing Ads assigned identifier of a customer.
CustomerName	String				The customer name.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
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.
CampaignId	Long	True			The Bing Ads assigned identifier of a campaign.
Network	String				The current network setting of an ad group.
PartitionType	String				The product partition type.
ProductGroup	String				The forward slash ('/') delimited list of product conditions, reported as Operand=
AdGroupCriterionId	Long				The Bing Ads assigned identifier of an ad group criterion, or product group in the context of a Bing Shopping campaign.
DestinationUrl	String				The destination URL attribute of the ad, keyword, or ad group criterion.
ClickType	String				Click type refers to each component of an ad that a customer can click.
ClickTypeId	Long				The click type ID.
MerchantProductId	Long	True			The click type ID.
SearchQuery	String	True			The click type ID.
Title	String				The click type ID.
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.
Conversions	Integer		True		The cost per click (CPC) summed for each click.
ConversionRate	Double		True		The cost per click (CPC) summed for each click.
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.
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).
TotalClicksOnAdElements	Integer		True		The number of clicks when this ad element was present in the ad copy, whether this or another ad element was clicked on.
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.
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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
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.
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.
PublisherUrl	String	True			The URL of the website that displayed the 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).
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

SearchCampaignChangeHistoryReport

Use this report to discover when changes to an account were made, as well as which user made the changes.

Columns


Name	Type	Select requirement	Metric	Aggregate	Description
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.
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.
EntityId	String				The Bing Ads system identifier of the entity that was updated.
EntityName	String				The name of the entity that was updated.
DateTime	String	True			The campaign name.
AdTitle	String				The ad title.
AdDescription	String				The campaign name.
DisplayUrl	String				The campaign name.
Keyword	String				The campaign name.
ItemChanged	String				The campaign name.
AttributeChanged	String				The campaign name.
ChangedBy	String				The username of the user that made the change to settings within the account. If the system made the change, the value will be Administrator.
HowChanged	String				The campaign name.
OldValue	String				The campaign name.
NewValue	String				The campaign name.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。LastSevenDays, LastMonth, LastThreeMonths
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.

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.

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.
AdId	Long				Ad Id
AdType	String				The ad type.
DestinationUrl	String				The destination URL attribute of the ad, keyword, or ad group criterion.
AccountStatus	String				The account status.
AdGroupStatus	String				The ad group status.
AdGroupCriterionId	Long				The Bing Ads assigned identifier of an ad group criterion.
AdStatus	String				The ad status.
CampaignStatus	String				The campaign status.
CampaignType	String				The type of campaign. Possible values include Search, Shopping, and Dynamic search.
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. 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.
SearchQuery	String	True			The search term used by your potential audience.
Keyword	String				The keyword text.
KeywordId	Long				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).
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

ShareOfVoiceReport

Use this report to view impression share (%) of successful bids for each keyword, and identify opportunities to increase impression share.

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.
AdDistribution	String				The ad distribution attribute of an ad group.
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.
Language	String				The ad group language.
Network	String				The current network setting of an ad group.
BidStrategyType	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.
KeywordId	String	True			The Bing Ads assigned identifier of a keyword.
Keyword	String				The keyword text.
KeywordStatus	String				The keyword status.
KeywordLabels	String				The labels applied to the keyword.
AdRelevance	String				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	String				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.
ExpectedCtr	String				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.
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		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).
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	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.
CurrentMaxCpc	Double		True		The maximum cost per click bid that was in effect at the time the report was generated. It is not a moving historical bid throughout the report time period.
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.
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.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

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.

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.
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.
Language	String				The ad group language.
Country	String				The country where the user was physically located when they clicked the ad.
State	String				The state where the user was physically located when they clicked the ad.
MetroArea	String				The metro area where the user was physically located when they clicked the ad.
City	String				The city where the user was physically located when they clicked the ad.
CurrencyCode	String				The account currency type.
AdDistribution	String				The ad distribution attribute of an ad group.
ProximityTargetLocation	String				The radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad.
Radius	String				The radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad.
BidMatchType	String				The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies.
DeliveredMatchType	String				The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies.
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.
DeviceType	String				The device name attribute of a device OS target bid. The type of device which showed ads.
County	String				The county where the user was physically located when they clicked the ad.
DeviceOS	String				The operating system of the device reported in the DeviceType column.
LocationId	Long				The Bing Ads identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes.
PostalCode	String				The postal code where the user was physically located when they clicked the ad.
QueryIntentCountry	String				The name of a country if the user's geographical intent can be determined. The country is set if the user's intent is related to a country, and not necessarily if they are physically located in the county.
QueryIntentState	String				The name of a state if the user's geographical intent can be determined. The state is set if the user's intent is a state or sub geography of the state, and not necessarily if they are physically located in the state.
QueryIntentCity	String				The name of a city if the user's geographical intent can be determined. The city is set if the user's intent is a city, and not necessarily if they are physically located in the city.
QueryIntentDMA	String				The postal code where the user was physically located when they clicked the ad.
QueryIntentCounty	String				The name of a county if the user's geographical intent can be determined. The county is set if the user's intent is related to a county, and not necessarily if they are physically located in the county.
QueryIntentPostalCode	String				The name of a postal code if the user's geographical intent can be determined. The postal code is set if the user's intent is a postal code, and not necessarily if they are physically located in the postal code.
QueryIntentLocationId	String				The location identifier if the user's geographical intent can be determined.
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.
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
CostPerConversion	Double		True		The cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions).
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 (%).
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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


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. 使用できる値は次のとおりです。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.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
DeveloperToken	DeveloperToken of the currently authenticated user.
CustomerId	CustomerId of the currently authenticated user.
UseSandbox	A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.

Connection

プロパティ	説明
AccountId	The id of the account that you want to get data for.

Azure Authentication

プロパティ	説明
AzureTenant	データにアクセスするために使用されるMicrosoft Online テナント。指定しない場合は、デフォルトのテナントが使用されます。
AzureEnvironment	接続を確立するときに使用するAzure 環境。

OAuth

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

Firewall

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

Proxy

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

Miscellaneous

プロパティ	説明
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
ReportScopes	Allows you to narrow or broaden the scope of access when getting data from Reporting service views.
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
DeveloperToken	DeveloperToken of the currently authenticated user.
CustomerId	CustomerId of the currently authenticated user.
UseSandbox	A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.

DeveloperToken

DeveloperToken of the currently authenticated user.

解説

DeveloperToken of the currently authenticated user.

Get a Developer Token

To use the Microsoft Ads APIs, you must have a DeveloperToken in addition to the CustomerId and AccountId. 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. BBD37VB98 may be used for sandbox accounts.

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

CustomerId

CustomerId of the currently authenticated user.

解説

CustomerId of the currently authenticated user.

You can find this value in the Microsoft Ads Web application, under Settings -> Accounts and Billing -> Your Account -> Account.

UseSandbox

A boolean indicating if you are using a Sandbox account. The provider makes requests to the production environment by default.

解説

If you are using a production account, this property can be left blank. If you are using a developer test account, set this to 'TRUE'.

Connection

このセクションでは、本プロバイダーの接続文字列で設定可能なConnection プロパティの全リストを提供します。

プロパティ	説明
AccountId	The id of the account that you want to get data for.

AccountId

The id of the account that you want to get data for.

解説

If it is not specified the driver will use the first AccountId it finds from querying the API.

You can find a value either by querying Accounts table or by going to the Microsoft Ads Web application, under Settings -> Accounts and Billing -> Your Account -> Account.

Azure Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAzure Authentication プロパティの全リストを提供します。

プロパティ	説明
AzureTenant	データにアクセスするために使用されるMicrosoft Online テナント。指定しない場合は、デフォルトのテナントが使用されます。
AzureEnvironment	接続を確立するときに使用するAzure 環境。

AzureTenant

データにアクセスするために使用されるMicrosoft Online テナント。指定しない場合は、デフォルトのテナントが使用されます。

解説

データにアクセスするために使用されるMicrosoft Online テナント。例えば、contoso.onmicrosoft.com です。あるいは、テナントId を指定します。この値は［Azure ポータル］->［Azure Active Directory］->［プロパティ］のディレクトリId です。

通常、Tenant を指定する必要はありません。OAuthGrantType をCODE（デフォルト）に設定している場合は、Microsoft が自動的に決定します。ただし、ユーザーがマルチテナントに所属している場合は失敗する可能性があります。例えば、ドメインA の管理者がドメインB のユーザーをゲストユーザーとして招待した場合。ユーザーは両方のテナントに属していることになります。 Tenant を指定するのはグッドプラクティスですが、一般的には指定しなくてもうまく動作するはずです。

OAuthGrantType をCLIENT に設定する場合は、AzureTenant が必須です。クライアント資格情報を使用する場合、ユーザーコンテキストはありません。資格情報は、アプリ自体のコンテキストから取得されます。Microsoft ではTenant を指定せずにクライアント資格情報を取得することを許容していますが、使用する特定のテナントを選択する可能性ははるかに低くなっています。このため、接続するドメインに適用される資格情報を確実に取得するために、すべてのクライアント資格情報接続に対してAzureTenant を明示的に指定する必要があります。

AzureEnvironment

接続を確立するときに使用するAzure 環境。

解説

ほとんどの場合、環境をグローバルに設定したままにしておくとうまく機能します。ただし、 Azure アカウントが別の環境に追加されている場合は、AzureEnvironment を使用してどの環境かを指定できます。利用可能な値はGLOBAL、CHINA、USGOVT、USGOVTDOD です。

OAuth

このセクションでは、本プロバイダーの接続文字列で設定可能なOAuth プロパティの全リストを提供します。

プロパティ	説明
OAuthClientId	OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。
OAuthClientSecret	OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

OAuthClientId

OAuth 認証サーバーを使用してアプリケーションを登録する場合に割り当てられたクライアントId。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId 値、およびクライアントシークレットOAuthClientSecret が提供されます。

OAuthClientSecret

OAuth 認証サーバーにアプリケーションを登録する場合に割り当てられたクライアントシークレット。

解説

OAuth アプリケーションの登録の一環として、コンシューマキーとも呼ばれるOAuthClientId が提供されます。また、コンシューマーシークレットと呼ばれるクライアントシークレットも提供されます。クライアントシークレットをOAuthClientSecret プロパティに設定します。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

SSLServerCert

TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

FirewallType

プロキシベースのファイアウォールで使われるプロトコル。

解説

このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。


タイプ	デフォルトポート	説明
TUNNEL	80	これが設定されている場合、Sync App はMicrosoft Ads への接続を開き、プロキシを経由して通信が行われます。
SOCKS4	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

プロキシベースのファイアウォールの名前もしくはIP アドレス。

解説

ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。

Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。

FirewallPort

プロキシベースのファイアウォールのTCP ポート。

解説

ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。

FirewallUser

プロキシベースのファイアウォールに認証するために使うユーザー名。

解説

FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。

FirewallPassword

プロキシベースのファイアウォールへの認証に使われるパスワード。

解説

このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

ProxyAutoDetect

これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

解説

これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。

解説

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。

SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。

ProxyPort

ProxyServer プロキシが起動しているTCP ポート。

解説

HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer プロキシへの認証で使われる認証タイプ。

解説

この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。

Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

認証タイプは、次のどれかになります。

BASIC： Sync App はHTTP BASIC 認証を行います。
DIGEST： Sync App はHTTP DIGEST 認証を行います。
NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKereros トークンを取得します。
PROPRIETARY： Sync App はNTLM もしくはKerberos トークンを発行しません。このトークンを、HTTP リクエストのAuthorization ヘッダーに含める必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer プロキシへの認証に使われるユーザー名。

解説

ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。

ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。

user@domain
domain\user

ProxyPassword

ProxyServer プロキシへの認証に使われるパスワード。

解説

このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。

HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。

NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。

ProxySSLType

ProxyServer プロキシへの接続時に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。


AUTO	デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

LogModules

ログファイルに含めるコアモジュール。

解説

指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。

概要はログページを参照してください。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。

解説

Sync App のスキーマファイル（テーブルとビューの場合は.rsd ファイル、ストアドプロシージャの場合は.rsb ファイル）を含むディレクトリへのパス。このフォルダの場所は、実行ファイルの場所からの相対パスにすることができます。Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

指定しない場合、デフォルトの場所は"%APPDATA%\\CData\\BingAds Data Provider\\Schema" となり、%APPDATA% はユーザーのコンフィギュレーションディレクトリに設定されます：

BrowsableSchemas

このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、パフォーマンスが向上します。

Tables

このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。

解説

テーブルを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でテーブルのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Views

使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

解説

ビューを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でビューのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
MaxRows	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
ReportScopes	Allows you to narrow or broaden the scope of access when getting data from Reporting service views.
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

MaxRows

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

解説

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

Other

これらの隠しプロパティは特定のユースケースでのみ使用されます。

解説

以下にリストされているプロパティは、特定のユースケースで使用可能です。通常のドライバーのユースケースおよび機能では、これらのプロパティは必要ありません。

複数のプロパティをセミコロン区切りリストで指定します。

統合およびフォーマット


DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

PseudoColumns

このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。

解説

Entity Framework ではテーブルカラムでない疑似カラムに値を設定できないため、この設定はEntity Framework で特に便利です。この接続設定の値は、"Table1=Column1, Table1=Column2, Table2=Column3" の形式です。"*=*" のように"*" 文字を使用して、すべてのテーブルとすべてのカラムを含めることができます。

ReportScopes

Allows you to narrow or broaden the scope of access when getting data from Reporting service views.

解説

For example, the AccountPerformanceReport, CampaignPerformanceReport, AdGroupPerformanceReport, and other views with Report in the name are part of the Report Service.

You can specify the scope so that you include specific Accounts, Campaigns or AdGroups.

Accounts should be specified in this format: AccountId, AccountId, AccountId;
Campaigns should be specified in this comma-separated format: CampaignId:AccountId, CampaignId:AccountId;
AdGroups should be specified in this format (again, comma-separated): AdGroupId:CampaignId:AccountId, AdGroupId:CampaignId:AccountId, AdGroupId:CampaignId:AccountId;

Here are a few examples:

ReportScopes='Accounts=1494730,969378; Campaigns=234401540:18503857,1730399:96740690; AdGroups=1958:9607:1655,0973:192782:1655;';
ReportScopes='AdGroups=1958:9607:1655, 0973:192782:1655;';
ReportScopes='Campaigns=234401540:18503857, 1730399:96740690;';
ReportScopes='Accounts=1494730,969378;';

By default this connection property will be empty. In that case the driver uses the first AccountId that it finds from querying the API.

You can specify up to 1000 Accounts, 300 Campaigns and 300 AdGroups.

Timeout

タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

解説

Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。

Timeout の有効期限が切れても処理が完了していない場合は、Sync App は例外をスローします。

UserDefinedViews

カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

解説

ユーザー定義ビューは、UserDefinedViews.json というJSON 形式のコンフィギュレーションファイルで定義されています。Sync App は、このファイルで指定されたビューを自動的に検出します。

また、複数のビュー定義を持ち、UserDefinedViews 接続プロパティを使用して制御することも可能です。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。

このユーザー定義ビューのコンフィギュレーションファイルは、次のようにフォーマットされています。

各ルートエレメントはビューの名前を定義します。
各ルートエレメントには、query と呼ばれる子エレメントが含まれており、この子エレメントにはビューのカスタムSQL クエリが含まれています。

次に例を示します。

{
	"MyView": {
		"query": "SELECT * FROM AdGroups WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

UserDefinedViews 接続プロパティを使用して、JSON コンフィギュレーションファイルの場所を指定します。次に例を示します。

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"