AudienceInsights
Get Audience Insights for an ad account.
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 | = |
| Type | = |
For example:
SELECT * FROM AudienceInsights
SELECT * FROM AudienceInsights WHERE AdAccountId = '54736262148'
SELECT * FROM AudienceInsights WHERE Type = 'PINTEREST_TOTAL_AUDIENCE'
Columns
| Name | Type | References | Description |
| Type | String | Type of audience insights. | |
| Date | Datetime | Generation date. | |
| Size | Integer | Population count. | |
| SizeIsUpperBound | Boolean | Indicates whether the audience size has been rounded up to the next highest upper boundary. | |
| Categories | String | Categories. | |
| Demographics | String | Audience demographics. |
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. |