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 本製品 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. |