AccountTimeSeriesMediaProductType
It returns the metric endtime and the value. For this view, the Metric type is time_series and breakdown 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 '=' 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 | The unique identifier for the Instagram business account Id. |
| Metric | String | Metric Type. The supported Metric types are reach, impressions website_clicks, profile_views. The default metric type is reach. |
| EndTime | Datetime | End time. |
| Value | Integer | Total values of the metrics. |
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 earliest time for insight data to have been collected. |
| ToDateTime | Datetime | The latest time for insight data to have been collected. |