Data Model Templates

Start from a proven data model, make it yours

Free industry data models, built from our hands-on analytics work and interviews with market experts. Pick your industry, connect your data sources, and adapt a ready model instead of starting from scratch. Get them on GitHub in the OKF format, or import them in one click from the OWOX Data Marts gallery with the Import Model plugin.

16 pages

Data Models

E-CommerceE-CommerceEcommerce12 data marts87 fieldsVlad FlaksRus ObolonskyTraffic, browsing sessions and the product catalogue lead through to orders and repeat purchases, with unified ad spend across major channels tying acquisition cost back to the revenue it drives.Explore Model E-Commerce Subscription StoreE-Commerce Subscription StoreEcommerce15 data marts189 fieldsVlad FlaksRus ObolonskySelling the same catalogue once and on a schedule, this model tracks contracts, charges and lifecycle changes, keeping voluntary churn separate from failed payments and pauses separate from cancellations.Explore Model FinanceFinanceFinance8 data marts66 fieldsVlad FlaksRus ObolonskyFrom acquisition and identity verification through loan origination to repayments and collections, with each borrower's risk tier shaping approval, pricing and eventual write-offs.Explore Model HealthcareHealthcareHealthcare8 data marts56 fieldsVlad FlaksRus ObolonskyPatients move from a booked appointment through the clinical encounter to the insurance claim that pays for it, while daily bed census tracks capacity alongside providers, payers and departments.Explore Model Healthcare Clinic AttributionHealthcare Clinic AttributionHealthcare14 data marts132 fieldsLesley van de MortelVlad FlaksOne clinic's patients followed from an anonymous ad click through enquiries, clinician-qualified consultations and treatment to the copay and insurer payment, on a single identity minted at the first page view.Explore Model Healthcare Clinic NetworkHealthcare Clinic NetworkHealthcare10 data marts150 fieldsVlad FlaksRus ObolonskyOutpatient clinics across the US and Canada tracked from advertising spend through contact-centre enquiries and booked appointments to the revenue clinicians bill, with patient history and value carried across two currencies.Explore Model Marketing LeadgenMarketing LeadgenAgency9 data marts81 fieldsVlad FlaksRus ObolonskyCampaigns anchor a B2B demand-generation business, tying ad spend, web traffic and attribution to leads that move through pipeline stages to a closed deal, with accounts carrying the firmographics ABM depends on.Explore Model MarketplaceMarketplaceEcommerce8 data marts66 fieldsVlad FlaksRus ObolonskyBuyers and sellers meet through listings and search, with every order carrying gross merchandise value, take rate and seller payout, alongside the unmet searches, unsold listings and ratings that show where the match breaks down.Explore Model MeasureCampMeasureCamp11 data marts61 fieldsVlad FlaksPeter O’NeillAn unconference put on by local volunteers in one city on one day, where tickets become attendees, a board of rooms and time slots fills with session cards on the morning, and sponsors pay for the venue.Explore Model Retail ChainRetail ChainRetail10 data marts128 fieldsVlad FlaksRus ObolonskyShoppers move from footfall through priced and discounted sales lines to nightly stock counts, replenishment and shrink, with loyalty accounts carrying recency, frequency and spend for identified customers.Explore Model SaaSSaaSSaaS10 data marts99 fieldsVlad FlaksRus ObolonskyAccounts move from marketing and trials through subscriptions and seat expansion, with usage, support and billing signals deciding who stays, and every plan change captured as an MRR movement.Explore Model SEOSEO18 data marts111 fieldsMax RoslyakovVlad FlaksA site's content, technical health and backlinks meet where a page ranks for a query on a given day, with crawls, indexing, topical authority and knowledge gain explaining the position and the visits it earns.Explore Model TradingTradingFinance8 data marts168 fieldsVlad FlaksRus ObolonskyA click becomes a lead, then a registration, a verified client and a funded account at a forex and CFD brokerage, with lifetime value and withdrawals tracked alongside.Explore Model E-Commerce ExtendedE-Commerce ExtendedEcommerce20 data marts125 fieldsIevgen KrasovytskyiMarketing, Sales, Product and Finance in one model: each context's Data Marts and daily plans, the Data Marts they share, and every join written out, down to the Calendar that sets actuals beside the plan.Explore Model GA4 StandardGA4 Standard10 data marts78 fieldsThe Google Analytics 4 export to BigQuery as ten Data Marts: sessions at the hub, with the events, page views and purchases that join them and the traffic sources, devices, locations and users behind them.Explore Model GA360 StandardGA360 Standard10 data marts71 fieldsThe Google Analytics 360 export to BigQuery as ten Data Marts: sessions at the hub, with the page views, events and purchases that join them and the locations, devices, traffic sources, users, pages and event details behind them.Explore Model