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

Amplitude: Sessions

Last updated 1 year ago

Was this helpful?

Description

  • Each record represents a distinct session with aggregated metrics for that session.

Supported Data Sources

  • Amplitude

Columns

Type
Name
Description

STRING

unique_session_id

Unique key of each session, concatenating user_id and session_id

STRING

user_id

A readable ID specified by you. Amplitude uses a combination of three different methods to identify your users: device IDs, Amplitude ID, and user IDs. The first comes directly from your users' devices, while the second is an ID that Amplitude automatically creates once it has enough information to conclusively identify a unique user. The user ID, however, is something you'd set up. In Amplitude, a user ID is a unique identifier applied to individual users. Using them is optional, but recommended: your product should set a user ID once a user has created an account, logged in, or is otherwise identified in your product. Amplitude can use a user ID to reconcile events across multiple devices under the same user ID. Additionally, a user's event data will be merged on the backend so that all anonymous events prior to the assignment of a user ID will be connected to the correct user. For this reason, you can wait to assign user IDs if that makes sense for your product. Conversely, this is also why you should not set user IDs for anonymous users. Once set, user IDs in Amplitude cannot be changed.Once set, user IDs in Amplitude cannot be changed.

INTEGER

events_per_session

The count of events in a session

DATETIME

session_started_at

The time of the first event in a session

DATETIME

session_ended_at

The time of the last event in a session

DECIMAL

session_length_in_minutes

DATETIME

session_started_at_day

The day the session started

DATETIME

session_ended_at_day

The day the session ended

INTEGER

user_session_number

The number of the session, within a user's lifetime

DATETIME

last_session_ended_at

The time the prior session ended at

DATETIME

last_session_ended_at_day

The day the prior session ended

INTEGER

is_first_user_session

Boolean of whether or not a session is the user's first session

DECIMAL

minutes_in_between_sessions

The minutes in between sessions of a user