Shopify Holistic Reporting dbt Package
This dbt package transforms data from Fivetran's Shopify Holistic Reporting connector into analytics-ready tables.
Resources
- Number of materialized models¹: 131 (Shopify REST API) / 141 (Shopify GraphQL API)
- Connector documentation
- dbt package documentation
What does this dbt package do?
This package enables you to tie e-commerce revenue to your email and SMS marketing via last-touch attribution, consolidate customers and their activity across platforms, and create rich customer personas based on marketing engagement. It creates enriched models with metrics focused on order attribution, daily customer activity, and enhanced customer profiles.
Wanna see Shopify combined with another connector? Please make create a Feature Request.
Check out our blog post for further discussion on how the package can accelerate your business analysis.
Output schema
Final output tables are generated in the following target schema:
<your_database>.<connector/schema_name>_shopify_holistic_reporting
Final output tables
By default, this package materializes the following final tables:
| Table | Description |
|---|---|
| shopify_holistic_reporting__orders_attribution | Connects Shopify orders to the Klaviyo email campaigns and flows that influenced purchases using a customizable last-touch attribution model (see attribution lookback window options) to measure marketing effectiveness and understand which emails drive revenue for new versus repeat customers. Example Analytics Questions:
|
| shopify_holistic_reporting__daily_customer_metrics | Tracks daily customer engagement with Klaviyo email campaigns alongside their Shopify purchase behavior including revenue, taxes, discounts, and interaction counts to connect marketing touches with revenue outcomes at the customer level. Example Analytics Questions:
|
| shopify_holistic_reporting__customer_enhanced | Unifies customer profiles across Shopify and Klaviyo to provide a complete view of purchase history, lifetime order metrics, and all-time email campaign engagement for every customer based on email address. 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.
Materialized Models
Each Quickstart transformation job run materializes 113 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 Shopify Holistic Reporting connection syncing data into your destination.
- A BigQuery, Snowflake, Redshift, Databricks, or PostgreSQL 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.
The Fivetran team also maintains the upstream Klaviyo and Shopify packages on which the Shopify Holistic Reporting package is built off of. Refer to the Klaviyo and Shopify CHANGELOGs 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.