SocialBakers Source

Renta поддерживает экспорт данных из SocialBakers в следующие пункты назначения:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Создание интеграции в хранилище данных (DWH)

  1. Перейдите в каталог интеграций;
  2. Выберите SocialBakers;
  3. Добавьте аккаунт SocialBakers, в котором находятся необходимые данные;
  4. Выберите добавленный аккаунт SocialBakers;
  5. Укажите место назначения, в которое вы хотите импортировать данные;
  6. Перейдите на экран настроек и установите необходимую конфигурацию:

Report type

Тип отчета — состоит из уникального набора параметров и метрик, доступных для выгрузки в DWH. Каждый тип отчета соответствует одноименному методу API SocialBakers. 

Namedescription
ProfilesProfile metrics endpoints return daily values for the specified set of metrics and profiles. Profile metrics attribute data to the profile/page, focusing on when engagement happened, regardless if a post was published during the analyzed date range or not. Data is aggregated by when it happened, and it is not related to a specific piece of content.
PostsThe endpoints in this section return a list of posts/videos/tweets, accompanied by the fields you specify. It can be an attribute of the post (text, created time, author, id, paid status) or metric (Number of comments, Number of Likes).

Parameters

Параметры —  содержат список параметров и метрик, доступных для экспорта. Укажите необходимые для выгрузки параметры.

В результате Renta создаст таблицу, которая будет содержать данные выбранных параметров. Порядок выбранных параметров в интерфейсе будет соответствовать порядку столбцов таблицы.

Profiles

Учетная запись, в личном кабинете которой есть необходимые данные.

Date range type

Диапазон дат — укажите период, за который необходимо экспортировать данные. Вы можете указать любой исторический временной интервал.

Чтобы выбрать необходимое время, введите в поле «From» дату, с которой вы хотите начать выгрузку данных, затем введите дату окончания в поле «To».

Если вы хотите, чтобы данные в таблице обновлялись ежедневно и дополнялись новыми днями, тогда в поле «To» укажите «Yesterday».
Подробная инструкция по работе с диапазоном дат

Integration name

Имя интеграции — при создании интеграции автоматически генерируется её имя. В этом поле вы можете переименовать название интеграции. Разрешены как кириллица, так и латиница, но не более 100 символов.

Название интеграции отображается на странице Integration List.

Table name

Имя таблицы — при создании интеграции автоматически генерируется имя таблицы, которая будет создана в DWH. В этом поле вы можете переименовать её.

Разрешена только латиница, цифры и символ «_».

Update time

Время обновления — вы можете указать любое время обновления, которое вам нужно. Рента обновляет интеграции ежедневно в интервале выбранного часа. 

Обычно наши пользователи выбирают время обновления интеграций рано утром, например, в 5 утра. В этом случае ваша интеграция будет обновляться в период с 5 утра до 6 утра. 

Обновление интеграций происходит по часовому поясу, выбранном в настройках вашего профайла. 

Overwrite period

Период перезаписи данных — это ретроспективное обновление данных за выбранный период.

Например, вы выбираете период перезаписи «Последние 7 дней» — это означает, что все данные за последние 7 дней будут удалены из таблицы и вставлены снова с обновленными данными.

Примечание: данная настройка доступна только в том случае, если был выбран параметр с типом date или dateTime. 

Создание интеграции в Google Spreadsheets

Воспользуйтесь бесплатным расширением, доступным в Google Workspace Marketplace. Для этого:

  1. Установите расширение Renta Spreadsheets Add-on.
  2. Затем зайдите в Google Sheets, и во вкладке Tools выберите Renta, после чего нажмите кнопку Run. 

После чего в правом сайдбаре откроется рабочая область с настройками интеграций. Подробная инструкция по созданию интеграции доступна по данной ссылке. Обратите внимание, что все созданные интеграции в Google Spreadsheets также доступны для управления в веб-версии Renta. 

Структура данных

