AccountMediaProductType
Analyzes content performance by media type, including standard posts and IGTV videos, over a chosen time period. Metrics are categorized by media_product_type and offer insights into which formats enhance user engagement. The permissions required are instagram_basic and instagram_manage_insights permissions.
Select
The driver 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 associated with the Instagram business account used to retrieve media insights. This ID is essential for querying metrics across various media formats tied to the business profile. |
| Metric | String | Specifies the type of performance metric to retrieve for the business account's media content. Acceptable values include reach, engagement, and others. The default metric is reach.
The allowed values are reach, total_interactions, likes, comments, saves, shares, views. |
| POST | Int | Represents the total number of standard feed posts (images or videos) published by the business account within the specified time range. |
| IGTV | Int | Represents the total number of IGTV videos published by the business account during the selected reporting period. IGTV content is long-form video hosted on the Instagram platform. |
| StartDate | Datetime | The starting date of when the metric is calculated for a row. |
| EndDate | Datetime | The ending date of when the metric is calculated for a row. |
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 |
| FromDateTime | Datetime | Defines the start of the reporting window for which insights are retrieved. Only data collected on or after this timestamp will be included in the result set. |
| ToDateTime | Datetime | Defines the end of the reporting window for which insights are retrieved. Only data collected up to and including this timestamp will be considered in the output. |