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

Marketo: Lead History

Last updated 1 year ago

Was this helpful?

Description

  • Each record is what a Marketo lead looked like on each day.

Supported Data Sources

  • Marketo

Columns

Type
Name
Description

DATE

date_day

The date of the lead was observed in this state.

INTEGER

lead_id

ID of the lead.

STRING

lead_history_id

Surrogate key combining date_day and lead_id.