JDBC Driver for Instagram

Build 25.0.9434

AccountFollowType

Captures follower dynamics by reporting the number of new followers, unfollows, and users who deactivated accounts over a defined period. This data is aggregated under the 'follow_type' breakdown and can be used to understand audience growth trends. The permissions required are instagram_basic and instagram_manage_insights.

Columns

Name Type Description
InstagramBusinessAccountId String The globally unique identifier assigned to the Instagram business account, used to distinguish it from other accounts within the platform's ecosystem.
Metric String Indicates the type of account follow activity metric to be retrieved. The default setting is follows_and_unfollows, which encompasses both new followers and unfollowers during the specified date range.

The allowed values are follows_and_unfollows, reach.

Follower Int Represents the total number of new followers who began following the Instagram business account during the specified time window.
Nonfollower Int Represents the total number of users who stopped following the Instagram business account within the defined reporting period.
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 Indicates the beginning of the time interval for which insight metrics should be queried. Only data collected at or after this timestamp is considered.
ToDateTime Datetime Marks the end of the time range for insight metric collection. The metrics returned will include data recorded up until this timestamp.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434