JDBC Driver for Instagram

Build 24.0.9062

AccountTimeSeriesWithoutBreakdown

It returns the metric endtime and the value. For this view, the Metric type is time_series. Requires the instagram_basic and instagram_manage_insights scopes.

Select

The 本製品 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 '=' operator.

The default query returns results for the 'impressions' metric.

SELECT * FROM AccountTimeSeriesWithoutBreakdown
SELECT * FROM AccountTimeSeriesWithoutBreakdown WHERE FromDateTime='2023-06-20T00:00:00Z' AND ToDateTime='2023-07-12T00:00:00Z'

Columns

Name Type Description
InstagramBusinessAccountId String The unique identifier for the Instagram business account Id.
Metric String Metric Type. The supported Metric types are impressions, website_clicks, profile_views, reach. The default metric type is impressions.
EndTime Datetime End time.
Value Integer Total values of the metrics.

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062