AdAccounts
Get a list of the ad_accounts that the User has access to.
View-Specific Information
SELECT
The provider uses the Pinterest API to process WHERE clause conditions built with the following columns and operators. Any remaining filters are processed client-side within the provider.
| Column | Supported Operators |
| IncludeSharedAccounts | = |
| Id | = |
For example:
SELECT * FROM AdAccounts
Columns
| Name | Type | References | Description |
| Id [KEY] | String | Id of the Ad Account. | |
| Name | String | Name of the Ad Account. | |
| OwnerUsername | String | Owner Usernameof the Ad Account. | |
| Country | String | Country of the ad account. | |
| Currency | String | Currency of the ad account. | |
| OwnerId | String | Owner UserId of the ad account. | |
| CreatedTime | Datetime | Created Time of the ad account. | |
| UpdatedTime | Datetime | Updated Time of the ad account. | |
| Permissions | String | Permissions of the ad account. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description | |
| IncludeSharedAccounts | Boolean | Include shared ad accounts |