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
In case of errors, the HTTP status code returns either 404 for a non-existing resource or 500 for any other error. You can expect the following JSON response to be sent in the response's body. There is success set to false and errors and errors.reason holding more specific information about the error. In most cases errors.errorType will further return a unique identifier you can use to identify the specific error type.
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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Except for fans, checkins and people talking about metrics this data source calculates account-wide metrics by aggregating the results of all the posts (data source facebookOwnPosts) created in each interval. This also means that days, weeks or months without any posts published show 0 for all engagement metrics. This is to be differentiated from Facebook Insights data (data source facebookInsights) where the actual interaction time is considered for reporting, independent of when content has been published.
- Targeted posts are not imported.
- Deleted posts will not be removed from our database once they have been imported.
- When a Facebook Page disallows visitor posts, user posts will always be 0. Additionally, some user posts might not be included if the users who made them, do not allow their data to be shared via the API.
- Posts that contain links to YouTube or other web video players are considered video posts.
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 Facebook ads running in the context of a Facebook Page.
Hints
- Shows ads from ad accounts under which the selected Facebook Pages have been promoted and where the ad's promoted post belongs to one of the selected Facebook Pages.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 |
INTEGER | The distinct number of people who clicked on the ad. |
|
unique |
INTEGER | The number of people who performed an inline link click. |
| 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. |
|
omni |
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 |
DECIMAL | The percentage of people who saw the ad and performed a unique click. |
|
unique |
DECIMAL | The percentage of people who saw the ad and performed a link click. |
|
unique |
DECIMAL | TThe percentage of people who saw the ad and performed an outbound click. |
|
outbound |
DECIMAL | The percentage of times people saw the ad and performed an outbound click. |
|
website |
DECIMAL | The percentage of times people saw the ad and performed a link click. |
|
inline |
DECIMAL | The percentage of time people saw the ads and performed an inline link click. |
|
unique |
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 |
INTEGER | The number of people who engaged with the Facebook Page through the ad. |
|
post |
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 |
INTEGER | The number of people who viewed the video through the ad (when relevant). |
|
link |
INTEGER | The number of people who clicked on a link through the ad (when relevant). |
|
landing |
INTEGER | The number of people who viewed a landing page through the ad (when relevant). |
|
photo |
INTEGER | The number of people who viewed the photo through the ad (when relevant). |
|
post |
INTEGER | The number of Facebook reactions on the post through the ad. |
|
post |
INTEGER | The number of people who shared the post through the ad. |
|
mobile |
INTEGER | The number of people who installed the mobile app through the ad. |
| purchase | INTEGER | The number of purchase events attributed to your ads, based on information received from one or more of your connected Facebook Business Tools. |
| uniquePurchase | INTEGER | The estimated number of people who completed at least one purchase. |
| 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. |
| qualityRanking | STRING | A ranking of your ad's perceived quality. Quality is measured using feedback on your ads and the post-click experience. Your ad is ranked against ads that competed for the same audience. |
| engagementRateRanking | STRING | A ranking of your ad's expected engagement rate. Engagement includes all clicks, likes, comments and shares. Your ad is ranked against ads that competed for the same audience. |
| conversionRateRanking | STRING | A ranking of your ad's expected conversion rate. Your ad is ranked against ads with your optimization goal that competed for the same audience. |
| actions | OBJECT | The total number of actions people took that are attributed to your ads. Actions may include engagement, clicks or conversions. |
| actionValues | OBJECT | The total value of all conversions attributed to your ads. |
| uniqueActions | OBJECT | The number of people who took an action that was attributed to your ads. This metric is estimated. |
| costsPerAction | OBJECT | The average cost of a relevant action. |
| costsPerUniqueAction | OBJECT | The average cost of each unique action. 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 comment was made. |
| 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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Demographic metrics, such as age, gender, and location, are only returned if there is data for 100 or more people.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of data.
- Facebook updates most metrics once every 24 hours. Columns referencing to metrics refreshing several times a day hold a hint in their column description. Make use of column importTime to know exactly when a data row has been last modified.
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). |
| intervalStartTime | DATETIME | Holding the full date and time information describing the beginning of the current interval in user timezone. |
| intervalEndTime | DATETIME | Holding the full date and time information describing the end of the current interval in user timezone. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot for this profile and interval using the APIs of the social networks and there was a modification compared to its former state. |
|
page |
INTEGER |
Number of stories created about your Page within the current interval. Additional interval specific columns for this metric exist: page_content_activity_day page_content_activity_week page_content_activity_days_28 |
|
page |
INTEGER |
The number of stories about Page checkins published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_checkin_day page_content_activity_by_action_type_checkin_week page_content_activity_by_action_type_checkin_days_28 |
|
page |
INTEGER |
The number of stories about offer claims published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_coupon_day page_content_activity_by_action_type_coupon_week page_content_activity_by_action_type_coupon_days_28 |
|
page |
INTEGER |
The number of stories about RSVPing to events published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_event_day page_content_activity_by_action_type_event_week page_content_activity_by_action_type_event_days_28 |
|
page |
INTEGER |
The number of stories about Page likes published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_fan_day page_content_activity_by_action_type_fan_week page_content_activity_by_action_type_fan_days_28 |
|
page |
INTEGER |
The number of stories about Page mentions published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_mention_day page_content_activity_by_action_type_mention_week page_content_activity_by_action_type_mention_days_28 |
|
page |
INTEGER |
The number of stories about posts by other Pages published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_page_post_day page_content_activity_by_action_type_page_post_week page_content_activity_by_action_type_page_post_days_28 |
|
page |
INTEGER |
The number of stories about answers to questions published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_question_day page_content_activity_by_action_type_question_week page_content_activity_by_action_type_question_days_28 |
|
page |
INTEGER |
The number of stories about posts by users on the Page's timeline. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_user_post_day page_content_activity_by_action_type_user_post_week page_content_activity_by_action_type_user_post_days_28 |
|
page |
INTEGER |
The number of stories about other story types published about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_other_day page_content_activity_by_action_type_other_week page_content_activity_by_action_type_other_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's Page checkin stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_checkin_day page_content_activity_by_action_type_unique_checkin_week page_content_activity_by_action_type_unique_checkin_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's offer claim stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_coupon_day page_content_activity_by_action_type_unique_coupon_week page_content_activity_by_action_type_unique_coupon_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's RSVPing to event stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_event_day page_content_activity_by_action_type_unique_event_week page_content_activity_by_action_type_unique_event_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's Page like stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_fan_day page_content_activity_by_action_type_unique_fan_week page_content_activity_by_action_type_unique_fan_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's Page mention stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_mention_day page_content_activity_by_action_type_unique_mention_week page_content_activity_by_action_type_unique_mention_days_28 |
|
page |
INTEGER |
The number of people talking about posts by other Pages about the Page. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_page_post_day page_content_activity_by_action_type_unique_page_post_week page_content_activity_by_action_type_unique_page_post_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's answers to question stories. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_question_day page_content_activity_by_action_type_unique_question_week page_content_activity_by_action_type_unique_question_days_28 |
|
page |
INTEGER |
The number of people talking about posts by users on the Page's timeline. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_user_post_day page_content_activity_by_action_type_unique_user_post_week page_content_activity_by_action_type_unique_user_post_days_28 |
|
page |
INTEGER |
The number of people talking about the Page's other story types. Additional interval specific columns for this metric exist: page_content_activity_by_action_type_unique_other_day page_content_activity_by_action_type_unique_other_week page_content_activity_by_action_type_unique_other_days_28 |
|
page |
INTEGER |
The number of times any content from the Page or about the Page entered a person's screen. This includes posts, stories, check-ins, ads, social information from people who interact with the Page and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_day page_impressions_week page_impressions_days_28 |
|
page |
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. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_paid_day page_impressions_paid_week page_impressions_paid_days_28 |
|
page |
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, stories, check-ins, social information from people who interact with the Page and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_organic_day page_impressions_organic_week page_impressions_organic_days_28 |
|
page |
INTEGER |
Total impressions of Page checkin stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_checkin_day page_impressions_by_story_type_checkin_week page_impressions_by_story_type_checkin_days_28 |
|
page |
INTEGER |
Total impressions of offer claim stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_coupon_day page_impressions_by_story_type_coupon_week page_impressions_by_story_type_coupon_days_28 |
|
page |
INTEGER |
Total impressions of RSVPing to event stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_event_day page_impressions_by_story_type_event_week page_impressions_by_story_type_event_days_28 |
|
page |
INTEGER |
Total impressions of Page like stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_fan_day page_impressions_by_story_type_fan_week page_impressions_by_story_type_fan_days_28 |
|
page |
INTEGER |
Total impressions of Page mention stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_mention_day page_impressions_by_story_type_mention_week page_impressions_by_story_type_mention_days_28 |
|
page |
INTEGER |
Total impressions of posts by other Pages published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_page_post_day page_impressions_by_story_type_page_post_week page_impressions_by_story_type_page_post_days_28 |
|
page |
INTEGER |
Total impressions of answers to question stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_question_day page_impressions_by_story_type_question_week page_impressions_by_story_type_question_days_28 |
|
page |
INTEGER |
Total impressions of posts by users on the Page's timeline. Additional interval specific columns for this metric exist: page_impressions_by_story_type_user_post_day page_impressions_by_story_type_user_post_week page_impressions_by_story_type_user_post_days_28 |
|
page |
INTEGER |
Total impressions of other story types published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_other_day page_impressions_by_story_type_other_week page_impressions_by_story_type_other_days_28 |
|
page |
INTEGER |
The number of people who saw Page checkin stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_checkin_day page_impressions_by_story_type_unique_checkin_week page_impressions_by_story_type_unique_checkin_days_28 |
|
page |
INTEGER |
The number of people who saw offer claim stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_coupon_day page_impressions_by_story_type_unique_coupon_week page_impressions_by_story_type_unique_coupon_days_28 |
|
page |
INTEGER |
The number of people who saw RSVPing to event stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_event_day page_impressions_by_story_type_unique_event_week page_impressions_by_story_type_unique_event_days_28 |
|
page |
INTEGER |
The number of people who saw Page like stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_fan_day page_impressions_by_story_type_unique_fan_week page_impressions_by_story_type_unique_fan_days_28 |
|
page |
INTEGER |
The number of people who saw Page mention stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_mention_day page_impressions_by_story_type_unique_mention_week page_impressions_by_story_type_unique_mention_days_28 |
|
page |
INTEGER |
The number of people who saw posts by other Pages published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_page_post_day page_impressions_by_story_type_unique_page_post_week page_impressions_by_story_type_unique_page_post_days_28 |
|
page |
INTEGER |
The number of people who saw answers to question stories published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_question_day page_impressions_by_story_type_unique_question_week page_impressions_by_story_type_unique_question_days_28 |
|
page |
INTEGER |
The number of people who saw posts by users on the Page's timeline. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_user_post_day page_impressions_by_story_type_unique_user_post_week page_impressions_by_story_type_unique_user_post_days_28 |
|
page |
INTEGER |
The number of people who saw other story types published about the Page. Additional interval specific columns for this metric exist: page_impressions_by_story_type_unique_other_day page_impressions_by_story_type_unique_other_week page_impressions_by_story_type_unique_other_days_28 |
|
page |
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, stories, check-ins, ads, social information from people who interact with the Page and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_unique_day page_impressions_unique_week page_impressions_unique_days_28 |
|
page |
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. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_paid_unique_day page_impressions_paid_unique_week page_impressions_paid_unique_days_28 |
|
page |
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, stories, check-ins, social information from people who interact with the Page and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_organic_unique_day page_impressions_organic_unique_week page_impressions_organic_unique_days_28 |
|
page |
INTEGER |
The number of people who had any of the Page's posts enter their screen. Posts include statuses, photos, links, videos and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_unique_day page_posts_impressions_unique_week page_posts_impressions_unique_days_28 |
|
page |
INTEGER |
The number of people who had any of the Page's posts enter their screen through paid distribution such as an ad. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_paid_unique_day page_posts_impressions_paid_unique_week page_posts_impressions_paid_unique_days_28 |
|
page |
INTEGER |
The number of times the Page's posts entered a person's screen through unpaid distribution. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_organic_day page_posts_impressions_organic_week page_posts_impressions_organic_days_28 |
|
page |
INTEGER |
The number of people who had any of the Page's posts enter their screen through unpaid distribution. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_organic_unique_day page_posts_impressions_organic_unique_week page_posts_impressions_organic_unique_days_28 |
|
page |
INTEGER |
The number of times people have engaged with the Page's posts through reactions, comments, shares and more. For example, this includes when a person clicks to enlarge an image, or clicks to "read more" text. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_post_engagements_day page_post_engagements_week page_post_engagements_days_28 |
|
page |
INTEGER |
The number of times any content from your Page or about your Page entered a person's screen with social information attached. Social information displays when a person's friend interacted with your Page, post or story. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_viral_day page_impressions_viral_week page_impressions_viral_days_28 |
|
page |
INTEGER |
The number of people who had any content from your Page or about your Page enter their screen through with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with your Page, post or story. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_viral_unique_day page_impressions_viral_unique_week page_impressions_viral_unique_days_28 |
|
page |
INTEGER |
The number of times any content from your Page entered a person's screen. This does not include content created about your Page with social information attached. Social information displays when a person's friend interacted with your Page, post or story. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_nonviral_day page_impressions_nonviral_week page_impressions_nonviral_days_28 |
|
page |
INTEGER |
The number of people who had any content from your Page enter their screen. This does not include content created about your Page with social information attached. As a form of organic distribution, social information displays when a person's friend interacted with your Page, post or story. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_impressions_nonviral_unique_day page_impressions_nonviral_unique_week page_impressions_nonviral_unique_days_28 |
|
page |
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 does not include when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_nonviral_day page_posts_impressions_nonviral_week page_posts_impressions_nonviral_days_28 |
|
page |
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 does not include when someone's friend likes or follows the Page, engages with a post, shares a photo of the Page and checks into the Page. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_nonviral_unique_day page_posts_impressions_nonviral_unique_week page_posts_impressions_nonviral_unique_days_28 |
|
page |
INTEGER |
Number of clicks on the Facebook Page's website link. Additional interval specific columns for this metric exist: page_website_clicks_logged_in_count_day page_website_clicks_logged_in_count_week page_website_clicks_logged_in_count_days_28 |
|
page |
INTEGER |
Number of unique people who logged in to Facebook and clicked the goto website CTA (Click to Action) button Additional interval specific columns for this metric exist: page_website_clicks_logged_in_unique_day page_website_clicks_logged_in_unique_week page_website_clicks_logged_in_unique_days_28 |
|
page |
INTEGER |
Number of people who engaged with the Page. Engagement includes any click or story created. Additional interval specific columns for this metric exist: page_engaged_users_day page_engaged_users_week page_engaged_users_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_consumptions_day page_consumptions_week page_consumptions_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_consumptions_unique_day page_consumptions_unique_week page_consumptions_unique_days_28 |
|
page |
INTEGER |
Number of clicks on links the Page got. This e.g. includes clicks on links in the Page's posts. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_link_clicks_day page_consumptions_by_consumption_type_link_clicks_week page_consumptions_by_consumption_type_link_clicks_days_28 |
|
page |
INTEGER |
Number of other clicks on the Page's content which doesn't include link clicks, photo views or video plays. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_other_clicks_day page_consumptions_by_consumption_type_other_clicks_week page_consumptions_by_consumption_type_other_clicks_days_28 |
|
page |
INTEGER |
Number of clicks on photos the Page got. Clicks on photos always leads to an expanded view of the photo. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_photo_view_day page_consumptions_by_consumption_type_photo_view_week page_consumptions_by_consumption_type_photo_view_days_28 |
|
page |
INTEGER |
Number of clicks on photos the Page got. Clicks on photos always leads to an expanded view of the photo. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_video_play_day page_consumptions_by_consumption_type_video_play_week page_consumptions_by_consumption_type_video_play_days_28 |
|
page |
INTEGER |
Number of people who clicked on the Page's links. This e.g. includes clicks on links in the Page's posts. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_unique_link_clicks_day page_consumptions_by_consumption_type_unique_link_clicks_week page_consumptions_by_consumption_type_unique_link_clicks_days_28 |
|
page |
INTEGER |
Number of people who clicked on the Page's content which doesn't include link clicks, photo views or video plays. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_unique_other_clicks_day page_consumptions_by_consumption_type_unique_other_clicks_week page_consumptions_by_consumption_type_unique_other_clicks_days_28 |
|
page |
INTEGER |
Number of people who clicked on the Page's photos. Clicks on photos always leads to an expanded view of the photo. Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_unique_photo_view_day page_consumptions_by_consumption_type_unique_photo_view_week page_consumptions_by_consumption_type_unique_photo_view_days_28 |
|
page |
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 Additional interval specific columns for this metric exist: page_consumptions_by_consumption_type_unique_video_play_day page_consumptions_by_consumption_type_unique_video_play_week page_consumptions_by_consumption_type_unique_video_play_days_28 |
|
page |
INTEGER |
Number of check-ins at the Page's Place. Only available if checkin functionality is enabled for the Facebook Page. Additional interval specific columns for this metric exist: page_places_checkin_total_day page_places_checkin_total_week page_places_checkin_total_days_28 |
|
page |
INTEGER |
Number of people who checked in at the Page's Place. Only available if checkin functionality is enabled for the Facebook Page. Additional interval specific columns for this metric exist: page_places_checkin_total_unique_day page_places_checkin_total_unique_week page_places_checkin_total_unique_days_28 |
|
page |
INTEGER |
Number of check-ins at the Page's Place using mobile devices. Only available if checkin functionality is enabled for the Facebook Page. Additional interval specific columns for this metric exist: page_places_checkin_mobile_day page_places_checkin_mobile_week page_places_checkin_mobile_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_places_checkin_mobile_unique_day page_places_checkin_mobile_unique_week page_places_checkin_mobile_unique_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_negative_feedback_day page_negative_feedback_week page_negative_feedback_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_negative_feedback_unique_day page_negative_feedback_unique_week page_negative_feedback_unique_days_28 |
|
page |
INTEGER |
Number of times people have hidden one of the Page's posts or sponsored posts by clicking on 'Hide post' or 'Hide ad'. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_hide_clicks_day page_negative_feedback_by_type_hide_clicks_week page_negative_feedback_by_type_hide_clicks_days_28 |
|
page |
INTEGER |
Number of times people have clicked on 'Hide all' on one of the Page's posts or sponsored posts. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_hide_all_clicks_day page_negative_feedback_by_type_hide_all_clicks_week page_negative_feedback_by_type_hide_all_clicks_days_28 |
|
page |
INTEGER |
Number of times people have unliked the Page. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_unlike_page_clicks_day page_negative_feedback_by_type_unlike_page_clicks_week page_negative_feedback_by_type_unlike_page_clicks_days_28 |
|
page |
INTEGER |
Number of times people have reported one of the Page's posts as spam. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_report_spam_clicks_day page_negative_feedback_by_type_report_spam_clicks_week page_negative_feedback_by_type_report_spam_clicks_days_28 |
|
page |
INTEGER |
Number of people who have hidden one of the Page's posts or sponsored posts on 'Hide post' or 'Hide ad'. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_unique_hide_clicks_day page_negative_feedback_by_type_unique_hide_clicks_week page_negative_feedback_by_type_unique_hide_clicks_days_28 |
|
page |
INTEGER |
Number of people who have clicked on 'Hide all' on one of the Page's posts or sponsored posts. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_unique_hide_all_clicks_day page_negative_feedback_by_type_unique_hide_all_clicks_week page_negative_feedback_by_type_unique_hide_all_clicks_days_28 |
|
page |
INTEGER |
Number of people who have unliked the Page. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_unique_unlike_page_clicks_day page_negative_feedback_by_type_unique_unlike_page_clicks_week page_negative_feedback_by_type_unique_unlike_page_clicks_days_28 |
|
page |
INTEGER |
Number of people who have reported one of the Page's posts as spam. Additional interval specific columns for this metric exist: page_negative_feedback_by_type_unique_report_spam_clicks_day page_negative_feedback_by_type_unique_report_spam_clicks_week page_negative_feedback_by_type_unique_report_spam_clicks_days_28 |
|
page |
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.) Additional interval specific columns for this metric exist: page_positive_feedback_by_type_like_day page_positive_feedback_by_type_like_week page_positive_feedback_by_type_like_days_28 |
|
page |
INTEGER |
Number of times people have commented on one of the Page's stories. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_comment_day page_positive_feedback_by_type_comment_week page_positive_feedback_by_type_comment_days_28 |
|
page |
INTEGER |
Number of times people have shared one of the Page's stories. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_link_day page_positive_feedback_by_type_link_week page_positive_feedback_by_type_link_days_28 |
|
page |
INTEGER |
Number of times people have responded to one of the Page's events. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_rsvp_day page_positive_feedback_by_type_rsvp_week page_positive_feedback_by_type_rsvp_days_28 |
|
page |
INTEGER |
Number of times people have claimed one of the Page's offers. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_claim_day page_positive_feedback_by_type_claim_week page_positive_feedback_by_type_claim_days_28 |
|
page |
INTEGER |
Number of times people have answered one of the Page's questions. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_answer_day page_positive_feedback_by_type_answer_week page_positive_feedback_by_type_answer_days_28 |
|
page |
INTEGER |
Number of times people have given other types of positive feedback, such as checkins. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_other_day page_positive_feedback_by_type_other_week page_positive_feedback_by_type_other_days_28 |
|
page |
INTEGER |
Number of people who have liked one of the Page's stories. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_like_day page_positive_feedback_by_type_unique_like_week page_positive_feedback_by_type_unique_like_days_28 |
|
page |
INTEGER |
Number of people who have commented on one of the Page's stories. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_comment_day page_positive_feedback_by_type_unique_comment_week page_positive_feedback_by_type_unique_comment_days_28 |
|
page |
INTEGER |
Number of people who have shared one of the Page's stories. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_link_day page_positive_feedback_by_type_unique_link_week page_positive_feedback_by_type_unique_link_days_28 |
|
page |
INTEGER |
Number of people who have responded to one of the Page's events. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_rsvp_day page_positive_feedback_by_type_unique_rsvp_week page_positive_feedback_by_type_unique_rsvp_days_28 |
|
page |
INTEGER |
Number of people who have claimed one of the Page's offers. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_claim_day page_positive_feedback_by_type_unique_claim_week page_positive_feedback_by_type_unique_claim_days_28 |
|
page |
INTEGER |
Number of people who have answered one of the Page's questions. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_answer_day page_positive_feedback_by_type_unique_answer_week page_positive_feedback_by_type_unique_answer_days_28 |
|
page |
INTEGER |
Number of people who have given other types of positive feedback, such as checkins. Additional interval specific columns for this metric exist: page_positive_feedback_by_type_unique_other_day page_positive_feedback_by_type_unique_other_week page_positive_feedback_by_type_unique_other_days_28 |
|
page |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
INTEGER | Total number of clicks on the Page's contact info and call-to-action button. |
|
page |
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 |
INTEGER | Total number of Page Likes for this Facebook Page. |
|
page |
INTEGER | Change of the total number of Page Likes for this Facebook Page. |
|
page |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
INTEGER | The number of times a Page's profile has been viewed by logged in and logged out people. |
|
page |
INTEGER | The number of people logged in to Facebook who have viewed the Page profile. |
|
page |
INTEGER | The number of times a Page's profile has been viewed by people logged in to Facebook. |
|
page |
INTEGER | The number of times a Page's profile has been viewed by people not logged in to Facebook. |
|
page |
INTEGER |
The number of times the Page's posts entered a person's screen. Posts include statuses, photos, links, videos and more. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_day page_posts_impressions_week page_posts_impressions_days_28 |
|
page |
INTEGER |
The number of times the Page's posts entered a person's screen through paid distribution such as an ad. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_paid_day page_posts_impressions_paid_week page_posts_impressions_paid_days_28 |
|
page |
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. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_viral_day page_posts_impressions_viral_week page_posts_impressions_viral_days_28 |
|
page |
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. Refreshes several times during the day. Additional interval specific columns for this metric exist: page_posts_impressions_viral_unique_day page_posts_impressions_viral_unique_week page_posts_impressions_viral_unique_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_posts_served_impressions_organic_unique_day page_posts_served_impressions_organic_unique_week page_posts_served_impressions_organic_unique_days_28 |
|
page |
INTEGER |
Number of times the Page's videos have been viewed for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_views_day page_video_views_week page_video_views_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_day page_video_views_10s_week page_video_views_10s_days_28 |
|
page |
INTEGER |
Number of times the Page's videos have been viewed for more than 30 seconds. Additional interval specific columns for this metric exist: page_video_complete_views_30s_day page_video_complete_views_30s_week page_video_complete_views_30s_days_28 |
|
page |
INTEGER |
Total number of times page's videos have been played for unique people for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_views_unique_day page_video_views_unique_week page_video_views_unique_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_unique_day page_video_views_10s_unique_week page_video_views_10s_unique_days_28 |
|
page |
INTEGER |
Total number of times page's videos have been played for unique people to the end, or viewed for more than 30 seconds. Additional interval specific columns for this metric exist: page_video_complete_views_30s_unique_day page_video_complete_views_30s_unique_week page_video_complete_views_30s_unique_days_28 |
|
page |
INTEGER |
Total number of times page's promoted videos have been viewed for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_views_paid_day page_video_views_paid_week page_video_views_paid_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_paid_day page_video_views_10s_paid_week page_video_views_10s_paid_days_28 |
|
page |
INTEGER |
Total number of times page's promoted videos have been viewed to the end, or for more than 30 seconds. Additional interval specific columns for this metric exist: page_video_complete_views_30s_paid_day page_video_complete_views_30s_paid_week page_video_complete_views_30s_paid_days_28 |
|
page |
INTEGER |
Total number of times page's videos have been viewed for more than 3 seconds by organic reach. Additional interval specific columns for this metric exist: page_video_views_organic_day page_video_views_organic_week page_video_views_organic_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_organic_day page_video_views_10s_organic_week page_video_views_10s_organic_days_28 |
|
page |
INTEGER |
Total number of times page's videos have been viewed to the end, or viewed for more than 30 seconds by organic reach. Additional interval specific columns for this metric exist: page_video_complete_views_30s_organic_day page_video_complete_views_30s_organic_week page_video_complete_views_30s_organic_days_28 |
|
page |
INTEGER |
Total number of times page's autoplayed videos have been viewed for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_views_autoplayed_day page_video_views_autoplayed_week page_video_views_autoplayed_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_autoplayed_day page_video_views_10s_autoplayed_week page_video_views_10s_autoplayed_days_28 |
|
page |
INTEGER |
Total number of times page's autoplayed videos have been viewed to the end, or viewed for more than 30 seconds. Additional interval specific columns for this metric exist: page_video_complete_views_30s_autoplayed_day page_video_complete_views_30s_autoplayed_week page_video_complete_views_30s_autoplayed_days_28 |
|
page |
INTEGER |
Total number of times page's videos have been viewed after the user clicks on play for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_views_click_to_play_day page_video_views_click_to_play_week page_video_views_click_to_play_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_click_to_play_day page_video_views_10s_click_to_play_week page_video_views_10s_click_to_play_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_complete_views_30s_click_to_play_day page_video_complete_views_30s_click_to_play_week page_video_complete_views_30s_click_to_play_days_28 |
|
page |
INTEGER |
Total number of times that people replay a page's videos for more than 3 seconds. Additional interval specific columns for this metric exist: page_video_repeat_views_day page_video_repeat_views_week page_video_repeat_views_days_28 |
|
page |
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. Additional interval specific columns for this metric exist: page_video_views_10s_repeat_day page_video_views_10s_repeat_week page_video_views_10s_repeat_days_28 |
|
page |
INTEGER |
Total number of times that people replay a page's videos to the end, or for more than 30 seconds. Additional interval specific columns for this metric exist: page_video_complete_views_30s_repeat_views_day page_video_complete_views_30s_repeat_views_week page_video_complete_views_30s_repeat_views_days_28 |
|
page |
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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Demographic metrics, such as age, gender, and location, are only returned if there is data for 100 or more people.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Demographic metrics, such as age, gender, and location, are only returned if there is data for 100 or more people.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Demographic metrics, such as age, gender, and location, are only returned if there is data for 100 or more people.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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. |
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.
Hints
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| time | DATETIME | The time this conversation started. |
| updatedTime | DATETIME | The time this conversation on Facebook was updated the last time. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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.
Hints
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| time | DATETIME | The time this message was created. |
| conversationStartTime | DATETIME | The time the conversation this message belongs to started. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 published posts of Facebook Pages.
Hints
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of data.
- Facebook updates most metrics once every 24 hours. Columns referencing to metrics refreshing several times a day hold a hint in their column description. Make use of column importTime to know exactly when a post has been last modified.
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 published. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
|
is |
BOOLEAN | This shows if the post is published. |
|
is |
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}, ...]. |
| hashtags | OBJECT | The hashtags used within the post's message. Provided as a list of strings, e.g. ["#hashtag1", "#hashtag2"]. |
| 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. |
| appId | STRING | The id of the third party app which was used to publish the post. Returns NULL if the post wasn't published via a third party app. |
| appName | STRING | The name of the third party app which was used to publish the post. Returns NULL if the post wasn't published via a third party app. |
| likes | INTEGER | Number of "Like" reactions the post got. This does not include reactions 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 does not include comments on shares. |
| shares | INTEGER | Number of shares the post got. This does not 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. |
| attachmentDescription | STRING | The description of the link in this post (appears beneath the attachment's caption). |
| attachmentCaption | STRING | The caption of the link in this post. If this is a 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 |
INTEGER | Number of "Like" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Love" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Wow" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Haha" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Anger" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of people who have liked the Page and clicked anywhere in the post. |
|
post |
INTEGER | Number of times this post entered a person's screen. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen. This is also known as reach. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen through unpaid distribution. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who saw the Page post in news feed or ticker, or on the Page's timeline. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen through paid distribution such as an ad. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen through paid distribution such as an ad. This is also known as paid reach. Refreshes several times during the day. |
|
post |
INTEGER | Number of impressions for this post by people who have liked your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who like your Page and who saw this post. Refreshes several times during the day. |
|
post |
INTEGER | Number of impressions for this post by people who like your Page in an Ad or Sponsored Story. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who like your Page and saw this post in an Ad or Sponsored Story. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen with social information attached. Social information displays when a person's friend interacted with your Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen. This does not include content created about your 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen. This does not include content created about your 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people clicked on anywhere in this post without generating a story. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked anywhere in your post without generating a story. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on links in the post. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on photo attachments in the post which led to an expanded view of the photo. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on video attachments in the post which started the video. Refreshes several times during the day. |
|
post |
INTEGER | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on links in the post. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on video attachments in the post which started the video. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. Refreshes several times during the day. |
|
post |
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. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide post'. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide All'. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by unliking the page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by clicking on 'Hide post'. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by clicking on 'Hide All'. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by unliking the page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of post stories generated about this post. Post stories are created when a user engages with a post. For example a post story "User commented..." is created when a user comments a post. Facebook does not provide an exact definition of what engagement types create post stories, which is why we recommend using more specific engagement metrics instead, e.g. post_activity_by_action_type_like. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who created post stories about this post. Post stories are created when a user engages with a post. For example a post story "User commented..." is created when a user comments a post. Facebook does not provide an exact definition of what engagement types create post stories, which is why we recommend using more specific engagement metrics instead, e.g. post_activity_by_action_type_unique_like. Refreshes several times during the day. |
|
post |
INTEGER | Number of reactions the post got (Like, Love, Wow, Haha, Sorry, Angry and Thankful). This also includes reactions on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of comments the post got. This also includes comments on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of shares the post got. This also includes shares on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who reacted to this post (Like, Love, Wow, Haha, Sorry, Angry and Thankful). This also includes reactions on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who commented this post. This also includes comments on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who shared this post. This also includes shares on shares. Refreshes several times during the day. |
|
post |
INTEGER | The average time, in milliseconds, people viewed this video. Only available for videos created after August 25th 2016. Returns 0 for reshared videos. |
|
post |
INTEGER | The total time, in milliseconds, this video played, including videos played for less than 3 seconds and replays. Returns 0 for reshared videos. |
|
post |
INTEGER | The total time, in milliseconds, this video played by organic reach. Returns 0 for reshared videos. |
|
post |
INTEGER | Length of a video post (in milliseconds). |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds without any paid promotion. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds without any paid promotion. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds after paid promotion. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds after paid promotion. |
|
post |
INTEGER | Number of times people clicked to play this video and viewed it more than 3 seconds. |
|
post |
INTEGER | Number of times this video started automatically playing and people viewed it for more than 3 seconds. |
|
post |
INTEGER | Number of times this video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of people who viewed this video for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. |
|
post |
INTEGER | Number of times people clicked to play this video and viewed it for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds in the original post. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds in a shared post. |
|
post |
INTEGER | Number of times this video was viewed for 30 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of people who viewed this video for 30 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this promoted video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video automatically played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of people who viewed this video from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this promoted video played from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of people who viewed this promoted video from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
facebookInsightsExpiredPosts
Summary
Holding information about expired video posts of Facebook Pages.
Hints
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of data.
- Facebook updates most metrics once every 24 hours. Columns referencing to metrics refreshing several times a day hold a hint in their column description. Make use of column importTime to know exactly when a post has been last modified.
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 published. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 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}, ...]. |
| hashtags | OBJECT | The hashtags used within the post's message. Provided as a list of strings, e.g. ["#hashtag1", "#hashtag2"]. |
| externalId | STRING | The unique id of the post. |
| appId | STRING | The id of the third party app which was used to publish the post. Returns NULL if the post wasn't published via a third party app. |
| appName | STRING | The name of the third party app which was used to publish the post. Returns NULL if the post wasn't published via a third party app. |
| likes | INTEGER | Number of "Like" reactions the post got. This does not include reactions 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 does not include comments on shares. |
| shares | INTEGER | Number of shares the post got. This does not 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. |
| attachmentDescription | STRING | The description of the link in this post (appears beneath the attachment's caption). |
| attachmentCaption | STRING | The caption of the link in this post. If this is a 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 |
INTEGER | Number of "Like" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Love" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Wow" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Haha" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Sorry" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of "Anger" reactions the post got. This also includes reactions on shares. |
|
post |
INTEGER | Number of people who have liked the Page and clicked anywhere in the post. |
|
post |
INTEGER | Number of times this post entered a person's screen. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen. This is also known as reach. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen through unpaid distribution. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who saw the Page post in news feed or ticker, or on the Page's timeline. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen. This does not include content created about your 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen. This does not include content created about your 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen through paid distribution such as an ad. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post enter their screen through paid distribution such as an ad. This is also known as paid reach. Refreshes several times during the day. |
|
post |
INTEGER | Number of impressions for this post by people who have liked your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who like your Page and who saw this post. Refreshes several times during the day. |
|
post |
INTEGER | Number of impressions for this post by people who like your Page in an Ad or Sponsored Story. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who like your Page and saw this post in an Ad or Sponsored Story. Refreshes several times during the day. |
|
post |
INTEGER | Number of times this post entered a person's screen with social information attached. Social information displays when a person's friend interacted with your Page or post. This includes when someone's friend likes or follows your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who had this post 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 your Page, engages with a post, shares a photo of your Page and checks into your Page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people clicked on anywhere in this post without generating a story. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked anywhere in your post without generating a story. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on links in the post. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on photo attachments in the post which led to an expanded view of the photo. Refreshes several times during the day. |
|
post |
INTEGER | Number of clicks on video attachments in the post which started the video. Refreshes several times during the day. |
|
post |
INTEGER | Number of other clicks on the post which doesn't include link clicks, photo views or video plays. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on links in the post. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on photo attachments in the post which led to an expanded view of the photo. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on video attachments in the post which started the video. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who clicked on the post which doesn't include link clicks, photo views or video plays. Refreshes several times during the day. |
|
post |
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. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post. This includes clicks on 'Hide post' or reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide post'. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by clicking on 'Hide All'. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by unliking the page. Refreshes several times during the day. |
|
post |
INTEGER | Number of times people have given negative feedback to the post by reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by clicking on 'Hide post'. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by clicking on 'Hide All'. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by unliking the page. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who have given negative feedback to the post by reporting the post as spam. Refreshes several times during the day. |
|
post |
INTEGER | Number of post stories generated about this post. Post stories are created when a user engages with a post. For example a post story "User commented..." is created when a user comments a post. Facebook does not provide an exact definition of what engagement types create post stories, which is why we recommend using more specific engagement metrics instead, e.g. post_activity_by_action_type_like. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who created post stories about this post. Post stories are created when a user engages with a post. For example a post story "User commented..." is created when a user comments a post. Facebook does not provide an exact definition of what engagement types create post stories, which is why we recommend using more specific engagement metrics instead, e.g. post_activity_by_action_type_unique_like. Refreshes several times during the day. |
|
post |
INTEGER | Number of reactions the post got (Like, Love, Wow, Haha, Sorry, Angry and Thankful). This also includes reactions on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of comments the post got. This also includes comments on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of shares the post got. This also includes shares on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who reacted to this post (Like, Love, Wow, Haha, Sorry, Angry and Thankful). This also includes reactions on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who commented this post. This also includes comments on shares. Refreshes several times during the day. |
|
post |
INTEGER | Number of people who shared this post. This also includes shares on shares. Refreshes several times during the day. |
|
post |
INTEGER | The average time, in milliseconds, people viewed this video. Only available for videos created after August 25th 2016. Returns 0 for reshared videos. |
|
post |
INTEGER | The total time, in milliseconds, this video played, including videos played for less than 3 seconds and replays. Returns 0 for reshared videos. |
|
post |
INTEGER | The total time, in milliseconds, this video played by organic reach. Returns 0 for reshared videos. |
|
post |
INTEGER | Length of a video post (in milliseconds). |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds without any paid promotion. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds without any paid promotion. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds after paid promotion. |
|
post |
INTEGER | Number of people who viewed this video for more than 3 seconds after paid promotion. |
|
post |
INTEGER | Number of times people clicked to play this video and viewed it more than 3 seconds. |
|
post |
INTEGER | Number of times this video started automatically playing and people viewed it for more than 3 seconds. |
|
post |
INTEGER | Number of times this video sound was turned on and was viewed for 3 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of people who viewed this video for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. |
|
post |
INTEGER | Number of times this video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. |
|
post |
INTEGER | Number of times people clicked to play this video and viewed it for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video started automatically playing and people viewed it for 10 seconds or to the end, whichever came first. |
|
post |
INTEGER | Number of times this video sound was turned on and was viewed for 10 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds in the original post. |
|
post |
INTEGER | Number of times this video was viewed for more than 3 seconds in a shared post. |
|
post |
INTEGER | Number of times this video was viewed for 30 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of people who viewed this video for 30 seconds or viewed to the end, whichever came first. |
|
post |
INTEGER | Number of times this promoted video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds, after people clicked play. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video automatically played for at least 30 seconds, or for nearly their total length if they're shorter than 30 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this video played from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of people who viewed this video from the beginning to 95%, or more, of its length, by organic reach. During a single instance of a video playing, we'll exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of times this promoted video played from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. Returns 0 for reshared videos. |
|
post |
INTEGER | Number of people who viewed this promoted video from the beginning to 95%, or more, of its length. For each impression of a video, we'll count video views separately and exclude any time spent replaying the video. |
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. This is similar to data source facebookInsightsOwnPosts, but showing video posts only while offering more specific video metrics.
Hints
- This data source returns video posts, multiple posts potentially using the same video. Be aware that while there is one entry per post, video metrics belong to the video, not the post. Thus multiple posts using the same video will show the exact same numbers.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| time | DATETIME | The time this video was created. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 |
BOOLEAN | If a post about the video is published. Holds "1" if a post is published, "" if not. |
|
live |
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 |
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. |
| 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 | The link to the raw video file. The source field will not be returned for videos unless the user making the request is an admin of the owning Page. Be aware that the link to the source of this video changes over time by design and thus might not work if the video was not updated recently. Please use the importTime column to know when the snapshot of this video post was last updated. |
| picture | LINK | The URL to the attachment preview picture. Holds "null" if no attachment preview picture is available. |
|
total |
INTEGER | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first. |
|
total |
INTEGER | Number of unique people who viewed the video for 3 seconds or viewed to the end, whichever came first. |
|
total |
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 |
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 |
INTEGER | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. |
|
total |
INTEGER | Number unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, without any paid promotion. |
|
total |
INTEGER | Number of times the video was viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. |
|
total |
INTEGER | Number of unique viewers who viewed for 3 seconds or viewed to the end, whichever came first, after paid promotion. |
|
total |
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 |
INTEGER | Number of times the video was viewed in a shared post. |
|
total |
INTEGER | Number of times the video was viewed in a post that was page owned. |
|
total |
INTEGER | Number of times the video was viewed in a crossposted post. |
|
total |
INTEGER | Total time (in milliseconds) video has been viewed in a shared post. |
|
total |
INTEGER | Total time (in milliseconds) video has been viewed in a post that was page owned. |
|
total |
INTEGER | Total time (in milliseconds) video has been viewed in a crossposted post. |
|
total |
INTEGER | Number of times the video was watched at 95% of its length, including watches that skipped to this point. |
|
total |
INTEGER | Number of unique people who watched the video at 95% of its length or more, including people that skipped to this point. |
|
total |
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 |
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 |
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 |
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 |
INTEGER | Number of times the video was watched at 95% of its length after paid promotion, including watches that skipped to this point. |
|
total |
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 |
INTEGER | Total times video has been viewed greater than 60-second grouped by they were monetizable. |
|
total |
INTEGER | Total times video has been viewed greater than 60-second grouped by they were not monetizable. |
|
total |
INTEGER | Total number of times your video was viewed for 15 minutes only if the video is 15 minutes or longer. |
|
total |
INTEGER | Number of unique people who viewed your video for 15 minutes only if the video is 15 minutes or longer. |
|
total |
INTEGER | Number of times the video was viewed for 30 seconds or 97% of the video if video is less than 30 seconds. |
|
total |
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 |
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 |
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 |
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 |
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 |
INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first. |
|
total |
INTEGER | Number of unique people who viewed the video for 10 seconds or viewed to the end, whichever came first. |
|
total |
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 |
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 |
INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, without a paid promotion. |
|
total |
INTEGER | Number of times the video was viewed for 10 seconds or viewed to the end, whichever came first, after a paid promotion. |
|
total |
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 |
INTEGER | The average length of time (in milliseconds) people spent viewing the video. |
|
total |
INTEGER | The total time (in ms) the video has been viewed. |
|
total |
INTEGER | The total time (in ms) the video has been viewed in news feed or ticker or on the Page's timeline. |
|
total |
INTEGER | The total time (in ms) the video has been viewed after paid promotion. |
|
total |
INTEGER | Number of impressions of the video. |
|
total |
INTEGER | Number of people the video was served to. |
|
total |
INTEGER | Number of people the advertised Page Video was served to. |
|
total |
INTEGER | Number of impressions of the Page Video in an Ad or Sponsored Story. |
|
total |
INTEGER | Number of people who saw the Page Video in news feed or ticker, or on the Page's timeline. |
|
total |
INTEGER | Number of impressions of the Video in news feed or ticker or on the Page's timeline. |
|
total |
INTEGER | Number of people who saw the Page Video in a story from a friend. |
|
total |
INTEGER | Number of impressions of the Page Video in a story generated by a friend. |
|
total |
INTEGER | Number of people who saw the Page video because they've liked the Page. |
|
total |
INTEGER | Number of impressions of the Page Video to people who have liked the Page. |
|
total |
INTEGER | Number of people who like the Page and who saw the Page Video in an ad or sponsored story. |
|
total |
INTEGER | Number of paid impressions of the Page Video to people who have liked the Page. |
|
total |
DECIMAL | The ratio of unique video views to total unique impressions. |
|
total |
INTEGER | Number of stories created about the Page Video by liking the post. |
|
total |
INTEGER | Number of stories created about the Page Video by commenting on the post. |
|
total |
INTEGER | Number of stories created about the Page Video by sharing the post. |
|
total |
INTEGER | Number of "Like" reactions the video got. This also includes reactions on shares. |
|
total |
INTEGER | Number of "Love" reactions the video got. This also includes reactions on shares. |
|
total |
INTEGER | Number of "Wow" reactions the video got. This also includes reactions on shares. |
|
total |
INTEGER | Number of "Haha" reactions the video got. This also includes reactions on shares. |
|
total |
INTEGER | Number of "Sorry" reactions the video got. This also includes reactions on shares. |
|
total |
INTEGER | Number of "Anger" reactions the video got. This also includes reactions on shares. |
|
total |
OBJECT | Lifetime Video View Time (in ms) by Age Bucket and Gender. Provided as an array of objects, each one having id, name and totalVideoViewTimeInMilliseconds properties. The id is a gender and age combination in format "<gender>-<ageRange>". <gender> one of "female", "male" or "unknown". <ageRange> one of "13-17", "18-24", "25-34", "35-44", "45-54", "55-64" or "65+". E.g. [{"id": "female-13-17", "name": "Female 13-17", "totalVideoViewTimeInMilliseconds": 1200}, ...]. |
|
total |
OBJECT | Lifetime Video View Time (in ms) of the top 45 cities. Provided as an array of objects, each one having id, name and totalVideoViewTimeInMilliseconds properties. E.g. [{"id": "Munich, Bayern", "name": "Munich, Bayern", "totalVideoViewTimeInMilliseconds": 400}, ...]. |
|
total |
OBJECT | Lifetime Video View Time (in ms) of the top 45 country. Provided as an array of objects, each one having id, name and totalVideoViewTimeInMilliseconds properties. E.g. [{"id": "DE", "name": "Germany", "totalVideoViewTimeInMilliseconds": 400}, ...]. |
|
total |
OBJECT | Lifetime Percentage of views at each interval (Video). Videos are divided into 40 equal intervals but each interval has a minimum length of 1 second. For example if a video is 30 seconds long the graph contains 30 intervals. Provided as an array of objects, each one having id, name and percentageOfAllViews properties. E.g. [{"id": 0, "name": "0. interval", "percentageOfAllViews": 25.21}, ...]. |
|
total |
OBJECT | Lifetime Percentage of auto-played views at each interval (Video). Videos are divided into 40 equal intervals but each interval has a minimum length of 1 second. For example if a video is 30 seconds long the graph contains 30 intervals. Provided as an array of objects, each one having id, name and percentageOfAllViews properties. E.g. [{"id": 0, "name": "0. interval", "percentageOfAllViews": 25.21}, ...]. |
|
total |
OBJECT | Lifetime Percentage of views clicked-to-play at each interval (Video). Videos are divided into 40 equal intervals but each interval has a minimum length of 1 second. For example if a video is 30 seconds long the graph contains 30 intervals. Provided as an array of objects, each one having id, name and percentageOfAllViews properties. E.g. [{"id": 0, "name": "0. interval", "percentageOfAllViews": 25.21}, ...]. |
|
total |
OBJECT | Views of your video by male viewers at each interval as a percentage of all male views. This metric doesn't count views of videos while they were live. Retention graphs may show more viewers later in the video than at the beginning. People might start the video in the middle, skip ahead, save and rewatch it from that point, or other similar behaviors. (video asset) (Total Count). E.g. [{"id": 0, "name": "0. interval", "percentageOfAllViews": 25.21}, ...]. |
|
total |
OBJECT | Views of your video by female viewers at each interval as a percentage of all female views. This metric doesn't count views of videos while they were live. Retention graphs may show more viewers later in the video than at the beginning. People might start the video in the middle, skip ahead, save and rewatch it from that point, or other similar behaviors. (video asset) (Total Count). E.g. [{"id": 0, "name": "0. interval", "percentageOfAllViews": 25.21}, ...]. |
facebookInsightsPageFansOnline
Summary
Holding the number of Fans (People liking a Facebook Page) online over time, broken down by hour.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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)
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Facebook.
- The monthly interval shows 28 day values as provided by Facebook representing the last 28 days of each month.
- Facebook provides access to Insights data for the past two years. Thus initial imports will cover up to two years of 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. |
| 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. |
facebookOwnPosts
Summary
Holding public information about posts of Facebook Pages.
Hints
- Facebook provides access to approximately 600 of the best ranked posts per year per Facebook Page. Thus initial imports will cover up to 600 ranked posts per year. For the same reason metrics of posts cannot be updated if they have moved out of the 600 ranked posts per year window.
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 published. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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. |
| 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. Please note this data source is a subset of facebookUserPosts, 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 published. |
| 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.
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 published. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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. |
| 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. |
Summary
Holding public data for Instagram Profiles and their development over time. All numbers are aggregates across the whole Instagram Profile.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Except for followers and following metrics this data source calculates account-wide metrics by aggregating the results of all the posts (data source instagramOwnPosts) created in each interval. This also means that days, weeks or months without any posts created show 0 for all engagement metrics. This is to be differentiated from Instagram Insights data (data source instagramInsights) where the actual interaction time is considered for reporting, independent of when content has been created or published.
- The performance of IGTV videos 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 | Holding the full date and time information describing the current interval (e.g. daily, weekly, monthly). |
| followers | INTEGER | Number of followers at the end of the current interval. |
| followersBefore | INTEGER | Number of followers at the beginning of the current interval. |
| followersChange | INTEGER | Change of the number of followers from the beginning to the end of the current interval. |
| following | INTEGER | Number of Instagram accounts this profile is following at the end of the current interval. |
| followingBefore | INTEGER | Number of Instagram accounts this profile is following at the beginning of the current interval. |
| followingChange | INTEGER | Change of the number of Instagram accounts this profile is following from the beginning to the end of the current interval. |
| posts | INTEGER | Number of posts created since the creation of this account at the end of the current interval. |
| postsBefore | INTEGER | Number of posts created since the creation of this account at the beginning of the current interval. |
| postsChange | INTEGER | Change of the number of posts created since the creation of this account from the beginning to the end of the current interval. This can be considered the number of new posts ignoring deletions. |
| images | INTEGER | Number of new image posts created. |
| imagesLikes | INTEGER | Number of likes on image posts. |
| imagesComments | INTEGER | Number of comments on image posts. |
| videos | INTEGER | Number of new video posts created. |
| videosLikes | INTEGER | Number of likes on video posts. |
| videosComments | INTEGER | Number of comments on video posts. |
| carousels | INTEGER | Number of new carousel posts created. |
| carouselsLikes | INTEGER | Number of likes on carousel posts. |
| carouselsComments | INTEGER | Number of comments on carousel posts. |
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.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Daily, weekly and monthly intervals are aggregated in PST timezone as provided by Instagram's API. Please note that the Instagram Creator Studio shows data in user time zone which is why numbers shown in quintly and Creator Studio can differ.
- The monthly interval shows 28 day values as provided by Instagram representing the last 28 days of each month.
- The online followers metric is usually available with a delay of 2 to 3 days and initially we can only import online followers for the last 30 days.
- Instagram does not provide historic access to audience metrics (cities, countries, gender and age, locales) which is why we can only show those metrics for days when you had an intact Insights connection set up. You will never receive data before we have introduced the audience columns at Jan 20th 2020.
- Insights data is not available for accounts that have fewer than 100 followers.
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) in user timezone. |
| intervalStartTime | DATETIME | Holding the full date and time information describing the beginning of the current interval in user timezone. |
| intervalEndTime | DATETIME | Holding the full date and time information describing the end of the current interval in user timezone. |
| importTime | DATETIME | The last time quintly fetched a fresh snapshot for this profile and interval using the APIs of the social networks and there was a modification compared to its former state. |
| impressions | INTEGER |
Total number of times the Instagram account's content (i.e. posts, stories and promotions) has been viewed. Includes ad activity generated through the API, Facebook ads interfaces, and the Promote feature. Additional interval specific columns for this metric exist: impressionsDay impressionsWeek impressionsDays28 |
| reach | INTEGER |
Total number of times the Instagram account's content (i.e. posts, stories and promotions) has been uniquely viewed. Includes ad activity generated through the API, Facebook ads interfaces, and the Promote feature. Additional interval specific columns for this metric exist: reachDay reachWeek reachDays28 |
| followerCountDay | INTEGER | Number of new followers each day. This metric is only available when using daily interval. |
| emailContactsDay | INTEGER | Number of taps on the email link in the Instagram account's profile in the selected time range. This metric is only available when using daily interval. |
| phoneCallClicksDay | INTEGER | Number of taps on the call link in the Instagram account's profile in the selected time range. This metric is only available when using daily interval. |
| textMessageClicksDay | INTEGER | Number of taps on the text message link in the Instagram account's profile in the selected time range. This metric is only available when using daily interval. |
| getDirectionsClicksDay | INTEGER | Number of taps on the directions link in the Instagram account's profile in the selected time range. This metric is only available when using daily interval. |
| websiteClicksDay | INTEGER | Number of taps on the website link in the Instagram account's profile in the selected time range. This metric is only available when using daily interval. |
| profileViewsDay | INTEGER | Number of users who have viewed the account's profile in the selected time range. Unlike impressions or reach this holds only the views of the profile page and does not include any other contexts (e.g. posts on the feed). This metric is only available when using daily interval. |
| audienceCities | OBJECT | The top 45 cities of the account's followers. Provided as an array of objects, each one having id, name and followers properties. E.g. [{"id": "Munich, Bayern", "name": "Munich, Bayern", "followers": 4}, ...]. |
| audienceCountries | OBJECT | The top 45 countries of the account's followers. Provided as an array of objects, each one having id, name and followers properties. The id is a ISO 3166-1 alpha-2 country code. E.g. [{"id": "DE", "name": "Germany", "followers": 105}, ...]. |
| audienceGenderAndAge | OBJECT | The gender and age distribution of the account's followers. The sum across all gender and age buckets must not match the total followers count as some users may not set the ages or genders in their profiles. Provided as an array of objects, each one having id, name and followers properties. The id is a gender and age combination in format "<gender>-<ageRange>". <gender> one of "female", "male" or "unknown". <ageRange> one of "13-17", "18-24", "25-34", "35-44", "45-54", "55-64" or "65+". E.g. [{"id": "female-13-17", "name": "Female 13-17", "followers": 39}, ...]. |
| audienceLocales | OBJECT | The locales of the account's followers. Provided as an array of objects, each one having id, name and followers properties. E.g. [{"id": "en_US", "name": "en_US", "followers": 85}, ...]. |
| onlineFollowers | OBJECT | The number of followers who were online during the specified hour of the day. Provided as an array of objects, each one having id, name and followers properties. The id holds the hour of the day. "0" represents the hour from 0 to 1 am, "1" from 1 to 2 am and so forth. The hour is in user timezone and thus can start in the middle of the day as the day relates to the full day aggregated in PST timezone as provided by Facebook. E.g. [{"id": "0", "name": "0-1", "followers": 85}, {"id": "1", "name": "1-2", "followers": 21}, ...]. |
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.
Hints
- IGTV videos are not included.
- Insights metrics including impressions, reach, engagement, saved and video views only report organic interactions; interactions on ads are not included.
- Instagram does not provide data for metrics with values less than 5. In such cases 0 will be returned.
- Insights data is not available for accounts that have fewer than 100 followers.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 | Number of likes the post got including replies, excluding likes on album children and likes on promoted posts created from the media object. |
| comments | INTEGER | Number of comments the post got including replies, excluding comments on album children. |
| link | LINK | The direct link to the post. |
| mediaUrl | LINK | The link to the story's media. Not available for videos that have been flagged for copyright violations. |
| 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 | The number of times this post has been seen. |
| reach | INTEGER | The number of unique Instagram accounts that have seen this post. |
| engagement | INTEGER | Total number of likes and comments on the post. This number is not unique. |
| saved | INTEGER | The number of unique Instagram accounts that have saved this post on Instagram. |
| videoViews | INTEGER | The number of times this video has been seen for at least three seconds. It does not count additional views when the video automatically restarts. If the type of this post is carousel, it will return 0. |
instagramInsightsStories
Summary
Holding private-level information about Instagram stories, including impressions, reach, taps and other metrics.
Hints
- Insights metrics including impressions, reach, exits, replies, taps forward and backward only report organic interactions; interactions on ads are not included.
- Instagram does not provide data for metrics with values less than 5. In such cases 0 will be returned.
- Live video stories are not included.
- Stories created when a user reshares another story are not included.
- Insights data is not available for accounts that have fewer than 100 followers.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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. Not available for videos that have been flagged for copyright violations. |
| thumbnailUrl | LINK | The link to the story's attached media thumbnail. |
| type | ENUM | The type of this story, photo or video. |
| impressions | INTEGER | The number of times this story has been seen. |
| reach | INTEGER | The number of unique Instagram accounts that have seen this story. |
| exits | INTEGER | Number of times someone exited this story. This includes users closing Instagram while viewing the story, users clicking on the X on the top-right corner of the story and users swiping down the media, going back to the main feed. |
| replies | INTEGER | The number of replies to this story. |
| 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.
Hints
- IGTV videos are not included.
- Posts of age-gated professional Instagram accounts are not included.
- Instagram does not provide data for metrics with values less than 5. In such cases 0 will be returned.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| type | ENUM | The type of the post. This can be either Image, Video or Carousel. |
| link | LINK | The link to the post. |
| externalId | STRING | The unique id of the post. |
| message | STRING | The contents of the post message. |
| mediaUrl | LINK | The link to the story's media. Not available for videos that have been flagged for copyright violations. |
| attachmentPreviewPicture | LINK | The link to the post's attached media thumbnail. |
| followers | INTEGER | Number of followers the Instagram account had at the day this post was created. |
| likes | INTEGER | Number of likes the post got including replies, excluding likes on album children and likes on promoted posts created from the media object. |
| comments | INTEGER | Number of comments the post got including replies, excluding comments on album children. |
| interactionRate | PERCENT | Holds the interaction rate of this post defined as likes+comments divided by the follower count at the day this posting was created. |
Summary
Holding public follower counts for LinkedIn Company Pages and their development over time.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
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. |
linkedInAnalyticsOwnPosts
Summary
Holding private information about posts of LinkedIn Company Pages.
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.
- Video views, viewers, time watched and time watched for video views metrics for video posts will not be available after six months.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| 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 | Total number of organic reactions (like, celebrate, love, insightful, curious) the post got. |
| likeReactions | INTEGER | Number of organic like reactions (thumbs up) the post got. |
| celebrateReactions | INTEGER | Number of organic celebrate reactions (clapping) the post got. |
| loveReactions | INTEGER | Number of organic love reactions (heart) the post got. |
| insightfulReactions | INTEGER | Number of organic insightful reactions (bulb) the post got. |
| curiousReactions | INTEGER | Number of organic curious reactions (curious smiley) the post got. |
| firstLevelComments | INTEGER | Number of first level comments the post got. |
| comments | INTEGER | Number of total comments the post got including first level comments and replies. |
| 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. |
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 accessible via the quintly API, however you can still access Twitter data directly in the tool.
Time-series data
This data source returns time-series data representing the development of a set of metrics over time. More specific, time-series data sources return one row per profile per time interval. Each of our data sources supports one or more of the following intervals: daily, weekly, monthly or total. E.g. a request with time period Jan 1st to Jan 10th, daily interval and two profiles selected will return 20 rows. The total interval by definition returns one row per profile holding the numbers for the single "total" interval.
Please note that for weekly and monthly intervals the start and end time of the selected time period will be expanded to cover full intervals. E.g. for monthly interval a time period from 3rd of March to 10th of April will be expanded to March 1st to April 30th to cover full months.
Hints
- Except for followers, following and lifetime Tweet metrics this data source calculates account-wide metrics by aggregating the results of all the Tweets and Mentions (data sources twitterOwnTweets and twitterMentions) created in each interval. This also means that days, weeks or months without any Tweets or Mentions published show 0 for all engagement metrics.
- This data source segments Tweets into Own Tweets, Retweeted Tweets and Replies. Learn more here.
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 profile at the end of the current interval. |
| followersBefore | INTEGER | Number of followers of the profile at the beginning of the current interval. |
| followersChange | INTEGER | Change of followers of the profile between the beginning and the end of the current interval. |
| following | INTEGER | Number of handles the profile is following at the end of the current interval. |
| followingBefore | INTEGER | Number of handles the profile is following at the beginning of the current interval. |
| followingChange | INTEGER | Change of handles the profile is following between the beginning and end of the current interval. |
| tweets | INTEGER | Total number of Tweets created since the creation of this profile at the end of the current interval. This includes Own Tweets, Retweeted Tweets and Replies. |
| tweetsBefore | INTEGER | Total number of Tweets created since the creation of this profile at the beginning of the current interval. This includes Own Tweets, Retweeted Tweets and Replies. |
| tweetsChange | INTEGER | Change of the total number of Tweets created between the beginning and the end of the current interval. This includes Own Tweets, Retweeted Tweets and Replies. |
| ownTweets | INTEGER | Number of Own Tweets created. |
| ownTweetsRetweets | INTEGER | Number of Retweets of Own Tweets. |
| ownTweetsFavs | INTEGER | Number of Likes on Own Tweets. |
| ownTweetsReplies | INTEGER | Number of Replies on Own Tweets. |
| retweetedTweets | INTEGER | Number of Retweeted Tweets created by the handle. |
| replies | INTEGER | Number of Replies created by the handle. |
| repliesFromUsers | INTEGER | Number of Replies towards 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 2 to 8 hours. |
| responseTime8To24h | INTEGER | Number of questions asked that have been answered in 8 to 24 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 Own Tweets of Twitter profiles, excluding Retweeted Tweets and Replies to users. To comply with the terms and conditions of Twitter, this data source is not accessible via the quintly API, however you can still access Twitter data directly in the tool.
Hints
- This data source returns Own Tweets only. Learn more here.
- Twitter provides access to the most recent 3200 Tweets of a Twitter profile. This limit refers to the total set of Tweets, including Own Tweets, Retweeted Tweets and Replies to users. Thus initial imports will cover up to 3200 Tweets into the past. For the same reason metrics of Tweets cannot be updated if they have moved out of the 3200 Tweet window.
- Twitter provides 90 days historic access for private metrics of Tweets including impressions and engagements. Thus while initial imports will cover up to 3200 Tweets, private metrics for those Tweets can only be covered for up to 90 days. For the same reason private metrics of Tweets cannot be updated later than 90 days after their creation.
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 last time quintly fetched a fresh snapshot of this posting using the APIs of the social networks and there was a modification compared to its former state. |
| externalId | STRING | No documentation available yet |
| type | STRING | Type of this Tweet. |
| mediaId | STRING | The ID of the attached media in this Tweet. |
| mediaUrl | LINK | The URL of the attached media in this Tweet. |
| link | LINK | The link to this Tweet. |
| message | STRING | The contents of this Tweet. |
| source | LINK | The name of the source which was used to publish this Tweet. |
| followers | INTEGER | Number of followers the profile had on the day this Tweet was created. |
| interactionRate | PERCENT | Holds the interaction rate of this Tweet defined as Likes+Retweets+Replies divided by the number of Followers the profile had at the day this Tweet was created. Holds "null" if this Tweet is a Retweeted Tweet because it would standardize the interactions of the original Tweet with the number of Followers of the Twitter profile. |
| impressions | INTEGER | Number of times this Tweet has been viewed in an organic context. Impressions generated from Tweets that are seen in a promoted or paid context are not included. |
| engagements | INTEGER | Number of times a user has interacted with this Tweet in any context, organic and paid. |
| engagementRate | PERCENT | Calculated as the ratio of engagements to impressions. Be aware that engagements include engagement from any context while impressions only include those from an organic context. |
| favs | INTEGER | Number of Likes this Tweet got. |
| retweets | INTEGER | Number of Retweets this Tweet got. |
| replies | INTEGER | Number of Replies this Tweet got. |
| quoteTweets | INTEGER | Number of times this Tweet has been Retweeted with a comment (also known as Quote). |
| videoViews | INTEGER | Number of times a video in the given Tweet has been 50% visible for at least two seconds. This does not include video views on gifs. |
twitterAnalyticsOwnReplies
Summary
Holding private-level information about Replies to users of Twitter profiles. To comply with the terms and conditions of Twitter, this data source is not accessible via the quintly API, however you can still access Twitter data directly in the tool.
Hints
- This data source returns Replies to users only. Learn more here. If combined with data source twitterAnalyticsOwnTweets it covers the set of all Tweets published by a Twitter profile.
- Twitter provides access to the most recent 3200 Tweets of a Twitter profile. This limit refers to the total set of Tweets, including Own Tweets, Retweeted Tweets and Replies to users. Thus initial imports will cover up to 3200 Tweets into the past. For the same reason metrics of Tweets cannot be updated if they have moved out of the 3200 Tweet window.
- Twitter provides 90 days historic access for private metrics of Tweets including impressions and engagements. Thus while initial imports will cover up to 3200 Tweets, private metrics for those Tweets can only be covered for up to 90 days. For the same reason private metrics of Tweets cannot be updated later than 90 days after their creation.