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.

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

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。