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