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.
The following is an example for fetching the number of Page Likes for Facebook Pages
The response will be sent in JSON format. Here is a sample response for the example above:
Authenticate profiles with Insights via quintly API
Please follow the documentation in our knowledge base
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 to see the table schema.
Summary
Holding public data for Facebook Pages and their development over time. All numbers are aggregates across the whole Facebook Page.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| fans | INTEGER | The number of users who liked the Page. For Global Pages this shows the Global Fan count. |
| fansBefore | INTEGER | The number of users who liked the Page.. |
| fansChange | INTEGER | Change of the number of users who liked he Page. |
| checkins | INTEGER | Number of times a Page checked in at a place. |
| checkinsBefore | INTEGER | No documentation available yet |
| checkinsChange | INTEGER | No documentation available yet |
| peopleTalkingAbout | INTEGER | Number of people talking about a Page. |
| peopleTalkingAboutBefore | INTEGER | No documentation available yet |
| peopleTalkingAboutChange | INTEGER | No documentation available yet |
| peopleTalkingAboutAverage | INTEGER | No documentation available yet |
| peopleTalkingAboutAverageRate | PERCENT | No documentation available yet |
| ownPosts | INTEGER | Number of posts created on the page. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsComments | INTEGER | Number of comments and replies on comment the Page's posts got. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsLikes | INTEGER | Number of likes on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsLove | INTEGER | Number of Love reactions on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsWow | INTEGER | Number of Wow reactions on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsHaha | INTEGER | Number of Haha reactions on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsSad | INTEGER | Number of Sad reactions on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsAngry | INTEGER | Number of Angry reactions on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsShares | INTEGER | Number of Shares on the Page's posts. This takes into account the creation time of the own post and not when the interaction occurred. |
| ownPostsTypeLink | INTEGER | Number of posts created in Link type. |
| ownPostsTypeMusic | INTEGER | Number of posts created in Music type |
| ownPostsTypePhoto | INTEGER | Number of posts created in Photo type |
| ownPostsTypeStatus | INTEGER | Number of posts created in Status type |
| ownPostsTypeFlash | INTEGER | Number of posts created in Flash type |
| ownPostsTypeVideo | INTEGER | Number of posts created in Video type |
| ownPostsTypeMisc | INTEGER | Number of posts created in Misc type |
| userPosts | INTEGER | Number of user posts created. |
| userPostsComments | INTEGER | Number of comments on user posts. This takes into account the creation time of the user post and not when the interaction occurred. |
| userPostsLikes | INTEGER | Number of likes on user posts. This takes into account the creation time of the user post and not when the interaction occurred. |
| userPostsShares | INTEGER | Number of shares on user posts. This takes into account the creation time of the user post and not when the interaction occurred. |
| userPostsTypeLink | INTEGER | Number of user posts created in Link type. |
| userPostsTypeMusic | INTEGER | Number of posts created in Music type. |
| userPostsTypePhoto | INTEGER | Number of posts created in Photo type. |
| userPostsTypeStatus | INTEGER | Number of posts created in Status type. |
| userPostsTypeFlash | INTEGER | Number of posts created in Flash type. |
| userPostsTypeVideo | INTEGER | Number of posts created in Video type. |
| userPostsTypeMisc | INTEGER | Number of posts created in Misc type. |
| questions | INTEGER | Number of questions on a Page. Questions are defined as any user post that includes a "?". |
| responseTime0To2h | INTEGER | Number of user questions that were replied to within 0 and 2 hours. |
| responseTime2To8h | INTEGER | Number of user questions that were replied to within 2 and 8 hours. |
| responseTime8To24h | INTEGER | Number of user questions that were replied to within 8 and 24 hours. |
| responseTimeLongerThan24h | INTEGER | Number of user questions that were replied to after 24 hours |
| responseTimeNotResponded | INTEGER | Number of user posts created which were detected as a question but were not commented on. |
facebookAdsPostAds
Summary
Holding information about promoted posts from Facebook Ads.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | Identifier for the profile this row belongs to. It's a quintly internal ID and meta data can be fetched by joining the "profiles" table which is ready to be used with all QQL queries. |
| accountId | STRING | The ID of the ad account with which the ad was published. |
| accountName | STRING | The name of the ad account with which the ad was published. |
| currency | STRING | The currency by which all costs under the Facebook ad account are specified. |
| campaignId | INTEGER | The ID of the ad campaign to which the ad belongs. |
| campaignName | STRING | The name of the ad campaign to which the ad belongs. |
| campaignObjective | STRING | The defined objective of the ad campaign to which the ad belongs. |
| campaignStatus | ENUM | The status of the ad campaign to which the ad belongs. |
| updatedTime | DATETIME | Updated time |
| adSetScheduleStartTime | DATETIME | The scheduled start time of the ad set to which the ad belongs. |
| adSetScheduleEndTime | DATETIME | The scheduled end time of the ad set to which the ad belongs. |
| time | DATETIME | The time this posting was created. In this case, this field refers to the creation time of the ad set to which the ad belongs. |
| importTime | DATETIME | The time this posting was imported. |
| adSetId | INTEGER | The ID of the ad set to which the ad belongs. |
| adSetName | STRING | The name of the ad set to which the ad belongs. |
| adSetBillingEvent | STRING | The billing event of the ad set to which the ad belongs. A billing event refers to the event that triggers charging the ad account (e.g. post engagements, video views, etc.). |
| adSetOptimizationGoal | STRING | The optimization goal of the ad set to which the ad belongs. |
| adSetStatus | ENUM | The status of the ad set to which the ad belongs. |
| adSetCreatedTime | DATETIME | The time the adset was created. |
| id | INTEGER | The ID of the ad. |
| name | STRING | The name of the ad. |
| status | ENUM | The effective status of the ad. |
| adStatus | ENUM | The status of the ad. |
| bidType | STRING | The bidding type of the ad (e.g. CPA, Absolute OCPM, etc.). |
| isOrganicPost | BOOLEAN | Yields "1" if the post of this ad is a promoted post, which could also appear on the page's timeline, and an empty string otherwise (also known as a "Dark Post", which is visible only in a promoted manner). |
| postId | INTEGER | The ID of the post that's being presented with the ad. |
| message | STRING | The contents of the post's body. |
| postType | ENUM | The type of the post that's presented with the ad. |
| thumbnailUrl | LINK | The ad's thumbnail URL. |
| link | LINK | The link to the ad's post |
| spend | INTEGER | The estimated total amount of money spent on an ad during its schedule. |
| socialSpend | DECIMAL | The total amount spent on ads showed with social information (e.g. John Doe likes this). |
| isPublishedOnFacebook | BOOLEAN | Yields "1" if the post of this ad was published on Facebook, and an empty string otherwise. |
| isPublishedOnInstagram | BOOLEAN | Yields "1" if the post of this ad was published on Instagram, and an empty string otherwise. |
| targetedPlatforms | STRING | Describes which are the targeted platforms of this ad. |
| targetingSummary | STRING | A summary of the ad's targeting settings, that may include location, age and language targeting. |
| targetingLocation | STRING | The ad's target user locations |
| targetingLivingIn | STRING | The ad's target user countries of residence |
| targetingAge | STRING | The ad's target user ages |
| targetingLanguage | STRING | The ad's targeted user languages |
| targetingExclude | STRING | The ad's excluded matches (e.g. excluded interests) |
| targetingPeopleWhoMatch | STRING | The ad's targeted users (e.g. interests) |
| targetingConnections | STRING | The ad's target connections (e.g. people who liked the page already) |
| targetingCustomAudience | STRING | The ad's custom audience targeting |
| targetingPlacements | STRING | The Ad's placements (e.g. news feed on desktop computers) |
| frequency | DECIMAL | The average number of times each person saw the ad. |
| impressions | INTEGER | The number of times the ad was on screen. |
| clicks | INTEGER | The number of clicks on the ads. |
| reach | INTEGER | The number of people who saw the ad at least once. Reach is different from impressions, which may include multiple views of the ad by the same people. |
| unique_clicks | INTEGER | The distinct number of people who clicked on the ad. |
| unique_inline_link_clicks | INTEGER | The number of people who performed an inline link click. |
| relevance_score | INTEGER | A rating from 1 to 10 that estimates how well the ad's target audience is responding to the ad. This score is shown after the ad receives more than 500 impressions. |
| cpm | DECIMAL | The average cost for 1000 impressions of the ad. |
| cpp | DECIMAL | The average cost to reach 1000 people with the ad. |
| cpc | DECIMAL | The average cost for each click on the ad. |
| uniqueCpc | DECIMAL | The average cost for each unique click. |
| website_purchase_roas | DECIMAL | The total return on ad spend (ROAS) from website purchases. This is based on the value of all conversions recorded by the Facebook pixel on the website and attributed to the ads. |
| omni_purchase | DECIMAL | The total return on ad spend from omni purchases. |
| estimatedAdRecallRate | DECIMAL | The rate at which an estimated number of additional people, when asked, would remember seeing your ads within 2 days. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development. |
| estimatedAdRecallers | INTEGER | An estimate of the number of additional people who may remember seeing your ads, if asked, within 2 days. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development. |
| ctr | DECIMAL | The percentage of times people saw the ad and performed a click. |
| unique_ctr | DECIMAL | The percentage of people who saw the ad and performed a unique click. |
| unique_link_clicks_ctr | DECIMAL | The percentage of people who saw the ad and performed a link click. |
| unique_outbound_clicks_ctr | DECIMAL | TThe percentage of people who saw the ad and performed an outbound click. |
| outbound_clicks_ctr | DECIMAL | The percentage of times people saw the ad and performed an outbound click. |
| website_ctr | DECIMAL | The percentage of times people saw the ad and performed a link click. |
| inline_link_click_ctr | DECIMAL | The percentage of time people saw the ads and performed an inline link click. |
| unique_inline_link_click_ctr | DECIMAL | The percentage of times people saw the ad and performed a link click. Inline click-through rate uses a fixed 1-day-click attribution window. |
| page_engagement_unique | INTEGER | The number of people who engaged with the Facebook Page through the ad. |
| post_engagement_unique | INTEGER | The number of people who engaged with the ad. |
| likes | INTEGER | The number of likes performed on the page through the ad. |
| comments | INTEGER | The number of comments left on the post through the ad. |
| video_view_unique | INTEGER | The number of people who viewed the video through the ad (when relevant). |
| link_click_unique | INTEGER | The number of people who clicked on a link through the ad (when relevant). |
| landing_page_view_unique | INTEGER | The number of people who viewed a landing page through the ad (when relevant). |
| photo_view_unique | INTEGER | The number of people who viewed the photo through the ad (when relevant). |
| post_reaction_unique | INTEGER | The number of Facebook reactions on the post through the ad. |
| post_unique | INTEGER | The number of people who shared the post through the ad. |
| mobile_app_install_unique | INTEGER | The number of people who installed the mobile app through the ad. |
| uniqueFbPixelAddPaymentInfo | INTEGER | The number of people who added payment info that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelAddToChart | INTEGER | The number of people who added to chart that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelAddToWhitelist | INTEGER | The number of people who added to whitelist an action that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelCompleteRegistration | INTEGER | The number of people who completed registration that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelCustom | INTEGER | The number of people who took an action that was attributed to your ads which is a custom pixel events defined by the advertiser This metric is estimated. |
| uniqueFbPixelInitiateCheckout | INTEGER | The number of people who initiated checkout that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelLead | INTEGER | The number of people who took an action 'LEAD' that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelPurchase | INTEGER | The number of people who took an action 'PURCHASE' that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelSearch | INTEGER | The number of people who took an action 'SEARCH' that was attributed to your ads. This metric is estimated. |
| uniqueFbPixelViewContent | INTEGER | The number of people who viewed the content that was attributed to your ads. This metric is estimated. |
| uniqueLead | INTEGER | The number of people who took an action 'LEAD' on Facebook that was attributed to your ads. This metric is estimated. |
| costPerPageEngagement | DECIMAL | The average cost per engagement with the Facebook Page through the ad. |
| costPerPostEngagement | DECIMAL | The average cost per engagement with the ad. |
| costPerLike | DECIMAL | The average cost per like on the page through the ad. |
| costPerComment | DECIMAL | The average cost per comment left on the post through the ad. |
| costPerVideoView | DECIMAL | The average cost per video view through the ad (when relevant). |
| costPerLinkClick | DECIMAL | The average cost per link click through the ad (when relevant). |
| costPerLandingPageView | DECIMAL | The average cost per landing page view through the ad (when relevant). |
| costPerPhotoView | DECIMAL | The average cost per photo view through the ad (when relevant). |
| costPerPostReaction | DECIMAL | The average cost per Facebook reaction on the post through the ad. |
| costPerPost | DECIMAL | The average cost per share of the post through the ad. |
| costPerMobileAppInstall | DECIMAL | The average cost per mobile app installation through the ad. |
| costPerFbPixelAddPaymentInfo | INTEGER | The average cost per number of people who added payment info that was attributed to your ads. This metric is estimated. |
| costPerFbPixelAddToChart | INTEGER | The average cost per number of people who added to chart that was attributed to your ads. This metric is estimated. |
| costPerFbPixelAddToWhitelist | INTEGER | The average cost per number of people who added to whitelist an action that was attributed to your ads. This metric is estimated. |
| costPerFbPixelCompleteRegistration | INTEGER | The average cost per number of people who completed registration that was attributed to your ads. This metric is estimated. |
| costPerFbPixelCustom | INTEGER | The average cost per number of people who took an action that was attributed to your ads which is a custom pixel events defined by the advertiser This metric is estimated. |
| costPerFbPixelInitiateCheckout | INTEGER | The average cost per number of people who initiated checkout that was attributed to your ads. This metric is estimated. |
| costPerFbPixelLead | INTEGER | The average cost per number of people who took an action 'LEAD' that was attributed to your ads. This metric is estimated. |
| costPerFbPixelPurchase | INTEGER | The average cost per number of people who took an action 'PURCHASE' that was attributed to your ads. This metric is estimated. |
| costPerFbPixelSearch | INTEGER | The average cost per number of people who took an action 'SEARCH' that was attributed to your ads. This metric is estimated. |
| costPerFbPixelViewContent | INTEGER | The average cost per number of people who viewed the content that was attributed to your ads. This metric is estimated. |
| costPerLead | INTEGER | The average cost per lead that was attributed to your ads. This metric is estimated. |
| costPerUniquePageEngagement | DECIMAL | The average cost per unique engagement with the Facebook Page through the ad. |
| costPerUniquePostEngagement | DECIMAL | The average cost per unique engagement with the ad. |
| costPerUniqueLike | DECIMAL | The average cost per like on the post through the ad. |
| costPerUniqueComment | DECIMAL | The average cost per comment left on the post through the ad. |
| costPerUniqueVideoView | DECIMAL | The average cost per unique video view through the ad (when relevant). |
| costPerUniqueLinkClick | DECIMAL | The average cost per unique link click through the ad (when relevant). |
| costPerUniqueLandingPageView | DECIMAL | The average cost per unique landing page view through the ad (when relevant). |
| costPerUniquePhotoView | DECIMAL | The average cost per unique photo view through the ad (when relevant). |
| costPerUniquePostReaction | DECIMAL | The average cost per Facebook reaction on the post through the ad. |
| costPerUniquePost | DECIMAL | The average cost per unique share of the post through the ad. |
| costPerUniqueMobileAppInstall | DECIMAL | The average cost per unique mobile app installation through the ad. |
| costPerEstimatedAdRecaller | DECIMAL | The average cost for each estimated ad recall lift. This metric is only available for assets in the Brand awareness, Post engagement and Video views Objectives. This metric is estimated and in development. |
| costPerUniqueLead | INTEGER | The average cost per unique lead that was attributed to your ads. This metric is estimated. |
facebookComments
Summary
This table holds all comments and replies on comments created on posts that were posted in the selected time range. Please note that this takes into account the creation time of the commented-on posts and not the creation time of the comment and also might not contain all comments due to the privacy settings of users who commented.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | STRING | The name of the author. |
| time | DATETIME | The time this posting was created. |
| message | STRING | The main content of this comment (not including attachments). |
| link | LINK | A link to this comment on Facebook. |
| externalId | STRING | The ID of this comment provided by Facebook. |
| externalPostId | STRING | The ID of the post this comment belongs to provided by Facebook. |
facebookInsights
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| importTime | DATETIME | The time this posting was last imported. |
| page_content_activity | INTEGER | Number of stories created about your Page within the current interval. |
| page_content_activity_day | INTEGER | No documentation available yet |
| page_content_activity_week | INTEGER | No documentation available yet |
| page_content_activity_days_28 | INTEGER | No documentation available yet |
| page_impressions | INTEGER | The number of times any content from the Page or about the Page entered a person's screen. This includes posts, check-ins, ads, social information from people who interact with the Page and more. |
| page_impressions_day | INTEGER | No documentation available yet |
| page_impressions_week | INTEGER | No documentation available yet |
| page_impressions_days_28 | INTEGER | No documentation available yet |
| page_impressions_paid | INTEGER | The number of times any content from the Page or about the Page entered a person's screen through paid distribution such as an ad. |
| page_impressions_paid_day | INTEGER | No documentation available yet |
| page_impressions_paid_week | INTEGER | No documentation available yet |
| page_impressions_paid_days_28 | INTEGER | No documentation available yet |
| page_impressions_organic | INTEGER | The number of times any content from the Page or about the Page entered a person's screen through unpaid distribution. This includes posts, check-ins, social information from people who interact with the Page and more. |
| page_impressions_organic_day | INTEGER | No documentation available yet |
| page_impressions_organic_week | INTEGER | No documentation available yet |
| page_impressions_organic_days_28 | INTEGER | No documentation available yet |
| page_impressions_unique | INTEGER | Also known as Reach. The number of people who had any content from the Page or about the Page enter their screen. This includes posts, check-ins, ads, social information from people who interact with the Page and more. |
| page_impressions_unique_day | INTEGER | No documentation available yet |
| page_impressions_unique_week | INTEGER | No documentation available yet |
| page_impressions_unique_days_28 | INTEGER | No documentation available yet |
| page_impressions_paid_unique | INTEGER | The number of people who had any content from the Page or about the Page enter their screen through paid distribution such as an ad. |
| page_impressions_paid_unique_day | INTEGER | No documentation available yet |
| page_impressions_paid_unique_week | INTEGER | No documentation available yet |
| page_impressions_paid_unique_days_28 | INTEGER | No documentation available yet |
| page_impressions_organic_unique | INTEGER | The number of people who had any content from the Page or about the Page enter their screen through unpaid distribution. This includes posts, check-ins, social information from people who interact with the Page and more. |
| page_impressions_organic_unique_day | INTEGER | No documentation available yet |
| page_impressions_organic_unique_week | INTEGER | No documentation available yet |
| page_impressions_organic_unique_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_unique | INTEGER | The number of people who had any of the Page's posts enter their screen. Posts include statuses, photos, links, videos and more. |
| page_posts_impressions_unique_day | INTEGER | No documentation available yet |
| page_posts_impressions_unique_week | INTEGER | No documentation available yet |
| page_posts_impressions_unique_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_paid_unique | INTEGER | The number of people who had any of the Page's posts enter their screen through paid distribution such as an ad. |
| page_posts_impressions_paid_unique_day | INTEGER | No documentation available yet |
| page_posts_impressions_paid_unique_week | INTEGER | No documentation available yet |
| page_posts_impressions_paid_unique_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_organic | INTEGER | The number of times the Page's posts entered a person's screen through unpaid distribution. |
| page_posts_impressions_organic_day | INTEGER | No documentation available yet |
| page_posts_impressions_organic_week | INTEGER | No documentation available yet |
| page_posts_impressions_organic_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_organic_unique | INTEGER | The number of people who had any of the Page's posts enter their screen through unpaid distribution. |
| page_posts_impressions_organic_unique_day | INTEGER | No documentation available yet |
| page_posts_impressions_organic_unique_week | INTEGER | No documentation available yet |
| page_posts_impressions_organic_unique_days_28 | INTEGER | No documentation available yet |
| page_post_engagements | INTEGER | The number of times people have engaged with the Page's posts through likes, comments and shares and more. |
| page_post_engagements_day | INTEGER | No documentation available yet |
| page_post_engagements_week | INTEGER | No documentation available yet |
| page_post_engagements_days_28 | INTEGER | No documentation available yet |
| page_impressions_viral | INTEGER | The number of times any content from the Page or about the Page entered a person's screen with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_impressions_viral_day | INTEGER | No documentation available yet |
| page_impressions_viral_week | INTEGER | No documentation available yet |
| page_impressions_viral_days_28 | INTEGER | No documentation available yet |
| page_impressions_viral_unique | INTEGER | No documentation available yet |
| page_impressions_viral_unique_day | INTEGER | No documentation available yet |
| page_impressions_viral_unique_week | INTEGER | No documentation available yet |
| page_impressions_viral_unique_days_28 | INTEGER | No documentation available yet |
| page_impressions_nonviral | INTEGER | No documentation available yet |
| page_impressions_nonviral_day | INTEGER | No documentation available yet |
| page_impressions_nonviral_week | INTEGER | No documentation available yet |
| page_impressions_nonviral_days_28 | INTEGER | No documentation available yet |
| page_impressions_nonviral_unique | INTEGER | The number of times any content from the Page or about the Page entered a person's screen with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_impressions_nonviral_unique_day | INTEGER | No documentation available yet |
| page_impressions_nonviral_unique_week | INTEGER | No documentation available yet |
| page_impressions_nonviral_unique_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral | INTEGER | The number of times the Page's posts entered a person's screen. This does not include content created about the Page with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_posts_impressions_nonviral_day | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral_week | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral_unique | INTEGER | The number of people who had any posts by the Page enter their screen. This does not include content created about the Page with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_posts_impressions_nonviral_unique_day | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral_unique_week | INTEGER | No documentation available yet |
| page_posts_impressions_nonviral_unique_days_28 | INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_total (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_total_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_total_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_total_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_paid (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_paid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_paid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_paid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unpaid (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unpaid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unpaid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unpaid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_total (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_total_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_total_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_total_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_paid (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_paid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_paid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_paid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_unpaid (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_unpaid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_unpaid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_impressions_by_paid_non_paid_unique_unpaid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_paid (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_paid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_paid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_paid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_unpaid (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_day (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_week (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_unpaid_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_total (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_total_day (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_total_week (Deprecated) |
INTEGER | No documentation available yet |
| page_posts_impressions_by_paid_non_paid_unique_total_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_website_clicks_logged_in_count | INTEGER | Number of clicks on the Facebook Page's website link. |
| page_website_clicks_logged_in_count_day | INTEGER | No documentation available yet |
| page_website_clicks_logged_in_count_week | INTEGER | No documentation available yet |
| page_website_clicks_logged_in_count_days_28 | INTEGER | No documentation available yet |
| page_website_clicks_logged_in_unique | INTEGER | Number of unique people who logged in to Facebook and clicked the goto website CTA (Click to Action) button |
| page_website_clicks_logged_in_unique_day | INTEGER | No documentation available yet |
| page_website_clicks_logged_in_unique_week | INTEGER | No documentation available yet |
| page_website_clicks_logged_in_unique_days_28 | INTEGER | No documentation available yet |
| page_engaged_users | INTEGER | Number of people who engaged with the Page. Engagement includes any click or story created. |
| page_engaged_users_day | INTEGER | No documentation available yet |
| page_engaged_users_week | INTEGER | No documentation available yet |
| page_engaged_users_days_28 | INTEGER | No documentation available yet |
| page_consumptions | INTEGER | Number of clicks on any of the Page's content. Stories generated without clicks on page content (e.g., liking the page in Timeline) are not included. |
| page_consumptions_day | INTEGER | No documentation available yet |
| page_consumptions_week | INTEGER | No documentation available yet |
| page_consumptions_days_28 | INTEGER | No documentation available yet |
| page_consumptions_unique | INTEGER | Number of people who clicked on any of the Page's content. Stories that are created without clicking on Page content (ex, liking the Page from timeline) are not included. |
| page_consumptions_unique_day | INTEGER | No documentation available yet |
| page_consumptions_unique_week | INTEGER | No documentation available yet |
| page_consumptions_unique_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks | INTEGER | Number of clicks on links the Page got. This e.g. includes clicks on links in the Page's posts. |
| page_consumptions_by_consumption_type_link_clicks_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_link_clicks_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks | INTEGER | Number of other clicks on the Page's content which doesn't include link clicks, photo views or video plays. |
| page_consumptions_by_consumption_type_other_clicks_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_other_clicks_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view | INTEGER | Number of clicks on photos the Page got. Clicks on photos always leads to an expanded view of the photo. |
| page_consumptions_by_consumption_type_photo_view_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_photo_view_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_video_play | INTEGER | Number of clicks on photos the Page got. Clicks on photos always leads to an expanded view of the photo. |
| page_consumptions_by_consumption_type_video_play_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_video_play_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_video_play_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks | INTEGER | Number of people who clicked on the Page's links. This e.g. includes clicks on links in the Page's posts. |
| page_consumptions_by_consumption_type_unique_link_clicks_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_link_clicks_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks | INTEGER | Number of people who clicked on the Page's content which doesn't include link clicks, photo views or video plays. |
| page_consumptions_by_consumption_type_unique_other_clicks_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_other_clicks_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view | INTEGER | Number of people who clicked on the Page's photos. Clicks on photos always leads to an expanded view of the photo. |
| page_consumptions_by_consumption_type_unique_photo_view_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_photo_view_days_28 | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play | INTEGER | Number of people who clicked on the Page's videos. Auto-plays on videos aren't included here as they didn't require any clicks |
| page_consumptions_by_consumption_type_unique_video_play_day | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play_week | INTEGER | No documentation available yet |
| page_consumptions_by_consumption_type_unique_video_play_days_28 | INTEGER | No documentation available yet |
| page_places_checkin_total | INTEGER | Number of check-ins at the Page's Place. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_total_day | INTEGER | No documentation available yet |
| page_places_checkin_total_week | INTEGER | No documentation available yet |
| page_places_checkin_total_days_28 | INTEGER | No documentation available yet |
| page_places_checkin_total_unique | INTEGER | Number of people who checked in at the Page's Place. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_total_unique_day | INTEGER | No documentation available yet |
| page_places_checkin_total_unique_week | INTEGER | No documentation available yet |
| page_places_checkin_total_unique_days_28 | INTEGER | No documentation available yet |
| page_places_checkin_mobile | INTEGER | Number of check-ins at the Page's Place using mobile devices. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_mobile_day | INTEGER | No documentation available yet |
| page_places_checkin_mobile_week | INTEGER | No documentation available yet |
| page_places_checkin_mobile_days_28 | INTEGER | No documentation available yet |
| page_places_checkin_mobile_unique | INTEGER | Number of people who checked in at the Page's Place using mobile devices. Only available if checkin functionality is enabled for the Facebook Page. |
| page_places_checkin_mobile_unique_day | INTEGER | No documentation available yet |
| page_places_checkin_mobile_unique_week | INTEGER | No documentation available yet |
| page_places_checkin_mobile_unique_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback | INTEGER | Number of times people have given negative feedback to the Page. This includes clicks on 'Hide post', clicks on 'Hide all', unliking the Page or reporting posts as spam. |
| page_negative_feedback_day | INTEGER | No documentation available yet |
| page_negative_feedback_week | INTEGER | No documentation available yet |
| page_negative_feedback_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_unique | INTEGER | Number of people who have given negative feedback to the Page. This includes clicks on 'Hide post', clicks on 'Hide all', unliking the Page or reporting posts as spam. |
| page_negative_feedback_unique_day | INTEGER | No documentation available yet |
| page_negative_feedback_unique_week | INTEGER | No documentation available yet |
| page_negative_feedback_unique_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks | INTEGER | Number of times people have hidden one of the Page's posts or sponsored posts by clicking on 'Hide post' or 'Hide ad'. |
| page_negative_feedback_by_type_hide_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks | INTEGER | Number of times people have clicked on 'Hide all' on one of the Page's posts or sponsored posts. |
| page_negative_feedback_by_type_hide_all_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_hide_all_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks | INTEGER | Number of times people have unliked the Page. |
| page_negative_feedback_by_type_unlike_page_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unlike_page_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks | INTEGER | Number of times people have reported one of the Page's posts as spam. |
| page_negative_feedback_by_type_report_spam_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_report_spam_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks | INTEGER | Number of people who have hidden one of the Page's posts or sponsored posts on 'Hide post' or 'Hide ad'. |
| page_negative_feedback_by_type_unique_hide_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks | INTEGER | Number of people who have clicked on 'Hide all' on one of the Page's posts or sponsored posts. |
| page_negative_feedback_by_type_unique_hide_all_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_hide_all_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks | INTEGER | Number of people who have unliked the Page. |
| page_negative_feedback_by_type_unique_unlike_page_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_unlike_page_clicks_days_28 | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks | INTEGER | Number of people who have reported one of the Page's posts as spam. |
| page_negative_feedback_by_type_unique_report_spam_clicks_day | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_week | INTEGER | No documentation available yet |
| page_negative_feedback_by_type_unique_report_spam_clicks_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_like | INTEGER | Number of times people have liked one of the Page's stories. Please note this column is not only about the Like reaction, it actually includes the sum of all reactions (Like, Love, Haha, Wow, Sorry, Anger.) |
| page_positive_feedback_by_type_like_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_like_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_like_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_comment | INTEGER | Number of times people have commented on one of the Page's stories. |
| page_positive_feedback_by_type_comment_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_comment_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_comment_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_link | INTEGER | Number of times people have shared one of the Page's stories. |
| page_positive_feedback_by_type_link_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_link_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_link_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_rsvp | INTEGER | Number of times people have responded to one of the Page's events. |
| page_positive_feedback_by_type_rsvp_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_rsvp_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_rsvp_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_claim | INTEGER | Number of times people have claimed one of the Page's offers. |
| page_positive_feedback_by_type_claim_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_claim_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_claim_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_answer (Deprecated) |
INTEGER | Number of times people have answered one of the Page's questions. 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 (Deprecated) |
INTEGER | No documentation available yet |
| page_positive_feedback_by_type_answer_week (Deprecated) |
INTEGER | No documentation available yet |
| page_positive_feedback_by_type_answer_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_like | INTEGER | Number of people who have liked one of the Page's stories. |
| page_positive_feedback_by_type_unique_like_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_like_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_like_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_comment | INTEGER | Number of people who have commented on one of the Page's stories. |
| page_positive_feedback_by_type_unique_comment_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_comment_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_comment_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_link | INTEGER | Number of people who have shared one of the Page's stories. |
| page_positive_feedback_by_type_unique_link_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_link_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_link_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp | INTEGER | Number of people who have responded to one of the Page's events. |
| page_positive_feedback_by_type_unique_rsvp_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_rsvp_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_claim | INTEGER | Number of people who have claimed one of the Page's offers. |
| page_positive_feedback_by_type_unique_claim_day | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_claim_week | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_claim_days_28 | INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_answer (Deprecated) |
INTEGER | Number of people who have answered one of the Page's questions. 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 (Deprecated) |
INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_answer_week (Deprecated) |
INTEGER | No documentation available yet |
| page_positive_feedback_by_type_unique_answer_days_28 (Deprecated) |
INTEGER | No documentation available yet |
| page_fans_online_per_day | INTEGER | Number of people who liked the Page and who were online. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_like | INTEGER | Number of post 'like' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_love | INTEGER | Number of post 'love' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_wow | INTEGER | Number of post 'wow' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_haha | INTEGER | Number of post 'haha' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_sorry | INTEGER | Number of post 'sorry' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_actions_post_reactions_total_anger | INTEGER | Number of post 'anger' reactions of the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_fans | INTEGER | Total number of Page Likes for this Facebook Page. A Page must have at least 30 or more fans for this data to be returned. |
| page_fans_before | INTEGER | Total number of Page Likes for this Facebook Page. |
| page_fans_change | INTEGER | Change of the total number of Page Likes for this Facebook Page. |
| page_fan_adds | INTEGER | Number of times people have liked the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_adds_unique | INTEGER | Number of new people who have liked the Page. 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 | INTEGER | Number of new people who have liked the Page. 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 | INTEGER | Number of new people who have liked the Page from an ad or sponsored post. 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 | INTEGER | Number of new people who have liked the Page 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 | INTEGER | Number of times people have unliked the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_fan_removes_unique | INTEGER | Number of people who have unliked the Page. This column only supports daily intervals and won't work if you select any other interval. |
| page_cta_clicks_logged_in_total | INTEGER | Total number of clicks on the Page call-to-action button by people who are logged into Facebook. |
| page_cta_clicks_logged_in_unique | INTEGER | Unique number of clicks on the Page call-to-action button by people who are logged into Facebook. |
| page_views_total | INTEGER | The number of times a Page's profile has been viewed by logged in and logged out people. |
| page_views_logged_in_unique | INTEGER | The number of people logged in to Facebook who have viewed the Page profile. |
| page_views_logged_in_total | INTEGER | The number of times a Page's profile has been viewed by people logged in to Facebook. |
| page_views_logout | INTEGER | The number of times a Page's profile has been viewed by people not logged in to Facebook. |
| page_posts_impressions | INTEGER | The number of times the Page's posts entered a person's screen. Posts include statuses, photos, links, videos and more. |
| page_posts_impressions_day | INTEGER | No documentation available yet |
| page_posts_impressions_week | INTEGER | No documentation available yet |
| page_posts_impressions_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_paid | INTEGER | The number of times the Page's posts entered a person's screen through paid distribution such as an ad. |
| page_posts_impressions_paid_day | INTEGER | No documentation available yet |
| page_posts_impressions_paid_week | INTEGER | No documentation available yet |
| page_posts_impressions_paid_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_viral | INTEGER | The number of times the Page's posts entered a person's screen with social information attached. Social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_posts_impressions_viral_day | INTEGER | No documentation available yet |
| page_posts_impressions_viral_week | INTEGER | No documentation available yet |
| page_posts_impressions_viral_days_28 | INTEGER | No documentation available yet |
| page_posts_impressions_viral_unique | INTEGER | The number of people who had any of the Page's posts enter their screen with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with you Page or post. This includes when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. |
| page_posts_impressions_viral_unique_day | INTEGER | No documentation available yet |
| page_posts_impressions_viral_unique_week | INTEGER | No documentation available yet |
| page_posts_impressions_viral_unique_days_28 | INTEGER | No documentation available yet |
| page_posts_served_impressions_organic_unique | INTEGER | Number of people who were served the Page's organic posts in their News Feed, whether it entered their screen or not. This column is only provided by Facebook for comparison reasons and contains data from 2018, January 25th onwards. Read this article for details. |
| page_posts_served_impressions_organic_unique_day | INTEGER | No documentation available yet |
| page_posts_served_impressions_organic_unique_week | INTEGER | No documentation available yet |
| page_posts_served_impressions_organic_unique_days_28 | INTEGER | No documentation available yet |
| page_video_views | INTEGER | Number of times the Page's videos have been viewed for more than 3 seconds. |
| page_video_views_day | INTEGER | No documentation available yet |
| page_video_views_week | INTEGER | No documentation available yet |
| page_video_views_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s | INTEGER | The number of times the Page's videos were watched for an aggregate of at least 10 seconds, or for nearly its total length, whichever happened first. |
| page_video_views_10s_day | INTEGER | No documentation available yet |
| page_video_views_10s_week | INTEGER | No documentation available yet |
| page_video_views_10s_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s | INTEGER | Number of times the Page's videos have been viewed for more than 30 seconds. |
| page_video_complete_views_30s_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_days_28 | INTEGER | No documentation available yet |
| page_video_views_unique | INTEGER | Total number of times page's videos have been played for unique people for more than 3 seconds. |
| page_video_views_unique_day | INTEGER | No documentation available yet |
| page_video_views_unique_week | INTEGER | No documentation available yet |
| page_video_views_unique_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_unique | INTEGER | The number of times the Page's videos were watched for an aggregate of at least 10 seconds, or for nearly its total length, whichever happened first, by unique users. |
| page_video_views_10s_unique_day | INTEGER | No documentation available yet |
| page_video_views_10s_unique_week | INTEGER | No documentation available yet |
| page_video_views_10s_unique_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_unique | INTEGER | Total number of times page's videos have been played for unique people to the end, or viewed for more than 30 seconds. |
| page_video_complete_views_30s_unique_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_unique_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_unique_days_28 | INTEGER | No documentation available yet |
| page_video_views_paid | INTEGER | Total number of times page's promoted videos have been viewed for more than 3 seconds. |
| page_video_views_paid_day | INTEGER | No documentation available yet |
| page_video_views_paid_week | INTEGER | No documentation available yet |
| page_video_views_paid_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_paid | INTEGER | The number of times the Page's videos with paid activity were watched for at least a total of 10 seconds, or for nearly their total length, whichever happened first. |
| page_video_views_10s_paid_day | INTEGER | No documentation available yet |
| page_video_views_10s_paid_week | INTEGER | No documentation available yet |
| page_video_views_10s_paid_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_paid | INTEGER | Total number of times page's promoted videos have been viewed to the end, or for more than 30 seconds. |
| page_video_complete_views_30s_paid_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_paid_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_paid_days_28 | INTEGER | No documentation available yet |
| page_video_views_organic | INTEGER | Total number of times page's videos have been viewed for more than 3 seconds by organic reach. |
| page_video_views_organic_day | INTEGER | No documentation available yet |
| page_video_views_organic_week | INTEGER | No documentation available yet |
| page_video_views_organic_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_organic | INTEGER | The number of times the Page's videos were watched without any paid distribution for at least a total of 10 seconds, or for nearly their total length, whichever happened first. |
| page_video_views_10s_organic_day | INTEGER | No documentation available yet |
| page_video_views_10s_organic_week | INTEGER | No documentation available yet |
| page_video_views_10s_organic_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_organic | INTEGER | Total number of times page's videos have been viewed to the end, or viewed for more than 30 seconds by organic reach. |
| page_video_complete_views_30s_organic_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_organic_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_organic_days_28 | INTEGER | No documentation available yet |
| page_video_views_autoplayed | INTEGER | Total number of times page's autoplayed videos have been viewed for more than 3 seconds. |
| page_video_views_autoplayed_day | INTEGER | No documentation available yet |
| page_video_views_autoplayed_week | INTEGER | No documentation available yet |
| page_video_views_autoplayed_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_autoplayed | INTEGER | The number of times the Page's videos were started automatically and watched for at least a total of 10 seconds, or for nearly their total length, whichever happened first. |
| page_video_views_10s_autoplayed_day | INTEGER | No documentation available yet |
| page_video_views_10s_autoplayed_week | INTEGER | No documentation available yet |
| page_video_views_10s_autoplayed_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_autoplayed | INTEGER | Total number of times page's autoplayed videos have been viewed to the end, or viewed for more than 30 seconds. |
| page_video_complete_views_30s_autoplayed_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_autoplayed_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_autoplayed_days_28 | INTEGER | No documentation available yet |
| page_video_views_click_to_play | INTEGER | Total number of times page's videos have been viewed after the user clicks on play for more than 3 seconds. |
| page_video_views_click_to_play_day | INTEGER | No documentation available yet |
| page_video_views_click_to_play_week | INTEGER | No documentation available yet |
| page_video_views_click_to_play_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_click_to_play | INTEGER | The number of times the Page's videos were started by clicking the play button and watched for at least a total of 10 seconds, or for nearly their total length, whichever happened first. |
| page_video_views_10s_click_to_play_day | INTEGER | No documentation available yet |
| page_video_views_10s_click_to_play_week | INTEGER | No documentation available yet |
| page_video_views_10s_click_to_play_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_click_to_play | INTEGER | Total number of times page's videos have been viewed to the end, or viewed after the user clicks on play for more than 30 seconds. |
| page_video_complete_views_30s_click_to_play_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_click_to_play_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_click_to_play_days_28 | INTEGER | No documentation available yet |
| page_video_repeat_views | INTEGER | Total number of times that people replay a page's videos for more than 3 seconds. |
| page_video_repeat_views_day | INTEGER | No documentation available yet |
| page_video_repeat_views_week | INTEGER | No documentation available yet |
| page_video_repeat_views_days_28 | INTEGER | No documentation available yet |
| page_video_views_10s_repeat | INTEGER | The number of times the Page's videos were replayed for at least 10 seconds, or for nearly its total length, whichever happened first. |
| page_video_views_10s_repeat_day | INTEGER | No documentation available yet |
| page_video_views_10s_repeat_week | INTEGER | No documentation available yet |
| page_video_views_10s_repeat_days_28 | INTEGER | No documentation available yet |
| page_video_complete_views_30s_repeat_views | INTEGER | Total number of times that people replay a page's videos to the end, or for more than 30 seconds. |
| page_video_complete_views_30s_repeat_views_day | INTEGER | No documentation available yet |
| page_video_complete_views_30s_repeat_views_week | INTEGER | No documentation available yet |
| page_video_complete_views_30s_repeat_views_days_28 | INTEGER | No documentation available yet |
| page_video_view_time | INTEGER | The total amount of time (in milliseconds) people spent watching videos on the Page. |
facebookInsightsByCity
Summary
Holding the number of Page Likes, Reach and People Talking About This of Facebook Pages per city including their development over time.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| cityName | STRING | Name of the city. |
| cityLat | INTEGER | Latitude of the city. |
| cityLon | INTEGER | Longitude of the city. |
| cityCountryCode | STRING | Code of the country this city belongs to, following ISO 3166 standard. |
| cityCountryName | STRING | The full name of the country this city belongs to, e.g. Germany. |
| fans | INTEGER | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | INTEGER | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | INTEGER | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | INTEGER | 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 | INTEGER | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | INTEGER | The number of People Talking About the Page in the current interval. |
facebookInsightsByCountry
Summary
Holding the number of Page Likes, Reach and People Talking About This of Facebook Pages per country including their development over time.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | STRING | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| countryCode | STRING | The code of the country following ISO 3166 standard. |
| countryName | STRING | The full name of the country, e.g. Germany. |
| fans | INTEGER | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | INTEGER | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | INTEGER | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | INTEGER | 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 | INTEGER | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | INTEGER | The number of People Talking About the Page in the current interval. |
facebookInsightsByGenderAndAge
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| gender | ENUM | Either "Male", "Female" or "Unknown". |
| ageBucket | ENUM | 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 | INTEGER | Total number of Page Likes for this Facebook Page at the end of the interval. |
| fansBefore | INTEGER | Total number of Page Likes for this Facebook Page at the beginning of the interval. |
| fansChange | INTEGER | Change of the total number of Page Likes for this Facebook Page between the beginning and the end of the interval. |
| fansShare | DECIMAL | 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 | INTEGER | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | INTEGER | The number of People Talking About the Page in the current interval. |
facebookInsightsByStoryType
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| storyType | ENUM | The story type according to Facebook's documentation. |
| stories | INTEGER | The number of stories created about your Page (Stories) in the current interval. |
| impressions | INTEGER | The total number of impressions seen of any content associated with your Page in the current interval. |
| reach | INTEGER | The number of people who have seen any content associated with your Page in the current interval. |
| ptat | INTEGER | The number of People Talking About the Page in the current interval. |
facebookInsightsConversations
Summary
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 Facebook splits into separate conversations if there is a new incoming request by a user after a long time. Messages within a conversation are kept separately within the facebookInsightsConversationMessages data source.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this conversation started. |
| updatedTime | DATETIME | The time this conversation on Facebook was updated the last time. |
| importTime | DATETIME | The time this posting was imported. |
| conversationId | INTEGER | 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. |
| folder | STRING | The folder the conversation is located. |
| link | LINK | The link to this conversation on Facebook. |
| userName | STRING | The name of the author. |
| userId | STRING | The ID of the author provided by Facebook. |
| messageCount | INTEGER | The number of messages within the conversation, including both messages from the user and the Facebook Page. |
| pageMessageCount | INTEGER | The number of messages by the Facebook Page within the conversation. |
| userMessageCount | INTEGER | The number of messages by the user within the conversation. |
| responseTime | DATETIME | Holding the full date and time information when the first reply by the Facebook Page was sent. 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. |
| secondResponseTime | DATETIME | Holding the full date and time information when the second reply by the Facebook Page was sent. 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 | INTEGER | 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. |
| secondTimeToRespond | INTEGER | The time from the creation of the initial user message until the second 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 | STRING | 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 | STRING | The contents of the first reply by the Facebook Page. |
| secondPageReply | STRING | The contents of the second reply by the Facebook Page. |
| wasInitiatedByPrivateReplyToComment | BOOLEAN | 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. |
| unreadMessageCount | INTEGER | Number of unread message in the conversations. |
| participants | OBJECT | People and Pages who are on this conversation. Provided as a list of objects, e.g. [{"id" => STRING, "name" => STRING}, ...]. |
facebookInsightsConversationMessages
Summary
Holding private messages of Facebook Pages. Messages are filtered by the time the related conversation started.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this message was created. |
| conversationStartTime | DATETIME | The time the conversation this message belongs to started. |
| importTime | DATETIME | The time this message was imported. |
| id | STRING | The ID of this message. |
| conversationId | STRING | The ID of the conversation this message belongs to. This can be used to join with the facebookInsightsConversations data source. |
| message | STRING | The content of this message. |
| sender | OBJECT | The user or Facebook Page who created this message. Provided as an object, e.g. {"id" => STRING, "name" => STRING}. |
| recipient | OBJECT | The user or Facebook Page who received this message. Provided as an object, e.g. {"id" => STRING, "name" => STRING}. |
facebookInsightsOwnPosts
Summary
Holding information about posts of Facebook Pages with all their private statistics attached.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| is_published | BOOLEAN | This shows if the post is published. |
| is_hidden | BOOLEAN | This shows if the post is hidden. |
| type | ENUM | The type of the post. |
| link | LINK | The link to the post. |
| message | STRING | The contents of the post message. |
| mentions | OBJECT | The tagged users or Facebook Pages within the post's message. Provided as a list of objects, e.g. [{"id": "128340270541979", "name": "quintly", "type": "Page", "offset": 10, "length": 7}, ...]. |
| externalId | STRING | The unique id of the post. |
| objectId | STRING | The unique id of the object in the post. The ID of any uploaded photo or video attached to the post. |
| parentId | STRING | The unique id of a parent post of the post, if it exists. For example, if this is a shared post, this field will be the unique id of the original post that was shared. |
| likes | INTEGER | Number of likes the post got. This doesn't include likes on shares. |
| love | INTEGER | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | INTEGER | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | INTEGER | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | INTEGER | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | INTEGER | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | INTEGER | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | INTEGER | Number of comments the post got. This doesn't include comments on shares. |
| shares | INTEGER | Number of shares the post got. This doesn't include shares of shares. |
| fans | INTEGER | Number of fans the page had on the day the post was created. |
| attachmentName | STRING | The name of the post's attachment. |
| attachmentDescription | STRING | A description of a link in the post (appears beneath the attachmentCaption). |
| attachmentCaption | STRING | The link in the caption of a post. The caption must be an actual URL and when clicking on it, it should accurately reflect the URL of the associated advertiser, business or owner of the posted content (e.g. news article). If the post is shared and contains another shared post the value will be null. |
| attachmentHref | LINK | The URL of the post's attachment. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. |
| privacy | STRING | Holds information about the targeting of the post. If the post is not targeted it will show "Public". |
| isLiveVideo | BOOLEAN | If the posted video was live or not. |
| isLiveAudio | BOOLEAN | If the posted audio was live or not. |
| isSharedPost | BOOLEAN | If the post is a shared post or not. |
| isSpherical | BOOLEAN | If the post contains a 360 degree photo/video or not. If the post is a shared 360 degree photo/video, Facebook can not detect whether the original post contains 360 degree content. |
| post_reactions_by_type_total_like | INTEGER | Number of "Like" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_love | INTEGER | Number of "Love" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_wow | INTEGER | Number of "Wow" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_haha | INTEGER | Number of "Haha" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_sorry | INTEGER | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_anger | INTEGER | Number of "Anger" reactions the post got. This also includes reactions on shares. |
| post_engaged_fan | INTEGER | Number of people who have liked the Page and clicked anywhere in the post. |
| post_impressions | INTEGER | Number of impressions of the Page post. |
| post_impressions_unique | INTEGER | Number of people the Page post was served to. This is also known as reach. |
| post_impressions_organic | INTEGER | Number of impressions of the post in News Feed or ticker or on the Page's Timeline. |
| post_impressions_organic_unique | INTEGER | Number of people who saw the Page post in news feed or ticker, or on the Page's timeline. |
| post_impressions_paid | INTEGER | Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_paid_unique | INTEGER | Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_fan | INTEGER | The number of impressions on your Page post by people who have also liked the page. |
| post_impressions_fan_unique | INTEGER | The number of your page's fans who saw your Page post. This includes only the people who saw your Page post and as well liked your Page before. |
| post_impressions_fan_paid | INTEGER | The number of impressions on your Page’s ad or sponsored post by people who have also liked your page. |
| post_impressions_fan_paid_unique | INTEGER | The number of your page's fans who saw your Page’s post in an ad or sponsored post. This includes only the people who saw your Page's post in an ad or sponsored post and as well liked your Page before. |
| post_impressions_viral | INTEGER | Number of impressions of the Page post in a story generated by a friend. |
| post_impressions_viral_unique | INTEGER | Number of people who saw the Page post in a story from a friend. |
| post_impressions_nonviral | INTEGER | Number of times people saw the Page post. |
| post_impressions_nonviral_unique | INTEGER | Number of people the Page post was served to. |
| post_clicks | INTEGER | Number of clicks anywhere in the post. |
| post_clicks_unique | INTEGER | Number of people who clicked anywhere in the post. |
| post_clicks_by_type_link_clicks | INTEGER | Number of clicks on links in the post. |
| post_clicks_by_type_photo_view | INTEGER | Number of clicks on photo attachments in the post which led to an expanded view of the photo. |
| post_clicks_by_type_video_play | INTEGER | Number of clicks on video attachments in the post which started the video. |
| post_clicks_by_type_other_clicks | INTEGER | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. |
| post_clicks_by_type_unique_link_clicks | INTEGER | Number of people who clicked on links in the post. |
| post_clicks_by_type_unique_photo_view | INTEGER | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. |
| post_clicks_by_type_unique_video_play | INTEGER | Number of people who clicked on video attachments in the post which started the video. |
| post_clicks_by_type_unique_other_clicks | INTEGER | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. |
| post_engaged_users | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_hide_all_clicks | INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unlike_page_clicks | INTEGER | Number of times people have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_report_spam_clicks | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of people who have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_unique_report_spam_clicks | INTEGER | Number of people who have given negative feedback to the post by reporting the post as spam. |
| post_activity | INTEGER | Number of post stories generated about the Page post. Post stories are shared post on your own page by commenting on a content of another page, e.g. “Page A commented …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_unique | INTEGER | Number of people who created a post story by interacting with the Page post. Post story is a shared post on your own page by commenting on a content of another page, e.g. “Page A commented on …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_like | INTEGER | Number of post stories created about the Page post by reacting to the post. Post stories are shared post on your own page by liking on a content of another page, e.g. “Page A liked …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_comment | INTEGER | Number of post stories created about the Page post by commenting on the post. Post stories are shared post on your own page by commenting on a content of another page, e.g. “Page A commented …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_share | INTEGER | Number of post stories created about the Page post by sharing the post. Post stories are shared post on your own page by sharing on a content of another page, e.g. “Page A shared …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_unique_like | INTEGER | Number of people who created a post story about the Page post by reacting to it. Post story is a shared post on your own page by liking on a content of another page, e.g. “Page A liked …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_unique_comment | INTEGER | Number of people who created a post story about the Page post by commenting on it. Post story is a shared post on your own page by commenting on a content of another page, e.g. “Page A commented on …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_activity_by_action_type_unique_share | INTEGER | Number of people who created a post story about the Page post. Post story is a shared post on your own page by commenting on a content of another page, e.g. “Page A commented on …“. Post story should not be confused with Facebook story published on the Facebook page. |
| post_video_avg_time_watched | INTEGER | The average length of time (in milliseconds) people spent viewing the video. Returns null for reshared videos. |
| post_video_view_time | INTEGER | Total time (in milliseconds) video has been viewed. |
| post_video_view_time_organic | INTEGER | Total time (in milliseconds) video has been viewed in news feed or ticker or on the Page's Timeline. |
| post_video_length | INTEGER | Length of a video post (in milliseconds). |
| post_video_views | INTEGER | Number of times the video was viewed for more than 3 seconds. |
| post_video_views_unique | INTEGER | Number of people who viewed the video for more than 3 seconds. |
| post_video_views_organic | INTEGER | Number of times the video was viewed for more than 3 seconds without any paid promotion. |
| post_video_views_organic_unique | INTEGER | Number of people who viewed the video for more than 3 seconds without any paid promotion. |
| post_video_views_paid | INTEGER | Number of times the video was viewed for more than 3 seconds after paid promotion. |
| post_video_views_paid_unique | INTEGER | Number of people who viewed the video for more than 3 seconds after paid promotion. |
| post_video_views_clicked_to_play | INTEGER | Number of times people clicked to play the video and viewed it more than 3 seconds. |
| post_video_views_autoplayed | INTEGER | Number of times the video started automatically playing and people viewed it for more than 3 seconds. |
| post_video_views_sound_on | INTEGER | Number of times the video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. |
| post_video_views_10s | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. |
| post_video_views_10s_unique | INTEGER | Number of people who viewed the video for 10 seconds or to the end, whichever came first. |
| post_video_views_10s_paid | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. |
| post_video_views_10s_organic | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. |
| post_video_views_10s_clicked_to_play | INTEGER | Number of times people clicked to play the video and viewed it for 10 seconds or to the end, whichever came first. |
| post_video_views_10s_autoplayed | INTEGER | Number of times the video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. |
| post_video_views_10s_sound_on | INTEGER | Number of times the video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. |
| post_video_views_by_distribution_type_page_owned | INTEGER | Number of times the video was viewed for more than 3 seconds in the original post. |
| post_video_views_by_distribution_type_shared | INTEGER | Number of times the video was viewed for more than 3 seconds in a shared post. |
| post_video_complete_views_30s | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first. |
| post_video_complete_views_30s_unique | INTEGER | Number of people who viewed the video for 30 seconds or viewed to the end, whichever came first. |
| post_video_complete_views_30s_paid | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, after a paid promotion. |
| post_video_complete_views_30s_organic | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, without a paid promotion. |
| post_video_complete_views_30s_clicked_to_play | INTEGER | Number of times people clicked to play the video and viewed it for 30 seconds or to the end, whichever came first. |
| post_video_complete_views_30s_autoplayed | INTEGER | Number of times the video started automatically playing and people viewed it for 30 seconds or to the end, whichever came first. |
| post_video_complete_views_organic | INTEGER | Number of times the video was viewed to 95% of its length without any paid promotion. |
| post_video_complete_views_organic_unique | INTEGER | Number of people who viewed the video to 95% of its length without any paid promotion. |
| post_video_complete_views_paid | INTEGER | Number of times the video was viewed to 95% of its length after paid promotion. |
| post_video_complete_views_paid_unique | INTEGER | Number of people who viewed the video to 95% of its length after paid promotion. |
facebookInsightsExpiredPosts
Summary
Holding information about expired posts of Facebook Pages with all their private statistics attached.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| expireTime | DATETIME | The time this posting has expired. |
| objectId | STRING | The ID of any uploaded photo or video attached to the post. |
| type | ENUM | The object type of the post. |
| link | LINK | The link to the post. |
| message | STRING | The contents of the post message. |
| mentions | OBJECT | The tagged users or Facebook Pages within the post's message. Provided as a list of objects, e.g. [{"id": "128340270541979", "name": "quintly", "type": "Page", "offset": 10, "length": 7}, ...]. |
| externalId | STRING | The unique id of the post. |
| likes | INTEGER | Number of likes the post got. This does not include likes on shares. |
| love | INTEGER | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | INTEGER | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | INTEGER | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | INTEGER | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | INTEGER | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | INTEGER | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | INTEGER | Number of comments the post got. This doesn't include comments on shares. |
| shares | INTEGER | Number of shares the post got. This doesn't include shares of shares. |
| fans | INTEGER | Number of fans the page had on the day the post was published. |
| attachmentName | STRING | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | STRING | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | STRING | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | LINK | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
| privacy | STRING | Holds information about the targeting of the post. If the post is not targeted it will show "public". |
| isLiveVideo | BOOLEAN | If the posted video was live or not. Holds “1” if the post was a live post, “” if not. |
| isLiveAudio | BOOLEAN | If the posted audio was live or not. Holds “1” if the post was a live post, “” if not. |
| isSharedPost | BOOLEAN | If the post is a shared post or not. Holds “1” if the post is a shared post, “” if not. |
| isSpherical | BOOLEAN | 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 | INTEGER | Number of "Like" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_love | INTEGER | Number of "Love" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_wow | INTEGER | Number of "Wow" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_haha | INTEGER | Number of "Haha" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_sorry | INTEGER | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
| post_reactions_by_type_total_anger | INTEGER | Number of "Anger" reactions the post got. This also includes reactions on shares. |
| post_engaged_fan | INTEGER | Number of people who have liked the Page and clicked anywhere in the post. |
| post_impressions | INTEGER | Number of impressions of the Page post. |
| post_impressions_unique | INTEGER | Number of people the Page post was served to. This is also known as reach. |
| post_impressions_organic | INTEGER | Number of impressions of the Page post that didn't come from an Ad or Sponsored Story. |
| post_impressions_organic_unique | INTEGER | Number of people who didn't see the Page post in an Ad or Sponsored Story. This is also known as organic reach. |
| post_impressions_nonviral | INTEGER | The number of times your Page's post entered a person's screen. |
| post_impressions_nonviral_unique | INTEGER | The number of people who had your Page's post enter their screen. |
| post_impressions_paid | INTEGER | Number of impressions of the Page post in an Ad or Sponsored Story. |
| post_impressions_paid_unique | INTEGER | Number of people the advertised Page post was served to. This is also known as paid reach. |
| post_impressions_fan | INTEGER | Number of impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_unique | INTEGER | Number of people who saw the Page post because they've liked the Page |
| post_impressions_fan_paid | INTEGER | Number of paid impressions of the Page post to people who have liked the Page. |
| post_impressions_fan_paid_unique | INTEGER | Number of people who like the Page and who saw the Page post in an ad or sponsored story. |
| post_impressions_viral | INTEGER | Number of impressions of the Page post in a story generated by a friend. |
| post_impressions_viral_unique | INTEGER | Number of people who saw the Page post in a story from a friend. |
| post_clicks | INTEGER | Number of clicks anywhere in the post. |
| post_clicks_unique | INTEGER | Number of people who clicked anywhere in the post. |
| post_clicks_by_type_link_clicks | INTEGER | Number of clicks on links in the post. |
| post_clicks_by_type_photo_view | INTEGER | Number of clicks on photo attachments in the post which led to an expanded view of the photo. |
| post_clicks_by_type_video_play | INTEGER | Number of clicks on video attachments in the post which started the video. |
| post_clicks_by_type_other_clicks | INTEGER | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. |
| post_clicks_by_type_unique_link_clicks | INTEGER | Number of people who clicked on links in the post. |
| post_clicks_by_type_unique_photo_view | INTEGER | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. |
| post_clicks_by_type_unique_video_play | INTEGER | Number of people who clicked on video attachments in the post which started the video. |
| post_clicks_by_type_unique_other_clicks | INTEGER | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. |
| post_engaged_users | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide post'. |
| post_negative_feedback_by_type_hide_all_clicks | INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide All'. |
| post_negative_feedback_by_type_unlike_page_clicks | INTEGER | Number of times people have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_report_spam_clicks | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of people who have given negative feedback to the post by unliking the page. |
| post_negative_feedback_by_type_unique_report_spam_clicks | INTEGER | Number of people who have given negative feedback to the post by reporting the post as spam. |
| post_activity | INTEGER | Number of stories generated about the Page post. |
| post_activity_unique | INTEGER | Number of people who created a story by interacting with the Page post. |
| post_activity_by_action_type_like | INTEGER | Number of stories created about the Page post by liking the post. |
| post_activity_by_action_type_comment | INTEGER | Number of stories created about the Page post by commenting on the post. |
| post_activity_by_action_type_share | INTEGER | Number of stories created about the Page post by sharing the post. |
| post_activity_by_action_type_unique_like | INTEGER | Number of people who created a story about the Page post by liking it. |
| post_activity_by_action_type_unique_comment | INTEGER | Number of people who created a story about the Page post by commenting on it. |
| post_activity_by_action_type_unique_share | INTEGER | Number of people who created a story about the Page post by sharing it. |
| post_video_avg_time_watched | INTEGER | The average length of time (in milliseconds) people spent viewing the video. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time | INTEGER | Total time (in milliseconds) video has been viewed. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_view_time_organic | INTEGER | Total time (in milliseconds) video has been viewed in news feed or ticker or on the Page's Timeline. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_length | INTEGER | Length of a video post (in milliseconds). If the post doesn't include a video it will shown "0". |
| post_video_views | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_unique | INTEGER | Number of people who viewed the video for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_paid | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_organic | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_clicked_to_play | INTEGER | Number of times people clicked to play the video and viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_autoplayed | INTEGER | Number of times the video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_10s_sound_on | INTEGER | Number of times the video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_views_by_distribution_type_page_owned | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_unique | INTEGER | Number of people who viewed the video for 30 seconds or viewed to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_paid | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, after a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_organic | INTEGER | Number of times the video was viewed for 30 seconds or viewed to the end, whichever came first, without a paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_clicked_to_play | INTEGER | Number of times people clicked to play the video and viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_30s_autoplayed | INTEGER | Number of times the video started automatically playing and people viewed it for 30 seconds or to the end, whichever came first. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic | INTEGER | Number of times the video was viewed to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_organic_unique | INTEGER | Number of people who viewed the video to 95% of its length without any paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid | INTEGER | Number of times the video was viewed to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
| post_video_complete_views_paid_unique | INTEGER | Number of people who viewed the video to 95% of its length after paid promotion. If the post doesn't include a video it will shown "0". Returns null for reshared videos. |
facebookInsightsPostAuthors
Summary
Holding information about authors of posts.
Schema
| Column name | Type | Description |
|---|---|---|
| id | STRING | The external id of the Facebook Business User, User or Application who created posts for the selected Pages. Only includes authors of Pages with more than one admin. |
| name | STRING | The name of the Facebook Business User, User or Application who created posts for the selected Pages. Only includes authors of Pages with more than one admin. |
| posts | OBJECT | The posts created by this author in the selected time period. Provided as a list of objects, e.g. [{"profileId": 92, "postId": "128340270541979_3180363705339605"}, ...]. |
facebookInsightsOwnVideos
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| expireTime | DATETIME | The time this posting has expired. |
| externalId | STRING | The unique id of the video. |
| link | LINK | The link to the video. |
| title | STRING | The video title or caption. |
| description | STRING | The description of the video. |
| is_published | BOOLEAN | If a post about the video is published. Holds “1” if a post is published, “” if not. |
| live_status | STRING | 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 | STRING | The content category of the video. |
| length | INTEGER | The duration of this video in seconds. |
| height | INTEGER | The height of this video in pixel. |
| width | INTEGER | The width of this video in pixel. |
| privacy | STRING | Holds information about the targeting of the post. If the post is not targeted it will show "public". |
| fans | INTEGER | Number of fans the page had on the day the post was published. |
| likes | INTEGER | Number of people who liked the video. This doesn't include likes on shares. |
| love | INTEGER | Number of "Love" reactions the post got. This does not include reactions on shares. |
| wow | INTEGER | Number of "Wow" reactions the post got. This does not include reactions on shares. |
| haha | INTEGER | Number of "Haha" reactions the post got. This does not include reactions on shares. |
| sad | INTEGER | Number of "Sorry" reactions the post got. This does not include reactions on shares. |
| angry | INTEGER | Number of "Angry" reactions the post got. This does not include reactions on shares. |
| thankful | INTEGER | Number of "Thankful" reactions the post got. This does not include reactions on shares. |
| comments | INTEGER | Number of comments on the video. This doesn't include comments on shares. |
| isExpired | BOOLEAN | If the posted video is expired |
| isCrossPosted | BOOLEAN | If the posted video is crossposted |
| source | LINK | A URL to the raw, playable video file. |
| picture | LINK | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
| total_video_views | INTEGER | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first. |
| total_video_views_unique | INTEGER | Number of unique people who viewed the video for 3 seconds or viewed to the end, whichever came first. |
| total_video_views_autoplayed | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. |
| total_video_views_paid | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times the video was viewed in a shared post. |
| total_video_views_by_distribution_type_page_owned | INTEGER | Number of times the video was viewed in a post that was page owned. |
| total_video_views_by_distribution_type_crossposted | INTEGER | Number of times the video was viewed in a crossposted post. |
| total_video_view_time_by_distribution_type_shared | INTEGER | Total time (in milliseconds) video has been viewed in a shared post. |
| total_video_view_time_by_distribution_type_page_owned | INTEGER | Total time (in milliseconds) video has been viewed in a post that was page owned. |
| total_video_view_time_by_distribution_type_crossposted | INTEGER | Total time (in milliseconds) video has been viewed in a crossposted post. |
| total_video_complete_views | INTEGER | Number of times the video was watched at 95% of its length, including watches that skipped to this point. |
| total_video_complete_views_unique | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. |
| total_video_10s_views_unique | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | 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 | INTEGER | The average length of time (in milliseconds) people spent viewing the video. |
| total_video_view_total_time | INTEGER | The total time (in ms) the video has been viewed. |
| total_video_view_total_time_organic | INTEGER | 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 | INTEGER | The total time (in ms) the video has been viewed after paid promotion. |
| total_video_impressions | INTEGER | Number of impressions of the video. |
| total_video_impressions_unique | INTEGER | Number of people the video was served to. |
| total_video_impressions_paid_unique | INTEGER | Number of people the advertised Page Video was served to. |
| total_video_impressions_paid | INTEGER | Number of impressions of the Page Video in an Ad or Sponsored Story. |
| total_video_impressions_organic_unique | INTEGER | Number of people who saw the Page Video in news feed or ticker, or on the Page's timeline. |
| total_video_impressions_organic | INTEGER | Number of impressions of the Video in news feed or ticker or on the Page's timeline. |
| total_video_impressions_viral_unique | INTEGER | Number of people who saw the Page Video in a story from a friend. |
| total_video_impressions_viral | INTEGER | Number of impressions of the Page Video in a story generated by a friend. |
| total_video_impressions_fan_unique | INTEGER | Number of people who saw the Page video because they've liked the Page. |
| total_video_impressions_fan | INTEGER | Number of impressions of the Page Video to people who have liked the Page. |
| total_video_impressions_fan_paid_unique | INTEGER | Number of people who like the Page and who saw the Page Video in an ad or sponsored story. |
| total_video_impressions_fan_paid | INTEGER | Number of paid impressions of the Page Video to people who have liked the Page. |
| total_video_stories_by_action_type_like | INTEGER | Number of stories created about the Page Video by liking the post. |
| total_video_stories_by_action_type_comment | INTEGER | Number of stories created about the Page Video by commenting on the post. |
| total_video_stories_by_action_type_share | INTEGER | Number of stories created about the Page Video by sharing the post. |
| total_video_reactions_by_type_total_like | INTEGER | Number of "Like" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_love | INTEGER | Number of "Love" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_wow | INTEGER | Number of "Wow" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_haha | INTEGER | Number of "Haha" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_sorry | INTEGER | Number of "Sorry" reactions the video got. This also includes reactions on shares. |
| total_video_reactions_by_type_total_anger | INTEGER | Number of "Anger" reactions the video got. This also includes reactions on shares. |
facebookInsightsPageFansOnline
Summary
Holding the number of Fans (People liking a Facebook Page) online over time, broken down by hour.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| fans | INTEGER | 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
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| source | LINK | The source according to Facebook's documentation. |
| likes | INTEGER | The number of new Page Likes in the current interval. |
| likesUnique | INTEGER | The number of unique new Page Likes in the current interval. |
| unlikesUnique | INTEGER | The number of unique lost Page Likes in the current interval. |
facebookInsightsPageViewsReferrals
Summary
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)
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| referral | STRING | 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 | INTEGER | The total number of Page Views. |
facebookInsightsVideosRetention
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | STRING | The ID of the video provided by Facebook. |
| publishedTime | DATETIME | Holding the full date and time information when this video was published. |
| message | STRING | The message sent along with the video. |
| title | STRING | The title of the video. |
| link | LINK | The link to the video on Facebook. |
| intervalAtSecond | INTEGER | Describing the beginning of this interval in seconds after the video started. |
| percentageOfViewers | INTEGER | The percentage of people still viewing the video at the end of this interval in 0-100 scale. |
facebookOwnPosts
Summary
Holding public information about posts of Facebook Pages with all their statistics attached.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| message | STRING | The contents of the post message. |
| mentions | OBJECT | The tagged users or Facebook Pages within the post's message. Provided as a list of objects, e.g. [{"id": "128340270541979", "name": "quintly", "type": "Page", "offset": 10, "length": 7}, ...]. |
| type | STRING | The object type of the post. |
| link | STRING | The link to the post. |
| externalId | STRING | The unique id of the post. |
| likes | INTEGER | Number of "Like" reactions the post got. This doesn't include reactions on shares. |
| love | INTEGER | Number of "Love" reactions the post got. This doesn't include reactions on shares. |
| wow | INTEGER | Number of "Wow" reactions the post got. This doesn't include reactions on shares. |
| haha | INTEGER | Number of "Haha" reactions the post got. This doesn't include reactions on shares. |
| sad | INTEGER | Number of "sad" reactions the post got. This doesn't include reactions on shares. |
| angry | INTEGER | Number of "angry" reactions the post got. This doesn't include reactions on shares. |
| thankful | INTEGER | Number of "Thankful" reactions the post got. This doesn't include reactions on shares. |
| comments | INTEGER | Number of comments the post got. This doesn't include comments on shares. |
| shares | INTEGER | Number of shares the post got. This doesn't include shares of shares. |
| interactionRate | PERCENT | 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 | STRING | 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 | INTEGER | Number of fans the page had on the day the post was published. |
| appId (Deprecated) |
STRING | 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. UPDATE: This metric is deprecated and will return always "null". |
| appName (Deprecated) |
STRING | 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. UPDATE: This metric is deprecated and will return always "null". |
| isLiveVideo | BOOLEAN | If the posted video was live or not. Holds “1” if the post was a live post, “” if not. |
| isLiveAudio | BOOLEAN | If the posted audio was live or not. Holds “1” if the post was a live post, “” if not. |
| isSharedPost | BOOLEAN | If the post is a shared post or not. Holds “1” if the post is a shared post, “” if not. |
| isSpherical | BOOLEAN | 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 | STRING | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | STRING | A description of a link in the post (appears beneath the attachmentCaption). Holds "null" if no attachment description is set. |
| attachmentCaption | STRING | The link in the caption of a post. The caption must be an actual URL and when clicking on it, it should accurately reflect the URL of the associated advertiser, business or owner of the posted content (e.g. news article). If the post is shared and contains another shared post the value will be null. |
| attachmentHref | LINK | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
facebookQuestions
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| userName | STRING | No documentation available yet |
| fans | INTEGER | Number of fans the page had on the day the post was published. |
| likes | INTEGER | No documentation available yet |
| love | INTEGER | No documentation available yet |
| wow | INTEGER | No documentation available yet |
| haha | INTEGER | No documentation available yet |
| sad | INTEGER | No documentation available yet |
| angry | INTEGER | No documentation available yet |
| comments | INTEGER | No documentation available yet |
| shares | INTEGER | No documentation available yet |
| responseTime | DATETIME | No documentation available yet |
| timeToRespond | INTEGER | No documentation available yet |
| interactionRate | PERCENT | No documentation available yet |
| link | LINK | No documentation available yet |
| message | STRING | No documentation available yet |
| isQuestion | BOOLEAN | No documentation available yet |
facebookUserPosts
Summary
Holding public information about posts by Facebook users to the Timeline of Facebook Pages with all their statistics attached.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| userName | STRING | The name of the user who created the user post. |
| message | STRING | The contents of the post message. |
| type | ENUM | The object type of the post. |
| link | LINK | The link to the post. |
| externalId | STRING | The unique id of the post. |
| likes | INTEGER | Number of "Like" reactions the post got. This doesn't include reactions on shares. |
| love | INTEGER | Number of "Love" reactions the post got. This doesn't include reactions on shares. |
| wow | INTEGER | Number of "Wow" reactions the post got. This doesn't include reactions on shares. |
| haha | INTEGER | Number of "Haha" reactions the post got. This doesn't include reactions on shares. |
| sad | INTEGER | Number of "Sorry" reactions the post got. This doesn't include reactions on shares. |
| angry | INTEGER | Number of "Anger" reactions the post got. This doesn't include reactions on shares. |
| thankful | INTEGER | Number of "Thankful" reactions the post got. This doesn't include reactions on shares. |
| comments | INTEGER | Number of comments the post got. This doesn't include comments on shares. |
| shares | INTEGER | Number of shares the post got. This doesn't include shares of shares. |
| isQuestion | BOOLEAN | If the post contains a question or not. Holds “1” if the post contains a question, “” if not. |
| responseTime | DATETIME | The date of the pages's first comment on the user post in "Y/m/d H:i:s" format. |
| timeToRespond | INTEGER | 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. |
| appId | STRING | The id of the third party app which was used to publish the post. |
| appName (Deprecated) |
STRING | The name of the third party app which was used to publish the post. |
| attachmentName (Deprecated) |
STRING | The name of the post's attachment. Holds "null" if no attachment name is set. |
| attachmentDescription | STRING | The description of the post's attachment. Holds "null" if no attachment description is set. |
| attachmentCaption | STRING | The caption of the post's attachment. Holds "null" if no attachment caption is set. |
| attachmentHref | LINK | The URL of the post's attachment. Holds "null" if no attachment URL is available. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
Summary
Holding public data for Instagram Profiles and their development over time. All numbers are aggregates across the whole Instagram Profile. Data related to IGTV posts are not provided by Instagram and thus not included in this data source.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| followers | INTEGER | Number of Followers of the account. |
| followersBefore | INTEGER | Number of Followers of the account. |
| followersChange | INTEGER | Change of the number of Followers of the account. |
| following | INTEGER | Total number of Instagram Accounts the analysed Account is following. |
| followingBefore | INTEGER | Total number of Instagram Accounts the analysed Account is following. |
| followingChange | INTEGER | Change of the total number of Instagram Accounts the analysed Account is following. |
| posts | INTEGER | Number of posts created by the account. |
| postsBefore | INTEGER | Number of posts created by the account. |
| postsChange | INTEGER | Change of number of posts created by the account. |
| images | INTEGER | Number of new image type posts created. |
| imagesLikes | INTEGER | Number of likes on new image type posts. |
| imagesComments | INTEGER | Number of comments on new image type posts. |
| videos | INTEGER | Number of new video type posts. |
| videosLikes | INTEGER | Number of likes on new video type posts. |
| videosComments | INTEGER | Number of comments on new video type posts. |
| carousels | INTEGER | Number of new carousel type posts. |
| carouselsLikes | INTEGER | Number of likes on new carousel type posts. |
| carouselsComments | INTEGER | Number of comments on new carousel type posts created. |
instagramInsights
Summary
Holding private-level data for Instagram Business Accounts from Instagram Insights and their development over time. All numbers are aggregates across the whole Instagram Business Account. Please note that Instagram Insights provide data for only three different intervals: daily, weekly and 28 days and thus for unique metrics like Reach one cannot go beyond 28 day analysis.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| importTime | DATETIME | The time this posting was imported. |
| impressions | INTEGER | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. |
| impressionsDay | INTEGER | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds daily fixed interval values. |
| impressionsWeek | INTEGER | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds weekly fixed interval values. |
| impressionsDays28 | INTEGER | Total number of times any content of the account was seen in the selected time interval. This value is not unique and includes impressions from both paid and organic context. It holds 28 days fixed interval values. |
| reach | INTEGER | Total number of times the Instagram Business User's media objects (i.e. posts, stories and promotions) have been uniquely viewed. This includes reach from both paid and organic context. Paid context are ad activity generated through the API, Facebook ads interfaces, and the Promote feature. |
| reachDay | INTEGER | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds daily fixed interval values. |
| reachWeek | INTEGER | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds weekly fixed interval values. |
| reachDays28 | INTEGER | Total number of times users have seen any content of the account in the selected time interval. This value is unique and includes reach from both paid and organic context. It holds 28 days fixed interval values. |
| followerCountDay | INTEGER | Number of followers added to the account in the selected time range. This metric is only available when using daily interval. |
| emailContactsDay | INTEGER | Number of times the Email Contact call to action button was clicked in the selected time range. This metric is only available when using daily interval. |
| phoneCallClicksDay | INTEGER | Number of times the Phone Call call to action button was clicked in the selected time range. This metric is only available when using daily interval. |
| textMessageClicksDay | INTEGER | Number of times the Text Message call to action button was clicked in the selected time range.This metric is only available when using daily interval. |
| getDirectionsClicksDay | INTEGER | Number of times the Get Directions call to action button was clicked in the selected time range.This metric is only available when using daily interval. |
| websiteClicksDay | INTEGER | Number of times users clicked on the website link in the selected time range. This metric is only available when using daily interval. |
| profileViewsDay | INTEGER | Number of times the account was viewed in the selected time range. Unlike reach or impressions this holds only the views of the profile page, it doesn't include any other contexts (e.g. posts on the feed). This metric is only available when using daily interval. |
instagramInsightsOwnPosts
Summary
Holding information about posts of Instagram Business Accounts with all their private statistics attached. Data related to IGTV posts are not provided by Instagram and thus not included in this data source.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was last imported. |
| externalId | STRING | The post's ID on Instagram's platform. |
| shortCode | STRING | The post's short-code as defined on Instagram's platform. |
| message | STRING | The caption of the Instagram post. |
| mentions | OBJECT | The mentioned users within the post's message. Provided as a list of strings, e.g. ["username1", "username2"]. |
| hashtags | OBJECT | The hashtags used within the post's message. Provided as a list of strings, e.g. ["#hashtag1", "#hashtag2"]. |
| likes | INTEGER | Total number of likes a post received. Please note that this includes organic content only. |
| comments | INTEGER | Total number of comments a post received. Please note that this includes organic content only. |
| link | LINK | The direct link to the post. |
| mediaUrl | LINK | The link to the post's attached media. |
| attachmentPreviewPicture | LINK | The link to the post's attached media thumbnail. |
| type | ENUM | The type of the post. This can be either Image, Video or Carousel. |
| impressions | INTEGER | Total number of times the post was seen. This number is not unique. |
| engagement | INTEGER | Total number of engagements (likes, comments and saves) on the post. This number is not unique. Please note that this includes organic content only. |
| reach | INTEGER | Total number of users who have seen the post. This number is unique, one user is only counted once even if they've seen the post multiple times. |
| saved | INTEGER | The number of times users saved the post on Instagram. |
| videoViews | INTEGER | This shows the total number of times a video has been played. This value is not unique, however, it won't count a view as new when the video automatically restarts and includes views only that were at least 3s long. If the type of a post is carousel, the result will be 0. It contains views from organic content only. |
instagramInsightsStories
Summary
Holding private-level information about Instagram stories, including impressions, reach, taps and other metrics. Please note that this doesn’t include re-shared stories and live video stories.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | The story's ID on Instagram's platform |
| shortCode | STRING | The story's short-code as defined on Instagram's platform |
| caption | STRING | The captions of the Instagram story. If there's more than one text item, the text items are concatenated and whitespace-separated. |
| link | LINK | The direct link to the story (works only on mobile devices with the Instagram app). The link will be active for as long as the story is active on Instagram (24 hours from the time of creation). |
| mediaUrl | LINK | The link to the story's media |
| thumbnailUrl | LINK | The link to the story's preview picture |
| type | ENUM | The type of the story (photo/video) |
| impressions | INTEGER | The number of impressions on the story |
| exits | INTEGER | Number of times someone exited the story. This includes users closing Instagram while viewing the story, users clicking on the X on the top-right corner of the story or users swiping down the media, ending back on the main feed. |
| reach | INTEGER | The number of people who saw the story at least once; reach is different from impressions, which may include multiple views of the story by the same people. |
| replies | INTEGER | The total number of replies to the stories carousel |
| tapsForward | INTEGER | The total number of taps to see this story's next photo or video |
| tapsBack | INTEGER | The total number of taps to see this story's previous photo or video |
instagramOwnPosts
Summary
Holding public information about posts of Instagram profiles with all their statistics attached. Data related to IGTV posts are not provided by Instagram and thus not included in this data source.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was last imported. |
| likes | INTEGER | Number of likes the post got on organic context. |
| comments | INTEGER | Number of comments the post got on organic context. |
| type | ENUM | The type of the post. This can be either Image, Video or Carousel. |
| interactionRate | PERCENT | Holds the interaction rate of organic post. You can find more information on how we calculate the interaction rate in our knowledge base article. |
| link | LINK | The link to the post. |
| externalId | STRING | The unique id of the post. |
| message | STRING | The contents of the post message. |
| filter | STRING | The name of the filter which was applied to the photo/video. |
| followers | INTEGER | Number of followers the account had on the day the post was published. |
| mediaUrl | LINK | The Url of the raw media file. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. |
Summary
Holding public data for LinkedIn Company Pages and their development over time. All numbers are aggregates across the whole LinkedIn Company Page. Post related columns of this data source have been marked as deprecated on 17th of October 2019 due to changes by LinkedIn. Those columns will be removed 1st of January 2020. Until then historic data up until the change became effective is still accessible.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| followers | INTEGER | Total number of Followers for the LinkedIn Company Page. |
| followersBefore | INTEGER | Total number of Followers for the LinkedIn Company Page. |
| followersChange | INTEGER | Change of the total number of Followers for the LinkedIn Company Page. |
| ownPosts (Deprecated) |
INTEGER | Total number of new updates by the LinkedIn Company Page. |
| ownPostsLikes (Deprecated) |
INTEGER | Total number of likes on new updates. |
| ownPostsComments (Deprecated) |
INTEGER | Total number of comments on new updates. |
| ownPostsTypeStatus (Deprecated) |
INTEGER | Total number of new updates of type Status (text only) by the LinkedIn Company Page. |
| ownPostsTypePhoto (Deprecated) |
INTEGER | Number of new updates of type Photo (holding a photo attachment) by the LinkedIn Company Page. |
| ownPostsTypeLink (Deprecated) |
INTEGER | Total number of new updates of type Link (holding a link attachment) by the LinkedIn Company Page. |
| ownPostsTypeJob (Deprecated) |
INTEGER | 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 (Deprecated) |
INTEGER | Total number of new updates of all other types by the LinkedIn Company Page. |
linkedInUpdates (deprecated)
Summary
Holding public information about Status Updates of LinkedIn Company Pages with all their statistics attached. This data source has been marked as deprecated on 17th of October 2019 due to changes by LinkedIn. This data source as a whole will be removed 1st of January 2020. Until then historic data up until the change became effective is still accessible.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was last imported. |
| likes | INTEGER | Number of likes the update got. |
| comments | INTEGER | Number of comments the update got. |
| link | LINK | The link to the update. |
| type | ENUM | The type of the update. This can be Status, Link or Photo. |
| externalId | STRING | The unique id of the update. |
| interactionRate | PERCENT | Holds the interaction rate of the update. Please note, it takes into the account the number of followers from the day the Update was created. You can find out more information on how we calculate interaction rate on our knowledge base. |
| message | STRING | The content of the update message. |
| followers | INTEGER | Number of followers the LinkedIn Company Page had on the day the Update was created. |
| attachmentName | STRING | The name of the update's attachment. |
| attachmentDescription | STRING | The description of the update's attachment. |
| attachmentHref | LINK | The URL of the update's attachment. |
| attachmentPreviewPicture | LINK | The URL to the attachment preview picture. |
linkedInAnalyticsOwnPosts
Summary
Holding private information about posts of LinkedIn Company Pages with all their statistics attached.
Hints
- Post statistics only reflect the performance of the past 12 months, using a rolling 12-month window. E.g. engagement on a post longer than 12 months ago is not included.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | The unique id of the post. |
| type | ENUM | The type of the post. This can be Link, Image, Status, Rich, Video, Course, Job, Question, Answer, Carousel, Topic, Document, Reference or LiveVideo. |
| message | STRING | The post's message. |
| link | LINK | The link to the post. |
| attachment | OBJECT | The details of the posts's attachment. Provided as an object, e.g. {"description": "text", "thumbnail": "https://quintly.com/thumbnail/social.jpg", "title": "title", "url": "http://bit.ly/2L8Qw5u"} |
| targeting | OBJECT | The details of the posts's targeting settings. The object holds the following properties representing targeting types: "location", "language", "jobFunction", "companySize", "school", "seniority", "industries", "fieldOfStudy" and "degree". Provided as an object with a list of objects for each targeting property, e.g. {[ { "id": STRING, "type": STRING, "name": STRING }, ... ].} |
| mentions | OBJECT | The companies, schools or users/members mentioned in the post's message. Provided as a list of objects, e.g. [{"id": "urn:li:organization:1", "username": "quintly", "name": "quintly", "type": "company"},{"id": "urn:li:person:1", "username": "user1", "name": "User", "type": "member"},{"id": "urn:li:organization:2", "username": "uni", "name": "University", "type": "school"}] |
| likes | INTEGER | Number of organic likes the post got. |
| comments | INTEGER | Number of organic comments the post got. |
| shares | INTEGER | Number of organic shares the post got. |
| clicks | INTEGER | Number of organic clicks the post got. |
| impressions | INTEGER | Number of organic impressions the post got. |
| engagementRate | DECIMAL | Number of organic clicks, likes, comments, and shares divided by impressions. |
| videoViews | INTEGER | Video views with play-pause cycles for at least 3 seconds. Auto-looping videos are counted as one when loaded. Each subsequent auto-looped play does not increase this metric. |
| videoViewers | INTEGER | Unique viewers who made engaged plays on the video. Auto-looping videos are counted as one when loaded. Each subsequent auto-looped play does not increase this metric. |
| videoTimeWatched | INTEGER | The time the video was watched in milliseconds. Video auto-looping will continue to increase this metric for each subsequent play. |
| videoTimeWatchedForVideoViews | INTEGER | The time watched in milliseconds for video play-pause cycles that are at least 3 seconds. Video auto-looping will continue to increase this metric for each subsequent play. |
pinterest (deprecated)
Summary
Holding public data for Pinterest Profiles and their development over time. All numbers are aggregates across the whole Pinterest Profile. This data source has been marked as deprecated on 8th of November 2019 due to Pinterest removing public data access for any Pinterest user via their API. This data source as a whole will be removed 1st of January 2020. Until then historic data up until the API change became effective is still accessible.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| followers | INTEGER | The number of users following this profile. |
| followersBefore | INTEGER | No documentation available yet |
| followersChange | INTEGER | No documentation available yet |
| following | INTEGER | The number of users this profile is following. |
| followingBefore | INTEGER | No documentation available yet |
| followingChange | INTEGER | No documentation available yet |
| pins | INTEGER | The number of pins this profile created. This does not include pins which are deleted or on a private board. |
| pinsBefore | INTEGER | No documentation available yet |
| pinsChange | INTEGER | No documentation available yet |
| boards | INTEGER | The number of boards listed on the profile. |
| boardsBefore | INTEGER | No documentation available yet |
| boardsChange | INTEGER | No documentation available yet |
| likes (Deprecated) |
INTEGER | No documentation available yet |
| likesBefore (Deprecated) |
INTEGER | No documentation available yet |
| likesChange (Deprecated) |
INTEGER | No documentation available yet |
| boardCollaborators | INTEGER | The number of collaborators across all boards. |
| boardCollaboratorsBefore | INTEGER | No documentation available yet |
| boardCollaboratorsChange | INTEGER | No documentation available yet |
| boardFollowers | INTEGER | The sum of followers across all the boards. |
| boardFollowersBefore | INTEGER | No documentation available yet |
| boardFollowersChange | INTEGER | No documentation available yet |
| boardPins | INTEGER | The number of pins across all the boards. |
| boardPinsBefore | INTEGER | No documentation available yet |
| boardPinsChange | INTEGER | No documentation available yet |
| pinComments | INTEGER | How often all the pins on boards have been commented. |
| pinCommentsBefore | INTEGER | No documentation available yet |
| pinCommentsChange | INTEGER | No documentation available yet |
| pinLikes (Deprecated) |
INTEGER | No documentation available yet |
| pinLikesBefore (Deprecated) |
INTEGER | No documentation available yet |
| pinLikesChange (Deprecated) |
INTEGER | No documentation available yet |
| saves | INTEGER | How often all the pins on boards have been saved. |
| savesBefore | INTEGER | No documentation available yet |
| savesChange | INTEGER | No documentation available yet |
| ownBoards | INTEGER | The number of boards where the only contributor is the profile. |
| ownBoardsBefore | INTEGER | No documentation available yet |
| ownBoardsChange | INTEGER | No documentation available yet |
| ownBoardsFollowers | INTEGER | The sum of followers across boards where the only contributor is the profile. |
| ownBoardsFollowersBefore | INTEGER | No documentation available yet |
| ownBoardsFollowersChange | INTEGER | No documentation available yet |
| ownBoardsPins | INTEGER | The number of pins across boards where the only contributor is the profile. |
| ownBoardsPinsBefore | INTEGER | No documentation available yet |
| ownBoardsPinsChange | INTEGER | No documentation available yet |
| collaboratorBoards | INTEGER | The number of group boards. |
| collaboratorBoardsBefore | INTEGER | No documentation available yet |
| collaboratorBoardsChange | INTEGER | No documentation available yet |
| collaboratorBoardsFollowers | INTEGER | The sum of followers across group boards. |
| collaboratorBoardsFollowersBefore | INTEGER | No documentation available yet |
| collaboratorBoardsFollowersChange | INTEGER | No documentation available yet |
| collaboratorBoardsPins | INTEGER | The number of pins across group boards. |
| collaboratorBoardsPinsBefore | INTEGER | No documentation available yet |
| collaboratorBoardsPinsChange | INTEGER | No documentation available yet |
| ownPins | INTEGER | The number of pins this profile created. This also includes number of pins on a private board. |
| ownPinsBefore | INTEGER | No documentation available yet |
| ownPinsChange | INTEGER | No documentation available yet |
| ownPinsLikes (Deprecated) |
INTEGER | No documentation available yet |
| ownPinsLikesBefore (Deprecated) |
INTEGER | No documentation available yet |
| ownPinsLikesChange (Deprecated) |
INTEGER | No documentation available yet |
| ownPinsComments | INTEGER | The number of comments on pins this profile created. |
| ownPinsCommentsBefore | INTEGER | No documentation available yet |
| ownPinsCommentsChange | INTEGER | No documentation available yet |
| ownPinsSaves | INTEGER | The number of saves on pins this profile created. |
| ownPinsSavesBefore | INTEGER | No documentation available yet |
| ownPinsSavesChange | INTEGER | No documentation available yet |
| collaboratorPins | INTEGER | The number of pins created by collorators. |
| collaboratorPinsBefore | INTEGER | No documentation available yet |
| collaboratorPinsChange | INTEGER | No documentation available yet |
| collaboratorPinsLikes (Deprecated) |
INTEGER | No documentation available yet |
| collaboratorPinsLikesBefore (Deprecated) |
INTEGER | No documentation available yet |
| collaboratorPinsLikesChange (Deprecated) |
INTEGER | No documentation available yet |
| collaboratorPinsComments | INTEGER | The number of comments on pins created by collaborators. |
| collaboratorPinsCommentsBefore | INTEGER | No documentation available yet |
| collaboratorPinsCommentsChange | INTEGER | No documentation available yet |
| collaboratorPinsSaves | INTEGER | The number of saves on pins created by collaborators. |
| collaboratorPinsSavesBefore | INTEGER | No documentation available yet |
| collaboratorPinsSavesChange | INTEGER | No documentation available yet |
pinterestBoards (deprecated)
Summary
Holding public information about Boards of Pinterest profiles with all their statistics attached. This data source has been marked as deprecated on 8th of November 2019 due to Pinterest removing public data access for any Pinterest user via their API. This data source as a whole will be removed 1st of January 2020. Until then historic data up until the API change became effective is still accessible.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this board was created. |
| importTime | DATETIME | The time this board was last imported. |
| followers | INTEGER | The number of users following this board. |
| pins | INTEGER | The number of pins on this board. |
| collaborators | INTEGER | The number of collaborators contributing to this group board. |
| name | STRING | The name of the board. |
| link | LINK | The link to the board. |
| externalId | STRING | The unique string of numbers and letters that identifies the board on Pinterest. |
| description | STRING | The description of the board. |
| isCollaboratorBoard | BOOLEAN | This is true if the board is a group board, allowing other users to collaborate and add pins. |
pinterestPins (deprecated)
Summary
Holding public information about Pins on Boards of Pinterest profiles with all their statistics attached. This data source has been marked as deprecated on 8th of November 2019 due to Pinterest removing public data access for any Pinterest user via their API. This data source as a whole will be removed 1st of January 2020. Until then historic data up until the API change became effective is still accessible.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | INTEGER | The ID of the board that the Pin is published on. |
| time | DATETIME | The time this Pin was created. |
| importTime | DATETIME | The time this Pin was last imported. |
| creatorId | INTEGER | The ID of the user who created the Pin. |
| creatorUrl | LINK | The profile URL of the user who created the Pin. |
| likes (Deprecated) |
INTEGER | No documentation available yet |
| comments | INTEGER | No documentation available yet |
| saves | INTEGER | No documentation available yet |
| message | STRING | The description of the Pin. |
| pinType | ENUM | The type of the Pin. This can be Regular, Recipe, Article or Product. |
| mediaType | ENUM | The media type of the Pin. This can be Image or Video. |
| pinLink | LINK | The URL of the webpage where the Pin was created. |
| link | LINK | The URL of the Pin on Pinterest. |
| attachmentPreviewPicture | LINK | The Pin’s image. |
| externalId | STRING | The unique string of numbers and letters that identifies the Pin on Pinterest. |
| price | DECIMAL | The product price (without any currency sign, e.g., "6.50"). |
| currency | STRING | The code of the currency. |
| isOwnPin | STRING | This shows if the pin has been created/added to the board by the profile itself. |
Summary
Holding public data for Twitter Profiles and their development over time. All numbers are aggregates across the whole Twitter Profile. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| followers | INTEGER | Number of followers of the handle at the end of the internal. |
| followersBefore | INTEGER | Number of followers of the handle at the beginning of the internal. |
| followersChange | INTEGER | Change of the total number of Followers. |
| following | INTEGER | Number of handles the analysed handle is following. |
| followingBefore | INTEGER | Number of handles the analysed handle is following. |
| followingChange | INTEGER | Change of the total number of handles the analysed handle is following. |
| tweets | INTEGER | Number of Tweets created. This includes Own Tweets, Retweeted Tweets and Replies. |
| tweetsBefore | INTEGER | Number of Tweets created. This includes Own Tweets, Retweeted Tweets and Replies. |
| tweetsChange | INTEGER | Change of the total number of Tweets created. This includes Own Tweets, Retweeted Tweets and Replies. |
| ownTweets | INTEGER | Number of Own Tweets created. |
| ownTweetsRetweets | INTEGER | Number of Retweets on Own Tweets. |
| ownTweetsFavs | INTEGER | Number of Likes on Own Tweets. |
| ownTweetsReplies | INTEGER | Number of Replies on Own Tweets created. |
| retweetedTweets | INTEGER | Number of Retweeted Tweets created by the handle. |
| replies | INTEGER | Number of Replies created by the handle. |
| repliesFromUsers | INTEGER | Number of Replies created to the handle. |
| retweets | INTEGER | Number of retweets on Own Tweets and Replies. |
| favorites | INTEGER | Number of Likes on Own Tweets and Replies. |
| mentions | INTEGER | Number of tweets the analysed handle was mentioned. This includes replies from users because in every reply the handle is mentioned as well. |
| responseTime0To2h | INTEGER | Number of questions asked that have been answered in less than 2 hours. |
| responseTime2To8h | INTEGER | Number of questions asked that have been answered in less than 2 hours. |
| responseTime8To24h | INTEGER | Number of questions asked that have been answered in less than 2 hours. |
| responseTimeLongerThan24h | INTEGER | Number of questions asked that have been answered in more than a day. |
| responseTimeNotResponded | INTEGER | Number of questions asked that have not been answered. |
| questions | INTEGER | Number of all questions asked. |
twitterAnalyticsOwnTweets
Summary
Holding private-level information about Tweets, excluding Retweeted Tweets and Replies, of Twitter profiles with all their statistics attached. Twitter’s API provides us with typically around 90 days historic data for the connected profiles, meaning data availability will begin around 90 days leading up to when you connect the account with Analytics, onwards. This also means we are only allowed to update data for the past 90 days, e.g. tweets older than 90 days can’t be updated. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | No documentation available yet |
| type | STRING | Type of the tweet. |
| mediaId | STRING | The ID of the attached media in the tweet. |
| mediaUrl | LINK | The URL of the attached media in the tweet. |
| followers | INTEGER | The number of followers this account currently has. |
| interactionRate | PERCENT | 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 | INTEGER | Number of times the Tweet has been retweeted. This includes Own Tweets only. |
| favs | INTEGER | Number of times the Tweet has been favorited. This includes Own Tweets only. |
| replies | INTEGER | Number of times the Tweet has been replied to. This includes Own Tweets only. |
| link | LINK | The link to the tweet. |
| message | STRING | The contents of the tweet message. |
| source | LINK | The name of the source which was used to publish the tweet. |
| impressions | INTEGER | Number of times the Tweet has been viewed. Please note that this includes organic content only. |
| engagements | INTEGER | A count of the number of times a user has interacted with the Tweet. Please note that this includes organic content only. |
| engagementRate | PERCENT | Engagement Rate is calculated as the ratio between the number of non-unique engagements and the number of non-unique impressions. Please note that this includes organic content only. |
| videoViews | INTEGER | Number of times a video in the given Tweet has been 50% visible for at least two seconds. |
twitterInteractionPatterns
Summary
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. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | No documentation available yet |
| profileUsername | STRING | No documentation available yet |
| profileLink | LINK | No documentation available yet |
| uniqueUsers | INTEGER | No documentation available yet |
| share | INTEGER | No documentation available yet |
twitterKeyInteractingUsers
Summary
Holding information about Twitter users mentioning Twitter profiles, sorting by most active Twitter users by default. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| id | STRING | No documentation available yet |
| name | STRING | No documentation available yet |
| mentions | INTEGER | No documentation available yet |
| overlaps | STRING | No documentation available yet |
| overlapsCount | INTEGER | No documentation available yet |
twitterMentions
Summary
Holding information about Mentions of Twitter profiles with all their statistics attached. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | No documentation available yet |
| userName | STRING | No documentation available yet |
| userFollowers | INTEGER | No documentation available yet |
| message | STRING | No documentation available yet |
| link | LINK | No documentation available yet |
| isRetweet | BOOLEAN | No documentation available yet |
| isReply | BOOLEAN | No documentation available yet |
| isQuestion | BOOLEAN | No documentation available yet |
| responseTime | DATETIME | No documentation available yet |
| timeToRespond | INTEGER | No documentation available yet |
| retweets | INTEGER | No documentation available yet |
| favs | INTEGER | No documentation available yet |
| userLocation | STRING | No documentation available yet |
| lat | DECIMAL | No documentation available yet |
| lon | DECIMAL | No documentation available yet |
| placeType | STRING | No documentation available yet |
| placeCountry | STRING | No documentation available yet |
| placeCountryCode | STRING | No documentation available yet |
| placeName | STRING | No documentation available yet |
twitterOwnReplies
Summary
Holding information about Replies, excluding Own Tweets and Retweeted Tweets, of Twitter profiles with all their statistics attached. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | No documentation available yet |
| followers | INTEGER | No documentation available yet |
| link | LINK | No documentation available yet |
| message | STRING | No documentation available yet |
| source | STRING | No documentation available yet |
| replyToTweetId | STRING | No documentation available yet |
| retweets | INTEGER | No documentation available yet |
| favs | INTEGER | No documentation available yet |
| replies | INTEGER | No documentation available yet |
| interactionRate | INTEGER | No documentation available yet |
twitterOwnTweets
Summary
Holding information about Own Tweets and Retweeted Tweets, excluding Replies to Users, of Twitter accounts with all their statistics attached. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| externalId | STRING | The unique id of the post. |
| followers | INTEGER | Number of followers the account had on the day the tweet was created. |
| interactionRate | PERCENT | 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 | INTEGER | 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 | INTEGER | 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 | LINK | The link to the tweet. |
| message | STRING | The contents of the tweet message. |
| isRetweet | BOOLEAN | This shows if the tweet is retweeted by the Twitter account or not. |
| source | STRING | The name of the source which was used to publish the tweet. |
| replies | INTEGER | Number of direct replies by a different user on the original tweet. It doesn’t include replies by the creator of the original tweet. If the tweet was retweeted it doesn’t include replies on retweets. This value is based on twitterMentions and estimated. |
twitterQuestions
Summary
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. To comply with the terms and conditions of Twitter, this data source is not supported when using the Quintly API, however you can access Twitter data directly in the tool.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| userName | STRING | No documentation available yet |
| favs | INTEGER | No documentation available yet |
| retweets | INTEGER | No documentation available yet |
| responseTime | DATETIME | No documentation available yet |
| timeToRespond | INTEGER | No documentation available yet |
| link | LINK | No documentation available yet |
| message | STRING | No documentation available yet |
| isQuestion | BOOLEAN | No documentation available yet |
youtube
Summary
Holding public data for YouTube Channels and their development over time. All numbers are aggregates across the whole YouTube Channel.
Special meaning of postfixes:
****Before: Value of node at the beginning of the interval.
****Change: Change of value between the beginning and the end of the interval.
****Counted: Calculated by walking over every single entity of our database. This could include videos that were deleted for example.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| subscribers | INTEGER | Total number of subscribers for the YouTube Channel. |
| subscribersBefore | INTEGER | Total number of subscribers for this YouTube Channel. |
| views | INTEGER | Total number of views counted on this date for the YouTube Channel. |
| viewsBefore | INTEGER | Total number of views counted on this date for the YouTube Channel. |
| videos | INTEGER | Total number of videos for this YouTube Channel. |
| videosBefore | INTEGER | Total number of videos for this YouTube Channel. |
| channelComments | INTEGER | Total number of channel comments for the YouTube Channel. |
| channelCommentsBefore | INTEGER | Total number of channel comments for this YouTube Channel. |
youtubeAnalytics
Summary
Holding private-level data for youtube channels and their development over time. All numbers are aggregates across the whole youtube channel.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| views | INTEGER | Number of views occured on the YouTube channel in the selected time range. |
| likes | INTEGER | Number of likes occured on the YouTube channel in the selected time range. |
| dislikes | INTEGER | Number of dislikes occured on the YouTube channel in the selected time range. |
| subscribersLost | INTEGER | Number of subscribers lost on the YouTube channel in the selected time range. |
| subscribersGained | INTEGER | Number of subsribers gained on the YouTube channel in the selected time range. |
| shares | INTEGER | Number of shares occured on the YouTube channel in the selected time range. |
| estimatedMinutesWatched | INTEGER | Number of minutes that users watched videos on the YouTube channel in the selected time range. |
| comments | INTEGER | Number of comments posted on the YouTube channel in the selected time range. |
| averageViewDuration | INTEGER | The average length, in seconds, of video playbacks on the YouTube channel in the selected time range. |
| annotationCloseRate | PERCENT | The ratio of annotations that viewers closed to the total number of annotation impressions in the selected time range. |
| annotationClickThroughRate | PERCENT | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions in the selected time range. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback in the selected time range. |
youtubeAnalyticsCountries
Summary
Holding key metrics like Views and Engagement numbers of YouTube Channels per country. All numbers are related to the selected time period.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | STRING | The country associated with the metrics in the report row. The dimension value is a two-letter ISO-3166-1 country code, such as US, CN (China), or FR (France). The country code ZZ is used to report metrics for which YouTube could not identify the associated country. |
| countryName | STRING | The full name of the country from the country Code. |
| views | INTEGER | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| likes | INTEGER | Total number of likes for the Youtube Channel at the end of the interval. |
| dislikes | INTEGER | Total number of dislikes for the Youtube Channel at the end of the interval. |
| subscribersLost | INTEGER | The number of people who unsubscribed from the channel during the selected timeframe. |
| subscribersGained | INTEGER | The number of people who subscribed to the channel during the selected timeframe. |
| shares | INTEGER | Total number of shares for the youtube channel at the end of the interval. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched videos for the youtube channel. |
| comments | INTEGER | Total number of comments for the youtube channel at the end of the interval. |
| averageViewDuration | INTEGER | The average length, in seconds, of video playbacks for the youtube channel. |
| annotationCloseRate | INTEGER | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | INTEGER | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback. |
youtubeAnalyticsDevices
Summary
Holding Views and Estimated Minutes Watched of YouTube Channels per device and their development over time.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| deviceType | ENUM | Identifies the physical form factor of the device on which the view occurred. One of: DESKTOP, GAME_CONSOLE, MOBILE, TABLET, TV, UNKNOWN_PLATFORM |
| deviceName | STRING | Readable representation of deviceType. For example: "DESKTOP" => "Laptop and desktops" |
| views | INTEGER | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched videos for the youtube channel. |
youtubeAnalyticsPlaybackLocations
Summary
Holding Views and Estimated Minutes Watched of YouTube Channels per Playback Location and their development over time.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| insightPlaybackLocationType | ENUM | Type of page or application where video playbacks occured. For example: EMBEDDED, MOBILE |
| insightPlaybackLocationName | STRING | Readable representation if PlaybackLocationType. For example: "EMBEDDED" => "Embedded player on other websites" |
| views | INTEGER | Total number of views counted on this date for the Youtube Channel at the end of the interval. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched videos for the youtube channel. |
youtubeAnalyticsPlaylists
Summary
Holding information about Playlists of YouTube Channels with all their private-level statistics attached. All numbers are related to the selected time period.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Time the playlist was published. |
| link | LINK | Link to the playlist. |
| status | STRING | Privacy status of the playlist. |
| title | STRING | Title of the playlist. |
| description | STRING | Description of the playlist. |
| views | INTEGER | The total number of times the playlist got viewed. |
| estimatedMinutesWatched | INTEGER | The total number of minutes viewers watched the playlist during the selected timeframe. |
| averageViewDuration | INTEGER | The number of seconds on average that a viewer would watch the playlist during the selected timeframe. |
| playlistStarts | INTEGER | The number of times that viewers initiated playback of the playlist during the selected timeframe. |
| viewsPerPlaylistStart | INTEGER | The number of views on average per playlist start. The average number of video views that occurred each time a playlist was initiated during the selected timeframe. |
| averageTimeInPlaylist | INTEGER | The number of minutes on average that a viewer would spend in the playlist during the selected timeframe. |
youtubeAnalyticsTopTenVideos
(deprecated)
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The date when the video got published. |
| link | LINK | Link to the video. |
| status | STRING | Privacy status of the video. |
| title | STRING | Title of the video. |
| description | STRING | Description of the video. |
| duration | INTEGER | Duration of the video in seconds |
| views | INTEGER | Views of the video. |
| likes | INTEGER | Likes of the video. |
| dislikes | INTEGER | Dislikes of the video. |
| subscribersLost | INTEGER | The total amount of subscribers lost on the videos watch page. |
| subscribersGained | INTEGER | The total amount of subscribers gained on the videos watch page. |
| shares | INTEGER | Shares of the video. |
| estimatedMinutesWatched | INTEGER | The number of minutes users watched the video. |
| comments | INTEGER | Total number of comments of this video. |
| averageViewDuration | INTEGER | Average duration a user watched this video in seconds. |
| annotationCloseRate | PERCENT | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | PERCENT | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback. |
youtubeAnalyticsTopVideos
Summary
Holding information about the top 200 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. Please note, that videos created in the last 72 hours could potentially be missing due to the delay of YouTube Analytics views data.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The date when the video got published. |
| link | LINK | Link to the video. |
| status | STRING | Privacy status of the video. |
| title | STRING | Title of the video. |
| description | STRING | Description of the video. |
| duration | INTEGER | Duration of the video in seconds |
| views | INTEGER | Views of the video. |
| likes | INTEGER | Likes of the video. |
| dislikes | INTEGER | Dislikes of the video. |
| subscribersLost | INTEGER | The total amount of subscribers lost on the videos watch page. |
| subscribersGained | INTEGER | The total amount of subscribers gained on the videos watch page. |
| shares | INTEGER | Shares of the video. |
| estimatedMinutesWatched | INTEGER | The number of minutes users watched the video. |
| comments | INTEGER | Total number of comments of this video. |
| averageViewDuration | INTEGER | Average duration a user watched this video in seconds. |
| annotationCloseRate | PERCENT | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | PERCENT | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback. |
youtubeAnalyticsTotal
Summary
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.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | INTEGER | Total number of views for the youtube channel at the end of the interval. |
| likes | INTEGER | Total number of likes for the youtube channel at the end of the interval. |
| dislikes | INTEGER | Total number of dislikes for the youtube channel at the end of the interval. |
| subscribersLost | INTEGER | The number of people who unsubscribed from the channel during the selected timeframe. |
| subscribersGained | INTEGER | The number of people who subscribed to the channel during the selected timeframe. |
| shares | INTEGER | Total number of shares for the youtube channel at the end of the interval. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched videos for the youtube channel |
| comments | INTEGER | Total number of comments for the youtube channel at the end of the interval. |
| averageViewDuration | INTEGER | The average length, in seconds, of video playbacks for the youtube channel. |
| annotationCloseRate | PERCENT | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | PERCENT | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback. |
youtubeAnalyticsTrafficSources
Summary
Holding Views and Estimated Minutes Watched of YouTube Channels per traffic source and their development over time.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| insightTrafficSourceType | ENUM | Type of the traffic source. One of: ADVERTISING, ANNOTATION, EXT_URL, NO_LINK_EMBEDDED, NO_LINK_OTHER, PLAYLIST, PROMOTED, RELATED_VIDEO, SUBSCRIBER, YT_CHANNEL, YT_OTHER_PAGE, YT_SEARCH, GOOGLE_SEARCH, EXT_APP, END_SCREEN |
| insightTrafficSourceName | STRING | More readable representation of the traffic type. For example: "RELATED_VIDEO" => "YouTube suggested video" |
| views | INTEGER | Total number of views from this traffic source. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched videos from this traffic source. |
youtubeAnalyticsVideos
Summary
Holding information about videos of YouTube Channels with all their private-level statistics attached. Please note, that the data has a delay up to 72 hours.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported in "Y/m/d H:i:s" format and UTC timezone. |
| link | LINK | Link to the video. |
| status | STRING | Privacy status of the video. |
| title | STRING | Title of the video. |
| description | STRING | Description of the video. |
| views | INTEGER | Total number of views for the video at the end of the interval. |
| likes | INTEGER | Total number of likes for the video at the end of the interval. |
| dislikes | INTEGER | Total number of dislikes for the youtube channel at the end of the interval. |
| subscribersLost | INTEGER | The total amount of subscribers lost on the videos watch page. |
| subscribersGained | INTEGER | The total amount of subscribers gained on the videos watch page. |
| shares | INTEGER | Total number of shares for the video at the end of the interval. |
| estimatedMinutesWatched | INTEGER | The number of minutes that users watched the video. |
| comments | INTEGER | Total number of comments for the video at the end of the interval. |
| averageViewDuration | INTEGER | The average length, in seconds, of video playbacks for the video. |
| annotationCloseRate | PERCENT | The ratio of annotations that viewers closed to the total number of annotation impressions. |
| annotationClickThroughRate | PERCENT | The ratio of annotations that viewers clicked to the total number of clickable annotation impressions. |
| averageViewPercentage | PERCENT | The average percentage of a video watched during a video playback. |
youtubeVideos
Summary
Holding information about videos of YouTube Channels with all their public statistics attached.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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 | DATETIME | The time this posting was created. |
| importTime | DATETIME | The time this posting was imported. |
| title | STRING | Title of the video. |
| link | LINK | Link to the video. |
| externalId | STRING | Id of the video in youtube's database. |
| videoId | STRING | The same as externalId. Node exists for backwards compatibility to an older version of the API. |
| views | INTEGER | Total amount of times a user watched this video. |
| likes | INTEGER | Total amount of times a user liked this video. |
| dislikes | INTEGER | Total amount of times a user disliked this video. |
| comments | INTEGER | Total amount of comments on this video. |
| duration | INTEGER | Duration of the video in seconds. |
snapchatShowInsights
Summary
Holding information about Snapchat shows and their development over time. All numbers are aggregates across the whole show.
Hints
- This data source only supports daily as an interval.
- Daily intervals are based on the PST timezone as provided by Snapchat.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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. |
| intervalStartTime | DATETIME | Holding the full date and time information describing the beginning of the current interval in PST timezone. For Snapchat shows there is only the daily interval available. |
| intervalEndTime | DATETIME | Holding the full date and time information describing the end of the current interval in PST timezone. For Snapchat shows there is only the daily interval available. |
| importTime | DATETIME | The time metrics for the current interval were last imported. |
| dailyUniques | INTEGER | The number of unique users who saw this show within the current interval. |
| monthlyUniques | INTEGER | The number of unique users who saw this show in the context of the month before the current interval. |
| subscribers | INTEGER | The number of the show's subscribers at the end of the current interval. |
| loyalUsers | INTEGER | The number of users that browsed the shows's content 5 to 7 days in the context of the previous 7 days from the current interval. |
| frequentUsers | INTEGER | The number of users that browsed the shows's content 3 to 4 days in the context of the previous 7 days from the current interval. |
| returningUsers | INTEGER | The number of users that browsed the shows's content twice in the context of the previous 7 days from the current interval. |
| newUsers | INTEGER | The number of users that browsed the shows's content once in the context of the previous 7 days from the current interval. |
| genderDemographicsMaleUsers | INTEGER | The number of male users who saw this show within the current interval. |
| genderDemographicsFemaleUsers | INTEGER | The number of female users who saw this show within the current interval. |
| genderDemographicsUnknownGenderUsers | INTEGER | The number of users with unknown gender who saw this show within the current interval. |
| ageDemographicsAgeRange13To17Users | INTEGER | The number of users in the age group 13 to 17 years who saw this show within the current interval. |
| ageDemographicsAgeRange18To24Users | INTEGER | The number of users in the age group 18 to 24 years who saw this show within the current interval. |
| ageDemographicsAgeRange25To34Users | INTEGER | The number of users in the age group 25 to 34 years who saw this show within the current interval. |
| ageDemographicsAgeRange35PlusUsers | INTEGER | The number of users in the age group 35 and older years who saw this show within the current interval. |
| ageDemographicsUnknownAgeUsers | INTEGER | The number of users with unknown age who saw this show within the current interval. |
| totalTimeViewed | INTEGER | The total time users spent on this show's content in seconds. |
| averageTimeSpentPerUser | INTEGER | The average time users spent on this show's content in seconds per user. |
| uniqueTopsnapsPerUser | INTEGER | The average number of topsnaps viewed in this show's stories. |
| uniqueTopsnapViews | INTEGER | The total number of unique topsnap views by users that engaged with this show's content. |
| topsnapViews | INTEGER | The total number of topsnap views by users that engaged with this show's content. |
| attachmentConversion | PERCENT | The percentage of unique users that swiped up on this show's snaps with attachments. |
| attachmentArticleViews | PERCENT | The total number of attachment article views by users that engaged with this show's content. |
| attachmentVideoViews | PERCENT | The total number of attachment video views by users that engaged with this show's content. |
| screenshots | INTEGER | The total number of screenshots made of this show's content within the current interval. |
| shares | INTEGER | The total number of shares of this show's content within the current interval. |
snapchatShowInsightsStories
Summary
Holding information about stories of Snapchat Shows.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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. |
| id | STRING | The ID of this story. |
| importTime | DATETIME | The time this story was imported. |
| createTime | DATETIME | The time this story was created. |
| startTime | DATETIME | The time this story was published. |
| firstLiveTime | DATETIME | The time this story went live for the first time. This is usually only seconds after it was published. |
| title | STRING | The title of this story. |
| state | ENUM | The state of this story. One of: Available, Scheduled |
| spotlightEndTime | DATETIME | The time this story stopped being the show's most recent story. |
| spotlightDuration | INTEGER | The total time in seconds this story was the shows's most recent story. |
| tags | OBJECT | The tags of this story. Provided as a list of strings, e.g. ["tag1", "tag2"]. |
| snaps | INTEGER | The number of snaps within this story. |
| genderDemographicsMaleUsers | INTEGER | The number of male users who saw this story. |
| genderDemographicsFemaleUsers | INTEGER | The number of female users who saw this story. |
| genderDemographicsUnknownGenderUsers | INTEGER | The number of users with unknown gender who saw this story. |
| ageDemographicsAgeRange13To17Users | INTEGER | The number of users in the age group 13 to 17 years who saw this story. |
| ageDemographicsAgeRange18To24Users | INTEGER | The number of users in the age group 18 to 24 years who saw this story. |
| ageDemographicsAgeRange25To34Users | INTEGER | The number of users in the age group 25 to 34 years who saw this story. |
| ageDemographicsAgeRange35PlusUsers | INTEGER | The number of users in the age group 35 and older years who saw this story. |
| ageDemographicsUnknownAgeUsers | INTEGER | The number of users with unknown age who saw this story. |
| viewTime | INTEGER | The total time this story was viewed in seconds. |
| averageViewTimePerUser | INTEGER | The average time per user this story was viewed in seconds. |
| totalViews | INTEGER | The total number of views for this story. |
| uniqueViewers | INTEGER | The total number of unique viewers for this story. |
| uniqueCompleters | INTEGER | The total number of users who completely watched this story. |
| completionRate | PERCENT | The percentage of users who completely watched this story. |
| shares | INTEGER | The total number of shares for this story. |
| uniqueSharers | INTEGER | The total number of users sharing this story. |
| viewersFromShares | INTEGER | The total number of users viewing this story from a share. |
| screenshots | INTEGER | The total number of screenshots made of this story. |
| subscribers | INTEGER | The total number of new subscribers to your show added when this story was live. |
| topsnapViewTime | INTEGER | The total time topsnaps of this story were viewed in seconds. |
| topsnapAverageViewTimePerUser | INTEGER | The average time per user topsnaps of this story were viewed in seconds. |
| topsnapTotalViews | INTEGER | The total number of views for topsnaps of this story. |
| topsnapUniqueViews | INTEGER | The total number of unique views for topsnaps of this story. |
| uniqueTopsnapsPerUser | INTEGER | The average number of topsnaps viewed per user in this story. |
snapchatShowInsightsSnaps
Summary
Holding information about snaps within stories of Snapchat Shows.
Schema
| Column name | Type | Description |
|---|---|---|
| profileId | INTEGER | 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. |
| id | STRING | The ID of this snap. |
| importTime | DATETIME | The time this snap was imported. |
| storyId | STRING | The ID of the story this snap belongs to. |
| storyStartTime | DATETIME | The time the story this snap belongs to was published. |
| name | STRING | The name of this snap. |
| position | INTEGER | The position of this snap within the story. The first snap has position 1. |
| duration | INTEGER | The duration of this snap in seconds. |
| tags | OBJECT | The tags of this snap. Provided as a list of strings, e.g. ["tag1", "tag2"]. |
| subscribeOptionsHeadline | STRING | The headline of the call to action to subscribe to the show present on this snap. |
| tiles | INTEGER | The number of tiles related to this snap. |
| tilesHeadlines | OBJECT | The headlines of the tiles related to this snap. Provided as a list of strings, e.g. ["headline1", "headline2"]. |
| genderDemographicsMaleUsers | INTEGER | The number of male users who saw this snap. |
| genderDemographicsFemaleUsers | INTEGER | The number of female users who saw this snap. |
| genderDemographicsUnknownGenderUsers | INTEGER | The number of users with unknown gender who saw this snap. |
| ageDemographicsAgeRange13To17Users | INTEGER | The number of users in the age group 13 to 17 years who saw this snap. |
| ageDemographicsAgeRange18To24Users | INTEGER | The number of users in the age group 18 to 24 years who saw this snap. |
| ageDemographicsAgeRange25To34Users | INTEGER | The number of users in the age group 25 to 34 years who saw this snap. |
| ageDemographicsAgeRange35PlusUsers | INTEGER | The number of users in the age group 35 and older years who saw this snap. |
| ageDemographicsUnknownAgeUsers | INTEGER | The number of users with unknown age who saw this snap. |
| viewTime | INTEGER | The total time this snap was viewed in seconds. |
| averageViewTimePerUser | INTEGER | The average time per user this snap was viewed in seconds. |
| totalViews | INTEGER | The total number of views for this snap. |
| uniqueViewers | INTEGER | The total number of unique viewers for this snap. |
| uniqueCompleters | INTEGER | The total number of users who completely watched this snap. |
| completionRate | PERCENT | The percentage of users who completely watched this snap. |
| shares | INTEGER | The total number of shares for this snap. |
| uniqueSharers | INTEGER | The total number of users sharing this snap. |
| viewersFromShares | INTEGER | The total number of users viewing this story from a snap. |
| screenshots | INTEGER | The total number of screenshots made of this snap. |
| dropOffRate | PERCENT | The percentage of users that dropped off from this snap to the next. |
| topsnapViewTime | INTEGER | The total time topsnaps related to this snap were viewed in seconds. |
| topsnapAverageViewTimePerUser | INTEGER | The average time per user topsnaps related to this snap were viewed in seconds. |
| topsnapTotalViews | INTEGER | The total number of views for topsnaps related to this snap. |
| topsnapUniqueViews | INTEGER | The total number of unique views for topsnaps related to this snap. |
profiles
Summary
Holding information about the selected profiles.
Schema
| Column name | Type | Description |
|---|---|---|
| id | INTEGER | Identifier for the selected profile. It's a quintly internal ID and can be joined with the "profileId" column in all other data sources. |
| name | STRING | The name of this profile. |
| profileDescription | STRING | The description of this profile. |
| profileLink | LINK | The link to this profile on the social network. |
| platformId | STRING | The social network specific identifier of this profile (e.g. the Facebook Page ID). |
| platformUsername | STRING | The username of this profile on the social network. |
| appendix | STRING | The appendix of this profile in your account. |
| nameWithAppendix | STRING | The name of this profile including the appendix. |
| originalName (Deprecated) |
STRING | The name of this profile. This field is deprecated and "name" should be used instead. |
| platformType | ENUM | The social network this profile belongs to. One of: facebook, instagram, twitter, youtube, linkedIn, pinterest, snapchatShow |
| profilePicture | LINK | The link to the picture of this profile. |