AudienceInsights
Get Audience Insights for an ad account.
Table Specific Information
Select
The 本製品 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 本製品.
- 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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| AdAccountID | String | Unique identifier of an ad account. |