{"repo":"fivetran/dbt_shopify","free":true,"listed":false,"github":"https://github.com/fivetran/dbt_shopify","clone":"git clone https://github.com/fivetran/dbt_shopify.git","description":"Fivetran's Shopify dbt package","language":null,"stars":82,"topics":["dbt","dbt-packages","fivetran","shopify"],"license":"Apache-2.0","category":"ecommerce","readme_excerpt":"Shopify dbt Package This dbt package transforms data from Fivetran's Shopify connector into analytics-ready tables. Resources - Number of materialized models¹: 109 (REST API) / 125 (GraphQL API) - Connector documentation - Shopify connector documentation - Shopify ERD - dbt package documentation - GitHub repository - dbt Docs - DAG - Changelog - dbt Core™ supported versions - =1.3.0, shopify gql customer cohorts Monthly customer behavior tracking by acquisition cohorts, showing retention rates, spending patterns, and lifetime value progression for each customer ID. Example Analytics Questions: • What is the month-over-month retention rate for customers by their first purchase month? • Which customer cohorts have the highest lifetime value progression over their first 12 months? shopify customers or shopify gql customers Complete customer profiles with lifetime spending, order history, abandoned checkouts, and customer tags. Includes CUSTOMER metafields if enabled. Example Analytics Questions: • Who are the top 100 customers by lifetime spending and what are their purchase patterns? • How many customers have abandoned checkouts but never completed a purchase? shopify customer email cohorts or shopify gql customer email cohorts Email-based cohort analysis showing retention and purchasing behavior grouped by email address rather than customer ID, useful for tracking guest checkout behavior. Example Analytics Questions: • How does email-based customer retention compare across dif","default_branch":null,"files":null,"tree":[],"storefront":"/r/fivetran","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/fivetran/dbt_shopify/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}