AccountTimeSeriesMediaProductType
Provides chronological data on various media types, such as Posts, Stories, IGTV, shared from an Instagram business account. It helps visualize performance trends over time by using media_product_type as a breakdown dimension and supports time-series metric evaluation. The required scopes include instagram_basic and instagram_manage_insights.
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 '=' operator.
The default query returns results for the 'reach' metric.
SELECT * FROM AccountTimeSeriesMediaProductType SELECT * FROM AccountTimeSeriesMediaProductType WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'
Columns
| Name | Type | Description |
| InstagramBusinessAccountId | String | A unique identifier assigned to an Instagram Business Account. This ID is used to associate the retrieved time series insights with the correct account across Application Programming Interface (API) operations and data aggregations. |
| Metric | String | Describes the different types of engagement metrics being measured. The supported values are reach and views. Reach refers to the number of unique accounts that have seen the content. Views typically represent the number of times a video has been played. |
| EndTime | Datetime | Represents the endpoint of the time window for which the insight metric data was collected. This is used to define the boundary of the measurement period. |
| Value | Integer | Indicates the total value of the specified metric within the defined time frame. For example, the number of unique views accumulated up to the end time. |
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 | The beginning of the time interval during which Instagram insight data was collected. Used to filter or slice metrics based on a defined reporting window. |
| ToDateTime | Datetime | The end of the time interval during which Instagram insight data was collected. Marks the upper boundary of the time range for data analysis and filtering. |