ODBC Driver for Instagram

Build 24.0.9060

AccountContactButtonType

It returns the number of taps on the DIRECTION, CALLs and EMAILs button during the selected time period. For this view, the Metric Type is total_value and Breakdown(dimension) is contact_button_type. Requires the instagram_basic and instagram_manage_insights scopes.

Select

The driver 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 'profile_links_taps' metric.

SELECT * FROM AccountContactButtonType
SELECT * FROM AccountContactButtonType WHERE FromDateTime='2023-07-02T00:00:00Z' AND ToDateTime='2023-07-24T00:00:00Z'

Columns

Name Type Description
InstagramBusinessAccountId String The unique identifier for the Instagram business account Id.
Metric String Metric Type. Default value is profile_links_taps.

The allowed values are profile_links_taps.

DIRECTION Int Number of taps on DIRECTION button.
CALL Int Number of taps on Calls button.
EMAIL Int Number of taps on Emails button.

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 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.9060