Looker LookML Templates

$39

Production LookML models for common business domains: revenue, marketing, product usage, and customer analytics with derived tables.

📁 31 files

MarkdownPostgreSQLCI/CD

📄 Product Preview

Try the interactive reader and demo tools below, or get the full product with all content unlocked.

📖 Interactive Reader (Free Preview) ⚙ Try Demo Tools 📦 Download Free Sample

📁 File Structure 31 files

looker-lookml-templates/ ├── LICENSE ├── README.md ├── derived_tables/ │ ├── customer_lifetime_value.view.lkml │ ├── daily_revenue_summary.view.lkml │ └── marketing_attribution.view.lkml ├── free-sample.zip ├── guide/ │ ├── deployment-guide.md │ └── naming-conventions.md ├── guides/ │ ├── deployment-guide.md │ └── naming-conventions.md ├── index.html ├── models/ │ ├── customer_analytics.model.lkml │ ├── marketing_analytics.model.lkml │ ├── product_analytics.model.lkml │ └── revenue_analytics.model.lkml ├── refinements/ │ ├── customer_refinements.lkml │ └── revenue_refinements.lkml └── views/ ├── customer/ │ ├── cohort_analysis.view.lkml │ ├── customer_facts.view.lkml │ └── customers.view.lkml ├── marketing/ │ ├── ad_spend.view.lkml │ ├── attribution_touchpoints.view.lkml │ └── campaigns.view.lkml ├── product/ │ ├── events.view.lkml │ ├── feature_usage.view.lkml │ └── sessions.view.lkml ├── revenue/ │ ├── order_items.view.lkml │ ├── orders.view.lkml │ └── subscriptions.view.lkml └── shared/ ├── calendar.view.lkml └── common_dimensions.view.lkml

📖 Documentation Preview README excerpt

Looker LookML Templates

Production-ready LookML project templates for revenue analytics, marketing attribution, product usage tracking, and customer analytics. Drop these into your Looker project and adapt the SQL table references to your schema.

What's Included

4 Complete Analytics Models — Revenue, Marketing, Product, Customer
16+ View Files — Dimensions, measures, derived tables, refinements
Explore Definitions — Pre-configured joins with proper relationship types
Derived Tables (PDTs) — Materialized aggregations for complex calculations
Reusable Refinements — Extend views without modifying originals
Naming Conventions Guide — Standards for a maintainable LookML project
Deployment Guide — Git workflow, CI/CD, and environment management

Directory Structure


looker-lookml-templates/
├── models/
│   ├── revenue_analytics.model.lkml
│   ├── marketing_analytics.model.lkml
│   ├── product_analytics.model.lkml
│   └── customer_analytics.model.lkml
├── views/
│   ├── revenue/
│   │   ├── orders.view.lkml
│   │   ├── order_items.view.lkml
│   │   └── subscriptions.view.lkml
│   ├── marketing/
│   │   ├── campaigns.view.lkml
│   │   ├── ad_spend.view.lkml
│   │   └── attribution_touchpoints.view.lkml
│   ├── product/
│   │   ├── events.view.lkml
│   │   ├── sessions.view.lkml
│   │   └── feature_usage.view.lkml
│   ├── customer/
│   │   ├── customers.view.lkml
│   │   ├── customer_facts.view.lkml
│   │   └── cohort_analysis.view.lkml
│   └── shared/
│       ├── calendar.view.lkml
│       └── common_dimensions.view.lkml
├── explores/
│   └── explores.lkml
├── derived_tables/
│   ├── customer_lifetime_value.view.lkml
│   ├── daily_revenue_summary.view.lkml
│   └── marketing_attribution.view.lkml
├── refinements/
│   ├── revenue_refinements.lkml
│   └── customer_refinements.lkml
└── guides/
    ├── naming-conventions.md
    └── deployment-guide.md

Quick Start

1. Copy the relevant model and view files into your Looker project

... continues with setup instructions, usage examples, and more.

📄 Content Sample guides/deployment-guide.md

LookML Deployment Guide

How to manage, validate, test, and deploy LookML projects in a team environment.

Git Workflow

Looker projects are backed by Git. Follow this branching strategy:


main (production)
├── develop (staging / QA)
│   ├── feature/add-marketing-attribution
│   ├── feature/new-customer-segments
│   └── fix/subscription-churn-calc

Branch Naming

feature/{ticket-id}-short-description
fix/{ticket-id}-what-was-broken
refactor/{area}-{what-changed}

Development Flow

1. Create a branch from main in Looker IDE (Develop → New Branch)

2. Make changes in Development Mode

3. Validate LookML (Develop → Validate LookML) — fix all errors

4. Run Content Validator — checks for broken references in dashboards/looks

5. Test in Dev Mode — run explores, verify data accuracy

6. Open Pull Request — request review from analytics team

7. Review & Merge — reviewer checks logic, naming, performance

8. Deploy to Production — merge to main triggers production update

Validation Checklist

Before opening a PR, verify:

LookML Validation (automated)

[ ] No syntax errors (red squiggles in IDE)
[ ] All sql_on references resolve correctly
[ ] No circular dependencies between views
[ ] All datagroup triggers have valid SQL

Content Validation

[ ] Run Content Validator (Develop menu)
[ ] No broken dashboards (missing fields after rename/delete)

... and much more in the full download.

Buy Now — $39 Back to Products