ODBC Driver for Instagram

Build 20.0.7654

AccountInsights

Allows you to get insights for an Instagram business account. Requires the instagram_basic and instagram_manage_insights scopes.

Select

You can query the following metrics given a date range. The default date range is the last 7 days.

  • Impressions (accepts time periods of day, week, and days_28)
  • Reach (accepts time periods of day, week, and days_28)
  • FollowerCount (only accepts the day period)
  • EmailContacts (only accepts the day period)
  • PhoneCallClicks (only accepts the day period)
  • TextMessageClicks (only accepts the day period)
  • GetDirectionsClicks (only accepts the day period)
  • WebsiteClicks (only accepts the day period)
  • ProfileViews (only accepts the day period)

Specify a date range with the FromDateTime and ToDateTime columns. Specify the intervals of the date range by setting the Period column in the WHERE clause. Note that you cannot use a period on a metric that does not support it. For example, you cannot use Impressions AND FollowerCount with period days_28 because FollowerCount only supports the day period.

The 本製品 will use the Instagram APIs to process filters that refer to a date range or Id. The 本製品 processes other filters client-side within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false, in which case any search criteria that refers to other columns will cause an error.

The following examples show how to retrieve metrics over a given date range:

  • The default query returns results for the following metrics during the last seven days: Impressions, Reach, FollowerCount, EmailContacts, PhoneCallClicks, TextMessageClicks, GetDirectionsClicks, WebsiteClicks, and ProfileViews.

    SELECT * FROM AccountInsights

  • Filter on FromDateTime and ToDateTime to explicitly specify a different date range. The max date range cannot be more than 30 days (2592000 s).

    SELECT * FROM AccountInsights WHERE FromDateTime='2018/01/01' AND ToDateTime='2018/01/30' AND period='day'

  • Return results over a period of 7 days.

    SELECT * FROM AccountInsights WHERE FromDateTime='2018/01/01' AND period='day'

  • Return results from 2018/01/01 to 2018/01/08.

    SELECT * FROM AccountInsights WHERE ToDateTime='2018/01/08' AND period='day'

  • Return a custom projection on account insights for the date range from 2018/01/01 to 2018/01/08.

    SELECT Impressions,FollowerCount,EmailContacts FROM AccountInsights WHERE FromDateTime='2018/01/01' AND ToDateTime='2018/01/30' AND period='day'

Columns

Name Type Description
InstagramBusinessAccountId String The unique identifier of the Instagram business account Id.
EndTime Date The most recent date this insight data is relevant for.
Impressions Integer Total number of times this profile has been seen.
Reach Integer Total number of unique accounts that have seen this profile.
ProfileViews Integer Total number of unique accounts that have viewed this profile within the specified period.
FollowerCount Integer Total number of unique accounts following this profile.
EmailContacts Integer Total number of taps on the email link in this profile.
PhoneCallClicks Integer Total number of taps on the call link in this profile.
TextMessageClicks Integer Total number of taps on the text message link in this profile.
GetDirectionsClicks Integer Total number of taps on the directions link in this profile.
Websiteclicks Integer Total number of taps on the website link in this profile.
Period String The period for the insight. This controls how rows will be broken up (by day, week, 28 days, or lifetime). This must always be specified.

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.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654