AudienceInsights
Get Audience Insights for an ad account.
Table Specific Information
Select
The add-in uses the Pinterest API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the add-in.
- AdAccountID supports the '=' operator.
- Type supports the '=' operator.
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 a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AdAccountID | String | Unique identifier of an ad account. |