SocialBakers Source

Renta supports data export from SocialBakers to following destinations:

  • Google BigQuery
  • Clickhouse
  • SQL Server
  • Google Spreadsheets

Integration creating in data warehouse (DWH)

  1. Go to integrations catalog;
  2. Select SocialBakers;
  3. Add a SocialBakers account that has the necessary data;
  4. Choose the added SocialBakers account;
  5. Specify the destination you want to import the data into;
  6. Go to the settings screen and set necessary configuration:

Report type

Report type consists of the unique set of parameters and metrics available for uploading to DWH. Each Report Type has its own parameters and metrics collection.

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

Parameters contains the list of parameters and metrics available for export. Specify the parameters required for uploading.

As a result, Renta will create the table that will contain the selected parameters data. The order of the selected parameters in the Rentas interface will match to the order of the table columns.

Profiles

The account that has necessary data in its private office.

Date range type

Choose the inserting period. You can specify any historical time interval.

To select the necessary time, enter the date from which you want to start uploading data in the “From” field, then enter the end date in the “To” field.

If you want the data in the table to be updated daily and supplemented with new days, then enter “Yesterday” in the “To” field.

Detailed instructions for working with a date range.

Integration name

There is an auto generated name for your integration and here you can edit it as much as you like.

Both Cyrillic and Latin are permitted, but not more than 100 symbols.

The integration name is displayed on the Integration List page.

Table name

There is an auto generated name for your table and here you can edit it as much as you like.

Only Latin is permitted, numbers and “_” symbol.

Update time

You can specify any update time that you need. Users choose early morning integration updates most often, for example 5 AM.

In that case your integration will update in period from 5 AM to 6 AM.

Integrations are updating according to the time zone selected in your profile settings.

Overwrite period

Data overwrite period is a retrospective update of data for the selected period.

For instance you choose the overwrite period “Last 7 days” – it means that all data for the last 7 days will be deleted and inserted once again with updated data.

Note: this tab appears only if parameters like Day/Date/Time Period etc have been chosen.

Integration creating in Google Spreadsheets

Take advantage of the free extension available in the Google Workspace Marketplace. In order to do it:

  1. Install the extension Renta Spreadsheets Add-on.
  2. Then go to Google Sheets and in the Tools tab select Renta
  3. Press the Run button.

After that a workspace with integration settings will open in the right sidebar. Detailed instructions for creating an integration are available at this link. Please note that all integrations created in Google Spreadsheets are also available for management in the web version of Renta.

Data Structure

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

Quotes and limits

Important note: Renta doesn’t provide any restrictions like amount of accounts, connectors, integrations or inserting date range.

Limits for SocialBakers:

  • Rate limits are defined for account and for user:
    • Account: 1000 requests per hour
    • User: 500 requests per hour
  • Each metrics request is limited by maximum number of:
    • Profiles: 100
    • Metrics: 25
    • Date range: 12 months

Link to the official documentation

_______________________________________________
If you have any questions – please contact us!