Endash: Data Templates
  • Data model templates
    • Ad Reporting: Ad Group Report
    • Ad Reporting: Account Report
    • Ad Reporting: Ad Report
    • Ad Reporting: Campaign Report
    • Ad Reporting: Keyword Report
    • Ad Reporting: Search Report
    • Ad Reporting: Url Report
    • Amazon Ads: Account Report
    • Amazon Ads: Ad Group Report
    • Amazon Ads: Ad Report
    • Amazon Ads: Campaign Report
    • Amazon Ads: Keyword Report
    • Amazon Ads: Portfolio Report
    • Amazon Ads: Search Report
    • Amplitude: Daily Performance
    • Amplitude: Event Enhanced
    • Amplitude: Sessions
    • Amplitude: User Enhanced
    • Apple Search Ads: Ad Group Report
    • Apple Search Ads: Ad Report
    • Apple Search Ads: Campaign Report
    • Apple Search Ads: Keyword Report
    • Apple Search Ads: Organization Report
    • Apple Search Ads: Search Term Report
    • Apple Store: App Version Report
    • Apple Store: Device Report
    • Apple Store: Overview Report
    • Apple Store: Platform Version Report
    • Apple Store: Source Type Report
    • Apple Store: Territory Report
    • Asana: Daily Metrics
    • Asana: Project
    • Asana: Tag
    • Asana: Task
    • Asana: Team
    • Asana: User
    • Facebook Ads: Account Report
    • Facebook Ads: Ad Report
    • Facebook Ads: Campaign Report
    • Facebook Ads: Ad Set Report
    • Facebook Ads: Url Report
    • Facebook Ads: Url Tags
    • Facebook Pages: Pages Report
    • Facebook Pages: Posts Report
    • Github: Daily Metrics
    • Github: Issues
    • Github: Monthly Metrics
    • Github: Pull Requests
    • Github: Quarterly Metrics
    • Github: Weekly Metrics
    • Google Ads: Account Report
    • Google Ads: Ad Group Report
    • Google Ads: Ad Report
    • Google Ads: Campaign Report
    • Google Ads: Keyword Report
    • Google Ads: Url Report
    • Google Play: App Version Report
    • Google Play: Country Report
    • Google Play: Device Report
    • Google Play: Os Version Report
    • Google Play: Overview Report
    • Greenhouse: Application Enhanced
    • Greenhouse: Application History
    • Greenhouse: Interview Enhanced
    • Greenhouse: Interview Scorecard Detail
    • Greenhouse: Job Enhanced
    • Hubspot: Companies
    • Hubspot: Company History
    • Hubspot: Contact History
    • Hubspot: Contact Lists
    • Hubspot: Contacts
    • Hubspot: Deal History
    • Hubspot: Deal Stages
    • Hubspot: Deals
    • Hubspot: Email Campaigns
    • Hubspot: Email Event Bounce
    • Hubspot: Email Event Clicks
    • Hubspot: Email Event Deferred
    • Hubspot: Email Event Delivered
    • Hubspot: Email Event Forward
    • Hubspot: Email Event Dropped
    • Hubspot: Email Event Opens
    • Hubspot: Email Event Print
    • Hubspot: Email Event Sent
    • Hubspot: Email Event Spam Report
    • Hubspot: Email Event Status Change
    • Hubspot: Email Sends
    • Hubspot: Engagement Calls
    • Hubspot: Engagement Emails
    • Hubspot: Engagement Meetings
    • Hubspot: Engagement Tasks
    • Hubspot: Engagement Notes
    • Hubspot: Engagements
    • Instagram Business: Posts
    • Intercom: Admin Metrics
    • Intercom: Company Enhanced
    • Intercom: Company Metrics
    • Intercom: Contact Enhanced
    • Intercom: Conversation Enhanced
    • Intercom: Conversation Metrics
    • Iterable: Campaigns
    • Iterable: List User History
    • Iterable: Events
    • Iterable: User Campaign
    • Iterable: User Unsubscriptions
    • Iterable: Users
    • Jira: Daily Issue Field History
    • Jira: Issue Enhanced
    • Jira: Project Enhanced
    • Jira: User Enhanced
    • Klaviyo: Campaigns
    • Klaviyo: Events
    • Klaviyo: Flows
    • Klaviyo: Person Campaign Flow
    • Klaviyo: Persons
    • Lever: Interview Enhanced
    • Lever: Opportunity Enhanced
    • Lever: Opportunity Stage History
    • Lever: Posting Enhanced
    • Lever: Requisition Enhanced
    • Linkedin Ads: Account Report
    • Linkedin Ads: Campaign Group Report
    • Linkedin Ads: Campaign Report
    • Linkedin Ads: Creative Report
    • Linkedin Ads: Url Report
    • Linkedin Pages: Posts
    • Mailchimp: Automation Activities
    • Mailchimp: Automation Emails
    • Mailchimp: Automations
    • Mailchimp: Campaign Activities
    • Mailchimp: Campaign Recipients
    • Mailchimp: Campaigns
    • Mailchimp: Lists
    • Mailchimp: Members
    • Mailchimp: Segments
    • Marketo: Calendar Spine
    • Marketo: Campaigns
    • Marketo: Change Data Details
    • Marketo: Change Data Pivot
    • Marketo: Email Sends
    • Marketo: Change Data Scd
    • Marketo: Email Templates
    • Marketo: Lead Calendar Spine
    • Marketo: Lead History
    • Marketo: Leads
    • Marketo: Programs
    • Microsoft Ads: Account Report
    • Microsoft Ads: Ad Group Report
    • Microsoft Ads: Ad Report
    • Microsoft Ads: Campaign Report
    • Microsoft Ads: Keyword Report
    • Microsoft Ads: Search Report
    • Microsoft Ads: Url Report
    • Pardot: Campaigns
    • Pardot: Lists
    • Pardot: Opportunities
    • Pardot: Prospects
    • Pendo: Account Daily Metrics
    • Pendo: Account
    • Pendo: Feature Daily Metrics
    • Pendo: Feature Event
    • Pendo: Feature
    • Pendo: Guide Daily Metrics
    • Pendo: Guide Event
    • Pendo: Guide
    • Pendo: Page Daily Metrics
    • Pendo: Page Event
    • Pendo: Page
    • Pendo: Visitor Daily Metrics
    • Pendo: Visitor Feature
    • Pendo: Visitor
    • Pinterest Ads: Ad Group Report
    • Pinterest Ads: Advertiser Report
    • Pinterest Ads: Campaign Report
    • Pinterest Ads: Keyword Report
    • Pinterest Ads: Pin Promotion Report
    • Pinterest Ads: Url Report
    • Qualtrics: Contact
    • Qualtrics: Daily Breakdown
    • Qualtrics: Directory
    • Qualtrics: Distribution
    • Qualtrics: Response
    • Qualtrics: Survey
    • Quickbooks: Ap Ar Enhanced
    • Quickbooks: Cash Flow Statement
    • Quickbooks: Expenses Sales Enhanced
    • Quickbooks: General Ledger By Period
    • Quickbooks: General Ledger
    • Quickbooks: Profit And Loss
    • Recharge: Billing History
    • Recharge: Charge Line Item History
    • Recharge: Customer Daily Rollup
    • Recharge: Customer Details
    • Recharge: Monthly Recurring Revenue
    • Recharge: Subscription Overview
    • Recurly: Account Daily Overview
    • Recurly: Account Overview
    • Recurly: Balance Transactions
    • Recurly: Churn Analysis
    • Recurly: Monthly Recurring Revenue
    • Recurly: Subscription Overview
    • Reddit Ads: Account Report
    • Reddit Ads: Ad Group Report
    • Reddit Ads: Ad Report
    • Reddit Ads: Campaign Report
    • Reddit Ads: Url Report
    • Sage Intacct: Ap Ar Enhanced
    • Sage Intacct: Balance Sheet
    • Sage Intacct: General Ledger
    • Sage Intacct: General Ledger By Period
    • Sage Intacct: Profit And Loss
    • Salesforce: Account Daily History
    • Salesforce: Contact Daily History
    • Salesforce: Contact Enhanced
    • Salesforce: Daily Activity
    • Salesforce: Manager Performance
    • Salesforce: Opportunity Daily History
    • Salesforce: Opportunity Enhanced
    • Salesforce: Opportunity Line Item Enhanced
    • Salesforce: Owner Performance
    • Salesforce: Sales Snapshot
    • Shopify: Customer Cohorts
    • Shopify: Customer Email Cohorts
    • Shopify: Customer Emails
    • Shopify: Customers
    • Shopify: Daily Shop
    • Shopify: Discounts
    • Shopify: Inventory Levels
    • Shopify: Order Lines
    • Shopify: Orders
    • Shopify: Products
    • Shopify: Transactions
    • Snapchat Ads: Account Report
    • Snapchat Ads: Ad Report
    • Snapchat Ads: Ad Squad Report
    • Snapchat Ads: Campaign Report
    • Snapchat Ads: Url Report
    • Social Media Reporting: Rollup Report
    • Stripe: Activity Itemized 2
    • Stripe: Balance Change From Activity Itemized 3
    • Stripe: Balance Transactions
    • Stripe: Customer Overview
    • Stripe: Daily Overview
    • Stripe: Ending Balance Reconciliation Itemized 4
    • Stripe: Invoice Details
    • Stripe: Invoice Line Item Details
    • Stripe: Payout Itemized 3
    • Stripe: Subscription Details
    • Tiktok Ads: Ad Group Report
    • Tiktok Ads: Ad Report
    • Tiktok Ads: Advertiser Report
    • Tiktok Ads: Campaign Report
    • Tiktok Ads: Url Report
    • Twilio: Account Overview
    • Twilio: Message Enhanced
    • Twilio: Number Overview
    • Twitter Ads: Account Report
    • Twitter Ads: Campaign Report
    • Twitter Ads: Keyword Report
    • Twitter Ads: Line Item Report
    • Twitter Ads: Promoted Tweet Report
    • Twitter Ads: Url Report
    • Twitter Organic: Tweets
    • Xero: Balance Sheet Report
    • Xero: General Ledger
    • Xero: Invoice Line Items
    • Xero: Profit And Loss Report
    • Youtube: Age Demographics Pivot
    • Youtube: Demographics Report
    • Youtube: Gender Demographics Pivot
    • Youtube: Video Metadata
    • Youtube: Video Report
    • Zendesk: Sla Policies
    • Zendesk: Ticket Backlog
    • Zendesk: Ticket Enriched
    • Zendesk: Ticket Field History
    • Zendesk: Ticket Metrics
    • Zendesk: Ticket Summary
    • Zuora: Account Daily Overview
    • Zuora: Account Overview
    • Zuora: Billing History
    • Zuora: Line Item History
    • Zuora: Monthly Recurring Revenue
    • Zuora: Subscription Overview
  • 🏡Other guides
    • Endash: Main guide
    • Endash: Export to Google Sheets
    • Endash: Connectors guide