NameDescriptionType
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
commentsNumber of comments on page posts.FLOAT
comments_by_ppd_statusNumber of comments on page posts by paid status (organic/paid/unknown) based on PPD.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
comments_by_typeNumber of comments on page posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
fans_changeAbsolute change of fans count of a page.FLOAT
fans_lifetimeTotal number of likes (=fans) of a page.FLOAT
interactionsNumber of interactions on page posts.FLOAT
interactions_by_ppd_statusNumber of interactions on page posts by paid status (organic/paid/unknown) based on PPD.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_by_typeNumber of interactions on page posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_per_1000_fansNumber of interactions per thousand fans.FLOAT
interactions_per_1000_fans_by_typeNumber of interactions per thousand fans by type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
page_postsNumber of page posts.FLOAT
page_posts_by_appNumber of page posts by application via it was postedДобавить в маппинг: Nested (name Nullable(String),value Nullable(float))
page_posts_by_ppd_statusNumber of page posts by paid status (organic/paid/unknown) based on PPD.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
page_posts_by_typeNumber of page posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
reactionsNumber of reactions on page posts.FLOAT
reactions_by_ppd_statusNumber of reactions on page posts by paid status (organic/paid/unknown) based on PPD.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
reactions_by_reaction_typeNumber of reactions on page posts by reaction type (like, love, haha, etc...).Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
reactions_by_typeNumber of reactions on page posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
sharesNumber of shares on page posts.FLOAT
shares_by_ppd_statusNumber of shares on page posts by paid status (organic/paid/unknown) based on PPD.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
shares_by_typeNumber of shares on page posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
user_postsNumber of user posts.FLOAT
user_posts_average_response_timeAverage reponse time (mins) of responded user posts.FLOAT
user_posts_by_appNumber of user posts by application via it was posted (any facebook app is "web").Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
user_posts_respondedNumber of user posts that are responded (at least 1 page comment).FLOAT
user_posts_responded_by_timeNumber of responded user posts by response time category.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
user_posts_response_rateRatio of user posts and responded user posts.FLOAT
user_questionsNumber of user posts that are marked as a question.FLOAT
user_questions_average_response_timeAverage reponse time (mins) of responded user questions.FLOAT
user_questions_respondedNumber of user posts that are marked as a question and that are responded (at least 1 page comment).FLOAT
user_questions_responded_by_timeNumber of responded user questions by response time category.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
user_questions_response_rateRatio of user questions and responded user questions.FLOAT
insights_activityNumber of activities created about your Page. (Total Count)FLOAT
insights_activity_by_activity_typeNumber of activities about your Page by activity type. (Total Count)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_activity_uniqueNumber of people sharing activity about your page. These activity include liking your Page, posting to your Page's timeline, liking, commenting on or sharing one of your Page posts, answering a question you posted, responding to one of your events, mentioning your Page, tagging your Page in a photo or checking in at your location. (Unique Users)FLOAT
insights_activity_unique_by_activity_typeNumber of people talking about your Page, by activity type. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_activity_unique_by_age_genderNumber of People Talking About the Page by user age and gender (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_activity_unique_by_cityNumber of People Talking About the Page by user city. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_activity_unique_by_countryNumber of People Talking About the Page by user country (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_activity_unique_by_localeNumber of People Talking About the Page by user language. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_engaged_usersNumber of people who engaged with your Page. Engagement includes any click or activity created. (Unique Users).FLOAT
insights_fan_addsNumber of new people who have liked your Page.FLOAT
insights_fan_adds_by_paid_non_paid_uniqueNew likes by paid and non-paid : Number of new people who have liked your page broken down by paid and non-paid. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fan_adds_uniqueNew Likes : Number of new people who have liked your Page (Unique Users)FLOAT
insights_fan_removesNumber of Unlikes of your Page (Total Count)FLOAT
insights_fan_removes_uniqueNumber of Unlikes of your Page (Unique Users)FLOAT
insights_fans_by_like_sourceBreakdown of Number of Page likes from the most common places where people can like your Page. (Total Count)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_by_like_source_uniqueNumber of people who liked your Page, broken down by the most common places where people can like your Page. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_by_unlike_source_uniqueNumber of people who unliked your Page, broken down by the most common places where people can unlike your Page. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_cityAggregated location data, sorted by city, number of people who like your Page. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_gender_age_lifetimeAggregated demographic data about the people who like your Page based on the age and gender information they provide in their user profiles. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_lifetimeNumber of people who have liked your Page. (Unique Users)FLOAT
insights_fans_lifetime_by_countryLifetime value of number of fans grouped by country.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_locale_lifetimeAggregated language data about the people who like your Page based on the default language setting selected when accessing Facebook. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_fans_onlineNumber of people who liked your Page and when they are online (Unique Users)FLOAT
insights_fans_online_by_hourNumber of your fans who saw any posts on Facebook on a given day, broken down by hour of day in PST (Pacific Standard Time)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_impressionsNumber of impressions seen of any content associated with your Page. (Total Count)FLOAT
insights_impressions_by_paid_non_paidNumber of impressions seen of any content associated with your page broken down by paid and non-paid. (Total Count)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_impressions_organicNumber of times your posts were seen in News Feed or ticker or on visits to your Page. These impressions can be by people who have liked your Page and people who haven't. (Total Count)FLOAT
insights_impressions_paidNumber of impressions of a Sponsored Story or Ad pointing to your Page. (Total Count)FLOAT
insights_impressions_viralNumber of impressions of an activity published by a friend about your Page. These activities include liking your Page, posting to your page's Wall, liking, commenting on or sharing one of your Page posts, answering a Question you posted, RSVPing to one of your events, mentioning your Page, phototagging your Page or checking in at your Place. (Total Count)FLOAT
insights_impressions_viral_frequency_distributionNumber of people your Page reached from a story published by a friend, broken down by how many times people saw activities about your Page. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_negative_feedbackNumber of times people have given negative feedback to your Page. (Total Count)FLOAT
insights_positive_feedbackNumber of times people have given positive feedback to your Page. (Total Count)FLOAT
insights_post_clicksNumber of clicks on any of your content. Clicks generating activity are included in "Other Clicks." Activities generated without clicks on page content (e.g., liking the page in Timeline) are not included. (Total Count)FLOAT
insights_post_clicks_by_typeNumber of clicks on any of your content, by type. Clicks generating activity are included in "Other Clicks." Activities generated without clicks on page content (e.g., liking the page in Timeline) are not included. Other clicks is defined as "Clicks not on the content of the post, such as page title clicks or click to see more".Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_clicks_uniqueNumber of people who clicked on any of your content. Clicks that create activity are included in "Other Clicks." Activities that are created without clicking on Page content (ex, liking the Page from timeline) are not included. (Unique Users)FLOAT
insights_post_clicks_unique_by_typeNumber of of people who clicked on any of your content, by type. Clicks that create activity are included in "Other Clicks." Activities that are created without clicking on Page content (ex, liking the Page from timeline) are not included. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_impressionsNumber of impressions that came from all of your posts. (Total Count)FLOAT
insights_post_impressions_by_paid_non_paidNumber of impressions that came from all of your posts broken down by paid and non-paid. (Total Count)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_impressions_frequency_distributionNumber of people who saw your Page posts, broken down by how many times people saw your posts. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_impressions_paidNumber of impressions of your Page posts in an Ad or Sponsored Story. (Total Count)FLOAT
insights_post_reachNumber of people who saw any of your Page posts. (Unique Users)FLOAT
insights_post_reach_by_paid_non_paidNumber of impressions that came from all of your posts broken down by paid and non-paid. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_reach_organicNumber of people who saw your Page posts in news feed or ticker, or on your Page's timeline. (Unique Users)FLOAT
insights_post_reach_paidNumber of people who saw your Page posts in an ad or sponsored story. (Unique Users)FLOAT
insights_reachNumber of people who have seen any content associated with your Page. (Unique Users)FLOAT
insights_reach_by_age_genderTotal Page Reach by age and gender. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_reach_by_paid_non_paidNumber of impressions seen of any content associated with your page broken down by paid and non-paid. (Unique Users)Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_reach_engagementNumber of people who engaged with your Page per Number of people who have seen any content associated with your Page. Engagement includes any click or activity created.FLOAT
insights_reach_organicNumber of people who visited your Page, or saw your Page or one of its posts in news feed or ticker. These can be people who have liked your Page and people who haven't. (Unique Users)FLOAT
insights_reach_paidNumber of people who saw a sponsored story or ad pointing to your Page. (Unique Users)FLOAT
insights_reach_viralNumber of people who saw your Page or one of its posts from a activity shared by a friend. These activities include liking your Page, posting to your page's timeline, liking, commenting on or sharing one of your Page posts, answering a question you posted, responding to one of your events, mentioning your Page, tagging your Page in a photo or checking in at your location. (Unique Users)FLOAT
insights_reactionsNumber of reactions on any of your content.FLOAT
insights_reactions_by_typeNumber of reactions on any of your content by type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_video_complete_views_30sNumber of times page's videos have been viewed for more than 30 secondsFLOAT
insights_video_complete_views_30s_autoplayedNumber of times page's autoplayed videos have been viewed for more than 30 secondsFLOAT
insights_video_complete_views_30s_click_to_playNumber of times page's videos have been viewed after the user clicks on play for more than 30 secondsFLOAT
insights_video_complete_views_30s_organicNumber of times page's videos have been viewed for more than 30 seconds by organic reachFLOAT
insights_video_complete_views_30s_repeat_viewsNumber of times that people replay a page's videos for more than 30 secondsFLOAT
insights_video_complete_views_30s_uniqueNumber of times page's videos have been played for unique people for more than 30 secondsFLOAT
insights_video_repeat_viewsNumber of times that people replay a page's videos for more than 3 secondsFLOAT
insights_video_viewsNumber of times page's videos have been viewed for more than 3 secondsFLOAT
insights_video_views_autoplayedNumber of times page's autoplayed videos have been viewed for more than 3 secondsFLOAT
insights_video_views_click_to_playNumber of times page's videos have been viewed after the user clicks on play for more than 3 secondsFLOAT
insights_video_views_organicNumber of times page's videos have been viewed for more than 3 seconds by organic reachFLOAT
insights_video_views_paidNumber of times page's promoted videos have been viewed for more than 3 secondsFLOAT
insights_video_views_uniqueNumber of times page's videos have been played for unique people for more than 3 secondsFLOAT
insights_viewsPage views (Total Count)FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
commentsNumber of comments of profile posts.FLOAT
comments_by_image_filterNumber of comments of profile posts by used image filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
comments_by_typeNumber of comments of profile posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
comments_by_video_filterNumber of comments of profile posts by used video filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
followers_changeAbsolute change of followers count lifetime.FLOAT
followers_lifetimeFollowers count - lifetime value.FLOAT
following_changeAbsolute change of following count lifetime.FLOAT
following_lifetimeFollowing count - lifetime value.FLOAT
interactionsNumber of interactions on page posts.FLOAT
interactions_by_image_filterNumber of interactions of profile posts by used image filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_by_typeNumber of interactions of profile posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_by_video_filterNumber of interactions of profile posts by used video filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_per_1000_followersNumber of interactions (likes and comments) per thousand followers.FLOAT
interactions_per_1000_followers_by_image_filterNumber of interactions (likes and comments) per thousand followers by used image filter.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_per_1000_followers_by_typeNumber of interactions (likes and comments) per thousand followers by used post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
interactions_per_1000_followers_by_video_filterNumber of interactions (likes and comments) per thousand followers by used video filter.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
likesNumber of likes of profile posts.FLOAT
likes_by_image_filterNumber of likes of profile posts by used image filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
likes_by_post_typeNumber of likes of profile posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
likes_by_video_filterNumber of likes of profile posts by used video filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
profile_postsNumber of profile posts.FLOAT
profile_posts_by_image_filterNumber of profile posts by used image filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
profile_posts_by_typeNumber of profile posts by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
profile_posts_by_video_filterNumber of profile posts by used video filter of that post.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_followers_by_city_by_dayThe cities of the Business Account's followers.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_followers_by_country_by_dayThe countries of the Business Account's followers.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_followers_by_gender_by_age_by_dayThe gender and age distribution of the Business Account's followers.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_followers_by_locale_by_dayThe number of followers broken down by language preferences.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_engagement_by_dayTotal number of likes and comments on the posts.FLOAT
insights_post_engagement_by_type_by_dayTotal engagement (likes and comments) broken down by post type (video, carousel album, carousel, image).Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_impressions_by_dayThe number of times posts have been seen.FLOAT
insights_post_impressions_by_type_by_dayThe number of times posts have been seen, broken down by post type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_interactions_by_dayThe number of Likes, Comments and Saves posts received. The data source of this chart is different from the post_engagement. As a result, the number of interactions may vary.FLOAT
insights_post_interactions_by_int_type_by_dayThe number of Likes, Comments and Saves posts received, broken down by the type of Interactions. The data source of this chart is different from the post_engagement. As a result, the number of interactions may vary.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_saves_by_dayTotal number of saves on the posts.FLOAT
insights_post_saves_by_type_by_dayTotal number of saves broken down by post type (video, carousel album, carousel, image).Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_video_views_by_dayThe number of times videos have been viewed.FLOAT
insights_post_video_views_by_type_by_dayThe number of times videos have been viewed, broken down by video type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_profile_all_clicks_by_dayThe number of times user clicked on a specific contact on your Business Account's profile.FLOAT
insights_profile_email_contacts_by_dayTotal number of taps on the email link in the Business Account's profile.FLOAT
insights_profile_get_directions_clicks_by_dayTotal number of taps on the directions link in the Business Account's profile.FLOAT
insights_profile_impressions_by_dayTotal number of times the Business Account's media objects (i.e. posts, stories and promotions) have been viewed. Does not include profile views.FLOAT
insights_profile_phone_call_clicks_by_dayTotal number of taps on the call link in the Business Account's profile.FLOAT
insights_profile_reach_by_dayUnique Impressions (Reach) refers to the number of different people who see your post. One person can see your post 5 times but is only counted once toward Reach.FLOAT
insights_profile_text_message_clicks_by_dayTotal number of taps on the text message link in the Business Account's profile.FLOAT
insights_profile_views_by_dayTotal number of unique users who have viewed the Business Account's profile.FLOAT
insights_profile_website_clicks_by_dayTotal number of taps on the website link in the Business Account's profile.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
ff_ratioAbsolute change of following count lifetime.FLOAT
followers_changeAbsolute change of followers count lifetime.FLOAT
followers_lifetimeFollowers count - lifetime value.FLOAT
following_changeAbsolute change of following count lifetime.FLOAT
following_lifetimeFollowing count - lifetime value.FLOAT
incomingNumber of all incoming activities (mentions + retweets + replies) created by others mentioning this profile.FLOAT
incoming_questionsNumber of user tweets that are also marked as a question.FLOAT
incoming_questions_average_response_timeAverage reponse time (mins) of responded user questions.FLOAT
incoming_questions_respondedNumber of user tweets that are marked as a question and that are responded (profile reply).FLOAT
incoming_questions_responded_by_timeNumber of responded user questions by response time category.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
incoming_questions_response_rateRatio of user questions and responded user questions.FLOAT
incoming_repliesNumber of replies made by others.FLOAT
incoming_retweetsNumber of retweets made by others.FLOAT
incoming_tweetsNumber of user tweets. User tweet is considered any incoming activity (mention, reply), exluding retweets.FLOAT
incoming_tweets_average_response_timeAverage reponse time (mins) of responded user tweets.FLOAT
incoming_tweets_respondedNumber of user tweets that are responded (profile reply).FLOAT
incoming_tweets_responded_by_timeNumber of responded user tweets by response time category.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
incoming_tweets_response_rateRatio of user tweets and responded user tweets.FLOAT
interactionsNumber of interactions on page posts.FLOAT
interactions_per_1000_followersNumber of interactions per thousand followers.FLOAT
likesNumber of likes on profile tweets and replies.FLOAT
listed_changeAbsolute change of listed count lifetime.FLOAT
listed_lifetimeListed count - lifetime value (how many times profile has been listed).FLOAT
profile_activitiesNumber of all activities (tweets + retweets + replies) created by the profile.FLOAT
profile_activities_by_appNumber of all activities posted by profile by application via it was posted.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
profile_repliesNumber of replies made by profile.FLOAT
profile_retweetsNumber of retweets made by profile.FLOAT
profile_tweetsNumber of tweets made by profile.FLOAT
repliesNumber of replies on profile tweets and replies.FLOAT
retweetsNumber of retweets on profile tweets and replies.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
comments_changeAbsolute change of comments count on uploaded videos.FLOAT
dislikes_changeAbsolute change of dislikes count on uploaded videos.FLOAT
interaction_changeAbsolute change of interactions (likes + dislikes + comments) count on uploaded videos.FLOAT
interactions_per_1000_subscribersNumber of interactions per thousand subscribers.FLOAT
likes_changeAbsolute change of likes count on uploaded videos.FLOAT
subscribers_changeAbsolute change of subscribers count lifetime.FLOAT
subscribers_count_lifetimeSubscribers count - lifetime value.FLOAT
video_changeAbsolute change of videos count lifetime.FLOAT
video_count_lifetimeVideo count - lifetime value.FLOAT
viewed_time_changeAbsolute change of viewed time (in seconds) lifetime. Viewed time for each video is number of views multiplied by length of the video.FLOAT
viewed_time_lifetimeViewed time (in seconds) of all uploaded videos - lifetime value. Viewed time for each video is number of views multiplied by length of the video.FLOAT
views_changeAbsolute change of views count lifetime.FLOAT
views_count_lifetimeViews count of all uploaded videos - lifetime value.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
boards_changeAbsolute change of boards count lifetime.FLOAT
boards_lifetimeBoards count - lifetime value.FLOAT
commentsNumber of comments on profile pins.FLOAT
followers_changeAbsolute change of followers count lifetime.FLOAT
followers_lifetimeFollowers count - lifetime value.FLOAT
following_changeAbsolute change of following count lifetime.FLOAT
following_lifetimeFollowing count - lifetime value.FLOAT
interactionsNumber of interactions on page posts.FLOAT
likesNumber of likes on profile pins.FLOAT
pins_changeAbsolute change of pins count lifetime.FLOAT
pins_lifetimePins count - lifetime valueFLOAT
repinsNumber of repins on profile pins.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
attachmentsDetails about post attachmentsДобавить в маппинг: Nested (title Nullable(String),description Nullable(String),url Nullable(String),image_url Nullable(String))
commentsFacebook post comments count.FLOAT
created_timeFacebook post created time.DATE
idFacebook post id.STRING
interactionsSum of reactions, comments and shares.FLOAT
is_publishedIs post publishedBIT
messageFacebook post contents.STRING
page_idFacebook page id for the published post.STRING
post_labelsArray of post labels for given post and accountДобавить в маппинг: Nested (id Nullable(String),name Nullable(String))
ppd_statusIndicates whether the post was organic, paid or unknown based on PPD algorithm.STRING
reactionsFacebook post reactions count.FLOAT
reactions_by_typeObject containing Facebook post reactions number.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
sharesFacebook post share count.FLOAT
storyText from stories not intentionally generated by users, such as those generated when two people become friends, or when someone else posts on the person's wall.STRING
typeFacebook post type.STRING
universal_video_idThe publishers asset management code for this video. Only available in case the post type is a video.STRING
urlLink to facebook post.STRING
video_idThe id of the video object. Only available in case the post type is a video.STRING
video_lengthDuration of the video in seconds. Only available in case the post type is a video.FLOAT
insights_engaged_fanPeople who have liked your page and engaged with your post.FLOAT
insights_engaged_usersThe number of people who clicked anywhere in your postsFLOAT
insights_engagement_rateReach shows you how many people were exposed to your content and Reach Engagement Rate shows you how many of those reached people actually interacted with it.FLOAT
insights_impressionsThe number of impressions for your Page postFLOAT
insights_impressions_by_paid_non_paidThe number of impressions for your Page post, broken down by total, paid, and non-paidДобавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_impressions_fanThe number of impressions for your Page post by people who have liked your PageFLOAT
insights_impressions_fan_paidThe number of impressions for your Page post by people who like your Page in an Ad or Sponsored StoryFLOAT
insights_impressions_organicThe number of impressions of your post in Newsfeed, Ticker, or on your Page's WallFLOAT
insights_impressions_paidThe number of impressions for your Page post in an Ad or Sponsored StoryFLOAT
insights_negative_feedbackThe number of times people took a negative action in your post (e.g. hid it)FLOAT
insights_negative_feedback_uniqueThe number of people who took a negative action in your post (e.g., hid it)FLOAT
insights_paid_statusWhether the post has been promoted (received any paid impression) or notSTRING
insights_post_clicksThe number of times people clicked on anywhere in your posts without generating an activityFLOAT
insights_post_clicks_by_typeThe number of times people clicked on anywhere in your posts without generating an activity, broken-down by post click type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_clicks_by_type_uniqueThe number of people who clicked anywhere in your post without generating an activity, broken-down by post click type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_post_clicks_uniqueThe number of people who clicked anywhere in your post without generating an activity.FLOAT
insights_reachThe number of people who saw your Page postFLOAT
insights_reach_by_paid_non_paidThe number of people who saw your Page post, broken down by total, paid, and non-paidДобавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_reach_fanThe number of people who have like your Page who saw your Page postFLOAT
insights_reach_fan_paidThe number of people who have like your Page and saw your Page post in an Ad or Sponsored StoryFLOAT
insights_reach_organicThe number of people who saw your post in their Newsfeed or Ticker or on your Page's WallFLOAT
insights_reach_paidThe number of people who saw your Page post in an Ad or Sponsored StoryFLOAT
insights_reactions_by_type_totalThe number of reactions to a Page's post by reaction type.Добавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_reactions_like_totalThe number of "like" reactions to a post.FLOAT
insights_storiesThe number of stories created about your Page (Stories)FLOAT
insights_story_addsThe number of stories generated about your Page post.FLOAT
insights_storytellersThe number of people sharing stories about your page ("People Talking About This" / PTAT). These stories include liking your Page, posting to your Page's Wall, liking, commenting on or sharing one of your Page posts, answering a Question you posted, RSVPing to one of your events, mentioning your Page, phototagging your Page or checking in at your PlaceFLOAT
insights_video_avg_time_watchedThe average length of time (in milliseconds) people spent viewing your videoFLOAT
insights_video_complete_views_30sTotal number of times Page's videos have been viewed for more than 30 secondsFLOAT
insights_video_complete_views_30s_autoplayedTotal number of times Page's autoplayed videos have been viewed to the end, or viewed for more than 30 secondsFLOAT
insights_video_complete_views_30s_clicked_to_playTotal number of times Page's videos have been viewed to the end, or viewed after the user clicks on play for more than 30 secondsFLOAT
insights_video_complete_views_30s_organicTotal number of times Page's videos have been viewed to the end, or viewed for more than 30 seconds by organic reachFLOAT
insights_video_complete_views_30s_paidTotal number of times Page's promoted videos have been viewed to the end, or for more than 30 secondsFLOAT
insights_video_complete_views_30s_uniqueTotal number of times Page's videos have been played for unique people to the end, or viewed for more than 30 secondsFLOAT
insights_video_complete_views_organicThe number of times your video was organically viewed from the beginning to 95% of its lengthFLOAT
insights_video_complete_views_organic_uniqueThe number of people who viewed your video organically from the beginning to 95% of its lengthFLOAT
insights_video_complete_views_paidThe number of times your video was viewed via paid impression from the beginning to 95% of its lengthFLOAT
insights_video_complete_views_paid_uniqueThe number of people who viewed your video via paid impression from the beginning to 95% of its lengthFLOAT
insights_video_retention_graphPercentage of viewers at each interval. Video length is divided into short buckets. Each key in response represents a bucket. Values are percent of people saw the video in that bucketДобавить в маппинг: Array (float)
insights_video_retention_graph_autoplayedPercentage of viewers at each interval where the video started playing automatically. Video length is divided into short buckets. Each key in response represents a bucket. Values are percent of people saw the video in that bucketДобавить в маппинг: Array (float)
insights_video_view_timeThe total number of seconds your video was watched, including replays and views less than 3 seconds.FLOAT
insights_video_view_time_by_age_bucket_and_genderThe total time, in milliseconds, your video played for your Top Audiences, age and genderДобавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_video_view_time_by_country_idThe total number of minutes your video played for your Top 45 Locations - CountriesДобавить в маппинг: Nested (name Nullable(String),value Nullable(float))
insights_video_view_time_organicTotal time (in milliseconds) video has been viewed without paid promotionFLOAT
insights_video_view_time_paidTotal time (in milliseconds) video has been viewed with paid promotionFLOAT
insights_video_viewsThe number of times your video was watched for an aggregate of at least 3 seconds, or for nearly its total length, whichever happened first.FLOAT
insights_video_views_autoplayedNumber of times your video started automatically playing and people viewed it for more than 3 secondsFLOAT
insights_video_views_clicked_to_playNumber of times people clicked to play your video and viewed it more than 3 secondsFLOAT
insights_video_views_organicThe number of times your video was organically viewed for 3 seconds or moreFLOAT
insights_video_views_organic_uniqueThe number of people who viewed at least 3 seconds of your video organicallyFLOAT
insights_video_views_paidThe number of times your video was viewed via paid impression for 3 seconds or moreFLOAT
insights_video_views_paid_uniqueThe number of people who viewed at least 3 seconds of your video via paid impressionFLOAT
insights_video_views_uniqueThe number of distinct people who viewed your video at least once.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
attachmentsDetails about post attachmentsДобавить в маппинг: Nested (url Nullable(String))
commentsTotal number of comments on the media object.FLOAT
created_timeInstagram media created time.DATE
idInstagram media ID.STRING
interactionsSum of reactions, comments and shares.FLOAT
likesTotal number of likes on the media object.FLOAT
messageInstagram media contents.STRING
post_labelsArray of post labels for given post and accountДобавить в маппинг: Nested (id Nullable(String),name Nullable(String))
typeMedia post type.STRING
urlLink to instagram post.STRING
insights_engagementTotal number of likes and comments on the media object.FLOAT
insights_impressionsTotal number of times the media object has been seen.FLOAT
insights_reachTotal number of unique accounts that have seen the media object.FLOAT
insights_savedTotal number of unique accounts that have saved the media object.FLOAT
insights_video_views(Videos only) Total number of times the video has been seen. Returns 0 for videos in carousel albums.FLOAT
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
created_timeTweet created time.DATE
idTweet id.STRING
post_labelsArray of tweet labels for given tweet and accountДобавить в маппинг: Nested (id Nullable(String),name Nullable(String))
dateDateDATE
profile_idId of profileSTRING
profile_profileNameName of profileSTRING
profile_timezoneTimezone of profileSTRING
commentsThe number of comments for the video.FLOAT
created_timeDate and time the video was uploaded on Youtube.DATE
dislikesThe number of users who have indicated that they disliked the video.FLOAT
durationThe length of the video [s].FLOAT
idYoutube video id.STRING
interactionsThe sum of Likes, Dislikes, Shares and Comments.FLOAT
likesThe number of users who have indicated that they liked the video.FLOAT
messageThe video's description.STRING
post_labelsArray of post labels for given profile and accountДобавить в маппинг: Nested (id Nullable(String),name Nullable(String))
published_timeThe date and time when the video was published.DATE
video_view_timeThe number of time the video has been viewed multiplied by duration [s].FLOAT
video_viewsThe number of times the video has been viewed.FLOAT

Квоты и лимиты

Важное примечание: Renta не предусматривает никакие ограничения, такие как количество учетных записей или временной промежуток выгрузки данных.

Лимиты SocialBakers:

  • Лимиты скорости для аккаунта и для пользователя:
    • Аккаунт: 1000 запросов в час;
    • Пользователь: 500 запросов в час.
  • Каждый запрос метрики ограничен максимальным количеством:
    • Профили: 100;
    • Метрики: 25;
    • Временной промежуток: 12 месяцев.

Ссылка на официальную документацию SocialBakers.

_______________________________________________
Если у вас есть вопросы — свяжитесь с нами!