Instagram. Подключение коннектора
Дата:
Описание таблиц в базе данных
Каждый источник данных создает набор таблиц в вашей базе данных
Во вкладках ниже вы сможете найти шаблон имени таблицы и описание создаваемых колонок в таблице
Название таблицы:
instagram_{}_insights
| Название колонки | Описание |
|---|---|
date |
Date |
email_contacts |
Total number of taps on the email link in the IG User's profile |
follower_count |
Total number of new followers each day within the specified range. Returns a maximum of 30 days worth of data. Not available on IG Userswith fewer than 100 followers. |
get_directions_clicks |
Total number of taps on the directions link in the IG User's profile |
impressions |
Total number of times the IG User's IG Media have been viewed. Includes ad activity generated through the API, Facebook ads interfaces,and the Promote feature. Does not include profile views |
phone_call_clicks |
Total number of taps on the call link in the IG User's profile |
profile_views |
Total number of users who have viewed the IG User's profile within the specified period |
reach |
Total number of unique users who have viewed at least one of the IG User's IG Media. Repeat views and views across different IG Media owned by the IG User by the same user are only counted as a single view. Includes ad activity generated through the API, Facebook ads interfaces, and the Promote feature |
text_message_clicks |
Total number of taps on the text message link in the IG User's profile |
website_clicks |
Total number of taps on the website link in the IG User's profile |
Название таблицы:
instagram_{}
| Название колонки | Описание |
|---|---|
date |
Date |
followers |
Followers |
Название таблицы:
instagram_{}_media
| Название колонки | Описание |
|---|---|
item_id |
IG Media object ID |
media_product_type |
Surface where the media is published: AD, FEED, IGTV и STORY |
media_type |
Media type: CAROUSEL_ALBUM, IMAGE и VIDEO |
media_url |
Media URL. Is omitted from responses if the media contains copyrighted material, or has been flagged for a copyright violation |
caption |
Caption |
video_title |
Instagram TV Video Title |
create_date |
Date created (UTC) |
Название таблицы:
instagram_{}_media_facts
| Название колонки | Описание |
|---|---|
item_id |
IG Media object ID |
update_date |
Date of statistics update |
like_count |
Count of likes on the media |
comments_count |
Count of comments on the media |
engagement |
Sum of likes, comments, and saves on the IG Media |
saved |
Total number of unique Instagram accounts that have saved the IG Media object |
impressions |
Total number of times the IG Media object has been seen |
reach |
Total number of unique Instagram accounts that have seen the IG Media object |
Название таблицы:
instagram_{}_stories_facts
| Название колонки | Описание |
|---|---|
item_id |
IG Media object ID |
update_date |
Date of statistics update |
impressions |
Total number of times the IG Media object has been seen |
reach |
Total number of unique Instagram accounts that have seen the IG Media object |
replies |
Total number of replies (IG Comments) on the story IG Media object. Value does not include replies made by users in some regions |
exits |
Total number of times someone exited the story IG Media object |
taps_forward |
Total number of taps to see this story IG Media object's next photo or video |
taps_back |
Total number of taps to see this story IG Media object's previous photo or video |