Powered by GitBook
On this page
  • Description
  • Supported Data Sources
  • Columns

Was this helpful?

  1. Data model templates

Facebook Pages: Posts Report

Last updated 1 year ago

Was this helpful?

Description

  • Each record represents the daily performance of a Facebook post.

Supported Data Sources

  • Facebook Pages

Columns

Type
Name
Description

STRING

created_timestamp

The time the post was initially published. For a post about a life event, this is the date and time of the life event.

STRING

post_id

The ID of the post.

STRING

post_message

The status message in the post.

STRING

post_url

The URL of the post.

INTEGER

page_id

The ID of the page that posted the post.

STRING

page_name

The name of the page that posted the post.

STRING

date_day

The date of the metric performance.

INTEGER

clicks

The number of times the post was clicked.

INTEGER

impressions

The number of times the post was shown to users.

INTEGER

video_avg_time_watched

The average amount of time users watched the video.

INTEGER

video_view_time

The total amount of time users watched the video.

INTEGER

video_views

The number of times users watched the video.

INTEGER

video_views_10s

The number of times your Page's videos played for at least 10 seconds, or for nearly their total length if they're shorter than 10 seconds. During a single instance of a video playing, we'll exclude any time spent replaying the video.

INTEGER

video_views_15s

The total number of views on the post longer than 15 seconds

INTEGER

likes

The total amount of reactions with type 'like' on the post

STRING

source_relation

The source of the record, if the unioning functionality is being used.

BOOLEAN

is_most_recent_record

Boolean indicating if the record is the most recent record of the post.