AccountMediaProductType
It returns the number of POSTs and IGTVs during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is media_product_type. Requires the instagram_basic and instagram_manage_insights scopes.
Select
The connector will use the Instagram APIs to process filters that refer to a date range or InstagramBusinessAccountId and will process other filters client-side within itself.
- Metric supports the '=,IN' operator.
The default query returns results for the 'reach' metric.
SELECT * FROM AccountMediaProductType SELECT * FROM AccountMediaProductType WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'
To retrieve the result for other available metric, then explicitly specify the Metric in where clause. For example:
SELECT * FROM AccountMediaProductType WHERE Metric = 'total_interactions'
SELECT * FROM AccountMediaProductType WHERE Metric = 'likes'
SELECT * FROM AccountMediaProductType WHERE Metric = 'comments'
SELECT * FROM AccountMediaProductType WHERE Metric = 'saves'
SELECT * FROM AccountMediaProductType WHERE Metric = 'shares'
SELECT * FROM AccountMediaProductType WHERE Metric IN ('total_interactions', 'likes', 'comments', 'saves', 'shares')
Columns
| Name | Type | Description |
| InstagramBusinessAccountId | String | The unique identifier for the Instagram business account Id. |
| Metric | String | Metric Type. Default value is reach.
使用できる値は次のとおりです。reach, total_interactions, likes, comments, saves, shares |
| POST | Int | Number of POSTs. |
| IGTV | Int | Number of IGTVs. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FromDateTime | Datetime | The earliest time for insight data to have been collected. |
| ToDateTime | Datetime | The latest time for insight data to have been collected. |