Renta поддерживает экспорт данных из SocialBakers в следующие пункты назначения:
- Google BigQuery
- Clickhouse
- SQL Server
- Google Spreadsheets
Создание интеграции в хранилище данных (DWH)
- Перейдите в каталог интеграций;
- Выберите SocialBakers;
- Добавьте аккаунт SocialBakers, в котором находятся необходимые данные;
- Выберите добавленный аккаунт SocialBakers;
- Укажите место назначения, в которое вы хотите импортировать данные;
- Перейдите на экран настроек и установите необходимую конфигурацию:
Report type
Тип отчета — состоит из уникального набора параметров и метрик, доступных для выгрузки в DWH. Каждый тип отчета соответствует одноименному методу API SocialBakers.
Name | description |
---|---|
Profiles | Profile 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. |
Posts | The 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. Для этого:
- Установите расширение Renta Spreadsheets Add-on.
- Затем зайдите в Google Sheets, и во вкладке Tools выберите Renta, после чего нажмите кнопку Run.
После чего в правом сайдбаре откроется рабочая область с настройками интеграций. Подробная инструкция по созданию интеграции доступна по данной ссылке. Обратите внимание, что все созданные интеграции в Google Spreadsheets также доступны для управления в веб-версии Renta.
Структура данных
Name | Description | Type |
---|---|---|
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
comments | Number of comments on page posts. | FLOAT |
comments_by_ppd_status | Number of comments on page posts by paid status (organic/paid/unknown) based on PPD. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
comments_by_type | Number of comments on page posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
fans_change | Absolute change of fans count of a page. | FLOAT |
fans_lifetime | Total number of likes (=fans) of a page. | FLOAT |
interactions | Number of interactions on page posts. | FLOAT |
interactions_by_ppd_status | Number of interactions on page posts by paid status (organic/paid/unknown) based on PPD. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_by_type | Number of interactions on page posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_per_1000_fans | Number of interactions per thousand fans. | FLOAT |
interactions_per_1000_fans_by_type | Number of interactions per thousand fans by type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
page_posts | Number of page posts. | FLOAT |
page_posts_by_app | Number of page posts by application via it was posted | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
page_posts_by_ppd_status | Number of page posts by paid status (organic/paid/unknown) based on PPD. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
page_posts_by_type | Number of page posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
reactions | Number of reactions on page posts. | FLOAT |
reactions_by_ppd_status | Number of reactions on page posts by paid status (organic/paid/unknown) based on PPD. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
reactions_by_reaction_type | Number of reactions on page posts by reaction type (like, love, haha, etc...). | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
reactions_by_type | Number of reactions on page posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
shares | Number of shares on page posts. | FLOAT |
shares_by_ppd_status | Number of shares on page posts by paid status (organic/paid/unknown) based on PPD. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
shares_by_type | Number of shares on page posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
user_posts | Number of user posts. | FLOAT |
user_posts_average_response_time | Average reponse time (mins) of responded user posts. | FLOAT |
user_posts_by_app | Number of user posts by application via it was posted (any facebook app is "web"). | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
user_posts_responded | Number of user posts that are responded (at least 1 page comment). | FLOAT |
user_posts_responded_by_time | Number of responded user posts by response time category. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
user_posts_response_rate | Ratio of user posts and responded user posts. | FLOAT |
user_questions | Number of user posts that are marked as a question. | FLOAT |
user_questions_average_response_time | Average reponse time (mins) of responded user questions. | FLOAT |
user_questions_responded | Number of user posts that are marked as a question and that are responded (at least 1 page comment). | FLOAT |
user_questions_responded_by_time | Number of responded user questions by response time category. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
user_questions_response_rate | Ratio of user questions and responded user questions. | FLOAT |
insights_activity | Number of activities created about your Page. (Total Count) | FLOAT |
insights_activity_by_activity_type | Number of activities about your Page by activity type. (Total Count) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_activity_unique | Number 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_type | Number of people talking about your Page, by activity type. (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_activity_unique_by_age_gender | Number of People Talking About the Page by user age and gender (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_activity_unique_by_city | Number of People Talking About the Page by user city. (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_activity_unique_by_country | Number of People Talking About the Page by user country (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_activity_unique_by_locale | Number of People Talking About the Page by user language. (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_engaged_users | Number of people who engaged with your Page. Engagement includes any click or activity created. (Unique Users). | FLOAT |
insights_fan_adds | Number of new people who have liked your Page. | FLOAT |
insights_fan_adds_by_paid_non_paid_unique | New 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_unique | New Likes : Number of new people who have liked your Page (Unique Users) | FLOAT |
insights_fan_removes | Number of Unlikes of your Page (Total Count) | FLOAT |
insights_fan_removes_unique | Number of Unlikes of your Page (Unique Users) | FLOAT |
insights_fans_by_like_source | Breakdown 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_unique | Number 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_unique | Number 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_city | Aggregated 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_lifetime | Aggregated 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_lifetime | Number of people who have liked your Page. (Unique Users) | FLOAT |
insights_fans_lifetime_by_country | Lifetime value of number of fans grouped by country. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_fans_locale_lifetime | Aggregated 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_online | Number of people who liked your Page and when they are online (Unique Users) | FLOAT |
insights_fans_online_by_hour | Number 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_impressions | Number of impressions seen of any content associated with your Page. (Total Count) | FLOAT |
insights_impressions_by_paid_non_paid | Number 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_organic | Number 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_paid | Number of impressions of a Sponsored Story or Ad pointing to your Page. (Total Count) | FLOAT |
insights_impressions_viral | Number 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_distribution | Number 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_feedback | Number of times people have given negative feedback to your Page. (Total Count) | FLOAT |
insights_positive_feedback | Number of times people have given positive feedback to your Page. (Total Count) | FLOAT |
insights_post_clicks | Number 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_type | Number 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_unique | Number 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_type | Number 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_impressions | Number of impressions that came from all of your posts. (Total Count) | FLOAT |
insights_post_impressions_by_paid_non_paid | Number 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_distribution | Number 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_paid | Number of impressions of your Page posts in an Ad or Sponsored Story. (Total Count) | FLOAT |
insights_post_reach | Number of people who saw any of your Page posts. (Unique Users) | FLOAT |
insights_post_reach_by_paid_non_paid | Number 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_organic | Number of people who saw your Page posts in news feed or ticker, or on your Page's timeline. (Unique Users) | FLOAT |
insights_post_reach_paid | Number of people who saw your Page posts in an ad or sponsored story. (Unique Users) | FLOAT |
insights_reach | Number of people who have seen any content associated with your Page. (Unique Users) | FLOAT |
insights_reach_by_age_gender | Total Page Reach by age and gender. (Unique Users) | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_reach_by_paid_non_paid | Number 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_engagement | Number 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_organic | Number 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_paid | Number of people who saw a sponsored story or ad pointing to your Page. (Unique Users) | FLOAT |
insights_reach_viral | Number 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_reactions | Number of reactions on any of your content. | FLOAT |
insights_reactions_by_type | Number of reactions on any of your content by type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_video_complete_views_30s | Number of times page's videos have been viewed for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_autoplayed | Number of times page's autoplayed videos have been viewed for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_click_to_play | Number of times page's videos have been viewed after the user clicks on play for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_organic | Number of times page's videos have been viewed for more than 30 seconds by organic reach | FLOAT |
insights_video_complete_views_30s_repeat_views | Number of times that people replay a page's videos for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_unique | Number of times page's videos have been played for unique people for more than 30 seconds | FLOAT |
insights_video_repeat_views | Number of times that people replay a page's videos for more than 3 seconds | FLOAT |
insights_video_views | Number of times page's videos have been viewed for more than 3 seconds | FLOAT |
insights_video_views_autoplayed | Number of times page's autoplayed videos have been viewed for more than 3 seconds | FLOAT |
insights_video_views_click_to_play | Number of times page's videos have been viewed after the user clicks on play for more than 3 seconds | FLOAT |
insights_video_views_organic | Number of times page's videos have been viewed for more than 3 seconds by organic reach | FLOAT |
insights_video_views_paid | Number of times page's promoted videos have been viewed for more than 3 seconds | FLOAT |
insights_video_views_unique | Number of times page's videos have been played for unique people for more than 3 seconds | FLOAT |
insights_views | Page views (Total Count) | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
comments | Number of comments of profile posts. | FLOAT |
comments_by_image_filter | Number of comments of profile posts by used image filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
comments_by_type | Number of comments of profile posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
comments_by_video_filter | Number of comments of profile posts by used video filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
followers_change | Absolute change of followers count lifetime. | FLOAT |
followers_lifetime | Followers count - lifetime value. | FLOAT |
following_change | Absolute change of following count lifetime. | FLOAT |
following_lifetime | Following count - lifetime value. | FLOAT |
interactions | Number of interactions on page posts. | FLOAT |
interactions_by_image_filter | Number of interactions of profile posts by used image filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_by_type | Number of interactions of profile posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_by_video_filter | Number of interactions of profile posts by used video filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_per_1000_followers | Number of interactions (likes and comments) per thousand followers. | FLOAT |
interactions_per_1000_followers_by_image_filter | Number of interactions (likes and comments) per thousand followers by used image filter. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
interactions_per_1000_followers_by_type | Number 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_filter | Number of interactions (likes and comments) per thousand followers by used video filter. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
likes | Number of likes of profile posts. | FLOAT |
likes_by_image_filter | Number of likes of profile posts by used image filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
likes_by_post_type | Number of likes of profile posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
likes_by_video_filter | Number of likes of profile posts by used video filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
profile_posts | Number of profile posts. | FLOAT |
profile_posts_by_image_filter | Number of profile posts by used image filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
profile_posts_by_type | Number of profile posts by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
profile_posts_by_video_filter | Number of profile posts by used video filter of that post. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_followers_by_city_by_day | The cities of the Business Account's followers. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_followers_by_country_by_day | The countries of the Business Account's followers. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_followers_by_gender_by_age_by_day | The gender and age distribution of the Business Account's followers. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_followers_by_locale_by_day | The number of followers broken down by language preferences. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_post_engagement_by_day | Total number of likes and comments on the posts. | FLOAT |
insights_post_engagement_by_type_by_day | Total 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_day | The number of times posts have been seen. | FLOAT |
insights_post_impressions_by_type_by_day | The number of times posts have been seen, broken down by post type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_post_interactions_by_day | The 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_day | The 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_day | Total number of saves on the posts. | FLOAT |
insights_post_saves_by_type_by_day | Total 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_day | The number of times videos have been viewed. | FLOAT |
insights_post_video_views_by_type_by_day | The number of times videos have been viewed, broken down by video type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_profile_all_clicks_by_day | The number of times user clicked on a specific contact on your Business Account's profile. | FLOAT |
insights_profile_email_contacts_by_day | Total number of taps on the email link in the Business Account's profile. | FLOAT |
insights_profile_get_directions_clicks_by_day | Total number of taps on the directions link in the Business Account's profile. | FLOAT |
insights_profile_impressions_by_day | Total 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_day | Total number of taps on the call link in the Business Account's profile. | FLOAT |
insights_profile_reach_by_day | Unique 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_day | Total number of taps on the text message link in the Business Account's profile. | FLOAT |
insights_profile_views_by_day | Total number of unique users who have viewed the Business Account's profile. | FLOAT |
insights_profile_website_clicks_by_day | Total number of taps on the website link in the Business Account's profile. | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
ff_ratio | Absolute change of following count lifetime. | FLOAT |
followers_change | Absolute change of followers count lifetime. | FLOAT |
followers_lifetime | Followers count - lifetime value. | FLOAT |
following_change | Absolute change of following count lifetime. | FLOAT |
following_lifetime | Following count - lifetime value. | FLOAT |
incoming | Number of all incoming activities (mentions + retweets + replies) created by others mentioning this profile. | FLOAT |
incoming_questions | Number of user tweets that are also marked as a question. | FLOAT |
incoming_questions_average_response_time | Average reponse time (mins) of responded user questions. | FLOAT |
incoming_questions_responded | Number of user tweets that are marked as a question and that are responded (profile reply). | FLOAT |
incoming_questions_responded_by_time | Number of responded user questions by response time category. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
incoming_questions_response_rate | Ratio of user questions and responded user questions. | FLOAT |
incoming_replies | Number of replies made by others. | FLOAT |
incoming_retweets | Number of retweets made by others. | FLOAT |
incoming_tweets | Number of user tweets. User tweet is considered any incoming activity (mention, reply), exluding retweets. | FLOAT |
incoming_tweets_average_response_time | Average reponse time (mins) of responded user tweets. | FLOAT |
incoming_tweets_responded | Number of user tweets that are responded (profile reply). | FLOAT |
incoming_tweets_responded_by_time | Number of responded user tweets by response time category. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
incoming_tweets_response_rate | Ratio of user tweets and responded user tweets. | FLOAT |
interactions | Number of interactions on page posts. | FLOAT |
interactions_per_1000_followers | Number of interactions per thousand followers. | FLOAT |
likes | Number of likes on profile tweets and replies. | FLOAT |
listed_change | Absolute change of listed count lifetime. | FLOAT |
listed_lifetime | Listed count - lifetime value (how many times profile has been listed). | FLOAT |
profile_activities | Number of all activities (tweets + retweets + replies) created by the profile. | FLOAT |
profile_activities_by_app | Number of all activities posted by profile by application via it was posted. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
profile_replies | Number of replies made by profile. | FLOAT |
profile_retweets | Number of retweets made by profile. | FLOAT |
profile_tweets | Number of tweets made by profile. | FLOAT |
replies | Number of replies on profile tweets and replies. | FLOAT |
retweets | Number of retweets on profile tweets and replies. | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
comments_change | Absolute change of comments count on uploaded videos. | FLOAT |
dislikes_change | Absolute change of dislikes count on uploaded videos. | FLOAT |
interaction_change | Absolute change of interactions (likes + dislikes + comments) count on uploaded videos. | FLOAT |
interactions_per_1000_subscribers | Number of interactions per thousand subscribers. | FLOAT |
likes_change | Absolute change of likes count on uploaded videos. | FLOAT |
subscribers_change | Absolute change of subscribers count lifetime. | FLOAT |
subscribers_count_lifetime | Subscribers count - lifetime value. | FLOAT |
video_change | Absolute change of videos count lifetime. | FLOAT |
video_count_lifetime | Video count - lifetime value. | FLOAT |
viewed_time_change | Absolute 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_lifetime | Viewed 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_change | Absolute change of views count lifetime. | FLOAT |
views_count_lifetime | Views count of all uploaded videos - lifetime value. | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
boards_change | Absolute change of boards count lifetime. | FLOAT |
boards_lifetime | Boards count - lifetime value. | FLOAT |
comments | Number of comments on profile pins. | FLOAT |
followers_change | Absolute change of followers count lifetime. | FLOAT |
followers_lifetime | Followers count - lifetime value. | FLOAT |
following_change | Absolute change of following count lifetime. | FLOAT |
following_lifetime | Following count - lifetime value. | FLOAT |
interactions | Number of interactions on page posts. | FLOAT |
likes | Number of likes on profile pins. | FLOAT |
pins_change | Absolute change of pins count lifetime. | FLOAT |
pins_lifetime | Pins count - lifetime value | FLOAT |
repins | Number of repins on profile pins. | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
attachments | Details about post attachments | Добавить в маппинг: Nested (title Nullable(String),description Nullable(String),url Nullable(String),image_url Nullable(String)) |
comments | Facebook post comments count. | FLOAT |
created_time | Facebook post created time. | DATE |
id | Facebook post id. | STRING |
interactions | Sum of reactions, comments and shares. | FLOAT |
is_published | Is post published | BIT |
message | Facebook post contents. | STRING |
page_id | Facebook page id for the published post. | STRING |
post_labels | Array of post labels for given post and account | Добавить в маппинг: Nested (id Nullable(String),name Nullable(String)) |
ppd_status | Indicates whether the post was organic, paid or unknown based on PPD algorithm. | STRING |
reactions | Facebook post reactions count. | FLOAT |
reactions_by_type | Object containing Facebook post reactions number. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
shares | Facebook post share count. | FLOAT |
story | Text 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 |
type | Facebook post type. | STRING |
universal_video_id | The publishers asset management code for this video. Only available in case the post type is a video. | STRING |
url | Link to facebook post. | STRING |
video_id | The id of the video object. Only available in case the post type is a video. | STRING |
video_length | Duration of the video in seconds. Only available in case the post type is a video. | FLOAT |
insights_engaged_fan | People who have liked your page and engaged with your post. | FLOAT |
insights_engaged_users | The number of people who clicked anywhere in your posts | FLOAT |
insights_engagement_rate | Reach 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_impressions | The number of impressions for your Page post | FLOAT |
insights_impressions_by_paid_non_paid | The number of impressions for your Page post, broken down by total, paid, and non-paid | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_impressions_fan | The number of impressions for your Page post by people who have liked your Page | FLOAT |
insights_impressions_fan_paid | The number of impressions for your Page post by people who like your Page in an Ad or Sponsored Story | FLOAT |
insights_impressions_organic | The number of impressions of your post in Newsfeed, Ticker, or on your Page's Wall | FLOAT |
insights_impressions_paid | The number of impressions for your Page post in an Ad or Sponsored Story | FLOAT |
insights_negative_feedback | The number of times people took a negative action in your post (e.g. hid it) | FLOAT |
insights_negative_feedback_unique | The number of people who took a negative action in your post (e.g., hid it) | FLOAT |
insights_paid_status | Whether the post has been promoted (received any paid impression) or not | STRING |
insights_post_clicks | The number of times people clicked on anywhere in your posts without generating an activity | FLOAT |
insights_post_clicks_by_type | The 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_unique | The 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_unique | The number of people who clicked anywhere in your post without generating an activity. | FLOAT |
insights_reach | The number of people who saw your Page post | FLOAT |
insights_reach_by_paid_non_paid | The 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_fan | The number of people who have like your Page who saw your Page post | FLOAT |
insights_reach_fan_paid | The number of people who have like your Page and saw your Page post in an Ad or Sponsored Story | FLOAT |
insights_reach_organic | The number of people who saw your post in their Newsfeed or Ticker or on your Page's Wall | FLOAT |
insights_reach_paid | The number of people who saw your Page post in an Ad or Sponsored Story | FLOAT |
insights_reactions_by_type_total | The number of reactions to a Page's post by reaction type. | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_reactions_like_total | The number of "like" reactions to a post. | FLOAT |
insights_stories | The number of stories created about your Page (Stories) | FLOAT |
insights_story_adds | The number of stories generated about your Page post. | FLOAT |
insights_storytellers | The 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 Place | FLOAT |
insights_video_avg_time_watched | The average length of time (in milliseconds) people spent viewing your video | FLOAT |
insights_video_complete_views_30s | Total number of times Page's videos have been viewed for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_autoplayed | Total number of times Page's autoplayed videos have been viewed to the end, or viewed for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_clicked_to_play | Total number of times Page's videos have been viewed to the end, or viewed after the user clicks on play for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_organic | Total number of times Page's videos have been viewed to the end, or viewed for more than 30 seconds by organic reach | FLOAT |
insights_video_complete_views_30s_paid | Total number of times Page's promoted videos have been viewed to the end, or for more than 30 seconds | FLOAT |
insights_video_complete_views_30s_unique | Total number of times Page's videos have been played for unique people to the end, or viewed for more than 30 seconds | FLOAT |
insights_video_complete_views_organic | The number of times your video was organically viewed from the beginning to 95% of its length | FLOAT |
insights_video_complete_views_organic_unique | The number of people who viewed your video organically from the beginning to 95% of its length | FLOAT |
insights_video_complete_views_paid | The number of times your video was viewed via paid impression from the beginning to 95% of its length | FLOAT |
insights_video_complete_views_paid_unique | The number of people who viewed your video via paid impression from the beginning to 95% of its length | FLOAT |
insights_video_retention_graph | Percentage 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_autoplayed | Percentage 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_time | The 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_gender | The 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_id | The total number of minutes your video played for your Top 45 Locations - Countries | Добавить в маппинг: Nested (name Nullable(String),value Nullable(float)) |
insights_video_view_time_organic | Total time (in milliseconds) video has been viewed without paid promotion | FLOAT |
insights_video_view_time_paid | Total time (in milliseconds) video has been viewed with paid promotion | FLOAT |
insights_video_views | The 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_autoplayed | Number of times your video started automatically playing and people viewed it for more than 3 seconds | FLOAT |
insights_video_views_clicked_to_play | Number of times people clicked to play your video and viewed it more than 3 seconds | FLOAT |
insights_video_views_organic | The number of times your video was organically viewed for 3 seconds or more | FLOAT |
insights_video_views_organic_unique | The number of people who viewed at least 3 seconds of your video organically | FLOAT |
insights_video_views_paid | The number of times your video was viewed via paid impression for 3 seconds or more | FLOAT |
insights_video_views_paid_unique | The number of people who viewed at least 3 seconds of your video via paid impression | FLOAT |
insights_video_views_unique | The number of distinct people who viewed your video at least once. | FLOAT |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
attachments | Details about post attachments | Добавить в маппинг: Nested (url Nullable(String)) |
comments | Total number of comments on the media object. | FLOAT |
created_time | Instagram media created time. | DATE |
id | Instagram media ID. | STRING |
interactions | Sum of reactions, comments and shares. | FLOAT |
likes | Total number of likes on the media object. | FLOAT |
message | Instagram media contents. | STRING |
post_labels | Array of post labels for given post and account | Добавить в маппинг: Nested (id Nullable(String),name Nullable(String)) |
type | Media post type. | STRING |
url | Link to instagram post. | STRING |
insights_engagement | Total number of likes and comments on the media object. | FLOAT |
insights_impressions | Total number of times the media object has been seen. | FLOAT |
insights_reach | Total number of unique accounts that have seen the media object. | FLOAT |
insights_saved | Total 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 |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
created_time | Tweet created time. | DATE |
id | Tweet id. | STRING |
post_labels | Array of tweet labels for given tweet and account | Добавить в маппинг: Nested (id Nullable(String),name Nullable(String)) |
date | Date | DATE |
profile_id | Id of profile | STRING |
profile_profileName | Name of profile | STRING |
profile_timezone | Timezone of profile | STRING |
comments | The number of comments for the video. | FLOAT |
created_time | Date and time the video was uploaded on Youtube. | DATE |
dislikes | The number of users who have indicated that they disliked the video. | FLOAT |
duration | The length of the video [s]. | FLOAT |
id | Youtube video id. | STRING |
interactions | The sum of Likes, Dislikes, Shares and Comments. | FLOAT |
likes | The number of users who have indicated that they liked the video. | FLOAT |
message | The video's description. | STRING |
post_labels | Array of post labels for given profile and account | Добавить в маппинг: Nested (id Nullable(String),name Nullable(String)) |
published_time | The date and time when the video was published. | DATE |
video_view_time | The number of time the video has been viewed multiplied by duration [s]. | FLOAT |
video_views | The number of times the video has been viewed. | FLOAT |
Квоты и лимиты
Важное примечание: Renta не предусматривает никакие ограничения, такие как количество учетных записей или временной промежуток выгрузки данных.
Лимиты SocialBakers:
- Лимиты скорости для аккаунта и для пользователя:
- Аккаунт: 1000 запросов в час;
- Пользователь: 500 запросов в час.
- Каждый запрос метрики ограничен максимальным количеством:
- Профили: 100;
- Метрики: 25;
- Временной промежуток: 12 месяцев.
Ссылка на официальную документацию SocialBakers.
Если у вас есть вопросы — свяжитесь с нами!