Marketo dbt Package
This dbt package transforms data from Fivetran's Marketo connector into analytics-ready tables.
Resources
- Number of materialized models¹: 40
- Connector documentation
- dbt package documentation
What does this dbt package do?
This package enables you to better understand your Marketo email performance and how your leads change over time. It creates enriched models with metrics focused on leads, programs, email templates, and campaigns.
Output schema
Final output tables are generated in the following target schema:
<your_database>.<connector/schema_name>_marketo
Final output tables
By default, this package materializes the following final tables:
| Table | Description |
|---|---|
| marketo__campaigns | Tracks marketing campaign performance with email engagement metrics, lead counts, and campaign outcomes to evaluate campaign effectiveness and ROI. Example Analytics Questions:
|
| marketo__email_sends | Provides detailed email send data including recipient information, email content, delivery status, and engagement metrics to analyze email campaign performance at the send level. Example Analytics Questions:
|
| marketo__email_templates | Analyzes email template performance including usage frequency, open rates, click rates, and engagement metrics to identify top-performing creative and optimize template design. Example Analytics Questions:
|
| marketo__lead_history | Chronicles daily snapshots of lead states over time to track lead progression, analyze attribute changes, and measure lead velocity through the funnel. Columns are specified with the lead_history_columns variable, and the start date is configured by the marketo__first_date variable for dbt Core™ users, is the date of the earliest lead record, and for Fivetran Quickstart Data Model users, is 18 months in the past. Example Analytics Questions:
|
| marketo__leads | Tracks all leads with demographic information, lead scores, acquisition details, program memberships, and activity metrics to manage the sales pipeline and measure lead quality. Example Analytics Questions:
|
| marketo__programs | Summarizes marketing program performance including member counts, engagement metrics, and program costs to evaluate program effectiveness and ROI. Example Analytics Questions:
|
¹ Each Quickstart transformation job run materializes these models if all components of this data model are enabled. This count includes all staging, intermediate, and final models materialized as view, table, or incremental.
Prerequisites
To use this dbt package, you must have the following:
- At least one Fivetran Marketo connection syncing data into your destination.
- A BigQuery, Snowflake, Redshift, PostgreSQL, or Databricks destination.
How do I use the dbt package?
You can either add this dbt package in the Fivetran dashboard or import it into your dbt project:
- To add the package in the Fivetran dashboard, follow our Quickstart guide.
- To add the package to your dbt project, follow the setup instructions in the dbt package's README file to use this package.
How is this package maintained and can I contribute?
Package Maintenance
The Fivetran team maintaining this package only maintains the latest version of the package. We highly recommend you stay consistent with the latest version of the package and refer to the CHANGELOG and release notes for more information on changes across versions.
Contributions
A small team of analytics engineers at Fivetran develops these dbt packages. However, the packages are made better by community contributions.
We highly encourage and welcome contributions to this package. Learn how to contribute to a package in dbt's Contributing to an external dbt package article.