Data warehouse and CDP guides for marketing teams
These guides are for teams deciding whether marketing and product data should live in a warehouse, and for the people who build and run it. The sections follow the order the work happens. First, whether you need a warehouse at all, what a warehouse plus data activation changes and what the whole setup costs a small company. Then how Snowflake and BigQuery compare and what each costs for a marketing workload. Then modelling: layers, metric contracts, late-arriving data, currency conversion and revenue that reconciles with Stripe and the CRM. After modelling comes data quality: monitoring, alerts, dbt tests, observability tools and an incident process for when numbers break. Then the pipelines that load the data, such as Fivetran, Airbyte and CRM-to-warehouse sync, with worked cost examples. Then CDPs and event collection with Segment and RudderStack, followed by activation: reverse ETL, warehouse audiences and identity resolution. The last section covers the BI tools teams report from and what their licences cost. Each guide answers the question first, then gives setup steps, checks and sources. If you want a warehouse built or reviewed, see our data warehouse and CDP service.
Start here
Do you need a warehouse: the case, data activation and the path
Start with the guide
Do you need a data warehouse? A guide for companies with 1 to 50 people
Decide whether a warehouse will solve a real reporting problem. Compare simpler options, calculate the operating cost and scope a small first project.
Last updated
Choosing and pricing a marketing data warehouse
Start with the guide
Marketing data warehouse: what goes in, what comes out
Build a useful marketing warehouse with clear model grains, reconciled money, honest attribution, freshness checks and practical business outputs.
Last updated
What is Snowflake? A practical explanation for marketing and RevOps teams
See what Snowflake does in a marketing stack, how storage and compute are priced, and which data models and controls a useful first project needs.
Last updated
Snowflake vs BigQuery for startups: choose by workload, cost and ownership
Compare Snowflake and BigQuery for a small marketing data team. Evaluate workload costs, operations, integrations, sharing and the effort of changing platforms.
Last updated
Snowflake vs Databricks for Marketing Data: Workloads, Costs and Team Fit
Compare Snowflake and Databricks for marketing workloads, operating costs, storage and team fit. Use a practical proof of concept to choose with evidence.
Last updated
Snowflake Alternatives: Choose Around Your Workload
Compare BigQuery, Redshift, Databricks, PostgreSQL and DuckDB against your workload. Includes a pilot checklist, migration tests and total-cost example.
Last updated
BigQuery Alternatives: Choose for the Workload You Need to Change
Compare Snowflake, Redshift, Databricks, Fabric and ClickHouse for your BigQuery workload. Includes export risks, reconciliation examples and cutover checks.
Last updated
Snowflake key-pair authentication: migrate Fivetran, Airbyte, dbt and BI connections
Migrate Snowflake service connections to key-pair authentication. Includes OpenSSL commands, connector checks, dbt configuration and safe key rotation.
Last updated
Snowflake data sharing and Marketplace: a practical guide for marketing teams
Share Snowflake data with agencies, evaluate Marketplace datasets and decide when clean rooms help. Includes SQL, access checks, costs and practical examples.
Last updated
GA4 BigQuery export: setup, costs, limits and ten starter queries
Set up and validate GA4's BigQuery export. Use ten SQL examples to inspect events, sessions, acquisition, purchases, funnel steps and missing identifiers.
Last updated
GA4 BigQuery Sessionization: Build and Validate Session Counts
Build GA4 session counts in BigQuery with correct composite IDs, timezone boundaries, missing-data coverage and SQL validation fixtures.
Last updated
Snowflake Implementation Mistakes: Diagnose the Failure Before Changing the Setup
Diagnose Snowflake authentication failures, idle compute, Gen2 costs, storage growth and weak controls with practical checks and a recovery plan.
Last updated
BigQuery Implementation Mistakes: Fix Missing Data, Cost Surprises and Unreliable Reports
Fix missing GA4 exports, location mistakes, sandbox limits and costly raw scans with BigQuery diagnostics, reconciliation checks and recovery steps.
Last updated
Snowflake Pricing: Estimate Your Marketing Workload and Control the Bill
Estimate Snowflake costs for marketing workloads. Understand credits, storage, AI charges, warehouse sizing and the controls that prevent avoidable spending.
Last updated
BigQuery Pricing: Query Costs, Storage, GA4 Export and Budget Controls
Estimate BigQuery costs with worked marketing workloads. Compare on-demand and slots, storage models, GA4 export charges and practical spending controls.
Last updated
Modelling marketing data you can trust
Start with the guide
Data warehouse design for a small company: layers, models and rules that prevent rework
Design a marketing warehouse around clear record grain, identity and history. Includes model examples, metric definitions and a first-project checklist.
Last updated
Marketing Metric Contracts: Make the Definition as Reliable as the Dashboard
Define reliable marketing metrics with clear grain, denominators, time windows, dimensions and tests. Includes an activation contract and worked examples.
Last updated
dbt Incremental Backfills: Repair History Without Breaking Today's Reports
Plan reliable dbt backfills with affected-group recomputation, full refresh and microbatch guidance, validation fixtures and downstream release checks.
Last updated
How to Handle Late-Arriving Marketing Data
Handle late events, duplicates and older corrections with a versioned ledger, safe incremental processing, reconciliation fixtures and controlled backfills.
Last updated
How to Set a Useful Marketing Data Freshness SLA
Set a marketing data freshness agreement around real decisions. Define cutoffs, coverage, deadlines, alerts and recovery, with a runnable readiness fixture.
Last updated
Multi-Currency Marketing Reporting Without Misleading Growth
Build reliable multi-currency marketing reports with clear rate policies, worked FX examples, constant-currency growth and traceable refund handling.
Last updated
How to Model SaaS MRR Without Double Counting Revenue
Model SaaS MRR at subscription-item grain with effective dates, explicit policies and a checked SQL fixture. Stop invoice and CRM joins inflating totals.
Last updated
How to Reconcile Stripe Revenue With CRM Deals
Connect CRM deals, Stripe invoices, payments and refunds without double-counting. Build a traceable reconciliation with a worked example and exception queue.
Last updated
dbt Implementation Mistakes: Fix Stale Models, Incremental Errors and Fragile Deployments
Fix stale dbt models, incremental errors, schema backfills and fragile deployments with practical tests, build-cost checks and a reliable handover plan.
Last updated
Is dbt Still Free? A Practical Guide for Small Marketing Data Teams
Understand free dbt, hosted limits and State pricing. Build useful marketing models with clear grains, tested SQL and a practical small-team setup.
Last updated
Data pipelines: Fivetran, Airbyte and CRM-to-warehouse sync
Start with the guide
Fivetran Pricing: Estimate Your Bill and Cut the Right Costs
Understand Fivetran pricing, 2026 MAR rules, Free limits and real calculator examples. Audit history, connections and model runs without breaking reports.
Last updated
Fivetran vs Airbyte: Compare the Workload, the Bill and the Maintenance
Compare Fivetran and Airbyte with current billing rules, worked costs, HubSpot connector checks and a practical pilot for small marketing data teams.
Last updated
Airbyte Pricing: Estimate the Cost of Your Actual Syncs
Calculate Airbyte costs from API rows, database volume and sync behavior. Compare launch, recurring and recovery costs using current Standard and Plus rates.
Last updated
Fivetran Implementation Mistakes: Syncs, History and Downstream Checks
Avoid Fivetran sync mistakes around deletes, history mode, timestamps, re-syncs and schema changes. Includes a tested SQL example and incident checklist.
Last updated
Airbyte Implementation Mistakes: Syncs, Schemas and Recovery
Diagnose Airbyte duplicates, missing updates, incomplete backfills and unsafe recovery. Includes a tested SQL example and stream-level acceptance checks.
Last updated
CDPs and event collection: Segment, RudderStack and composable CDPs
Start with the guide
CDP vs data warehouse: do you need both?
A CDP and a warehouse solve different parts of customer data work. Compare identity, collection, activation and ownership before choosing an architecture.
Last updated
What is a composable CDP, and when should a small team pick one?
Decide whether a composable CDP fits your team. Compare ownership, identity, latency, storage boundaries and full costs using a practical pilot plan.
Last updated
Segment vs RudderStack in 2026: pricing, warehouse fit and migration effort
Compare Segment and RudderStack using your event flows, destinations and operating needs. Includes cost questions, migration checks and a pilot plan.
Last updated
Segment Alternatives for Small Teams: Pick the Right Replacement
Compare RudderStack, Jitsu, Snowplow, server-side GTM and direct integrations by workload, total cost, identity needs and migration requirements.
Last updated
Segment Implementation Mistakes: Fix Identity, Duplicate Events and Delivery Gaps
Fix Segment identity errors, duplicate purchases, schema gaps, consent buffering and delayed events. Includes a tested SQL diagnostic and acceptance checklist.
Last updated
RudderStack Implementation Mistakes: From Collected Events to Reliable Activation
Find missing warehouse values, unsafe transformation fallbacks and reverse ETL mistakes. Includes tested SQL checks and an activation release checklist.
Last updated
Twilio Segment Pricing: What You Pay and How to Control MTUs
Calculate Twilio Segment Team costs, understand MTUs and overages, and reduce avoidable spend without breaking identity, attribution or customer journeys.
Last updated
RudderStack Pricing: Budget Events, Plan Limits and Warehouse Operations
Understand RudderStack Free, Growth and Enterprise pricing, current versus legacy overages, annual rates and the warehouse costs behind an event budget.
Last updated
Reverse ETL, audience activation and identity resolution
Start with the guide
What is reverse ETL, and when do you need it?
Turn warehouse models into useful CRM and marketing actions. Define matching, field ownership, removals, retries, freshness and destination verification.
Last updated
Single customer view without an enterprise CDP
Connect product, billing, support and CRM data into a useful customer view. Learn identity rules, safe SQL joins, freshness checks and verified CRM delivery.
Last updated
Identity resolution for startups: connect web, app, CRM and billing correctly
Connect web, app, CRM and billing with reliable identity rules. Learn which IDs to collect, how to detect bad merges, and where Segment and Mixpanel fit.
Last updated
Hightouch vs Census, now Fivetran Activations: pricing and migration decisions
Compare Hightouch with Census, now Fivetran Activations. Check free tiers, MAR pricing, migration deadlines and the sync tests that should decide your choice.
Last updated
Warehouse Audiences: Activate Customer Data in Google Ads, Meta and HubSpot
Build useful warehouse audiences with clear entry and exit rules, channel permissions, reliable syncs and honest match-rate measurement across Ads and HubSpot.
Last updated
Hightouch Implementation Mistakes That Turn Clean Data Into Wrong Actions
Prevent Hightouch sync errors with practical checks for identity, null handling, removals, resyncs, approvals and destination outcomes.
Last updated
Hightouch Pricing: Count Activation Work Before You Compare Quotes
Understand Hightouch pricing, active sync counts, free limits and quote requirements. Build a realistic budget with warehouse costs and operating work.
Last updated
BI and reporting tools: Tableau, Data Studio and Metabase
Tableau Alternatives: Compare the Work Your Team Must Rebuild
Compare Power BI, Looker, Sigma, Qlik and ThoughtSpot with practical migration tests, calculation traps and a full transition-cost example.
Last updated
Data Studio Alternatives for Marketing and Revenue Teams
Compare Metabase, Power BI, Looker, Tableau and Superset using real reporting tasks, access tests, operating costs and a controlled migration plan.
Last updated
Metabase Alternatives: Choose by How Your Team Builds and Owns Analytics
Compare Lightdash, Omni, Evidence, Superset and Power BI by metric ownership, review, embedding and maintenance. Includes a practical change-cost example.
Last updated
Data Studio Problems: Fix Wrong Totals, Quota Errors and Slow Reports
Diagnose Data Studio blend errors, misleading ratios, GA4 quotas and slow reports with worked examples, clear tests and a practical recovery checklist.
Last updated
Metabase Implementation Mistakes: Fix Models, Permissions and Performance
Fix duplicated revenue, permission gaps, stale dashboards and time-zone errors in Metabase. Includes tested SQL and an implementation acceptance checklist.
Last updated
Tableau Pricing: Calculate Roles, Editions and the Full Reporting Budget
Calculate Tableau Creator, Explorer and Viewer costs, compare Standard and Enterprise, and budget for cloud capacity, data pipelines and implementation.
Last updated
Data Studio Pricing: Is It Free, What Pro Costs and the Full Reporting Budget
Data Studio is free, and Pro costs $9 per user per project a month. See who needs a license, what 10 to 50 people pay, and the connector and BigQuery costs.
Last updated
Metabase Pricing: Seats, Hosting, Embedding and the Real Operating Cost
Calculate Metabase Starter and Pro costs, understand billable accounts and embedding, and budget hosting, warehouse queries and optional usage.
Last updated
Want a second pair of eyes on your stack?
Bring your current setup and the decision you need to make. We can help you scope the next useful improvement.
Book a Free Audit
A free audit of your stack and what it needs. No pitch.
Thirty minutes, and you leave with a plan
We look at what you have, what it is costing you and what to do about it first.
- 30 minutes
- Video call, link on booking
- No obligation
What we'll cover
- Your current stack and where it hurts
- Quick wins we can ship first
- An integration roadmap
- Timeline, scope and next steps
Calendar not loading? Open it in a new tab or email hello@martechdevs.com.