API documentation
Introduction
The quintly API is made for you to access all data points you already know from our tool. You need to have a quintly business account in order to access this API. Please get in touch with our support if you like to get access.
Authentication
For authentication we use Basic Auth via HTTPS. For the username you have to send your quintly client id and for the password your API secret. If you don't have these details yet, please get in touch with our support.
Managing your profiles
There is full support to list, add and remove profiles within your account via the API.
Please use the following endpoint for listing all profiles within your account. Here you can also obtain the profile ids necessary to fetch data later on.
For adding profiles, please specify the space id (which you'll get from our support team once access to our API is granted), and a unique URL for the profile to be added. Usually you will use the search endpoint described below to identify the unique URL of a profile.
To remove an existing profile from your account, just provide the space id and the profile id (which can be obtained via the list-profiles endpoint described above).
Usually before adding a new profile you will need to uniquely identify a profile. For this use case and also to search profiles via all the search endpoints of the networks itself, you can use the following endpoint for search.
Fetching data
Loading data is handled via the qql endpoint and the following parameters have to be provided. Please find further information on how to write QQL queries in our knowledge base.
- qqlQuery: The QQL query describing the data to be loaded.
- startTime: The beginning of the period you want to get the data for in format YYYY-MM-DD
- endTime: The end of the period you want to get the data for in format YYYY-MM-DD
- interval: The aggregation interval used for the analysis (daily, weekly, monthly, yearly, total)
- timezone (optional): By default our API does fetch and aggregate data using the timezone setting of the admin user of your quintly account. Optionally you can set a specific timezone. The list of supported timezones can be found here. E.g. for fetching data in UTC timezone just use "UTC" here.
- profileIds: A comma-separated list of profile ids (you can find the id of a profile by using the list-profiles endpoint described above). You can only fetch data for profiles added to your quintly account.
Example requests
Fetching the number of Page Likes for Facebook Pages
Response format
The response will be sent in JSON format. Here is a sample response for the example right above:
Error Handling
If something goes wrong, the HTTP status code returned will be unequal to 200, using 4xx for client-side errors, 5xx for server-side errors. Beside the status code the following JSON response will be sent. If success is equal to false you can always expect error and error->message to be set.
Rate limits
So far rate limits have been set very loose and you should not hit any limits at all.
Data sources are represented by tables you can use within your QQL queries. Below you can find all available data tables and their columns. Just click the respective table name to get further information and see the table schema.
Holding public data for Facebook Pages and their development over time. All numbers are aggregates across the whole Facebook Page.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansLocal | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold an approximate number of Page Likes for the specific child Facebook Page at the end of the interval (e.g. for a certain country child Page). |
| fansLocalBefore | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold an approximate number of Page Likes for the specific child Facebook Page at the beginning of the interval (e.g. for a certain country child Page). |
| fansLocalChange | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold an approximate number of the change of Page Likes for the specific child Facebook Page between the beginning and the end of the interval. (e.g. for a certain country child Page). |
| fansGlobal | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold the total number of Page Likes for the overall Global Page at the end of the interval. |
| fansGlobalBefore | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold the total number of Page Likes for the overall Global Page at the beginning of the interval. |
| fansGlobalChange | NUMERIC | In case of Facebook Pages being part of a Global Page this column will hold the change of total number of Page Likes for the overall Global Page between the beginning and the end of the interval. |
| checkins | NUMERIC | Total number of checkins at a place represented by a Facebook Page, at the end of the interval. Only available if checkin functionality is enabled for the Facebook Page. |
| checkinsBefore | NUMERIC | Total number of checkins at a place represented by a Facebook Page, at the beginning of the interval. Only available if checkin functionality is enabled for the Facebook Page. |
| checkinsChange | NUMERIC | Change of the total number of checkins at a place represented by a Facebook Page, between the beginning and the end of the interval. Only available if checkin functionality is enabled for the Facebook Page. |
| peopleTalkingAbout | NUMERIC | Total number of people talking about this Facebook Page at the end of the interval. |
| peopleTalkingAboutBefore | NUMERIC | Total number of people talking about this Facebook Page at the beginning of the interval. |
| peopleTalkingAboutChange | NUMERIC | Change of the total number of people talking about this Facebook Page between the beginning and the end of the interval. |
| peopleTalkingAboutAverage | NUMERIC | Average of the total number of people talking about this Facebook Page between the beginning and the end of the interval. |
| peopleTalkingAboutAverageRate | NUMERIC | Average of the total number of people talking about this Facebook Page between the beginning and the end of the interval divided by the number of total Page Likes. |
| ownPosts | NUMERIC | Number of new posts by the Facebook Page in the current interval. |
| ownPostsComments | NUMERIC | Total number of comments on new posts created within the current interval. |
| ownPostsLikes | NUMERIC | Total number of Like reactions on new posts created within the current interval. |
| ownPostsLove | NUMERIC | Total number of Love reactions on new posts created within the current interval. |
| ownPostsWow | NUMERIC | Total number of Wow reactions on new posts created within the current interval. |
| ownPostsHaha | NUMERIC | Total number of Haha reactions on new posts created within the current interval. |
| ownPostsSad | NUMERIC | Total number of Sad reactions on new posts created within the current interval. |
| ownPostsAngry | NUMERIC | Total number of Angry reactions on new posts created within the current interval. |
| ownPostsShares | NUMERIC | Total number of shares on new posts created within the current interval. |
| ownPostsTypeLink | NUMERIC | Number of new posts of type Link (holding a link attachment) by the Facebook Page in the current interval. |
| ownPostsTypeMusic | NUMERIC | Number of new posts of type Music by the Facebook Page in the current interval. This column is deprecated and won't show values for newer posts. |
| ownPostsTypePhoto | NUMERIC | Number of new posts of type Photo (holding a photo attachment) by the Facebook Page in the current interval. |
| ownPostsTypeStatus | NUMERIC | Number of new posts of type Status (text only) by the Facebook Page in the current interval. |
| ownPostsTypeFlash | NUMERIC | Number of new posts of type Flash by the Facebook Page in the current interval. This column is deprecated and won't show values for newer posts. |
| ownPostsTypeVideo | NUMERIC | Number of new posts of type Video (holding a video attachment) by the Facebook Page in the current interval. |
| ownPostsTypeMisc | NUMERIC | Number of new posts of all other types by the Facebook Page in the current interval. |
| userPosts | NUMERIC | Number of user posts on the Facebook Page's timeline in the current interval. |
| userPostsComments | NUMERIC | Total number of comments on user posts on the Facebook Page's timeline within the current interval. |
| userPostsLikes | NUMERIC | Total number of Like reactions on user posts on the Facebook Page's timeline within the current interval. |
| userPostsShares | NUMERIC | Total number of shares on user posts on the Facebook Page's timeline within the current interval. |
| userPostsTypeLink | NUMERIC | Number of user posts of type Link on the Facebook Page's timeline (holding a link attachment) in the current interval. |
| userPostsTypeMusic | NUMERIC | Number of user posts of type Music on the Facebook Page's timeline in the current interval. This column is deprecated and won't show values for newer posts. |
| userPostsTypePhoto | NUMERIC | Number of user posts of type Photo (holding a photo attachment) on the Facebook Page's timeline in the current interval. |
| userPostsTypeStatus | NUMERIC | Number of user posts of type Status (text only) on the Facebook Page's timeline in the current interval. |
| userPostsTypeFlash | NUMERIC | Number of user posts of type Flash on the Facebook Page's timeline in the current interval. This column is deprecated and won't show values for newer posts. |
| userPostsTypeVideo | NUMERIC | Number of user posts of type Video (holding a video attachment) on the Facebook Page's timeline in the current interval. |
| userPostsTypeMisc | NUMERIC | Number of user posts of all other types on the Facebook Page's timeline in the current interval. |
| questions | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question in the current interval. A post qualifies as a question if it includes a question mark. |
| responseTime0To2h | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question answered within 2 hours by the Facebook Page by commenting on this post. |
| responseTime2To8h | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question answered between 2 and 8 hours by the Facebook Page by commenting on this post. |
| responseTime8To24h | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question answered between 8 and 24 hours by the Facebook Page by commenting on this post. |
| responseTimeLongerThan24h | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question answered later than 24 hours by the Facebook Page by commenting on this post. |
| responseTimeNotResponded | NUMERIC | Number of user posts on the Facebook Page's timeline identified as a question never answered by the Facebook Page. |
facebookAdsPostAds
Holding information about promoted posts from Facebook Ads.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| accountId | TEXT | The ID of the ad account with which the ad was published. |
| currency | TEXT | The currency by which all costs under the Facebook ad account are specified. |
| campaignId | NUMERIC | The ID of the ad campaign to which the ad belongs. |
| campaignName | TEXT | The name of the ad campaign to which the ad belongs. |
| campaignObjective | TEXT | The defined objective of the ad campaign to which the ad belongs. |
| campaignStatus | TEXT | The status of the ad campaign to which the ad belongs. |
| updatedTime | TEXT | Updated time |
| adSetScheduleStartTime | TEXT | The scheduled start time of the ad set to which the ad belongs. |
| adSetScheduleEndTime | TEXT | The scheduled end time of the ad set to which the ad belongs. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. In this case, this field refers to the creation time of the ad set to which the ad belongs. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| adSetId | NUMERIC | The ID of the ad set to which the ad belongs. |
| adSetName | TEXT | The name of the ad set to which the ad belongs. |
| adSetBillingEvent | TEXT | The billing event of the ad set to which the ad belongs. A billing event refers to the event that triggers charging the ad account (e.g. post engagements, video views, etc.). |
| adSetOptimizationGoal | TEXT | The optimization goal of the ad set to which the ad belongs. |
| adSetStatus | TEXT | The status of the ad set to which the ad belongs. |
| adSetCreatedTime | TEXT | The time the adset was created in "Y/m/d H:i:s" format and UTC timezone. |
| id | NUMERIC | The ID of the ad. |
| name | TEXT | The name of the ad. |
| status | TEXT | The effective status of the ad. |
| adStatus | TEXT | The status of the ad. |
| bidType | TEXT | The bidding type of the ad (e.g. CPA, Absolute OCPM, etc.). |
| isOrganicPost | NUMERIC | Yields "1" if the post of this ad is a promoted post, which could also appear on the page's timeline, and an empty string otherwise (also known as a "Dark Post", which is visible only in a promoted manner). |
| postId | TEXT | The ID of the post that's being presented with the ad. |
| message | TEXT | The contents of the post's body. |
| postType | TEXT | The type of the post that's presented with the ad. |
| thumbnailUrl | TEXT | The ad's thumbnail URL. |
| link | TEXT | The link to the ad's post |
| spend | NUMERIC | The estimated total amount of money spent on an ad during its schedule. |
| socialSpend | NUMERIC | The total amount spent on ads showed with social information (e.g. John Doe likes this). |
| isPublishedOnFacebook | TEXT | Yields "1" if the post of this ad was published on Facebook, and an empty string otherwise. |
| isPublishedOnInstagram | TEXT | Yields "1" if the post of this ad was published on Instagram, and an empty string otherwise. |
| targetedPlatforms | TEXT | Describes which are the targeted platforms of this ad. |
| targetingSummary | TEXT | A summary of the ad's targeting settings, that may include location, age and language targeting. |
| targetingLocation | TEXT | The ad's target user locations |
| targetingLivingIn | TEXT | The ad's target user countries of residence |
| targetingAge | TEXT | The ad's target user ages |
| targetingLanguage | TEXT | The ad's targeted user languages |
| targetingExclude | TEXT | The ad's excluded matches (e.g. excluded interests) |
| targetingPeopleWhoMatch | TEXT | The ad's targeted users (e.g. interests) |
| targetingConnections | TEXT | The ad's target connections (e.g. people who liked the page already) |
| targetingCustomAudience | TEXT | The ad's custom audience targeting |
| targetingPlacements | TEXT | The Ad's placements (e.g. news feed on desktop computers) |
| frequency | NUMERIC | The average number of times each person saw the ad. |
| impressions | NUMERIC | The number of times the ad was on screen. |
| clicks | NUMERIC | The number of clicks on the ads. |
| reach | NUMERIC | The number of people who saw the ad at least once. Reach is different from impressions, which may include multiple views of the ad by the same people. |
| unique_clicks | NUMERIC | The distinct number of people who clicked on the ad. |
| unique_social_clicks | NUMERIC | The number of people who clicked on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad. |
| total_unique_actions | NUMERIC | The number of people who took an action that was attributed to the ad. |
| total_actions | NUMERIC | The total number of actions people took that are attributed to an ad. Actions may include engagement, clicks or conversions. |
| social_clicks | NUMERIC | The number of clicks on the ad when it was displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad. |
| social_reach | NUMERIC | The number of people who saw the ad when displayed with social information, which shows other Facebook friends who engaged with the Facebook Page or ad. |
| social_impressions | NUMERIC | The number of times the ad was viewed when displayed with social information, which shows Facebook friends who engaged with the Facebook Page or ad. |
| unique_inline_link_clicks | NUMERIC | The number of people who performed an inline link click. |
| relevance_score | NUMERIC | A rating from 1 to 10 that estimates how well the ad's target audience is responding to the ad. This score is shown after the ad receives more than 500 impressions. |
| relevance_score_positive_feedback | TEXT | A score based on the number of times people performed actions that fulfil the targets of the ad (e.g. app installs, clicks, video views, etc.). |
| relevance_score_negative_feedback | TEXT | A score based on the number of times people hid the ad or chose not to see ads from the page. The ad's negative feedback level can be low, medium or high. If the ad gets a lot of negative feedback, it means people have indicated they don't want to see it anymore. |
| cpm | NUMERIC | The average cost for 1000 impressions of the ad. |
| cpp | NUMERIC | The average cost to reach 1000 people with the ad. |
| cpc | NUMERIC | The average cost for each click on the ad. |
| uniqueCpc | NUMERIC | The average cost for each unique click. |
| website_purchase_roas | NUMERIC | The total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on the website and attributed to the ads. |
| ctr | NUMERIC | The percentage of times people saw the ad and performed a click. |
| unique_ctr | NUMERIC | The percentage of people who saw the ad and performed a unique click. |
| unique_link_clicks_ctr | NUMERIC | The percentage of people who saw the ad and performed a link click. |
| unique_outbound_clicks_ctr | NUMERIC | TThe percentage of people who saw the ad and performed an outbound click. |
| outbound_clicks_ctr | NUMERIC | The percentage of times people saw the ad and performed an outbound click. |
| website_ctr | NUMERIC | The percentage of times people saw the ad and performed a link click. |
| inline_link_click_ctr | NUMERIC | The percentage of time people saw the ads and performed an inline link click. |
| unique_inline_link_click_ctr | NUMERIC | The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window. |
| page_engagement_unique | NUMERIC | The number of people who engaged with the Facebook Page through the ad. |
| post_engagement_unique | NUMERIC | The number of people who engaged with the ad. |
| likes | NUMERIC | The number of likes performed on the page through the ad. |
| comments | NUMERIC | The number of comments left on the post through the ad. |
| video_view_unique | NUMERIC | The number of people who viewed the video through the ad (when relevant). |
| link_click_unique | NUMERIC | The number of people who clicked on a link through the ad (when relevant). |
| landing_page_view_unique | NUMERIC | The number of people who viewed a landing page through the ad (when relevant). |
| photo_view_unique | NUMERIC | The number of people who viewed the photo through the ad (when relevant). |
| post_reaction_unique | NUMERIC | The number of Facebook reactions on the post through the ad. |
| post_unique | NUMERIC | The number of people who shared the post through the ad. |
| mobile_app_install_unique | NUMERIC | The number of people who installed the mobile app through the ad. |
| costPerPageEngagement | NUMERIC | The average cost per engagement with the Facebook Page through the ad. |
| costPerPostEngagement | NUMERIC | The average cost per engagement with the ad. |
| costPerLike | NUMERIC | The average cost per like on the page through the ad. |
| costPerComment | NUMERIC | The average cost per comment left on the post through the ad. |
| costPerVideoView | NUMERIC | The average cost per video view through the ad (when relevant). |
| costPerLinkClick | NUMERIC | The average cost per link click through the ad (when relevant). |
| costPerLandingPageView | NUMERIC | The average cost per landing page view through the ad (when relevant). |
| costPerPhotoView | NUMERIC | The average cost per photo view through the ad (when relevant). |
| costPerPostReaction | NUMERIC | The average cost per Facebook reaction on the post through the ad. |
| costPerPost | NUMERIC | The average cost per share of the post through the ad. |
| costPerMobileAppInstall | NUMERIC | The average cost per mobile app installation through the ad. |
| costPerUniquePageEngagement | NUMERIC | The average cost per unique engagement with the Facebook Page through the ad. |
| costPerUniquePostEngagement | NUMERIC | The average cost per unique engagement with the ad. |
| costPerUniqueLike | NUMERIC | The average cost per like on the post through the ad. |
| costPerUniqueComment | NUMERIC | The average cost per comment left on the post through the ad. |
| costPerUniqueVideoView | NUMERIC | The average cost per unique video view through the ad (when relevant). |
| costPerUniqueLinkClick | NUMERIC | The average cost per unique link click through the ad (when relevant). |
| costPerUniqueLandingPageView | NUMERIC | The average cost per unique landing page view through the ad (when relevant). |
| costPerUniquePhotoView | NUMERIC | The average cost per unique photo view through the ad (when relevant). |
| costPerUniquePostReaction | NUMERIC | The average cost per Facebook reaction on the post through the ad. |
| costPerUniquePost | NUMERIC | The average cost per unique share of the post through the ad. |
| costPerUniqueMobileAppInstall | NUMERIC | The average cost per unique mobile app installation through the ad. |
facebookComments
Holding all public comments on posts of Facebook Pages.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| userName | TEXT | The name of the author. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| message | TEXT | The main content of this comment (not including attachments). |
| link | TEXT | A link to this comment on Facebook. |
| externalId | TEXT | The ID of this comment provided by Facebook. |
| externalPostId | TEXT | The ID of the post this comment belongs to provided by Facebook. |
facebookFansByCountry
Holding the number of Page Likes of Facebook Pages per country including their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| countryCode | TEXT | The code of the country following ISO 3166 standard. |
| countryName | TEXT | The full name of the country, e.g. Germany. |
| fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | NUMERIC | The share of Page Likes for this entry in relation to all Page Likes for this Facebook Page at the end of the interval represented as a percentage (0-100 scale). |
facebookInsights
Holding private-level data for Facebook Pages from Facebook Insights and their development over time. All numbers are aggregates across the whole Facebook Page. Please note that Facebook Insights provide data for only three different intervals: daily, weekly and 28 days and thus for unique metrics like Reach one cannot go beyond 28 day analysis.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| page_stories | NUMERIC | Number of stories created about your Page within the current interval. |
| page_stories_day | NUMERIC | No documentation available yet |
| page_stories_week | NUMERIC | No documentation available yet |
| page_stories_days_28 | NUMERIC | No documentation available yet |
| page_impressions | NUMERIC | Number of impressions seen of any content associated with the Facebook Page within the current interval. |
| page_impressions_day | NUMERIC | No documentation available yet |
| page_impressions_week | NUMERIC | No documentation available yet |
| page_impressions_days_28 | NUMERIC | No documentation available yet |
| page_impressions_paid | NUMERIC | Number of impressions of a Sponsored Story or Ad pointing to your Page within the current interval. |
| page_impressions_paid_day | NUMERIC | No documentation available yet |
| page_impressions_paid_week | NUMERIC | No documentation available yet |
| page_impressions_paid_days_28 | NUMERIC | No documentation available yet |
| page_impressions_organic | NUMERIC | Number of impressions seen of any unpaid content associated with the Facebook Page within the current interval. |
| page_impressions_organic_day | NUMERIC | No documentation available yet |
| page_impressions_organic_week | NUMERIC | No documentation available yet |
| page_impressions_organic_days_28 | NUMERIC | No documentation available yet |
| page_impressions_unique | NUMERIC | Number of people who have seen any content associated with your Page within the current interval. This is also known as reach. |
| page_impressions_unique_day | NUMERIC | No documentation available yet |
| page_impressions_unique_week | NUMERIC | No documentation available yet |
| page_impressions_unique_days_28 | NUMERIC | No documentation available yet |
| page_impressions_paid_unique | NUMERIC | Number of people who saw a sponsored story or ad pointing to your Page within the current interval. This is also known as paid reach. |
| page_impressions_paid_unique_day | NUMERIC | No documentation available yet |
| page_impressions_paid_unique_week | NUMERIC | No documentation available yet |
| page_impressions_paid_unique_days_28 | NUMERIC | No documentation available yet |
| page_impressions_organic_unique | NUMERIC | Number of people who have seen any unpaid content associated with the Facebook Page within the current interval. This is also known as organic reach. |
| page_impressions_organic_unique_day | NUMERIC | No documentation available yet |
| page_impressions_organic_unique_week | NUMERIC | No documentation available yet |
| page_impressions_organic_unique_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_unique | NUMERIC | Number of people who saw any of the Page's posts within the current interval. |
| page_posts_impressions_unique_day | NUMERIC | No documentation available yet |
| page_posts_impressions_unique_week | NUMERIC | No documentation available yet |
| page_posts_impressions_unique_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_paid_unique | NUMERIC | Number of people who saw your Page's posts in an ad or sponsored story within the current interval. |
| page_posts_impressions_paid_unique_day | NUMERIC | No documentation available yet |
| page_posts_impressions_paid_unique_week | NUMERIC | No documentation available yet |
| page_posts_impressions_paid_unique_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_organic | NUMERIC | The number of times the Page's posts entered a person's screen through unpaid distribution within the current interval. |
| page_posts_impressions_organic_day | NUMERIC | No documentation available yet |
| page_posts_impressions_organic_week | NUMERIC | No documentation available yet |
| page_posts_impressions_organic_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_organic_unique | NUMERIC | The number of people who had any of the Page's posts enter their screen through unpaid distribution within the current interval. |
| page_posts_impressions_organic_unique_day | NUMERIC | No documentation available yet |
| page_posts_impressions_organic_unique_week | NUMERIC | No documentation available yet |
| page_posts_impressions_organic_unique_days_28 | NUMERIC | No documentation available yet |
| page_impressions_viral | NUMERIC | Number of impressions of a story published by a friend about the Facebook Page within the current interval. These stories include liking the Facebook Page, posting to the Page's Wall, liking, commenting on or sharing one of the Page posts, answering a Question the Page posted, RSVPing to one of the Page's events, mentioning the Page, phototagging the Page or checking in at the Page's Place. |
| page_impressions_viral_day | NUMERIC | No documentation available yet |
| page_impressions_viral_week | NUMERIC | No documentation available yet |
| page_impressions_viral_days_28 | NUMERIC | No documentation available yet |
| page_impressions_viral_unique | NUMERIC | Number of people who saw the Facebook Page or one of its posts from a story shared by a friend within the current interval. These stories include liking the Facebook Page, posting to the Page's timeline, liking, commenting on or sharing one of the Page posts, answering a question the Page posted, responding to one of the Page's events, mentioning the Page, tagging the Page in a photo or checking in at the Page's location. |
| page_impressions_viral_unique_day | NUMERIC | No documentation available yet |
| page_impressions_viral_unique_week | NUMERIC | No documentation available yet |
| page_impressions_viral_unique_days_28 | NUMERIC | No documentation available yet |
| page_impressions_nonviral | NUMERIC | Number of times posts by the Facebook Page were seen in News Feed or ticker or on visits to the Page within the current interval. These impressions can be by people who have liked your Page and people who haven't. |
| page_impressions_nonviral_day | NUMERIC | No documentation available yet |
| page_impressions_nonviral_week | NUMERIC | No documentation available yet |
| page_impressions_nonviral_days_28 | NUMERIC | No documentation available yet |
| page_impressions_nonviral_unique | NUMERIC | Number of people who visited the Facebook Page, or saw the Facebook Page or one of its posts in news feed or ticker within the current interval. These can be people who have liked your Page and people who haven't. This does not equal the usual known organic reach as it's missing people who only were virally reached by the pages content |
| page_impressions_nonviral_unique_day | NUMERIC | No documentation available yet |
| page_impressions_nonviral_unique_week | NUMERIC | No documentation available yet |
| page_impressions_nonviral_unique_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral | NUMERIC | Number of impressions of the Page's posts in news feed or ticker, or on the Page within the current interval. |
| page_posts_impressions_nonviral_day | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral_week | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral_unique | NUMERIC | Number of people who saw your Page's posts in news feed or ticker, or on the Page's timeline within the current interval. |
| page_posts_impressions_nonviral_unique_day | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral_unique_week | NUMERIC | No documentation available yet |
| page_posts_impressions_nonviral_unique_days_28 | NUMERIC | No documentation available yet |
| page_impressions_by_paid_non_paid_total | NUMERIC | Please note that this field will not be available soon. Number of impressions seen of any content associated with the Facebook Page within the current interval. |
| page_impressions_by_paid_non_paid_total_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_total_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_total_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_paid | NUMERIC | Please note that this field will not be available soon. Number of impressions of a Sponsored Story or Ad pointing to your Page within the current interval. |
| page_impressions_by_paid_non_paid_paid_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_paid_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_paid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unpaid | NUMERIC | Please note that this field will not be available soon. Number of impressions seen of any unpaid content associated with the Facebook Page within the current interval. |
| page_impressions_by_paid_non_paid_unpaid_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unpaid_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unpaid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_total | NUMERIC | Number of people who have seen any content associated with your Page within the current interval. This is also known as reach. |
| page_impressions_by_paid_non_paid_unique_total_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_total_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_total_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_paid | NUMERIC | Please note that this field will not be available soon. Number of people who saw a sponsored story or ad pointing to your Page within the current interval. This is also known as paid reach. |
| page_impressions_by_paid_non_paid_unique_paid_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_paid_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_paid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_unpaid | NUMERIC | Please note that this field will not be available soon. Number of people who have seen any unpaid content associated with the Facebook Page within the current interval. This is also known as organic reach. |
| page_impressions_by_paid_non_paid_unique_unpaid_day | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_unpaid_week | NUMERIC | Please note that this field will not be available soon. |
| page_impressions_by_paid_non_paid_unique_unpaid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_total | NUMERIC | Please note that this field will not be available soon. The total number of impressions that came from all of your posts. (Unique Users) |
| page_posts_impressions_by_paid_non_paid_unique_total_day | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_total_week | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_total_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_paid | NUMERIC | Please note that this field will not be available soon. The total number of impressions that came from all of your paid posts. (Unique Users) |
| page_posts_impressions_by_paid_non_paid_unique_paid_day | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_paid_week | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_paid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_unpaid | NUMERIC | Please note that this field will not be available soon. The total number of impressions that came from all of your unpaid posts. (Unique Users) |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_day | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_week | NUMERIC | Please note that this field will not be available soon. |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_days_28 | NUMERIC | Please note that this field will not be available soon. |
| page_visits_total | NUMERIC | No documentation available yet |
| page_visits_total_day | NUMERIC | No documentation available yet |
| page_visits_total_week | NUMERIC | No documentation available yet |
| page_visits_total_days_28 | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_count | NUMERIC | Number of clicks on the Facebook Page's website link within the current interval. |
| page_website_clicks_logged_in_count_day | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_count_week | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_count_days_28 | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_unique | NUMERIC | Number of logged-in users who clicked on the Facebook Page's website link within the current interval. |
| page_website_clicks_logged_in_unique_day | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_unique_week | NUMERIC | No documentation available yet |
| page_website_clicks_logged_in_unique_days_28 | NUMERIC | No documentation available yet |
| page_engaged_users | NUMERIC | Number of people who engaged with your Page within the current interval. Engagement includes any click or story created. |
| page_engaged_users_day | NUMERIC | No documentation available yet |
| page_engaged_users_week | NUMERIC | No documentation available yet |
| page_engaged_users_days_28 | NUMERIC | No documentation available yet |
| page_consumptions | NUMERIC | Number of clicks on any of the Page's content within the current interval. Stories generated without clicks on page content (e.g., liking the page in Timeline) are not included. |
| page_consumptions_day | NUMERIC | No documentation available yet |
| page_consumptions_week | NUMERIC | No documentation available yet |
| page_consumptions_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_unique | NUMERIC | Number of people who clicked on any of the Page's content within the current interval. Stories that are created without clicking on Page content (ex, liking the Page from timeline) are not included. |
| page_consumptions_unique_day | NUMERIC | No documentation available yet |
| page_consumptions_unique_week | NUMERIC | No documentation available yet |
| page_consumptions_unique_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks | NUMERIC | Number of clicks on links the Page got within the current interval. This e.g. includes clicks on links in the Page's posts. |
| page_consumptions_by_consumption_type_link_clicks_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks | NUMERIC | Number of other clicks on the Page's content within the current interval which doesn't include link clicks, photo views or video plays. |
| page_consumptions_by_consumption_type_other_clicks_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view | NUMERIC | Number of clicks on photos the Page got within the current interval. Clicks on photos always leads to an expanded view of the photo. |
| page_consumptions_by_consumption_type_photo_view_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_video_play | NUMERIC | Number of clicks on videos the Page got within the current interval. Auto-plays on videos aren't included here as they didn't require any clicks. |
| page_consumptions_by_consumption_type_video_play_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_video_play_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_video_play_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks | NUMERIC | Number of people who clicked on the Page's links within the current interval. This e.g. includes clicks on links in the Page's posts. |
| page_consumptions_by_consumption_type_unique_link_clicks_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks | NUMERIC | Number of people who clicked on the Page's content within the current interval which doesn't include link clicks, photo views or video plays. |
| page_consumptions_by_consumption_type_unique_other_clicks_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view | NUMERIC | Number of people who clicked on the Page's photos within the current interval. Clicks on photos always leads to an expanded view of the photo. |
| page_consumptions_by_consumption_type_unique_photo_view_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view_days_28 | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play | NUMERIC | Number of people who clicked on the Page's videos within the current interval. Auto-plays on videos aren't included here as they didn't require any clicks |
| page_consumptions_by_consumption_type_unique_video_play_day | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play_week | NUMERIC | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play_days_28 | NUMERIC | No documentation available yet |
| page_places_checkin_total | NUMERIC | Number of check-ins at your Page's Place within the current interval. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_total_day | NUMERIC | No documentation available yet |
| page_places_checkin_total_week | NUMERIC | No documentation available yet |
| page_places_checkin_total_days_28 | NUMERIC | No documentation available yet |
| page_places_checkin_total_unique | NUMERIC | Number of people who checked in at your Page's Place within the current interval. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_total_unique_day | NUMERIC | No documentation available yet |
| page_places_checkin_total_unique_week | NUMERIC | No documentation available yet |
| page_places_checkin_total_unique_days_28 | NUMERIC | No documentation available yet |
| page_places_checkin_mobile | NUMERIC | Number of check-ins at your Page's Place within the current interval using mobile devices. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_mobile_day | NUMERIC | No documentation available yet |
| page_places_checkin_mobile_week | NUMERIC | No documentation available yet |
| page_places_checkin_mobile_days_28 | NUMERIC | No documentation available yet |
| page_places_checkin_mobile_unique | NUMERIC | Number of people who checked in at your Page's Place within the current interval using mobile devices. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_mobile_unique_day | NUMERIC | No documentation available yet |
| page_places_checkin_mobile_unique_week | NUMERIC | No documentation available yet |
| page_places_checkin_mobile_unique_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback | NUMERIC | Number of times people have given negative feedback to your Page within the current interval. This includes clicks on 'Hide post', clicks on 'Hide all', unliking the Page or reporting posts as spam. |
| page_negative_feedback_day | NUMERIC | No documentation available yet |
| page_negative_feedback_week | NUMERIC | No documentation available yet |
| page_negative_feedback_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_unique | NUMERIC | Number of people who have given negative feedback to your Page within the current interval. This includes clicks on 'Hide post', clicks on 'Hide all', unliking the Page or reporting posts as spam. |
| page_negative_feedback_unique_day | NUMERIC | No documentation available yet |
| page_negative_feedback_unique_week | NUMERIC | No documentation available yet |
| page_negative_feedback_unique_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks | NUMERIC | Number of times people have hidden one of the Page's posts or sponsored posts within the current interval by clicking on 'Hide post' or 'Hide ad'. |
| page_negative_feedback_by_type_hide_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks | NUMERIC | Number of times people have clicked on 'Hide all' on one of the Page's posts or sponsored posts within the current interval. |
| page_negative_feedback_by_type_hide_all_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks | NUMERIC | Number of times people have unliked the Page within the current interval. |
| page_negative_feedback_by_type_unlike_page_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks | NUMERIC | Number of times people have reported one of the Page's posts as spam within the current interval. |
| page_negative_feedback_by_type_report_spam_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks | NUMERIC | Number of people who have hidden one of the Page's posts or sponsored posts within the current interval by clicking on 'Hide post' or 'Hide ad'. |
| page_negative_feedback_by_type_unique_hide_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks | NUMERIC | Number of people who have clicked on 'Hide all' on one of the Page's posts or sponsored posts within the current interval. |
| page_negative_feedback_by_type_unique_hide_all_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks | NUMERIC | Number of people who have unliked the Page within the current interval. |
| page_negative_feedback_by_type_unique_unlike_page_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_days_28 | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks | NUMERIC | Number of people who have reported one of the Page's posts as spam within the current interval. |
| page_negative_feedback_by_type_unique_report_spam_clicks_day | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_week | NUMERIC | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_like | NUMERIC | Number of times people have liked one of the Page's stories within the current interval. Please note this column is not only about the Like reaction, it actually includes the sum of all reactions (Like, Love, Haha, Wow, Sorry, Anger.) |
| page_positive_feedback_by_type_like_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_like_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_like_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_comment | NUMERIC | Number of times people have commented on one of the Page's stories within the current interval. |
| page_positive_feedback_by_type_comment_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_comment_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_comment_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_link | NUMERIC | Number of times people have shared one of the Page's stories within the current interval. |
| page_positive_feedback_by_type_link_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_link_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_link_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_rsvp | NUMERIC | Number of times people have responded to one of the Page's events within the current interval. |
| page_positive_feedback_by_type_rsvp_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_rsvp_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_rsvp_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_claim | NUMERIC | Number of times people have claimed one of the Page's offers within the current interval. |
| page_positive_feedback_by_type_claim_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_claim_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_claim_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_answer | NUMERIC | Number of times people have answered one of the Page's questions within the current interval. This column is deprecated and won't show values for newer dates because Facebook removed the questions feature. |
| page_positive_feedback_by_type_answer_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_answer_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_answer_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_like | NUMERIC | Number of people who have liked one of the Page's stories within the current interval. |
| page_positive_feedback_by_type_unique_like_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_like_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_like_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_comment | NUMERIC | Number of people who have commented on one of the Page's stories within the current interval. |
| page_positive_feedback_by_type_unique_comment_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_comment_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_comment_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_link | NUMERIC | Number of people who have shared one of the Page's stories within the current interval. |
| page_positive_feedback_by_type_unique_link_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_link_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_link_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp | NUMERIC | Number of people who have responded to one of the Page's events within the current interval. |
| page_positive_feedback_by_type_unique_rsvp_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_claim | NUMERIC | Number of people who have claimed one of the Page's offers within the current interval. |
| page_positive_feedback_by_type_unique_claim_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_claim_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_claim_days_28 | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_answer | NUMERIC | Number of people who have answered one of the Page's questions within the current interval. This column is deprecated and won't show values for newer dates because Facebook removed the questions feature. |
| page_positive_feedback_by_type_unique_answer_day | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_answer_week | NUMERIC | No documentation available yet |
| page_positive_feedback_by_type_unique_answer_days_28 | NUMERIC | No documentation available yet |
| page_fans_online_per_day | NUMERIC | Number of people who liked the Page and who were online within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_like | NUMERIC | Number of post 'like' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_love | NUMERIC | Number of post 'love' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_wow | NUMERIC | Number of post 'wow' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_haha | NUMERIC | Number of post 'haha' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_sorry | NUMERIC | Number of post 'sorry' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_anger | NUMERIC | Number of post 'anger' reactions of the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| page_fans_before | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| page_fans_change | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| page_fan_adds | NUMERIC | Number of times people have liked the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_adds_unique | NUMERIC | Number of new people who have liked the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_adds_by_paid_non_paid_unique_total | NUMERIC | Number of new people who have liked the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_adds_by_paid_non_paid_unique_paid | NUMERIC | Number of new people who have liked the Page from an ad or sponsored post within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_adds_by_paid_non_paid_unique_unpaid | NUMERIC | Number of new people who have liked the Page within the current interval excluding likes from a not sponsored post. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_removes | NUMERIC | Number of times people have unliked the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_removes_unique | NUMERIC | Number of people who have unliked the Page within the current interval. This column only supports daily intervals and won't work if you select any other interval. |
| page_cta_clicks_logged_in_total | NUMERIC | Total number of clicks on the Page call-to-action button by people who are logged into Facebook. |
| page_cta_clicks_logged_in_unique | NUMERIC | Unique number of clicks on the Page call-to-action button by people who are logged into Facebook. |
| page_views_total | NUMERIC | Number of Page views within the current interval. |
| page_views_logged_in_unique | NUMERIC | Number of logged in users who viewed the Page within the current interval. |
| page_views_logged_in_total | NUMERIC | Number of Page Views within the current interval from users logged into Facebook. |
| page_views_logout | NUMERIC | Number of Page views within the current interval from users not logged into Facebook. |
| page_posts_impressions | NUMERIC | Number of impressions that came from all of the Page's posts within the current interval. |
| page_posts_impressions_day | NUMERIC | No documentation available yet |
| page_posts_impressions_week | NUMERIC | No documentation available yet |
| page_posts_impressions_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_paid | NUMERIC | Number of impressions of the Page's posts in an Ad or Sponsored Story within the current interval. |
| page_posts_impressions_paid_day | NUMERIC | No documentation available yet |
| page_posts_impressions_paid_week | NUMERIC | No documentation available yet |
| page_posts_impressions_paid_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_viral | NUMERIC | Number of times users saw the Page's posts via stories published by their friends within the current interval. |
| page_posts_impressions_viral_day | NUMERIC | No documentation available yet |
| page_posts_impressions_viral_week | NUMERIC | No documentation available yet |
| page_posts_impressions_viral_days_28 | NUMERIC | No documentation available yet |
| page_posts_impressions_viral_unique | NUMERIC | Number of people who saw the Page's posts through a story shared by a friend within the current interval. |
| page_posts_impressions_viral_unique_day | NUMERIC | No documentation available yet |
| page_posts_impressions_viral_unique_week | NUMERIC | No documentation available yet |
| page_posts_impressions_viral_unique_days_28 | NUMERIC | No documentation available yet |
| page_posts_served_impressions_organic_unique | NUMERIC | Number of people who were served the Page's organic posts in their News Feed, whether it entered their screen or not, within the current interval. This column is only provided by Facebook for comparison reasons and contains data from 2018, January 25th onwards. Read this article for details. |
| page_posts_served_impressions_organic_unique_day | NUMERIC | No documentation available yet |
| page_posts_served_impressions_organic_unique_week | NUMERIC | No documentation available yet |
| page_posts_served_impressions_organic_unique_days_28 | NUMERIC | No documentation available yet |
| page_video_views | NUMERIC | Number of times the Page's videos have been viewed for more than 3 seconds within the current interval. |
| page_video_views_day | NUMERIC | No documentation available yet |
| page_video_views_week | NUMERIC | No documentation available yet |
| page_video_views_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s | NUMERIC | Number of times the Page's videos have been viewed for more than 10 seconds within the current interval. |
| page_video_views_10s_day | NUMERIC | No documentation available yet |
| page_video_views_10s_week | NUMERIC | No documentation available yet |
| page_video_views_10s_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s | NUMERIC | Number of times the Page's videos have been viewed for more than 30 seconds within the current interval. |
| page_video_complete_views_30s_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_days_28 | NUMERIC | No documentation available yet |
| page_video_views_unique | NUMERIC | Number of people who viewed at least one of the Page's videos for more than 3 seconds within the current interval. |
| page_video_views_unique_day | NUMERIC | No documentation available yet |
| page_video_views_unique_week | NUMERIC | No documentation available yet |
| page_video_views_unique_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_unique | NUMERIC | Number of people who viewed at least one of the Page's videos for more than 10 seconds within the current interval. |
| page_video_views_10s_unique_day | NUMERIC | No documentation available yet |
| page_video_views_10s_unique_week | NUMERIC | No documentation available yet |
| page_video_views_10s_unique_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_unique | NUMERIC | Number of people who viewed at least one of the Page's videos for more than 30 seconds within the current interval. |
| page_video_complete_views_30s_unique_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_unique_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_unique_days_28 | NUMERIC | No documentation available yet |
| page_video_views_paid | NUMERIC | Number of times a Page's promoted video has been viewed for more than 3 seconds within the current interval. |
| page_video_views_paid_day | NUMERIC | No documentation available yet |
| page_video_views_paid_week | NUMERIC | No documentation available yet |
| page_video_views_paid_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_paid | NUMERIC | Number of times a Page's promoted video has been viewed for more than 10 seconds within the current interval. |
| page_video_views_10s_paid_day | NUMERIC | No documentation available yet |
| page_video_views_10s_paid_week | NUMERIC | No documentation available yet |
| page_video_views_10s_paid_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_paid | NUMERIC | Number of times a Page's promoted video has been viewed for more than 30 seconds within the current interval. |
| page_video_complete_views_30s_paid_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_paid_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_paid_days_28 | NUMERIC | No documentation available yet |
| page_video_views_organic | NUMERIC | Number of times a Page's video has been viewed for at least 3 seconds due to organic reach within the current interval. |
| page_video_views_organic_day | NUMERIC | No documentation available yet |
| page_video_views_organic_week | NUMERIC | No documentation available yet |
| page_video_views_organic_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_organic | NUMERIC | Number of times a Page's video has been viewed for at least 10 seconds due to organic reach within the current interval. |
| page_video_views_10s_organic_day | NUMERIC | No documentation available yet |
| page_video_views_10s_organic_week | NUMERIC | No documentation available yet |
| page_video_views_10s_organic_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_organic | NUMERIC | Number of times a Page's video has been viewed for at least 30 seconds due to organic reach within the current interval. |
| page_video_complete_views_30s_organic_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_organic_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_organic_days_28 | NUMERIC | No documentation available yet |
| page_video_views_autoplayed | NUMERIC | Number of times the Page's videos started automatically playing and people viewed it for at least 3 seconds within the current interval. |
| page_video_views_autoplayed_day | NUMERIC | No documentation available yet |
| page_video_views_autoplayed_week | NUMERIC | No documentation available yet |
| page_video_views_autoplayed_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_autoplayed | NUMERIC | Number of times the Page's videos started automatically playing and people viewed it for at least 10 seconds or to the end within the current interval, whichever came first. |
| page_video_views_10s_autoplayed_day | NUMERIC | No documentation available yet |
| page_video_views_10s_autoplayed_week | NUMERIC | No documentation available yet |
| page_video_views_10s_autoplayed_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_autoplayed | NUMERIC | Number of times the Page's videos started automatically playing and people viewed it for at least 30 seconds or to the end within the current interval, whichever came first. |
| page_video_complete_views_30s_autoplayed_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_autoplayed_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_autoplayed_days_28 | NUMERIC | No documentation available yet |
| page_video_views_click_to_play | NUMERIC | Number of times a Page's video has been viewed for at least 3 seconds after the user clicked play within the current interval. |
| page_video_views_click_to_play_day | NUMERIC | No documentation available yet |
| page_video_views_click_to_play_week | NUMERIC | No documentation available yet |
| page_video_views_click_to_play_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_click_to_play | NUMERIC | Number of times a Page's video has been viewed for at least 10 seconds or to the end after the user clicked play within the current interval. |
| page_video_views_10s_click_to_play_day | NUMERIC | No documentation available yet |
| page_video_views_10s_click_to_play_week | NUMERIC | No documentation available yet |
| page_video_views_10s_click_to_play_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_click_to_play | NUMERIC | Number of times a Page's video has been viewed for at least 30 seconds or to the end after the user clicked play within the current interval. |
| page_video_complete_views_30s_click_to_play_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_click_to_play_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_click_to_play_days_28 | NUMERIC | No documentation available yet |
| page_video_repeat_views | NUMERIC | Number of times the Page's video has been seen for at least 3 seconds outside the first play within the current interval. |
| page_video_repeat_views_day | NUMERIC | No documentation available yet |
| page_video_repeat_views_week | NUMERIC | No documentation available yet |
| page_video_repeat_views_days_28 | NUMERIC | No documentation available yet |
| page_video_views_10s_repeat | NUMERIC | Number of times the Page's video has been seen for at least 10 seconds outside the first play within the current interval. |
| page_video_views_10s_repeat_day | NUMERIC | No documentation available yet |
| page_video_views_10s_repeat_week | NUMERIC | No documentation available yet |
| page_video_views_10s_repeat_days_28 | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_repeat_views | NUMERIC | Number of times the Page's video has been seen for at least 30 seconds outside the first play within the current interval. |
| page_video_complete_views_30s_repeat_views_day | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_repeat_views_week | NUMERIC | No documentation available yet |
| page_video_complete_views_30s_repeat_views_days_28 | NUMERIC | No documentation available yet |
| page_video_view_time | NUMERIC | The total amount of time (in milliseconds) people spent watching the Page's videos in the current interval. Facebook only supports daily interval for this metric. |
facebookInsightsByCity
Holding the number of Page Likes, Reach and People Talking About This of Facebook Pages per city including their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| cityName | TEXT | Name of the city. |
| cityLat | NUMERIC | Latitude of the city. |
| cityLon | NUMERIC | Longitude of the city. |
| cityCountryCode | TEXT | Code of the country this city belongs to, following ISO 3166 standard. |
| cityCountryName | TEXT | The full name of the country this city belongs to, e.g. Germany. |
| fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | NUMERIC | The share of Page Likes for this entry in relation to all Page Likes for this Facebook Page at the end of the interval represented as a percentage (0-100 scale). |
| reach | NUMERIC | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | NUMERIC | The number of People Talking About the Page in the current interval. |
facebookInsightsByCountry
Holding the number of Page Likes, Reach and People Talking About This of Facebook Pages per country including their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| countryCode | TEXT | The code of the country following ISO 3166 standard. |
| countryName | TEXT | The full name of the country, e.g. Germany. |
| fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | NUMERIC | The share of Page Likes for this entry in relation to all Page Likes for this Facebook Page at the end of the interval represented as a percentage (0-100 scale). |
| reach | NUMERIC | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | NUMERIC | The number of People Talking About the Page in the current interval. |
facebookInsightsByGenderAndAge
Holding the number of Page Likes, Reach and People Talking About This of Facebook Pages per gender and age bucket including their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| gender | TEXT | Either "Male", "Female" or "Unknown". |
| ageBucket | TEXT | The age range in years. Typically the following ranges are shown: "13-17", "18-24", "25-34", "35-44", "45-54", "55-64" and "65+". |
| fans | NUMERIC | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | NUMERIC | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | NUMERIC | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | NUMERIC | The share of Page Likes for this entry in relation to all Page Likes for this Facebook Page at the end of the interval represented as a percentage (0-100 scale). |
| reach | NUMERIC | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | NUMERIC | The number of People Talking About the Page in the current interval. |
facebookInsightsByStoryType
Holding the number of Stories, Impressions, Reach and People Talking About This of Facebook Pages per story type (e.g. Page Post, User Post, Question) including their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| storyType | TEXT | The story type according to Facebook's documentation. |
| stories | NUMERIC | The number of stories created about your Page (Stories) in the current interval. |
| impressions | NUMERIC | The total number of impressions seen of any content associated with your Page in the current interval. |
| reach | NUMERIC | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | NUMERIC | The number of People Talking About the Page in the current interval. |
facebookInsightsConversations
Holding private conversations of Facebook Pages. A conversation includes private messages between the Facebook Page and a specific Facebook user. Please note that there can be multiple conversations per user as we split into separate conversations if there is a new incoming request by a user after 3 weeks of no communication and it will be counted as a new conversation.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this conversation started in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| conversationId | TEXT | The ID of the conversation provided by Facebook concatenated with a running number per conversation with a user, e.g. <Facebook's conversation id>_1 for the first conversation with this user. |
| link | TEXT | The link to this conversation on Facebook. |
| userName | TEXT | The name of the author. |
| userId | TEXT | The ID of the author provided by Facebook. |
| messageCount | NUMERIC | The number of messages within the conversation, including both messages from the user and the Facebook Page. |
| pageMessageCount | NUMERIC | The number of messages by the Facebook Page within the conversation. |
| userMessageCount | NUMERIC | The number of messages by the user within the conversation. |
| responseTime | TEXT | Holding the full date and time information when the first reply by the Facebook Page was sent in "Y/m/d H:i:s" format and UTC timezone. If the Page started the conversation by privately replying to a user's comment on one of the Page's posts this would show "null" as we don't get the created time of the comment. |
| timeToRespond | TEXT | The time from the creation of the initial user message until the first reply of the Facebook Page in seconds. If the Page started the conversation by privately replying to a user's comment on one of the Page's posts this would show "null" as we don't get the created time of the comment. |
| initialUserMessage | TEXT | The contents of the initial message by the user. If the Page privately replied to a comment on one of it's posts it will show the text of the comment. |
| firstPageReply | TEXT | The contents of the first reply by the Facebook Page. |
| wasInitiatedByPrivateReplyToComment | TEXT | If conversation was started by the Page, privately replying to a user's comment on one of the Page's posts. Holds "1" if conversation was initiated by private reply to comment, "" if not. |
facebookInsightsExpiredPosts
Holding information about expired posts of Facebook Pages with all their private statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| expireTime | TEXT | The time this posting has expired in "Y/m/d H:i:s" format and UTC timezone. |
| objectId | TEXT | The ID of any uploaded photo or video attached to the post. |
| type | TEXT | The object type of the post. |
| link | TEXT | The link to the post. |
| message | TEXT | The contents of the post message. |
| externalId | TEXT | The unique id of the post. |
| likes | NUMERIC | Number of likes the post got. This does not include likes on shares. |
| love | NUMERIC | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | NUMERIC | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | NUMERIC | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | NUMERIC | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | NUMERIC | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | NUMERIC | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | NUMERIC | Number of comments the post got. This doesn't include comments on shares. |
| shares | NUMERIC | Number of shares the post got. This doesn't include shares of shares. |
| fans | NUMERIC | Number of fans the page had on the day the post was published. |
| adminCreator | TEXT | The name of the Facebook user who created the post for the page. |
| adminCreatorId | TEXT | The user id of the Facebook user who created the post for the page. |
| attachmentName | TEXT | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | TEXT | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | TEXT | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | TEXT | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
| privacy | TEXT | Holds information about the targeting of the post. If the post is not targeted it will show "public". |
| isLiveVideo | TEXT | If the posted video was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isLiveAudio | TEXT | If the posted audio was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isSharedPost | TEXT | If the post is a shared post or not. Holds โ1โ if the post is a shared post, โโ if not. |
| isSpherical | TEXT | If the post contains a 360 degree photo/video or not. Holds โ1โ if the post contains a 360 degree photo or video, โโ if not. If the post is a shared 360 degree photo/video, Facebook can not detect that the original post contains 360 degree content thus the column would also hold โโ. |
| post_reactions_by_type_total_like | NUMERIC | Number of "Like" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_love | NUMERIC | Number of "Love" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_wow | NUMERIC | Number of "Wow" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_haha | NUMERIC | Number of "Haha" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_sorry | NUMERIC | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_anger | NUMERIC | Number of "Anger" reactions the post got. This also includes reactions on shares. |
| post_fan_reach | NUMERIC | Number of people who saw the Page post because they've liked the Page. |
| post_engaged_fan | NUMERIC | Number of people who have liked the Page and clicked anywhere in the post. |
| post_impressions | NUMERIC | Number of impressions of the Page post. |
| post_impressions_unique | NUMERIC | Number of people the Page post was served to. This is also known as reach. |
| post_impressions_organic | NUMERIC | Number of impressions of the Page post that didn't come from an Ad or Sponsored Story. |
| post_impressions_organic_unique | NUMERIC | Number of people who didn't see the Page post in an Ad or Sponsored Story. This is also known as organic reach. |
| post_impressions_nonviral | NUMERIC | The number of times your Page's post entered a person's screen. |
| post_impressions_nonviral_unique | NUMERIC | The number of people who had your Page's post enter their screen. |
| post_impressions_paid | NUMERIC | Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_paid_unique | NUMERIC | Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_fan | NUMERIC | Number of impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_unique | NUMERIC | Number of people who saw the Page post because they've liked the Page |
| post_impressions_fan_paid | NUMERIC | Number of paid impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_paid_unique | NUMERIC | Number of people who like the Page and who saw the Page post in an ad or sponsored story. |
| post_impressions_viral | NUMERIC | Number of impressions of the Page post in a story generated by a friend. |
| post_impressions_viral_unique | NUMERIC | Number of people who saw the Page post in a story from a friend. |
| post_impressions_by_paid_non_paid_total | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post. |
| post_impressions_by_paid_non_paid_paid | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_by_paid_non_paid_unpaid | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post that didn't come from an Ad or Sponsored Story. |
| post_impressions_by_paid_non_paid_unique_total | NUMERIC | Please note that this field will not be available soon. Number of people the Page post was served to. This is also known as reach. |
| post_impressions_by_paid_non_paid_unique_paid | NUMERIC | Please note that this field will not be available soon. Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_by_paid_non_paid_unique_unpaid | NUMERIC | Please note that this field will not be available soon. Number of people who didn't see the Page post in an Ad or Sponsored Story. This is also known as organic reach. |
| post_consumptions | NUMERIC | Number of clicks anywhere in the post. |
| post_consumptions_unique | NUMERIC | Number of people who clicked anywhere in the post. |
| post_consumptions_by_type_link_clicks | NUMERIC | Number of clicks on links in the post. |
| post_consumptions_by_type_photo_view | NUMERIC | Number of clicks on photo attachments in the post which led to an expanded view of the photo. |
| post_consumptions_by_type_video_play | NUMERIC | Number of clicks on video attachments in the post which started the video. |
| post_consumptions_by_type_other_clicks | NUMERIC | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. |
| post_consumptions_by_type_unique_link_clicks | NUMERIC | Number of people who clicked on links in the post. |
| post_consumptions_by_type_unique_photo_view | NUMERIC | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. |
| post_consumptions_by_type_unique_video_play | NUMERIC | Number of people who clicked on video attachments in the post which started the video. |
| post_consumptions_by_type_unique_other_clicks | NUMERIC | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. |
| post_engaged_users | NUMERIC | Number of unique people who engaged in certain ways with the Page post, for example by commenting on, liking, sharing, or clicking upon particular elements of the post. |
| post_negative_feedback | NUMERIC | Number of times people have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. |
| post_negative_feedback_unique | NUMERIC | Number of people who have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. |
| post_negative_feedback_by_type_hide_clicks | NUMERIC | Number of times people have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_hide_all_clicks | NUMERIC | Number of times people have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unlike_page_clicks | NUMERIC | Number of times people have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_report_spam_clicks | NUMERIC | Number of times people have given negative feedback to the post by reporting the post as spam. |
| post_negative_feedback_by_type_unique_hide_clicks | NUMERIC | Number of people who have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_unique_hide_all_clicks | NUMERIC | Number of people who have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unique_unlike_page_clicks | NUMERIC | Number of people who have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_unique_report_spam_clicks | NUMERIC | Number of people who have given negative feedback to the post by reporting the post as spam. |
| post_stories | NUMERIC | Number of stories generated about the Page post. |
| post_storytellers | NUMERIC | Number of people who created a story by interacting with the Page post. |
| post_story_adds_by_action_type_like | NUMERIC | Number of stories created about the Page post by liking the post. |
| post_story_adds_by_action_type_comment | NUMERIC | Number of stories created about the Page post by commenting on the post. |
| post_story_adds_by_action_type_share | NUMERIC | Number of stories created about the Page post by sharing the post. |
| post_stories_by_action_type_like | NUMERIC | Number of stories created about the Page post by liking the post. |
| post_stories_by_action_type_comment | NUMERIC | Number of stories created about the Page post by commenting on the post. |
| post_stories_by_action_type_share | NUMERIC | Number of stories created about the Page post by sharing the post. |
| post_story_adds_by_action_type_unique_like | NUMERIC | Number of people who created a story about the Page post by liking it. |
| post_story_adds_by_action_type_unique_comment | NUMERIC | Number of people who created a story about the Page post by commenting on it. |
| post_story_adds_by_action_type_unique_share | NUMERIC | Number of people who created a story about the Page post by sharing it. |
| post_storytellers_by_action_type_like | NUMERIC | Number of people who created a story about the Page post by liking it. |
| post_storytellers_by_action_type_comment | NUMERIC | Number of people who created a story about the Page post by commenting on it. |
| post_storytellers_by_action_type_share | NUMERIC | Number of people who created a story about the Page post by sharing it. |
| post_video_avg_time_watched | NUMERIC | The average length of time (in milliseconds) people spent viewing the video. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time | NUMERIC | Total time (in milliseconds) video has been viewed. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time_organic | NUMERIC | Total time (in milliseconds) video has been viewed in news feed or ticker or on the Page's Timeline. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_length | NUMERIC | Length of a video post (in milliseconds). If the post doesn't include a video it will shown "0". |
| post_video_views | NUMERIC | Number of times the video was viewed for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_organic | NUMERIC | Number of times the video was viewed for more than 3 seconds without any paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_organic_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds without any paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_paid | NUMERIC | Number of times the video was viewed for more than 3 seconds after paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_paid_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds after paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". |
| post_video_views_10s | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_unique | NUMERIC | Number of people who viewed the video for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_paid | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_organic | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_by_distribution_type_page_owned | NUMERIC | Number of times the video was viewed for more than 3 seconds in the original post. If the post doesn't include a video it will shown "0". |
| post_video_views_by_distribution_type_shared | NUMERIC | Number of times the video was viewed for more than 3 seconds in a shared post. If the post doesn't include a video it will shown "0". |
| post_video_complete_views_30s | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_unique | NUMERIC | Number of people who viewed the video for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_paid | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_organic | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic | NUMERIC | Number of times the video was viewed to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic_unique | NUMERIC | Number of people who viewed the video to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid | NUMERIC | Number of times the video was viewed to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid_unique | NUMERIC | Number of people who viewed the video to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
facebookInsightsOwnPosts
Holding information about posts of Facebook Pages with all their private statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| is_published | NUMERIC | If the post is published. Holds โ1โ if the post is published, โโ if not. |
| is_hidden | NUMERIC | If the post is hidden. Holds โ1โ if the post is hidden, โโ if not. |
| type | TEXT | The object type of the post. |
| link | TEXT | The link to the post. |
| message | TEXT | The contents of the post message. |
| externalId | TEXT | The unique id of the post. |
| objectId | TEXT | The unique id of the object in the post. The ID of any uploaded photo or video attached to the post. |
| likes | NUMERIC | Number of likes the post got. This doesn't include likes on shares. |
| love | NUMERIC | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | NUMERIC | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | NUMERIC | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | NUMERIC | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | NUMERIC | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | NUMERIC | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | NUMERIC | Number of comments the post got. This doesn't include comments on shares. |
| shares | NUMERIC | Number of shares the post got. This doesn't include shares of shares. |
| fans | NUMERIC | Number of fans the page had on the day the post was published. |
| adminCreator | TEXT | The name of the Facebook user who created the post for the page. |
| adminCreatorId | TEXT | The user id of the Facebook user who created the post for the page. |
| attachmentName | TEXT | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | TEXT | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | TEXT | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | TEXT | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
| privacy | TEXT | Holds information about the targeting of the post. If the post is not targeted it will show "public". |
| isLiveVideo | TEXT | If the posted video was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isLiveAudio | TEXT | If the posted audio was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isSharedPost | TEXT | If the post is a shared post or not. Holds โ1โ if the post is a shared post, โโ if not. |
| isSpherical | TEXT | If the post contains a 360 degree photo/video or not. Holds โ1โ if the post contains a 360 degree photo or video, โโ if not. If the post is a shared 360 degree photo/video, Facebook can not detect that the original post contains 360 degree content thus the column would also hold โโ. |
| post_reactions_by_type_total_like | NUMERIC | Number of "Like" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_love | NUMERIC | Number of "Love" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_wow | NUMERIC | Number of "Wow" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_haha | NUMERIC | Number of "Haha" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_sorry | NUMERIC | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_anger | NUMERIC | Number of "Anger" reactions the post got. This also includes reactions on shares. |
| post_fan_reach | NUMERIC | Number of people who saw the Page post because they've liked the Page. |
| post_engaged_fan | NUMERIC | Number of people who have liked the Page and clicked anywhere in the post. |
| post_impressions | NUMERIC | Number of impressions of the Page post. |
| post_impressions_unique | NUMERIC | Number of people the Page post was served to. This is also known as reach. |
| post_impressions_organic | NUMERIC | Number of impressions of the post in News Feed or ticker or on the Page's Timeline. |
| post_impressions_organic_unique | NUMERIC | Number of people who saw the Page post in news feed or ticker, or on the Page's timeline. |
| post_impressions_paid | NUMERIC | Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_paid_unique | NUMERIC | Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_fan | NUMERIC | Number of impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_unique | NUMERIC | Number of people who saw the Page post because they've liked the Page |
| post_impressions_fan_paid | NUMERIC | Number of paid impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_paid_unique | NUMERIC | Number of people who like the Page and who saw the Page post in an ad or sponsored story. |
| post_impressions_viral | NUMERIC | Number of impressions of the Page post in a story generated by a friend. |
| post_impressions_viral_unique | NUMERIC | Number of people who saw the Page post in a story from a friend. |
| post_impressions_nonviral | NUMERIC | Number of times people saw the Page post. |
| post_impressions_nonviral_unique | NUMERIC | Number of people the Page post was served to. |
| post_impressions_by_paid_non_paid_total | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post. |
| post_impressions_by_paid_non_paid_paid | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_by_paid_non_paid_unpaid | NUMERIC | Please note that this field will not be available soon. Number of impressions of the Page post that didn't come from an Ad or Sponsored Story. |
| post_impressions_by_paid_non_paid_unique_total | NUMERIC | Please note that this field will not be available soon. Number of people the Page post was served to. This is also known as reach. |
| post_impressions_by_paid_non_paid_unique_paid | NUMERIC | Please note that this field will not be available soon. Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_by_paid_non_paid_unique_unpaid | NUMERIC | Please note that this field will not be available soon. Number of people who didn't see the Page post in an Ad or Sponsored Story. This is also known as organic reach. |
| post_consumptions | NUMERIC | Number of clicks anywhere in the post. |
| post_consumptions_unique | NUMERIC | Number of people who clicked anywhere in the post. |
| post_consumptions_by_type_link_clicks | NUMERIC | Number of clicks on links in the post. |
| post_consumptions_by_type_photo_view | NUMERIC | Number of clicks on photo attachments in the post which led to an expanded view of the photo. |
| post_consumptions_by_type_video_play | NUMERIC | Number of clicks on video attachments in the post which started the video. |
| post_consumptions_by_type_other_clicks | NUMERIC | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. |
| post_consumptions_by_type_unique_link_clicks | NUMERIC | Number of people who clicked on links in the post. |
| post_consumptions_by_type_unique_photo_view | NUMERIC | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. |
| post_consumptions_by_type_unique_video_play | NUMERIC | Number of people who clicked on video attachments in the post which started the video. |
| post_consumptions_by_type_unique_other_clicks | NUMERIC | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. |
| post_engaged_users | NUMERIC | Number of unique people who engaged in certain ways with the Page post, for example by commenting on, liking, sharing, or clicking upon particular elements of the post. |
| post_negative_feedback | NUMERIC | Number of times people have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. |
| post_negative_feedback_unique | NUMERIC | Number of people who have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. |
| post_negative_feedback_by_type_hide_clicks | NUMERIC | Number of times people have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_hide_all_clicks | NUMERIC | Number of times people have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unlike_page_clicks | NUMERIC | Number of times people have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_report_spam_clicks | NUMERIC | Number of times people have given negative feedback to the post by reporting the post as spam. |
| post_negative_feedback_by_type_unique_hide_clicks | NUMERIC | Number of people who have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_unique_hide_all_clicks | NUMERIC | Number of people who have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unique_unlike_page_clicks | NUMERIC | Number of people who have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_unique_report_spam_clicks | NUMERIC | Number of people who have given negative feedback to the post by reporting the post as spam. |
| post_stories | NUMERIC | Number of stories generated about the Page post. |
| post_storytellers | NUMERIC | Number of people who created a story by interacting with the Page post. |
| post_story_adds_by_action_type_like | NUMERIC | Number of stories created about the Page post by liking the post. |
| post_story_adds_by_action_type_comment | NUMERIC | Number of stories created about the Page post by commenting on the post. |
| post_story_adds_by_action_type_share | NUMERIC | Number of stories created about the Page post by sharing the post. |
| post_stories_by_action_type_like | NUMERIC | Number of stories created about the Page post by liking the post. |
| post_stories_by_action_type_comment | NUMERIC | Number of stories created about the Page post by commenting on the post. |
| post_stories_by_action_type_share | NUMERIC | Number of stories created about the Page post by sharing the post. |
| post_story_adds_by_action_type_unique_like | NUMERIC | Number of people who created a story about the Page post by liking it. |
| post_story_adds_by_action_type_unique_comment | NUMERIC | Number of people who created a story about the Page post by commenting on it. |
| post_story_adds_by_action_type_unique_share | NUMERIC | Number of people who created a story about the Page post by sharing it. |
| post_storytellers_by_action_type_like | NUMERIC | Number of people who created a story about the Page post by liking it. |
| post_storytellers_by_action_type_comment | NUMERIC | Number of people who created a story about the Page post by commenting on it. |
| post_storytellers_by_action_type_share | NUMERIC | Number of people who created a story about the Page post by sharing it. |
| post_video_avg_time_watched | NUMERIC | The average length of time (in milliseconds) people spent viewing the video. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time | NUMERIC | Total time (in milliseconds) video has been viewed. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time_organic | NUMERIC | Total time (in milliseconds) video has been viewed in news feed or ticker or on the Page's Timeline. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_length | NUMERIC | Length of a video post (in milliseconds). If the post doesn't include a video it will shown "0". |
| post_video_views | NUMERIC | Number of times the video was viewed for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_organic | NUMERIC | Number of times the video was viewed for more than 3 seconds without any paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_organic_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds without any paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_paid | NUMERIC | Number of times the video was viewed for more than 3 seconds after paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_paid_unique | NUMERIC | Number of people who viewed the video for more than 3 seconds after paid promotion. If the post doesn't include a video it will shown "0". |
| post_video_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for more than 3 seconds. If the post doesn't include a video it will shown "0". |
| post_video_views_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". |
| post_video_views_10s | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_unique | NUMERIC | Number of people who viewed the video for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_paid | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_organic | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_by_distribution_type_page_owned | NUMERIC | Number of times the video was viewed for more than 3 seconds in the original post. If the post doesn't include a video it will shown "0". |
| post_video_views_by_distribution_type_shared | NUMERIC | Number of times the video was viewed for more than 3 seconds in a shared post. If the post doesn't include a video it will shown "0". |
| post_video_complete_views_30s | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_unique | NUMERIC | Number of people who viewed the video for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_paid | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_organic | NUMERIC | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic | NUMERIC | Number of times the video was viewed to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic_unique | NUMERIC | Number of people who viewed the video to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid | NUMERIC | Number of times the video was viewed to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid_unique | NUMERIC | Number of people who viewed the video to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
facebookInsightsOwnVideos
Holding information about videos of Facebook Pages with all their private statistics attached. This is similar to the facebookInsightsOwnPosts data source but showing video posts only while offering more specific video metrics.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| expireTime | TEXT | The time this posting has expired in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | The unique id of the video. |
| link | TEXT | The link to the video. |
| title | TEXT | The video title or caption. |
| description | TEXT | The description of the video. |
| is_published | TEXT | If a post about the video is published. Holds โ1โ if a post is published, โโ if not. |
| live_status | TEXT | The live status of the video. Could e.g. be โVODโ if the video is a live video or โSCHEDULED_UNPUBLISHEDโ if the live video is sheduled but not published yet. If the video is no live video it holds โโ. |
| content_category | TEXT | The content category of the video. |
| length | NUMERIC | The duration of this video in seconds. |
| privacy | TEXT | Holds information about the targeting of the post. If the post is not targeted it will show "public". |
| fans | NUMERIC | Number of fans the page had on the day the post was published. |
| likes | NUMERIC | Number of people who liked the video. This doesn't include likes on shares. |
| love | NUMERIC | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | NUMERIC | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | NUMERIC | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | NUMERIC | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | NUMERIC | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | NUMERIC | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | NUMERIC | Number of comments on the video. This doesn't include comments on shares. |
| isExpired | TEXT | If the posted video is expired |
| isCrossPosted | TEXT | If the posted video is crossposted |
| picture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
| total_video_views | NUMERIC | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first. |
| total_video_views_unique | NUMERIC | Number of unique people who viewed the video for 3 seconds or viewed to the end, whichever came first. |
| total_video_views_autoplayed | NUMERIC | Number of times the video started automatically playing and people viewed it for 3 seconds or viewed it to the end, whichever came first. |
| total_video_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 3 seconds or viewed it to the end, whichever came first. |
| total_video_views_organic | NUMERIC | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. |
| total_video_views_organic_unique | NUMERIC | Number unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. |
| total_video_views_paid | NUMERIC | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. |
| total_video_views_paid_unique | NUMERIC | Number of unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. |
| total_video_views_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. |
| total_video_views_by_distribution_type_shared | NUMERIC | Number of times the video was viewed in a shared post. |
| total_video_views_by_distribution_type_page_owned | NUMERIC | Number of times the video was viewed in a post that was page owned. |
| total_video_views_by_distribution_type_crossposted | NUMERIC | Number of times the video was viewed in a crossposted post. |
| total_video_view_time_by_distribution_type_shared | NUMERIC | Total time (in milliseconds) video has been viewed in a shared post. |
| total_video_view_time_by_distribution_type_page_owned | NUMERIC | Total time (in milliseconds) video has been viewed in a post that was page owned. |
| total_video_view_time_by_distribution_type_crossposted | NUMERIC | Total time (in milliseconds) video has been viewed in a crossposted post. |
| total_video_complete_views | NUMERIC | Number of times the video was watched at 95% of its length, including watches that skipped to this point. |
| total_video_complete_views_unique | NUMERIC | Number of unique people who watched the video at 95% of its length or more, including people that skipped to this point. |
| total_video_complete_views_auto_played | NUMERIC | Number of times the video started automatically playing and people watched it at 95% of its length, including watches that skipped to this point. |
| total_video_complete_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and watched it at 95% of its length, including watches that skipped to this point. |
| total_video_complete_views_organic | NUMERIC | Number of times the video was watched at 95% of its length without any paid promotion, including watches that skipped to this point. |
| total_video_complete_views_organic_unique | NUMERIC | Number of unique people who watched the video at 95% of its length without any paid promotion, including people that skipped to this point. |
| total_video_complete_views_paid | NUMERIC | Number of times the video was watched at 95% of its length after paid promotion, including watches that skipped to this point. |
| total_video_complete_views_paid_unique | NUMERIC | Number of unique people who watched the video at 95% of its length after paid promotion, including people that skipped to this point. |
| total_video_30s_views | NUMERIC | Number of times the video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds. |
| total_video_30s_views_unique | NUMERIC | Number of unique people who viewed the video for 30 seconds or 97% of the video if video is less than 30 seconds. |
| total_video_30s_views_auto_played | NUMERIC | Number of times the video started automatically playing and people viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. |
| total_video_30s_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 30 seconds or 97% of the video if video is less than 30 seconds. |
| total_video_30s_views_organic | NUMERIC | Number of times the video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds without a paid promotion. |
| total_video_30s_views_paid | NUMERIC | Number of times the video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds after a paid promotion. |
| total_video_10s_views | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. |
| total_video_10s_views_unique | NUMERIC | Number of unique people who viewed the video for 10 seconds or viewed to the end, whichever came first. |
| total_video_10s_views_auto_played | NUMERIC | Number of times the video started automatically playing and people viewed it for 10 seconds, or viewed it to the end, whichever came first. |
| total_video_10s_views_clicked_to_play | NUMERIC | Number of times people clicked to play the video and viewed it for 10 seconds or viewed it to the end, whichever came first. |
| total_video_10s_views_organic | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. |
| total_video_10s_views_paid | NUMERIC | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. |
| total_video_10s_views_sound_on | NUMERIC | Number of times the video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. |
| total_video_avg_time_watched | NUMERIC | The average length of time (in milliseconds) people spent viewing the video. |
| total_video_view_total_time | NUMERIC | The total time (in ms) the video has been viewed. |
| total_video_view_total_time_organic | NUMERIC | The total time (in ms) the video has been viewed in news feed or ticker or on the Page's timeline. |
| total_video_view_total_time_paid | NUMERIC | The total time (in ms) the video has been viewed after paid promotion. |
| total_video_impressions | NUMERIC | Number of impressions of the video. |
| total_video_impressions_unique | NUMERIC | Number of people the video was served to. |
| total_video_impressions_paid_unique | NUMERIC | Number of people the advertised Page Video was served to. |
| total_video_impressions_paid | NUMERIC | Number of impressions of the Page Video in an Ad or Sponsored Story. |
| total_video_impressions_organic_unique | NUMERIC | Number of people who saw the Page Video in news feed or ticker, or on the Page's timeline. |
| total_video_impressions_organic | NUMERIC | Number of impressions of the Video in news feed or ticker or on the Page's timeline. |
| total_video_impressions_viral_unique | NUMERIC | Number of people who saw the Page Video in a story from a friend. |
| total_video_impressions_viral | NUMERIC | Number of impressions of the Page Video in a story generated by a friend. |
| total_video_impressions_fan_unique | NUMERIC | Number of people who saw the Page video because they've liked the Page. |
| total_video_impressions_fan | NUMERIC | Number of impressions of the Page Video to people who have liked the Page. |
| total_video_impressions_fan_paid_unique | NUMERIC | Number of people who like the Page and who saw the Page Video in an ad or sponsored story. |
| total_video_impressions_fan_paid | NUMERIC | Number of paid impressions of the Page Video to people who have liked the Page. |
| total_video_stories_by_action_type_like | NUMERIC | Number of stories created about the Page Video by liking the post. |
| total_video_stories_by_action_type_comment | NUMERIC | Number of stories created about the Page Video by commenting on the post. |
| total_video_stories_by_action_type_share | NUMERIC | Number of stories created about the Page Video by sharing the post. |
| total_video_reactions_by_type_total_like | NUMERIC | Number of "Like" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_love | NUMERIC | Number of "Love" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_wow | NUMERIC | Number of "Wow" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_haha | NUMERIC | Number of "Haha" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_sorry | NUMERIC | Number of "Sorry" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_anger | NUMERIC | Number of "Anger" reactions the video got. This also includes reactions on shares. |
facebookInsightsPageFansOnline
Holding the number of Fans (People liking a Facebook Page) online over time, broken down by hour.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| fans | NUMERIC | The number of Fans of a Facebook Page being online on Facebook in the current interval. Facebook considers a user to be online if it saw any posts on Facebook in that time. |
facebookInsightsPageLikesAndUnlikesBySource
Holding the number of won and lost Page Likes of Facebook Pages including their development over time. In contrast to our change metrics for Page Likes in public data sources, this one can be used to show how many Page Likes were gained and lost over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| source | TEXT | The source according to Facebook's documentation. |
| likes | NUMERIC | The number of new Page Likes in the current interval. |
| likesUnique | NUMERIC | The number of unique new Page Likes in the current interval. |
| unlikesUnique | NUMERIC | The number of unique lost Page Likes in the current interval. |
facebookInsightsPageViewsReferrals
Holding the number of Views of Facebook Pages per Referral sending traffic to a Facebook Page including their development over time. Referrals can be both external domains and internal pages on Facebook (e.g. Profile, Search, Requests, Suggestions, Stream)
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| referral | TEXT | The referral the traffic is coming from, either an external domain name or internal pages on Facebook (e.g. Profile, Search, Requests, Suggestions, Stream). |
| views | NUMERIC | The total number of Page Views. |
facebookInsightsVideosRetention
Holding retention information for single videos of Facebook Pages. Retention for a video is defined by the share of viewers still watching a video at a given time point (described in intervals, usually an interval covers one second) after the video started. With this information you can easily show how the share of viewers drops over the length of a video and compare videos with each other.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| externalId | TEXT | The ID of the video provided by Facebook. |
| publishedTime | TEXT | Holding the full date and time information when this video was published in "Y/m/d H:i:s" format and UTC timezone. |
| message | TEXT | The message sent along with the video. |
| title | TEXT | The title of the video. |
| link | TEXT | The link to the video on Facebook. |
| intervalAtSecond | NUMERIC | Describing the beginning of this interval in seconds after the video started. |
| percentageOfViewers | NUMERIC | The percentage of people still viewing the video at the end of this interval in 0-100 scale. |
facebookKeyInteractingUsers
Holding information about Facebook users publicly commenting on posts or posting to the Timeline of Facebook Pages, sorting by most active users by default.
| Column name | Type | Description |
|---|---|---|
| name | TEXT | No documentation available yet |
| profileLink | TEXT | No documentation available yet |
| picture | TEXT | No documentation available yet |
| posts | NUMERIC | No documentation available yet |
| comments | NUMERIC | No documentation available yet |
| total | NUMERIC | No documentation available yet |
| overlaps | TEXT | No documentation available yet |
| overlapsCount | NUMERIC | No documentation available yet |
facebookOwnPosts
Holding public information about posts of Facebook Pages with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| message | TEXT | The contents of the post message. |
| type | TEXT | The object type of the post. |
| link | TEXT | The link to the post. |
| externalId | TEXT | The unique id of the post. |
| likes | NUMERIC | Number of "Like" reactions the post got. This doesn't include reactions on shares. |
| love | NUMERIC | Number of "Love" reactions the post got. This doesn't include reactions on shares. |
| wow | NUMERIC | Number of "Wow" reactions the post got. This doesn't include reactions on shares. |
| haha | NUMERIC | Number of "Haha" reactions the post got. This doesn't include reactions on shares. |
| sad | NUMERIC | Number of "Sorry" reactions the post got. This doesn't include reactions on shares. |
| angry | NUMERIC | Number of "Anger" reactions the post got. This doesn't include reactions on shares. |
| thankful | NUMERIC | Number of "Thankful" reactions the post got. This doesn't include reactions on shares. |
| comments | NUMERIC | Number of comments the post got. This doesn't include comments on shares. |
| shares | NUMERIC | Number of shares the post got. This doesn't include shares of shares. |
| clicks | NUMERIC | Number of clicks links within the post got. Note: This only includes links from link shorteners such as bit.ly or goo.gl as this data is publicly available. Holds โnullโ if the post doesn't include a shortened link. |
| interactionRate | NUMERIC | Holds the interaction rate of the post. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| isPotentiallyPaid | NUMERIC | If the post is potentially sponsored or not. Holds โ1โ if the post is potentially sponsored, โโ if not. You can find more information on how we estimate if a post is sponsored in our knowledge base article. |
| fans | NUMERIC | Number of fans the page had on the day the post was published. |
| appId | TEXT | The id of the third party app which was used to publish the post. Holds โnullโ if the post wasn't published via a third party app. |
| appName | TEXT | The name of the third party app which was used to publish the post. Holds โnullโ if the post wasn't published via a third party app. |
| isLiveVideo | NUMERIC | If the posted video was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isLiveAudio | NUMERIC | If the posted audio was live or not. Holds โ1โ if the post was a live post, โโ if not. |
| isSharedPost | NUMERIC | If the post is a shared post or not. Holds โ1โ if the post is a shared post, โโ if not. |
| isSpherical | NUMERIC | If the post contains a 360 degree photo/video or not. Holds โ1โ if the post contains a 360 degree photo or video, โโ if not. If the post is a shared 360 degree photo/video, Facebook can not detect that the original post contains 360 degree content thus the column would also hold โโ. |
| attachmentName | TEXT | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | TEXT | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | TEXT | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | TEXT | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
facebookQuestions
Holding public information about questions by Facebook users posted to the Timeline of Facebook Pages with all their statistics attached. Please note this data source is a subset of facebookOwnPosts, just showing User Posts identified as a question. A question is defined as any message containing a question mark.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| userName | TEXT | No documentation available yet |
| likes | NUMERIC | No documentation available yet |
| love | NUMERIC | No documentation available yet |
| wow | NUMERIC | No documentation available yet |
| haha | NUMERIC | No documentation available yet |
| sad | NUMERIC | No documentation available yet |
| angry | NUMERIC | No documentation available yet |
| comments | NUMERIC | No documentation available yet |
| shares | NUMERIC | No documentation available yet |
| responseTime | TEXT | No documentation available yet |
| timeToRespond | NUMERIC | No documentation available yet |
| interactionRate | NUMERIC | No documentation available yet |
| link | TEXT | No documentation available yet |
| message | TEXT | No documentation available yet |
| isQuestion | TEXT | No documentation available yet |
facebookUserPosts
Holding public information about posts by Facebook users to the Timeline of Facebook Pages with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| userName | TEXT | The name of the user who created the user post. |
| message | TEXT | The contents of the post message. |
| type | TEXT | The object type of the post. |
| link | TEXT | The link to the post. |
| externalId | TEXT | The unique id of the post. |
| likes | NUMERIC | Number of "Like" reactions the post got. This doesn't include reactions on shares. |
| love | NUMERIC | Number of "Love" reactions the post got. This doesn't include reactions on shares. |
| wow | NUMERIC | Number of "Wow" reactions the post got. This doesn't include reactions on shares. |
| haha | NUMERIC | Number of "Haha" reactions the post got. This doesn't include reactions on shares. |
| sad | NUMERIC | Number of "Sorry" reactions the post got. This doesn't include reactions on shares. |
| angry | NUMERIC | Number of "Anger" reactions the post got. This doesn't include reactions on shares. |
| thankful | NUMERIC | Number of "Thankful" reactions the post got. This doesn't include reactions on shares. |
| comments | NUMERIC | Number of comments the post got. This doesn't include comments on shares. |
| shares | NUMERIC | Number of shares the post got. This doesn't include shares of shares. |
| isQuestion | TEXT | If the post contains a question or not. Holds โ1โ if the post contains a question, โโ if not. |
| responseTime | TEXT | The time in seconds between the created time of the user post and the time of the pages's first comment on the user post. |
| timeToRespond | NUMERIC | The date of the pages's first comment on the user post in "Y/m/d H:i:s" format. |
| appId | TEXT | The id of the third party app which was used to publish the post. |
| appName | TEXT | The name of the third party app which was used to publish the post. |
| attachmentName | TEXT | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | TEXT | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | TEXT | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | TEXT | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
feed
Holding public data for RSS Feeds and their development over time. All numbers are aggregates across the whole RSS Feed.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| posts | NUMERIC | No documentation available yet |
| facebookShares | NUMERIC | No documentation available yet |
| facebookBoxComments | NUMERIC | No documentation available yet |
| alexaLinksInCount | NUMERIC | No documentation available yet |
| alexaLinksInCountBefore | NUMERIC | No documentation available yet |
| alexaLinksInCountChange | NUMERIC | No documentation available yet |
| alexaRank | NUMERIC | No documentation available yet |
| alexaRankBefore | NUMERIC | No documentation available yet |
| alexaRankChange | NUMERIC | No documentation available yet |
| alexaReachPerMillion | NUMERIC | No documentation available yet |
| alexaReachPerMillionBefore | NUMERIC | No documentation available yet |
| alexaReachPerMillionChange | NUMERIC | No documentation available yet |
| alexaPageViewsPerMillion | NUMERIC | No documentation available yet |
| alexaPageViewsPerMillionBefore | NUMERIC | No documentation available yet |
| alexaPageViewsPerMillionChange | NUMERIC | No documentation available yet |
| alexaPageViewsPerUser | NUMERIC | No documentation available yet |
| alexaPageViewsPerUserBefore | NUMERIC | No documentation available yet |
| alexaPageViewsPerUserChange | NUMERIC | No documentation available yet |
feedPosts
Holding public information about articles of RSS Feeds with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this article was created in "Y/m/d H:i:s" format and UTC timezone. |
| title | TEXT | No documentation available yet |
| authors | TEXT | No documentation available yet |
| categories | TEXT | No documentation available yet |
| link | TEXT | No documentation available yet |
| externalId | TEXT | No documentation available yet |
| description | TEXT | No documentation available yet |
| text | TEXT | No documentation available yet |
| facebookShares | NUMERIC | No documentation available yet |
| facebookBoxComments | NUMERIC | No documentation available yet |
| interactionRate | NUMERIC | No documentation available yet |
googlePlus
Holding public data for Google+ Pages and their development over time. All numbers are aggregates across the whole Google+ Page.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| plusOnes | NUMERIC | Total number of plus ones for the GooglePlus Page at the end of the interval. |
| plusOnesBefore | NUMERIC | Total number of plus ones for the GooglePlus Page at the beginning of the interval. |
| plusOnesChange | NUMERIC | Change of the total number of plus ones for the GooglePlus Page between the beginning and the end of the interval. |
| circledBy | NUMERIC | Total number of Circle Followers ones for the GooglePlus Page at the end of the interval. |
| circledByBefore | NUMERIC | Total number of Circle Followers for the GooglePlus Page at the beginning of the interval. |
| circledByChange | NUMERIC | Change of the total number of Circle Followers for the GooglePlus Page between the beginning and the end of the interval. |
| ownPosts | NUMERIC | Number of new posts by the GooglePlus Page in the current interval. |
| ownPostsLikes | NUMERIC | Total number of likes on new posts created within the current interval. |
| ownPostsComments | NUMERIC | Total number of comments on new posts created within the current interval. |
| ownPostsShares | NUMERIC | Total number of shares on new posts created within the current interval. |
| ownPostsTypeStatus | NUMERIC | Number of new posts of type Status (text only) by the GooglePlus Page in the current interval. |
| ownPostsTypePhoto | NUMERIC | Number of new posts of type Photo (holding a photo attachment) by the GooglePlus Page in the current interval. |
| ownPostsTypeAlbum | NUMERIC | Number of new posts of type Album (holding an album attachment) by the GooglePlus Page in the current interval. |
| ownPostsTypeVideo | NUMERIC | Number of new posts of type Video (holding a video attachment) by the GooglePlus Page in the current interval. |
| ownPostsTypeArticle | NUMERIC | Number of new posts of type Article (holding an article attachment) by the GooglePlus Page in the current interval. |
| ownPostsTypeMisc | NUMERIC | Number of new posts of all other types by the GooglePlus Page in the current interval. |
googlePlusOwnPosts
Holding public information about posts of Google+ Pages with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| likes | NUMERIC | Number of likes the post got. |
| comments | NUMERIC | Number of comments the post got. |
| shares | NUMERIC | Number of shares the post got. |
| type | TEXT | The object type of the post. |
| interactionRate | NUMERIC | Holds the interaction rate of the post. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| link | TEXT | The link to the post. |
| externalId | TEXT | The unique id of the post. |
| message | TEXT | The contents of the post message. |
| circledBy | NUMERIC | Number of Circle Followers the page had on the day the post was published. |
| clicks | NUMERIC | Number of clicks links within the post got. Note: This only includes links from link shorteners such as bit.ly or goo.gl as this data is publicly available. Holds โnullโ if the post doesn't include a shortened link. |
Holding public data for Instagram Profiles and their development over time. All numbers are aggregates across the whole Instagram Profile.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| followers | NUMERIC | Total number of Followers for the Instagram Account at the end of the interval. |
| followersBefore | NUMERIC | Total number of Followers for the Instagram Account at the beginning of the interval. |
| followersChange | NUMERIC | Change of the total number of Followers for the Instagram Account between the beginning and the end of the interval. |
| following | NUMERIC | Total number of Instagram Accounts the Account is following at the end of the interval. |
| followingBefore | NUMERIC | Total number of Instagram Accounts the Account is following at the beginning of the interval. |
| followingChange | NUMERIC | Change of the total number of Instagram Accounts the Account is following between the beginning and the end of the interval. |
| posts | NUMERIC | Total number of published posts of the Instagram Account at the end of the interval. |
| postsBefore | NUMERIC | Total number of published posts in the Instagram Account at the beginning of the interval. |
| postsChange | NUMERIC | Change of the total number of published posts in the Instagram Account between the beginning and the end of the interval. |
| images | NUMERIC | Number of new image posts by the Instagram Account in the current interval. |
| imagesLikes | NUMERIC | Total number of likes on new image posts created within the current interval. |
| imagesComments | NUMERIC | Total number of comments on new image posts created within the current interval. |
| videos | NUMERIC | Number of new video posts by the Instagram Account in the current interval. |
| videosLikes | NUMERIC | Total number of likes on new video posts created within the current interval. |
| videosComments | NUMERIC | Total number of comments on new video posts created within the current interval. |
| carousels | NUMERIC | Number of new carousel posts by the Instagram Account in the current interval. |
| carouselsLikes | NUMERIC | Total number of likes on new carousel posts created within the current interval. |
| carouselsComments | NUMERIC | Total number of comments on new carousel posts created within the current interval. |
instagramInsights
Holding private-level data for Instagram Business Accounts from Instagram Insights and their development over time. All numbers are aggregates across the whole Instagram Business Account. Please note that Instagram Insights provide data for only three different intervals: daily, weekly and 28 days and thus for unique metrics like Reach one cannot go beyond 28 day analysis.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| impressions | NUMERIC | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. |
| impressionsDay | NUMERIC | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds daily fixed interval values. |
| impressionsWeek | NUMERIC | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds weekly fixed interval values. |
| impressionsDays28 | NUMERIC | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds 28 days fixed interval values. |
| reach | NUMERIC | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. |
| reachDay | NUMERIC | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds daily fixed interval values. |
| reachWeek | NUMERIC | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds weekly fixed interval values. |
| reachDays28 | NUMERIC | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds 28 days fixed interval values. |
| followerCountDay | NUMERIC | Total number of followers of the account within the selected time interval. This metric is only available for daily interval. |
| emailContactsDay | NUMERIC | Total number of times the Email Contact call to action button was clicked on the selected account within the selected time interval. This metric is only available for daily interval. |
| phoneCallClicksDay | NUMERIC | Total number of times the Phone Call call to action button was clicked on the selected account within the selected time interval. This metric is only available for daily interval. |
| textMessageClicksDay | NUMERIC | Total number of times the Text Message call to action button was clicked on the selected account within the selected time interval. This metric is only available for daily interval. |
| getDirectionsClicksDay | NUMERIC | Total number of times the Get Directions call to action button was clicked on the selected account within the selected time interval. This metric is only available for daily interval. |
| websiteClicksDay | NUMERIC | Total number of times users clicked on the website link of the account. This metric is only available for daily interval. |
| profileViewsDay | NUMERIC | Total number of times the account was viewed. Unlike reach or impressions this holds only the views of the profile page, it doesn't include any other contexts (e.g. posts on the feed). This metric is only available for daily interval. |
instagramInsightsOwnPosts
Holding information about posts of Instagram Business Accounts with all their private statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | The post's ID on Instagram's platform. |
| shortCode | TEXT | The post's short-code as defined on Instagram's platform. |
| message | TEXT | The caption of the Instagram post. |
| likes | NUMERIC | Total number of likes a post received. This value doesn't include likes received from paid context. |
| comments | NUMERIC | Total number of comments a post received. This value doesn't include comments received from paid context. |
| link | TEXT | The direct link to the post. |
| mediaUrl | TEXT | The link to the post's attached media. |
| attachmentPreviewPicture | TEXT | The link to the post's attached media thumbnail. |
| type | TEXT | The type of the post. This can be either Image, Video or Carousel. |
| impressions | NUMERIC | Total number of times the post was seen. This number is not unique and it does not include impressions from paid context. |
| engagement | NUMERIC | Total number of engagements (likes, comments and saves) on the post. This number is not unique and it does not include engagements from paid context. |
| reach | NUMERIC | Total number of users who have seen the post. This number is unique, one user is only counted once even if they've seen the post multiple times. It does not include reach from paid context. |
| saved | NUMERIC | The number of times users saved the post on Instagram. This value doesn't include saves received from paid context. |
| videoViews | NUMERIC | This shows the total number of times a video has been played regardless of the watched time. This value is not unique. |
instagramInsightsStories
Holding private-level information about Instagram stories, including impressions reach, taps and other metrics.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | The story's ID on Instagram's platform |
| shortCode | TEXT | The story's short-code as defined on Instagram's platform |
| caption | TEXT | The captions of the Instagram story. If there's more than one text item, the text items are concatenated and whitespace-separated |
| link | TEXT | The direct link to the story (works only on mobile devices with the Instagram app) |
| mediaUrl | TEXT | The link to the story's media |
| thumbnailUrl | TEXT | The link to the story's preview picture |
| type | TEXT | The type of the story (photo/video) |
| impressions | NUMERIC | The number of impressions on the story |
| exits | NUMERIC | Number of times someone exited the stories carousel |
| reach | NUMERIC | The number of people who saw the story at least once; reach is different from impressions, which may include multiple views of the story by the same people |
| replies | NUMERIC | The total number of replies to the stories carousel |
| tapsForward | NUMERIC | The total number of taps to see this story's next photo or video |
| tapsBack | NUMERIC | The total number of taps to see this story's previous photo or video |
instagramOwnPosts
Holding public information about posts of Instagram profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| likes | NUMERIC | Number of likes the post got. |
| comments | NUMERIC | Number of comments the post got. |
| type | TEXT | The object type of the post. |
| interactionRate | NUMERIC | Holds the interaction rate of the post. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| link | TEXT | The link to the post. |
| externalId | TEXT | The unique id of the post. |
| message | TEXT | The contents of the post message. |
| filter | TEXT | The name of the filter which was applied to the photo/video. |
| followers | NUMERIC | Number of followers the page had on the day the post was published. |
| clicks | NUMERIC | Number of clicks links within the post got. Note: This only includes links from link shorteners such as bit.ly or goo.gl as this data is publicly available. Holds โnullโ if the post doesn't include a shortened link. |
| mediaUrl | TEXT | The Url of the raw media file. Holds "null" if no attachment preview picture is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
Holding public data for LinkedIn Company Pages and their development over time. All numbers are aggregates across the whole LinkedIn Company Page.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| followers | NUMERIC | Total number of Followers for the LinkedIn Page at the end of the interval. |
| followersBefore | NUMERIC | Total number of Followers for the LinkedIn Page at the beginning of the interval. |
| followersChange | NUMERIC | Change of the total number of Followers for the LinkedIn Page between the beginning and the end of the interval. |
| ownPosts | NUMERIC | Number of new updates by the LinkedIn Page in the current interval. |
| ownPostsLikes | NUMERIC | Total number of likes on new updates created within the current interval. |
| ownPostsComments | NUMERIC | Total number of comments on new updates created within the current interval. |
| ownPostsTypeStatus | NUMERIC | Number of new updates of type Status (text only) by the LinkedIn Page in the current interval. |
| ownPostsTypePhoto | NUMERIC | Number of new updates of type Photo (holding a photo attachment) by the LinkedIn Page in the current interval. |
| ownPostsTypeLink | NUMERIC | Number of new updates of type Link (holding a link attachment) by the LinkedIn Page in the current interval. |
| ownPostsTypeJob | NUMERIC | DEPRECATED: Number of new job updates by the LinkedIn Page in the current interval. This column is deprecated as there are limitation for importing job updates. |
| ownPostsTypeMisc | NUMERIC | Number of new updates of all other types by the LinkedIn Page in the current interval. |
linkedInUpdates
Holding public information about Status Updates of LinkedIn Company Pages with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| likes | NUMERIC | Number of likes the update got. |
| comments | NUMERIC | Number of comments the update got. |
| link | TEXT | The link to the update. |
| type | TEXT | The object type of the update. |
| externalId | TEXT | The unique id of the update. |
| interactionRate | NUMERIC | Holds the interaction rate of the update. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| message | TEXT | The contents of the update message. |
| followers | NUMERIC | 'Number of followers the page had on the day the update was published. |
| clicks | NUMERIC | Number of clicks links within the update got. Note: This only includes links from link shorteners such as bit.ly or goo.gl as this data is publicly available. Holds โnullโ if the update doesn't include a shortened link. |
| attachmentName | TEXT | The name of the update's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | TEXT | The description of the update's attachment. Holds "null" if no attachment description is set. |
| attachmentHref | TEXT | The URL of the update's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | TEXT | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
Holding public data for Pinterest Profiles and their development over time. All numbers are aggregates across the whole Pinterest Profile.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| followers | NUMERIC | No documentation available yet |
| followersBefore | NUMERIC | No documentation available yet |
| followersChange | NUMERIC | No documentation available yet |
| following | NUMERIC | No documentation available yet |
| followingBefore | NUMERIC | No documentation available yet |
| followingChange | NUMERIC | No documentation available yet |
| pins | NUMERIC | No documentation available yet |
| pinsBefore | NUMERIC | No documentation available yet |
| pinsChange | NUMERIC | No documentation available yet |
| boards | NUMERIC | No documentation available yet |
| boardsBefore | NUMERIC | No documentation available yet |
| boardsChange | NUMERIC | No documentation available yet |
| likes | NUMERIC | No documentation available yet |
| likesBefore | NUMERIC | No documentation available yet |
| likesChange | NUMERIC | No documentation available yet |
| boardCollaborators | NUMERIC | No documentation available yet |
| boardCollaboratorsBefore | NUMERIC | No documentation available yet |
| boardCollaboratorsChange | NUMERIC | No documentation available yet |
| boardFollowers | NUMERIC | No documentation available yet |
| boardFollowersBefore | NUMERIC | No documentation available yet |
| boardFollowersChange | NUMERIC | No documentation available yet |
| boardPins | NUMERIC | No documentation available yet |
| boardPinsBefore | NUMERIC | No documentation available yet |
| boardPinsChange | NUMERIC | No documentation available yet |
| pinComments | NUMERIC | No documentation available yet |
| pinCommentsBefore | NUMERIC | No documentation available yet |
| pinCommentsChange | NUMERIC | No documentation available yet |
| pinLikes | NUMERIC | No documentation available yet |
| pinLikesBefore | NUMERIC | No documentation available yet |
| pinLikesChange | NUMERIC | No documentation available yet |
| saves | NUMERIC | No documentation available yet |
| savesBefore | NUMERIC | No documentation available yet |
| savesChange | NUMERIC | No documentation available yet |
| ownBoards | NUMERIC | No documentation available yet |
| ownBoardsBefore | NUMERIC | No documentation available yet |
| ownBoardsChange | NUMERIC | No documentation available yet |
| ownBoardsFollowers | NUMERIC | No documentation available yet |
| ownBoardsFollowersBefore | NUMERIC | No documentation available yet |
| ownBoardsFollowersChange | NUMERIC | No documentation available yet |
| ownBoardsPins | NUMERIC | No documentation available yet |
| ownBoardsPinsBefore | NUMERIC | No documentation available yet |
| ownBoardsPinsChange | NUMERIC | No documentation available yet |
| collaboratorBoards | NUMERIC | No documentation available yet |
| collaboratorBoardsBefore | NUMERIC | No documentation available yet |
| collaboratorBoardsChange | NUMERIC | No documentation available yet |
| collaboratorBoardsFollowers | NUMERIC | No documentation available yet |
| collaboratorBoardsFollowersBefore | NUMERIC | No documentation available yet |
| collaboratorBoardsFollowersChange | NUMERIC | No documentation available yet |
| collaboratorBoardsPins | NUMERIC | No documentation available yet |
| collaboratorBoardsPinsBefore | NUMERIC | No documentation available yet |
| collaboratorBoardsPinsChange | NUMERIC | No documentation available yet |
| ownPins | NUMERIC | No documentation available yet |
| ownPinsBefore | NUMERIC | No documentation available yet |
| ownPinsChange | NUMERIC | No documentation available yet |
| ownPinsLikes | NUMERIC | No documentation available yet |
| ownPinsLikesBefore | NUMERIC | No documentation available yet |
| ownPinsLikesChange | NUMERIC | No documentation available yet |
| ownPinsComments | NUMERIC | No documentation available yet |
| ownPinsCommentsBefore | NUMERIC | No documentation available yet |
| ownPinsCommentsChange | NUMERIC | No documentation available yet |
| ownPinsSaves | NUMERIC | No documentation available yet |
| ownPinsSavesBefore | NUMERIC | No documentation available yet |
| ownPinsSavesChange | NUMERIC | No documentation available yet |
| collaboratorPins | NUMERIC | No documentation available yet |
| collaboratorPinsBefore | NUMERIC | No documentation available yet |
| collaboratorPinsChange | NUMERIC | No documentation available yet |
| collaboratorPinsLikes | NUMERIC | No documentation available yet |
| collaboratorPinsLikesBefore | NUMERIC | No documentation available yet |
| collaboratorPinsLikesChange | NUMERIC | No documentation available yet |
| collaboratorPinsComments | NUMERIC | No documentation available yet |
| collaboratorPinsCommentsBefore | NUMERIC | No documentation available yet |
| collaboratorPinsCommentsChange | NUMERIC | No documentation available yet |
| collaboratorPinsSaves | NUMERIC | No documentation available yet |
| collaboratorPinsSavesBefore | NUMERIC | No documentation available yet |
| collaboratorPinsSavesChange | NUMERIC | No documentation available yet |
pinterestBoards
Holding public information about Boards of Pinterest profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| followers | NUMERIC | No documentation available yet |
| pins | NUMERIC | No documentation available yet |
| collaborators | NUMERIC | No documentation available yet |
| name | TEXT | No documentation available yet |
| link | TEXT | No documentation available yet |
| externalId | TEXT | No documentation available yet |
| description | TEXT | No documentation available yet |
| isCollaboratorBoard | TEXT | No documentation available yet |
pinterestPins
Holding public information about Pins on Boards of Pinterest profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| boardId | TEXT | No documentation available yet |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| creatorId | TEXT | No documentation available yet |
| creatorUrl | TEXT | No documentation available yet |
| likes | NUMERIC | No documentation available yet |
| comments | NUMERIC | No documentation available yet |
| saves | NUMERIC | No documentation available yet |
| message | TEXT | No documentation available yet |
| pinType | TEXT | No documentation available yet |
| mediaType | TEXT | No documentation available yet |
| pinLink | TEXT | No documentation available yet |
| link | TEXT | No documentation available yet |
| attachmentPreviewPicture | TEXT | No documentation available yet |
| externalId | TEXT | No documentation available yet |
| price | NUMERIC | No documentation available yet |
| currency | TEXT | No documentation available yet |
| isOwnPin | TEXT | No documentation available yet |
Holding public data for Twitter Profiles and their development over time. All numbers are aggregates across the whole Twitter Profile.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| followers | NUMERIC | Total number of Followers for the Twitter Account at the end of the interval. |
| followersBefore | NUMERIC | Total number of Followers for the Twitter Account at the beginning of the interval. |
| followersChange | NUMERIC | Change of the total number of Followers for the Twitter Account between the beginning and the end of the interval. |
| following | NUMERIC | Total number of Twitter Accounts the Account is following at the end of the interval. |
| followingBefore | NUMERIC | Total number of Twitter Accounts the Account is following at the beginning of the interval. |
| followingChange | NUMERIC | Change of the total number of Twitter Accounts the Account is following between the beginning and the end of the interval. |
| tweets | NUMERIC | Total number of published tweets of the Twitter Account at the end of the interval. Beside own tweets this number also includes own replies and own retweets. |
| tweetsBefore | NUMERIC | Total number of published tweets in the Twitter Account at the beginning of the interval. Beside own tweets this number also includes own replies and own retweets. |
| tweetsChange | NUMERIC | Change of the total number of published tweets in the Twitter Account between the beginning and the end of the interval. Beside own tweets this number also includes own replies and own retweets. |
| ownTweets | NUMERIC | Number of new own tweets by the Twitter Account in the current interval. This doesn't include own retweets or own replies of the Account. |
| ownTweetsRetweets | NUMERIC | Total number of retweets on new tweets created within the current interval. |
| ownTweetsFavs | NUMERIC | Total number of likes on new tweets created within the current interval. |
| ownTweetsReplies | NUMERIC | Total number of replies on new tweets created within the current interval. |
| retweetedTweets | NUMERIC | Number of tweets the Twitter Account retweeted in the current interval. |
| replies | NUMERIC | Number of replies by the Twitter Account in the current interval. This includes replies on own tweets as well as replies on retweeted tweets and replies on other replies. |
| repliesFromUsers | NUMERIC | Number of replies the Twitter Account got from other Accounts in the current interval. |
| retweets | NUMERIC | Number of replies the Twitter Account got from other Accounts in the current interval. |
| favorites | NUMERIC | Total number of retweets on new tweets and on own replies created within the current interval. |
| mentions | NUMERIC | Total number of tweets the Twitter account was mentioned in within the current interval. This includes replies from users because in every reply the account is also mentioned. |
| responseTime0To2h | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question answered within 2 hours by the Twitter account. You find more information about how we calculate Twitter response times in our knowledge base article. |
| responseTime2To8h | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question answered between 2 and 8 hours by the Twitter account. You find more information about how we calculate Twitter response times in our knowledge base article. |
| responseTime8To24h | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question answered between 8 and 24 hours by the Twitter account. You find more information about how we calculate Twitter response times in our knowledge base article. |
| responseTimeLongerThan24h | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question answered later than 24 hours by the Twitter account. You find more information about how we calculate Twitter response times in our knowledge base article. |
| responseTimeNotResponded | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question never answered by the Twitter account. You find more information about how we calculate Twitter response times in our knowledge base article. |
| questions | NUMERIC | Number of tweets the Twitter account was mentioned in identified as a question in the current interval. A tweet qualifies as a question if it includes a question mark. |
twitterAnalyticsOwnTweets
Holding private-level information about Tweets, excluding Retweeted Tweets and Replies, of Twitter profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | No documentation available yet |
| followers | NUMERIC | No documentation available yet |
| interactionRate | NUMERIC | No documentation available yet |
| retweets | NUMERIC | No documentation available yet |
| favs | NUMERIC | No documentation available yet |
| replies | NUMERIC | No documentation available yet |
| link | TEXT | No documentation available yet |
| message | TEXT | No documentation available yet |
| source | TEXT | No documentation available yet |
| impressions | NUMERIC | Impressions are the amount of instances in which a Tweet showed up in someoneโs feed or search results |
| engagements | NUMERIC | Engagement is the amount of interactions received for a tweet, and can include likes, retweets, replies, mentions, follows, profile clicks, permalink/link clicks and tweet expansions |
| engagementRate | NUMERIC | Engagement Rate is calculated as the ratio between the number of non-unique engagements and the number of non-unique impressions |
twitterInteractionPatterns
Holding interaction patterns extracted from our overall database of Twitter Mentions. The general idea is about identify relationships between Twitter profiles by looking at the Twitter users mentioning selected Twitter profiles. A relationship between two Twitter profiles is established once there was a Twitter user mentioning both profiles in a given time period. Important to note is that this must not happen by mentioning both profiles within the same Tweet, but it can (and most likely will) be separate Tweets of the same user mentioning one of the profiles each. On top of just identifying relationships we do also count how many Twitter users support a certain relationship and thus can specify how strong a relationship between two Twitter profiles is.
A very similar use case is to detect overlaps between two Twitter profiles by analyzing their followers. One could deliver a top ranking of Twitter profiles having the biggest intersection with your own follower base. Instead of taking the followers of a profile as a base, this data source focuses on just active users (users mentioning a profile).
In just a few words: Taking a set of Twitter profiles as a starting point, it helps you to find out where Twitter users engaging with these profiles are also engaging. This information can be used for various different use cases like ad optimization and understanding interests of your active community.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | No documentation available yet |
| profileUsername | TEXT | No documentation available yet |
| profileLink | TEXT | No documentation available yet |
| uniqueUsers | NUMERIC | No documentation available yet |
| share | NUMERIC | No documentation available yet |
twitterKeyInteractingUsers
Holding information about Twitter users mentioning Twitter profiles, sorting by most active Twitter users by default.
| Column name | Type | Description |
|---|---|---|
| id | TEXT | No documentation available yet |
| name | TEXT | No documentation available yet |
| mentions | NUMERIC | No documentation available yet |
| overlaps | TEXT | No documentation available yet |
| overlapsCount | NUMERIC | No documentation available yet |
twitterMentions
Holding information about Mentions of Twitter profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | No documentation available yet |
| userName | TEXT | No documentation available yet |
| userFollowers | NUMERIC | No documentation available yet |
| message | TEXT | No documentation available yet |
| link | TEXT | No documentation available yet |
| isRetweet | TEXT | No documentation available yet |
| isReply | TEXT | No documentation available yet |
| isQuestion | TEXT | No documentation available yet |
| responseTime | TEXT | No documentation available yet |
| timeToRespond | NUMERIC | No documentation available yet |
| retweets | NUMERIC | No documentation available yet |
| favs | NUMERIC | No documentation available yet |
| userLocation | TEXT | No documentation available yet |
| lat | NUMERIC | No documentation available yet |
| lon | NUMERIC | No documentation available yet |
| placeType | TEXT | No documentation available yet |
| placeCountry | TEXT | No documentation available yet |
| placeCountryCode | TEXT | No documentation available yet |
| placeName | TEXT | No documentation available yet |
twitterOwnReplies
Holding information about Replies, excluding Own Tweets and Retweeted Tweets, of Twitter profiles with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | No documentation available yet |
| followers | NUMERIC | No documentation available yet |
| link | TEXT | No documentation available yet |
| message | TEXT | No documentation available yet |
| source | TEXT | No documentation available yet |
| replyToTweetId | TEXT | No documentation available yet |
| retweets | NUMERIC | No documentation available yet |
| favs | NUMERIC | No documentation available yet |
| replies | NUMERIC | No documentation available yet |
| clicks | NUMERIC | No documentation available yet |
| interactionRate | NUMERIC | No documentation available yet |
twitterOwnTweets
Holding information about Own Tweets and Retweeted Tweets, excluding Replies to Users, of Twitter accounts with all their statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| externalId | TEXT | The unique id of the post. |
| followers | NUMERIC | Number of followers the account had on the day the tweet was published. |
| interactionRate | NUMERIC | Holds the interaction rate of the tweet. Holds "null" if the tweet is retweeted by the Twitter account because it would standardize the interactions of the original tweet with the number of fans of the Twitter Account. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| retweets | NUMERIC | Number of retweets the tweet got. If the tweet is retweeted by the Twitter account it shows the number of retweets of the original tweet. |
| favs | NUMERIC | Number of likes the tweet got. If the tweet is retweeted by the Twitter account it shows the number of likes of the original tweet. |
| link | TEXT | The link to the tweet. |
| message | TEXT | The contents of the tweet message. |
| isRetweet | TEXT | If the tweet is retweeted by the Twitter account or not. Holds โ1โ if the tweet is a retweeted post, โโ if it's an own tweet. |
| clicks | NUMERIC | Number of clicks links within the tweet got. Note: This only includes links from link shorteners such as bit.ly or goo.gl as this data is publicly available. Holds โnullโ if the tweet doesn't include a shortened link. |
| source | TEXT | The name of the source which was used to publish the tweet. |
| replies | NUMERIC | Number of replies the tweet got. If the tweet is retweeted by the Twitter account it shows the number of replies of the original tweet. |
twitterQuestions
Holding information about questions sent to Twitter profiles in form of a Twitter Mention with all their statistics attached. Please note this data source is a subset of twitterMentions, just showing Mentions identified as a question. A question is defined as any Mention containing a question mark.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| userName | TEXT | No documentation available yet |
| favs | NUMERIC | No documentation available yet |
| retweets | NUMERIC | No documentation available yet |
| responseTime | TEXT | No documentation available yet |
| timeToRespond | NUMERIC | No documentation available yet |
| link | TEXT | No documentation available yet |
| message | TEXT | No documentation available yet |
| isQuestion | TEXT | No documentation available yet |
youtube
Holding public data for YouTube Channels and their development over time. All numbers are aggregates across the whole YouTube Channel.
Special meaning of postfixes:
****Before: Value of node at the beginning of the interval.
****Change: Change of value between the beginning and the end of the interval.
****Counted: Calculated by walking over every single entity of our database. This could include videos that were deleted for example.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| subscribers | NUMERIC | Total number of subscribers for the YouTube Channel at the end of the interval. |
| subscribersBefore | NUMERIC | Total number of subscribers for this YouTube Channel at the beginning of the interval. |
| views | NUMERIC | Total number of views counted on this date for the YouTube Channel at the end of the interval. |
| viewsBefore | NUMERIC | Total number of views counted on this date for the YouTube Channel at the beginning of the interval. |
| videos | NUMERIC | Total number of videos for this YouTube Channel at the end of the interval. |
| videosBefore | NUMERIC | Total number of videos for this YouTube Channel at the beginning of the interval. |
| channelComments | NUMERIC | Total number of channel comments for the YouTube Channel at the end of the interval. |
| channelCommentsBefore | NUMERIC | Total number of channel comments for this YouTube Channel at the beginning of the interval. |
youtubeAnalytics
Holding private-level data for youtube channels and their development over time. All numbers are aggregates across the whole youtube channel.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| views | NUMERIC | Total number of views for the youtube channel at the end of the interval. |
| likes | NUMERIC | Total number of likes for the youtube channel at the end of the interval. |
| dislikes | NUMERIC | Total number of dislikes for the youtube channel at the end of the interval. |
| subscribersLost | NUMERIC | The number of people who unsubscribed from the channel during the selected timeframe. |
| subscribersGained | NUMERIC | The number of people who subscribed to the channel during the selected timeframe. |
| shares | NUMERIC | Total number of shares for the youtube channel at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos for the youtube channel |
| comments | NUMERIC | Total number of comments for the youtube channel at the end of the interval. |
| averageViewDuration | NUMERIC | The average length, in seconds, of video playbacks for the youtube channel. |
| annotationCloseRate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | NUMERIC | The average percentage of a video watched during a video playback. |
youtubeAnalyticsCountries
Holding key metrics like Views and Engagement numbers of YouTube Channels per country. All numbers are related to the selected time period.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| countryCode | TEXT | The country associated with the metrics in the report row. The dimension value is a two-letter ISO-3166-1 country code, such as US, CN (China), or FR (France). The country code ZZ is used to report metrics for which YouTube could not identify the associated country. |
| countryName | TEXT | The full name of the country from the country Code. |
| views | NUMERIC | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| likes | NUMERIC | Total number of likes for the Youtube Channel at the end of the interval. |
| dislikes | NUMERIC | Total number of dislikes for the Youtube Channel at the end of the interval. |
| subscribersLost | NUMERIC | The number of people who unsubscribed from the channel during the selected timeframe. |
| subscribersGained | NUMERIC | The number of people who subscribed to the channel during the selected timeframe. |
| shares | NUMERIC | Total number of shares for the youtube channel at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos for the youtube channel. |
| comments | NUMERIC | Total number of comments for the youtube channel at the end of the interval. |
| averageViewDuration | NUMERIC | The average length, in seconds, of video playbacks for the youtube channel. |
| annotationCloseRate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | NUMERIC | The average percentage of a video watched during a video playback. |
youtubeAnalyticsDevices
Holding Views and Estimated Minutes Watched of YouTube Channels per device and their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| deviceType | TEXT | Identifies the physical form factor of the device on which the view occurred. One of: DESKTOP, GAME_CONSOLE, MOBILE, TABLET, TV, UNKNOWN_PLATFORM |
| deviceName | TEXT | Readable representation of deviceType. For example: "DESKTOP" => "Laptop and desktops" |
| views | NUMERIC | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos for the youtube channel. |
youtubeAnalyticsPlaybackLocations
Holding Views and Estimated Minutes Watched of YouTube Channels per Playback Location and their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| insightPlaybackLocationType | TEXT | Type of page or application where video playbacks occured. For example: EMBEDDED, MOBILE |
| insightPlaybackLocationName | TEXT | Readable representation if PlaybackLocationType. For example: "EMBEDDED" => "Embedded player on other websites" |
| views | NUMERIC | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos for the youtube channel. |
youtubeAnalyticsPlaylists
Holding information about Playlists of YouTube Channels with all their private-level statistics attached. All numbers are related to the selected time period.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| publishTime | TEXT | Time the playlist was published. |
| link | TEXT | Link to the playlist. |
| status | TEXT | Privacy status of the playlist. |
| title | TEXT | Title of the playlist. |
| description | TEXT | Description of the playlist. |
| views | NUMERIC | The total number of times the playlist got viewed. |
| estimatedMinutesWatched | NUMERIC | The total number of minutes viewers watched the playlist during the selected timeframe. |
| averageViewDuration | NUMERIC | The number of seconds on average that a viewer would watch the playlist during the selected timeframe. |
| playlistStarts | NUMERIC | The number of times that viewers initiated playback of the playlist during the selected timeframe. |
| viewsPerPlaylistStart | NUMERIC | The number of views on average per playlist start. The average number of video views that occurred each time a playlist was initiated during the selected timeframe. |
| averageTimeInPlaylist | NUMERIC | The number of minutes on average that a viewer would spend in the playlist during the selected timeframe. |
youtubeAnalyticsTopTenVideos
Holding information about the top 10 videos of YouTube Channels according to their number of Views, Estimated Minutes Watched or Subscribers Gained/Lost within the selected time period with all their private-level statistics attached. All numbers are related to the selected time period.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| publishTime | TEXT | The date when the video got published. |
| link | TEXT | Link to the video. |
| status | TEXT | Privacy status of the video. |
| title | TEXT | Title of the video. |
| description | TEXT | Description of the video. |
| duration | NUMERIC | Duration of the video in seconds |
| views | NUMERIC | Views of the video. |
| likes | NUMERIC | Likes of the video. |
| dislikes | NUMERIC | Dislikes of the video. |
| subscribersLost | NUMERIC | The total amount of subscribers lost on the videos watch page. |
| subscribersGained | NUMERIC | The total amount of subscribers gained on the videos watch page. |
| shares | NUMERIC | Shares of the video. |
| estimatedMinutesWatched | NUMERIC | The number of minutes users watched the video. |
| comments | NUMERIC | Total number of comments of this video. |
| averageViewDuration | NUMERIC | Average duration a user watched this video in seconds. |
| annotationCloseRate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | NUMERIC | The average percentage of a video watched during a video playback. |
youtubeAnalyticsTotal
Holding private-level data for YouTube Channels since the creation of these Channels. In contrast to the youtubeAnalytics data source this one holds total numbers since the creation of the specified YouTube Channels.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| views | NUMERIC | Total number of views for the youtube channel at the end of the interval. |
| likes | NUMERIC | Total number of likes for the youtube channel at the end of the interval. |
| dislikes | NUMERIC | Total number of dislikes for the youtube channel at the end of the interval. |
| subscribersLost | NUMERIC | The number of people who unsubscribed from the channel during the selected timeframe. |
| subscribersGained | NUMERIC | The number of people who subscribed to the channel during the selected timeframe. |
| shares | NUMERIC | Total number of shares for the youtube channel at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos for the youtube channel |
| comments | NUMERIC | Total number of comments for the youtube channel at the end of the interval. |
| averageViewDuration | NUMERIC | The average length, in seconds, of video playbacks for the youtube channel. |
| annotationCloseRate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | NUMERIC | The average percentage of a video watched during a video playback. |
youtubeAnalyticsTrafficSources
Holding Views and Estimated Minutes Watched of YouTube Channels per traffic source and their development over time.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| time | TEXT | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly) in "Y/m/d H:i:s" format and UTC timezone. |
| insightTrafficSourceType | TEXT | Type of the traffic source. One of: ADVERTISING, ANNOTATION, EXT_URL, NO_LINK_EMBEDDED, NO_LINK_OTHER, PLAYLIST, PROMOTED, RELATED_VIDEO, SUBSCRIBER, YT_CHANNEL, YT_OTHER_PAGE, YT_SEARCH, GOOGLE_SEARCH, EXT_APP, END_SCREEN |
| insightTrafficSourceName | TEXT | More readable representation of the traffic type. For example: "RELATED_VIDEO" => "YouTube suggested video" |
| views | NUMERIC | Total number of views from this traffic source. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched videos from this traffic source. |
youtubeAnalyticsVideos
Holding information about videos of YouTube Channels with all their private-level statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| publishTime | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| link | TEXT | Link to the video. |
| status | TEXT | Privacy status of the video. |
| title | TEXT | Title of the video. |
| description | TEXT | Description of the video. |
| views | NUMERIC | Total number of views for the video at the end of the interval. |
| likes | NUMERIC | Total number of likes for the video at the end of the interval. |
| dislikes | NUMERIC | Total number of dislikes for the youtube channel at the end of the interval. |
| subscribersLost | NUMERIC | The total amount of subscribers lost on the videos watch page. |
| subscribersGained | NUMERIC | The total amount of subscribers gained on the videos watch page. |
| shares | NUMERIC | Total number of shares for the video at the end of the interval. |
| estimatedMinutesWatched | NUMERIC | The number of minutes that users watched the video. |
| comments | NUMERIC | Total number of comments for the video at the end of the interval. |
| averageViewDuration | NUMERIC | The average length, in seconds, of video playbacks for the video. |
| annotationCloseRate | NUMERIC | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | NUMERIC | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | NUMERIC | The average percentage of a video watched during a video playback. |
youtubeVideos
Holding information about videos of YouTube Channels with all their public statistics attached.
| Column name | Type | Description |
|---|---|---|
| profileId | NUMERIC | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| publishTime | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| importTime | TEXT | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| title | TEXT | Title of the video. |
| link | TEXT | Link to the video. |
| externalId | TEXT | Id of the video in youtube's database. |
| videoId | TEXT | The same as externalId. Node exists for backwards compatibility to an older version of the API. |
| views | NUMERIC | Total amount of times a user watched this video. |
| likes | NUMERIC | Total amount of times a user liked this video. |
| dislikes | NUMERIC | Total amount of times a user disliked this video. |
| comments | NUMERIC | Total amount of comments on this video. |
| duration | NUMERIC | Duration of the video in seconds. |