AccountTimeSeriesFollowType
Provides time-based metrics on follower changes, tracking the fluctuations of follows and unfollows over specific intervals. This view uses follow_type as a breakdown dimension and facilitates time-series analysis for identifying trends. The permissions required include instagram_basic and instagram_manage_insights.
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 AccountTimeSeriesFollowType SELECT * FROM AccountTimeSeriesFollowType WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'
Columns
| Name | Type | Description |
| InstagramBusinessAccountId | String | A unique string identifier representing the Instagram Business Account associated with the data. This ID is used to link insights to a specific business profile within the Instagram Graph Application Programming Interface (API). |
| Metric | String | Defines the type of engagement metric 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 | The timestamp marking the end of the data collection period for the metric. This defines the upper boundary of the time range for the reported insights. |
| Value | Integer | The total number of reach or views for the specified time period. This value quantifies overall engagement. |
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 data collection period. Insight metrics are included only if they occurred on or after this date and time. |
| ToDateTime | Datetime | The ending point of the data collection window. Insight metrics are only included if they occurred on or before this datetime value. |