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. |
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. |
| page_stories | NUMERIC | Number of stories created about your Page within the current interval. |
| page_stories_day | NUMERIC | Not available yet |
| page_stories_week | NUMERIC | Not available yet |
| page_stories_days_28 | NUMERIC | Not available yet |
| page_impressions | NUMERIC | Number of impressions seen of any content associated with your Page within the current interval. |
| page_impressions_day | NUMERIC | Not available yet |
| page_impressions_week | NUMERIC | Not available yet |
| page_impressions_days_28 | NUMERIC | Not available yet |
| page_impressions_unique | NUMERIC | Number of people who have seen any content associated with your Page within the current interval. Unique impressions are also known as reach. |
| page_impressions_unique_day | NUMERIC | Not available yet |
| page_impressions_unique_week | NUMERIC | Not available yet |
| page_impressions_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_impressions_paid_week | NUMERIC | Not available yet |
| page_impressions_paid_days_28 | NUMERIC | Not 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 | Not available yet |
| page_impressions_paid_unique_week | NUMERIC | Not available yet |
| page_impressions_paid_unique_days_28 | NUMERIC | Not available yet |
| page_impressions_organic | 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_organic_day | NUMERIC | Not available yet |
| page_impressions_organic_week | NUMERIC | Not available yet |
| page_impressions_organic_days_28 | NUMERIC | Not available yet |
| page_impressions_organic_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_organic_unique_day | NUMERIC | Not available yet |
| page_impressions_organic_unique_week | NUMERIC | Not available yet |
| page_impressions_organic_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_impressions_viral_week | NUMERIC | Not available yet |
| page_impressions_viral_days_28 | NUMERIC | Not 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 | Not available yet |
| page_impressions_viral_unique_week | NUMERIC | Not available yet |
| page_impressions_viral_unique_days_28 | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_total | NUMERIC | 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 | Not available yet |
| page_impressions_by_paid_non_paid_total_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_total_days_28 | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_paid | NUMERIC | 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 | Not available yet |
| page_impressions_by_paid_non_paid_paid_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_paid_days_28 | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unpaid | NUMERIC | 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 | Not available yet |
| page_impressions_by_paid_non_paid_unpaid_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unpaid_days_28 | NUMERIC | Not available yet |
| 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 | Not available yet |
| page_impressions_by_paid_non_paid_unique_total_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_total_days_28 | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_paid | 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_by_paid_non_paid_unique_paid_day | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_paid_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_paid_days_28 | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_unpaid | 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_by_paid_non_paid_unique_unpaid_day | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_unpaid_week | NUMERIC | Not available yet |
| page_impressions_by_paid_non_paid_unique_unpaid_days_28 | NUMERIC | Not available yet |
| page_visits_total | NUMERIC | Not available yet |
| page_visits_total_day | NUMERIC | Not available yet |
| page_visits_total_week | NUMERIC | Not available yet |
| page_visits_total_days_28 | NUMERIC | Not 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 | Not available yet |
| page_website_clicks_logged_in_count_week | NUMERIC | Not available yet |
| page_website_clicks_logged_in_count_days_28 | NUMERIC | Not 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 | Not available yet |
| page_website_clicks_logged_in_unique_week | NUMERIC | Not available yet |
| page_website_clicks_logged_in_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_engaged_users_week | NUMERIC | Not available yet |
| page_engaged_users_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_week | NUMERIC | Not available yet |
| page_consumptions_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_unique_week | NUMERIC | Not available yet |
| page_consumptions_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_link_clicks_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_link_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_other_clicks_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_other_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_photo_view_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_photo_view_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_video_play_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_video_play_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_unique_photo_view_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_unique_photo_view_days_28 | NUMERIC | Not 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 | Not available yet |
| page_consumptions_by_consumption_type_unique_video_play_week | NUMERIC | Not available yet |
| page_consumptions_by_consumption_type_unique_video_play_days_28 | NUMERIC | Not 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 | Not available yet |
| page_places_checkin_total_week | NUMERIC | Not available yet |
| page_places_checkin_total_days_28 | NUMERIC | Not 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 | Not available yet |
| page_places_checkin_total_unique_week | NUMERIC | Not available yet |
| page_places_checkin_total_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_places_checkin_mobile_week | NUMERIC | Not available yet |
| page_places_checkin_mobile_days_28 | NUMERIC | Not 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 | Not available yet |
| page_places_checkin_mobile_unique_week | NUMERIC | Not available yet |
| page_places_checkin_mobile_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_week | NUMERIC | Not available yet |
| page_negative_feedback_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_unique_week | NUMERIC | Not available yet |
| page_negative_feedback_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_hide_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_hide_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_hide_all_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_hide_all_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_unlike_page_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_unlike_page_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_report_spam_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_report_spam_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_unique_hide_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_unique_hide_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_days_28 | NUMERIC | Not 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 | Not available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_week | NUMERIC | Not available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_days_28 | NUMERIC | Not 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. |
| page_positive_feedback_by_type_like_day | NUMERIC | Not available yet |
| page_positive_feedback_by_type_like_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_like_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_comment_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_comment_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_link_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_link_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_rsvp_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_rsvp_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_claim_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_claim_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_answer_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_answer_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_like_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_like_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_comment_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_comment_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_link_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_link_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_rsvp_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_rsvp_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_claim_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_claim_days_28 | NUMERIC | Not 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 | Not available yet |
| page_positive_feedback_by_type_unique_answer_week | NUMERIC | Not available yet |
| page_positive_feedback_by_type_unique_answer_days_28 | NUMERIC | Not 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 | AbstractDataSource::DESCRIPTION_FOR_FANS_IN_TIME_SERIES) |
| page_fans_before | NUMERIC | AbstractDataSource::DESCRIPTION_FOR_FANS_BEFORE_IN_TIME_SERIES) |
| page_fans_change | NUMERIC | AbstractDataSource::DESCRIPTION_FOR_FANS_CHANGE_IN_TIME_SERIES) |
| 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 | Not available yet |
| page_posts_impressions_week | NUMERIC | Not available yet |
| page_posts_impressions_days_28 | NUMERIC | Not 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 | Not available yet |
| page_posts_impressions_unique_week | NUMERIC | Not available yet |
| page_posts_impressions_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_posts_impressions_paid_week | NUMERIC | Not available yet |
| page_posts_impressions_paid_days_28 | NUMERIC | Not 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 | Not available yet |
| page_posts_impressions_paid_unique_week | NUMERIC | Not available yet |
| page_posts_impressions_paid_unique_days_28 | NUMERIC | Not available yet |
| page_posts_impressions_organic | 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_organic_day | NUMERIC | Not available yet |
| page_posts_impressions_organic_week | NUMERIC | Not available yet |
| page_posts_impressions_organic_days_28 | NUMERIC | Not available yet |
| page_posts_impressions_organic_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_organic_unique_day | NUMERIC | Not available yet |
| page_posts_impressions_organic_unique_week | NUMERIC | Not available yet |
| page_posts_impressions_organic_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_posts_impressions_viral_week | NUMERIC | Not available yet |
| page_posts_impressions_viral_days_28 | NUMERIC | Not 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 | Not available yet |
| page_posts_impressions_viral_unique_week | NUMERIC | Not available yet |
| page_posts_impressions_viral_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_week | NUMERIC | Not available yet |
| page_video_views_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_week | NUMERIC | Not available yet |
| page_video_views_10s_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_unique_week | NUMERIC | Not available yet |
| page_video_views_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_unique_week | NUMERIC | Not available yet |
| page_video_views_10s_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_unique_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_unique_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_paid_week | NUMERIC | Not available yet |
| page_video_views_paid_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_paid_week | NUMERIC | Not available yet |
| page_video_views_10s_paid_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_paid_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_paid_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_organic_week | NUMERIC | Not available yet |
| page_video_views_organic_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_organic_week | NUMERIC | Not available yet |
| page_video_views_10s_organic_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_organic_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_organic_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_autoplayed_week | NUMERIC | Not available yet |
| page_video_views_autoplayed_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_autoplayed_week | NUMERIC | Not available yet |
| page_video_views_10s_autoplayed_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_autoplayed_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_autoplayed_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_click_to_play_week | NUMERIC | Not available yet |
| page_video_views_click_to_play_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_click_to_play_week | NUMERIC | Not available yet |
| page_video_views_10s_click_to_play_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_click_to_play_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_click_to_play_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_repeat_views_week | NUMERIC | Not available yet |
| page_video_repeat_views_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_views_10s_repeat_week | NUMERIC | Not available yet |
| page_video_views_10s_repeat_days_28 | NUMERIC | Not 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 | Not available yet |
| page_video_complete_views_30s_repeat_views_week | NUMERIC | Not available yet |
| page_video_complete_views_30s_repeat_views_days_28 | NUMERIC | Not available yet |
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. |
| 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. |
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. |
| 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. |
| likes | NUMERIC | Number of likes the post got. This doesn't include likes 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. |
| 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 times people saw the Page post. |
| post_impressions_unique | NUMERIC | Number of people the Page post was served to. |
| 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. |
| 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_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_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 | Number of impressions of the Page post. |
| post_impressions_by_paid_non_paid_paid | NUMERIC | Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_by_paid_non_paid_unpaid | NUMERIC | 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 | Number of people the Page post was served to. This is also known as reach. |
| post_impressions_by_paid_non_paid_unique_paid | NUMERIC | 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 | 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
| 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". |
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. |
| 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. |
| comments | NUMERIC | Number of comments on the video. This doesn't include comments on shares. |
| 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 | Not available yet |
| profileLink | TEXT | Not available yet |
| picture | TEXT | Not available yet |
| posts | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| total | NUMERIC | Not available yet |
| overlaps | TEXT | Not available yet |
| overlapsCount | NUMERIC | Not 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. |
| 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. |
| 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 | Not available yet |
| likes | NUMERIC | Not available yet |
| love | NUMERIC | Not available yet |
| wow | NUMERIC | Not available yet |
| haha | NUMERIC | Not available yet |
| sad | NUMERIC | Not available yet |
| angry | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| responseTime | TEXT | Not available yet |
| timeToRespond | NUMERIC | Not available yet |
| interactionRate | NUMERIC | Not available yet |
| link | TEXT | Not available yet |
| message | TEXT | Not available yet |
| isQuestion | TEXT | Not 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 | Not available yet |
| facebookShares | NUMERIC | Not available yet |
| facebookBoxComments | NUMERIC | Not available yet |
| alexaLinksInCount | NUMERIC | Not available yet |
| alexaLinksInCountBefore | NUMERIC | Not available yet |
| alexaLinksInCountChange | NUMERIC | Not available yet |
| alexaRank | NUMERIC | Not available yet |
| alexaRankBefore | NUMERIC | Not available yet |
| alexaRankChange | NUMERIC | Not available yet |
| alexaReachPerMillion | NUMERIC | Not available yet |
| alexaReachPerMillionBefore | NUMERIC | Not available yet |
| alexaReachPerMillionChange | NUMERIC | Not available yet |
| alexaPageViewsPerMillion | NUMERIC | Not available yet |
| alexaPageViewsPerMillionBefore | NUMERIC | Not available yet |
| alexaPageViewsPerMillionChange | NUMERIC | Not available yet |
| alexaPageViewsPerUser | NUMERIC | Not available yet |
| alexaPageViewsPerUserBefore | NUMERIC | Not available yet |
| alexaPageViewsPerUserChange | NUMERIC | Not 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 | Not available yet |
| authors | TEXT | Not available yet |
| categories | TEXT | Not available yet |
| link | TEXT | Not available yet |
| externalId | TEXT | Not available yet |
| description | TEXT | Not available yet |
| text | TEXT | Not available yet |
| facebookShares | NUMERIC | Not available yet |
| facebookBoxComments | NUMERIC | Not available yet |
| interactionRate | NUMERIC | Not 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. |
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. |
| 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. |
| 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. |
| 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 | Not available yet |
| followersBefore | NUMERIC | Not available yet |
| followersChange | NUMERIC | Not available yet |
| following | NUMERIC | Not available yet |
| followingBefore | NUMERIC | Not available yet |
| followingChange | NUMERIC | Not available yet |
| pins | NUMERIC | Not available yet |
| pinsBefore | NUMERIC | Not available yet |
| pinsChange | NUMERIC | Not available yet |
| boards | NUMERIC | Not available yet |
| boardsBefore | NUMERIC | Not available yet |
| boardsChange | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| likesBefore | NUMERIC | Not available yet |
| likesChange | NUMERIC | Not available yet |
| boardCollaborators | NUMERIC | Not available yet |
| boardCollaboratorsBefore | NUMERIC | Not available yet |
| boardCollaboratorsChange | NUMERIC | Not available yet |
| boardFollowers | NUMERIC | Not available yet |
| boardFollowersBefore | NUMERIC | Not available yet |
| boardFollowersChange | NUMERIC | Not available yet |
| boardPins | NUMERIC | Not available yet |
| boardPinsBefore | NUMERIC | Not available yet |
| boardPinsChange | NUMERIC | Not available yet |
| pinComments | NUMERIC | Not available yet |
| pinCommentsBefore | NUMERIC | Not available yet |
| pinCommentsChange | NUMERIC | Not available yet |
| pinLikes | NUMERIC | Not available yet |
| pinLikesBefore | NUMERIC | Not available yet |
| pinLikesChange | NUMERIC | Not available yet |
| saves | NUMERIC | Not available yet |
| savesBefore | NUMERIC | Not available yet |
| savesChange | NUMERIC | Not available yet |
| ownBoards | NUMERIC | Not available yet |
| ownBoardsBefore | NUMERIC | Not available yet |
| ownBoardsChange | NUMERIC | Not available yet |
| ownBoardsFollowers | NUMERIC | Not available yet |
| ownBoardsFollowersBefore | NUMERIC | Not available yet |
| ownBoardsFollowersChange | NUMERIC | Not available yet |
| ownBoardsPins | NUMERIC | Not available yet |
| ownBoardsPinsBefore | NUMERIC | Not available yet |
| ownBoardsPinsChange | NUMERIC | Not available yet |
| collaboratorBoards | NUMERIC | Not available yet |
| collaboratorBoardsBefore | NUMERIC | Not available yet |
| collaboratorBoardsChange | NUMERIC | Not available yet |
| collaboratorBoardsFollowers | NUMERIC | Not available yet |
| collaboratorBoardsFollowersBefore | NUMERIC | Not available yet |
| collaboratorBoardsFollowersChange | NUMERIC | Not available yet |
| collaboratorBoardsPins | NUMERIC | Not available yet |
| collaboratorBoardsPinsBefore | NUMERIC | Not available yet |
| collaboratorBoardsPinsChange | NUMERIC | Not available yet |
| ownPins | NUMERIC | Not available yet |
| ownPinsBefore | NUMERIC | Not available yet |
| ownPinsChange | NUMERIC | Not available yet |
| ownPinsLikes | NUMERIC | Not available yet |
| ownPinsLikesBefore | NUMERIC | Not available yet |
| ownPinsLikesChange | NUMERIC | Not available yet |
| ownPinsComments | NUMERIC | Not available yet |
| ownPinsCommentsBefore | NUMERIC | Not available yet |
| ownPinsCommentsChange | NUMERIC | Not available yet |
| ownPinsSaves | NUMERIC | Not available yet |
| ownPinsSavesBefore | NUMERIC | Not available yet |
| ownPinsSavesChange | NUMERIC | Not available yet |
| collaboratorPins | NUMERIC | Not available yet |
| collaboratorPinsBefore | NUMERIC | Not available yet |
| collaboratorPinsChange | NUMERIC | Not available yet |
| collaboratorPinsLikes | NUMERIC | Not available yet |
| collaboratorPinsLikesBefore | NUMERIC | Not available yet |
| collaboratorPinsLikesChange | NUMERIC | Not available yet |
| collaboratorPinsComments | NUMERIC | Not available yet |
| collaboratorPinsCommentsBefore | NUMERIC | Not available yet |
| collaboratorPinsCommentsChange | NUMERIC | Not available yet |
| collaboratorPinsSaves | NUMERIC | Not available yet |
| collaboratorPinsSavesBefore | NUMERIC | Not available yet |
| collaboratorPinsSavesChange | NUMERIC | Not 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. |
| followers | NUMERIC | Not available yet |
| pins | NUMERIC | Not available yet |
| collaborators | NUMERIC | Not available yet |
| name | TEXT | Not available yet |
| link | TEXT | Not available yet |
| externalId | TEXT | Not available yet |
| description | TEXT | Not available yet |
| isCollaboratorBoard | TEXT | Not 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 | Not available yet |
| time | TEXT | The time this posting was created in "Y/m/d H:i:s" format and UTC timezone. |
| creatorId | TEXT | Not available yet |
| creatorUrl | TEXT | Not available yet |
| likes | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| saves | NUMERIC | Not available yet |
| message | TEXT | Not available yet |
| pinType | TEXT | Not available yet |
| mediaType | TEXT | Not available yet |
| pinLink | TEXT | Not available yet |
| link | TEXT | Not available yet |
| attachmentPreviewPicture | TEXT | Not available yet |
| externalId | TEXT | Not available yet |
| price | NUMERIC | Not available yet |
| currency | TEXT | Not available yet |
| isOwnPin | TEXT | Not 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. |
| externalId | TEXT | Not available yet |
| followers | NUMERIC | Not available yet |
| interactionRate | NUMERIC | Not available yet |
| retweets | NUMERIC | Not available yet |
| favs | NUMERIC | Not available yet |
| replies | NUMERIC | Not available yet |
| link | TEXT | Not available yet |
| message | TEXT | Not available yet |
| source | TEXT | Not 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 | Not available yet |
| profileUsername | TEXT | Not available yet |
| profileLink | TEXT | Not available yet |
| uniqueUsers | NUMERIC | Not available yet |
| share | NUMERIC | Not 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 | Not available yet |
| name | TEXT | Not available yet |
| mentions | NUMERIC | Not available yet |
| overlaps | TEXT | Not available yet |
| overlapsCount | NUMERIC | Not 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. |
| externalId | TEXT | Not available yet |
| userName | TEXT | Not available yet |
| userFollowers | NUMERIC | Not available yet |
| message | TEXT | Not available yet |
| link | TEXT | Not available yet |
| isRetweet | TEXT | Not available yet |
| isReply | TEXT | Not available yet |
| isQuestion | TEXT | Not available yet |
| responseTime | TEXT | Not available yet |
| timeToRespond | NUMERIC | Not available yet |
| retweets | NUMERIC | Not available yet |
| favs | NUMERIC | Not available yet |
| userLocation | TEXT | Not available yet |
| lat | NUMERIC | Not available yet |
| lon | NUMERIC | Not available yet |
| placeType | TEXT | Not available yet |
| placeCountry | TEXT | Not available yet |
| placeCountryCode | TEXT | Not available yet |
| placeName | TEXT | Not 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 | Not available yet |
| followers | NUMERIC | Not available yet |
| link | TEXT | Not available yet |
| message | TEXT | Not available yet |
| source | TEXT | Not available yet |
| replyToTweetId | TEXT | Not available yet |
| retweets | NUMERIC | Not available yet |
| favs | NUMERIC | Not available yet |
| replies | NUMERIC | Not available yet |
| clicks | NUMERIC | Not available yet |
| interactionRate | NUMERIC | Not available yet |
twitterOwnTweets
Holding 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. |
| 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 | Not available yet |
| favs | NUMERIC | Not available yet |
| retweets | NUMERIC | Not available yet |
| responseTime | TEXT | Not available yet |
| timeToRespond | NUMERIC | Not available yet |
| link | TEXT | Not available yet |
| message | TEXT | Not available yet |
| isQuestion | TEXT | Not available yet |
youtube
Holding public 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. |
| subscribers | NUMERIC | Not available yet |
| subscribersBefore | NUMERIC | Not available yet |
| subscribersChange | NUMERIC | Not available yet |
| views | NUMERIC | Not available yet |
| viewsBefore | NUMERIC | Not available yet |
| viewsChange | NUMERIC | Not available yet |
| videos | NUMERIC | Not available yet |
| videosBefore | NUMERIC | Not available yet |
| videosChange | NUMERIC | Not available yet |
| videosCounted | NUMERIC | Not available yet |
| videosCountedBefore | NUMERIC | Not available yet |
| videosCountedChange | NUMERIC | Not available yet |
| viewsCounted | NUMERIC | Not available yet |
| viewsCountedBefore | NUMERIC | Not available yet |
| viewsCountedChange | NUMERIC | Not available yet |
| favs | NUMERIC | Not available yet |
| favsBefore | NUMERIC | Not available yet |
| favsChange | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| likesBefore | NUMERIC | Not available yet |
| likesChange | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| dislikesBefore | NUMERIC | Not available yet |
| dislikesChange | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| commentsBefore | NUMERIC | Not available yet |
| commentsChange | NUMERIC | Not available yet |
| channelComments | NUMERIC | Not available yet |
| channelCommentsBefore | NUMERIC | Not available yet |
| channelCommentsChange | NUMERIC | Not available yet |
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 | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| subscribersLost | NUMERIC | Not available yet |
| subscribersGained | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| annotationCloseRate | NUMERIC | Not available yet |
| annotationClickThroughRate | NUMERIC | Not available yet |
| averageViewPercentage | NUMERIC | Not available yet |
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 | Not available yet |
| countryName | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| subscribersLost | NUMERIC | Not available yet |
| subscribersGained | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| annotationCloseRate | NUMERIC | Not available yet |
| annotationClickThroughRate | NUMERIC | Not available yet |
| averageViewPercentage | NUMERIC | Not available yet |
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 | Not available yet |
| deviceName | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
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 | Not available yet |
| insightPlaybackLocationName | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
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 | Not available yet |
| link | TEXT | Not available yet |
| status | TEXT | Not available yet |
| title | TEXT | Not available yet |
| description | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| playlistStarts | NUMERIC | Not available yet |
| viewsPerPlaylistStart | NUMERIC | Not available yet |
| averageTimeInPlaylist | NUMERIC | Not available yet |
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 | Not available yet |
| link | TEXT | Not available yet |
| status | TEXT | Not available yet |
| title | TEXT | Not available yet |
| description | TEXT | Not available yet |
| duration | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| subscribersLost | NUMERIC | Not available yet |
| subscribersGained | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| annotationCloseRate | NUMERIC | Not available yet |
| annotationClickThroughRate | NUMERIC | Not available yet |
| averageViewPercentage | NUMERIC | Not available yet |
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 | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| subscribersLost | NUMERIC | Not available yet |
| subscribersGained | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| annotationCloseRate | NUMERIC | Not available yet |
| annotationClickThroughRate | NUMERIC | Not available yet |
| averageViewPercentage | NUMERIC | Not available yet |
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 | Not available yet |
| insightTrafficSourceName | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
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 | Not available yet |
| status | TEXT | Not available yet |
| title | TEXT | Not available yet |
| description | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| subscribersLost | NUMERIC | Not available yet |
| subscribersGained | NUMERIC | Not available yet |
| shares | NUMERIC | Not available yet |
| estimatedMinutesWatched | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| averageViewDuration | NUMERIC | Not available yet |
| annotationCloseRate | NUMERIC | Not available yet |
| annotationClickThroughRate | NUMERIC | Not available yet |
| averageViewPercentage | NUMERIC | Not available yet |
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 | Not available yet |
| title | TEXT | Not available yet |
| link | TEXT | Not available yet |
| externalId | TEXT | Not available yet |
| videoId | TEXT | Not available yet |
| views | NUMERIC | Not available yet |
| likes | NUMERIC | Not available yet |
| dislikes | NUMERIC | Not available yet |
| comments | NUMERIC | Not available yet |
| favs | NUMERIC | Not available yet |
| duration | NUMERIC | Not available yet |
| subscribers | NUMERIC | Not available yet |
| interactionRate | NUMERIC | Not available yet |