Query the available Accounts in Bing Ads.

Table Specific Information

Select

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

SELECT * FROM [ Accounts ]

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

Columns

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