Analyzes comprehensive demographic and behavioral data of followers for an Instagram business account, including age, gender, location, and active times. This analysis is crucial for effectively understanding and targeting audience segments. The permissions required are instagram_basic and instagram_manage_insights.

Select

By default this table returns the following:

• The countries of this profile's followers.

To return any of the below demographic information about your followers:

• The gender and age distribution of this profile's followers.
• The locales of this profile's followers, by country code.
• The cities of this profile's followers.

you will need to filter on the AudienceType column:

SELECT * FROM AudienceInsights WHERE AudienceType='country'

SELECT * FROM AudienceInsights WHERE AudienceType IN ('city','country','genderandage')

The above query will return follower counts broken down by city, follower counts broken down by country, and follower counts broken down by gender and age.

Valid values for the AudienceType column are:

• city
• country
• gender
• age
• genderandage

Columns

Name	Type	Description
InstagramBusinessAccountId	String	A unique identifier assigned to the Instagram business account associated with the data. This ID is used to distinguish insights by account.
AudienceType	String	Specifies the category by which follower demographics are segmented. Supported values include: city, country, gender, age, gender and age. Each represents a different type of audience insight breakdown.
AudienceGroup	String	Represents the specific group within the selected AudienceType category. For example, if AudienceType is 'city', this could be 'New York'.
TotalAudience	Integer	Indicates the total count of Instagram users who follow the business account and match the specified AudienceType and AudienceGroup.
Description	String	The number of followers associated with the Instagram business profile who were actively online during the designated insight collection period.
Timeframe	String	Defines the reporting window for the insight data. Available values include: last_14_days, last_30_days, last_90_days, prev_month, this_month, this_week. Each denotes a distinct range of time used for aggregating the audience insights.