AccountTimeSeriesWithoutBreakdown
Returns time-series metrics without a specific breakdown dimension, making it useful for monitoring aggregated metrics like reach over time. It includes end-time and value pairs for temporal analysis. This 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 AccountTimeSeriesWithoutBreakdown SELECT * FROM AccountTimeSeriesWithoutBreakdown 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 the Instagram business account. This ID is used to retrieve account-specific insights and is required for linking Application Programming Interface (API) responses to the corresponding Instagram entity. |
| Metric | String | Specifies the type of engagement metric being measured. The supported values include reach, and views. By default, the reach metric is used. Values must be comma-separated as: reach, views. |
| EndTime | Datetime | Represents the timestamp marking the end of the reporting interval for the metrics. This value is used to define the boundary of the aggregated insight data. |
| Value | Integer | Indicates the total numeric value of the chosen metric, such as reach or views, for the specified time period. The value is computed as a cumulative count over the defined reporting duration. |
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 beginning of the time range for which insight data has been collected. This is a pseudo-column used for internal filtering of historical metrics. |
| ToDateTime | Datetime | Defines the end of the time range for which insight data has been collected. This is a pseudo-column used for internal filtering and aggregation of recent metric data. |