AuthorizedAdAccounts
Ad Accounts authorized to run ads for your business on a specified app. This view requires that you have at least one business configured for your user id.
Table Specific Information
AuthorizedAdAccounts in Facebook represent the ad accounts that have been authorized for advertising on the specified application for your Facebook business. You must have a business set up in Facebook for this view to work correctly.
Select
When querying AuthorizedAdAccounts, a Target must be specified and a business may optionally be specified. For instance:
SELECT * FROM AdAccounts WHERE Target = 'ApplicationId' AND Business = 'BusinessId'
If no business is specified, results for all of your available businesses will come back.
Columns
| Name | Type | Description |
| ID [KEY] | String | The Id of the Ad Account. |
| Target | String | The app id to request authorized ad accounts from. |
| AccountId | String | The Id of the Ad Account when viewed directly in Facebook. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source. For more information, see the WHERE clause section.
| Name | Type | Description |
| Business | String | The id of the business to retrieve authorized ad accounts for. |