AccountWithoutBreakdown
Summarizes cumulative Instagram performance metrics, including total views and engagements across various content types like posts, stories, and reels. No breakdown is provided, making it suitable for overall metric tracking. The permissions required are 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 '=,IN' operator.
The default query returns results for the 'reach' metric.
SELECT * FROM AccountWithoutBreakdown SELECT * FROM AccountWithoutBreakdown WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'
To retrieve the result for other available metric, then explicitly specify the Metric in where clause. For example:
SELECT * FROM AccountWithoutBreakdown WHERE Metric = 'accounts_engaged'
SELECT * FROM AccountWithoutBreakdown WHERE Metric = 'replies'
SELECT * FROM AccountWithoutBreakdown WHERE Metric = 'website_clicks'
SELECT * FROM AccountWithoutBreakdown WHERE Metric = 'profile_views'
SELECT * FROM AccountWithoutBreakdown WHERE Metric IN ('accounts_engaged', 'replies', 'website_clicks', 'profile_views')
Columns
| Name | Type | Description |
| InstagramBusinessAccountId | String | A unique string identifier assigned to the Instagram Business Account. This value is used to query and aggregate metrics specific to a business profile across the platform. |
| TotalValue | Int | The aggregate numeric value corresponding to the selected metric across the specified date range. This represents the total engagement or performance depending on the metric type selected. |
| Metric | String | Specifies the types of Instagram metrics available for reporting. The supported metrics include: accounts engaged, replies, website clicks, profile views, total interactions, reach, likes, comments, saves, shares, follows and unfollows, profile link taps, and views. For clarity, a space is added after each comma. The default metric is reach. |
| StartDate | Datetime | The starting date of when the metric is calculated for a row. |
| EndDate | Datetime | The ending date of when the metric is calculated for a row. |
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 start timestamp defining the earliest point in time from which the insight metrics are calculated. Must be in ISO 8601 format. |
| ToDateTime | Datetime | The end timestamp defining the latest point in time for which the insight metrics are included in the calculation. Must be in ISO 8601 format. |