AudienceInsightsScopeAndType
Get the scope and type of available audiences, which along with a date, is an audience that has recently had an interaction on pins.
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 |
| AdAccountID | = |
For example:
SELECT * FROM AudienceInsightsScopeAndType
SELECT * FROM AudienceInsightsScopeAndType WHERE AdAccountId = '547362621403'
Columns
| Name | Type | References | Description |
| Date | Datetime | Generation date. | |
| Type | String | Type. | |
| Scope | String | Scope. |
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 | |
| AdAccountID | String | Unique identifier of an ad account. |