Visual
Bret Lawson
I build analytics systems that help companies make better decisions and grow revenue. Twenty years across the full data stack. A decade as a founder before becoming an enterprise analytics leader. An agentic AI workflow that turns weeks of work into days.
Sample Visuals & Dashboards
Examples of the visualizations and interactive dashboards I build — click any card to view full-size.
Visual
Visual
AOV YoY Decomposition
Marketing Attribution
Conversion Funnel
Traffic Mix Over Time
Technologies
How I Help
Build a data practice from zero
Semantic layer, governed metrics, pipelines, and forecasts — a single source of truth across ERP, ecommerce, and marketing data. Dashboards designed for adoption, not just delivery.
See revenue impact →Measure what marketing actually drives
Attribution that connects every dollar of spend to actual revenue — including in-store transactions, not just digital pixels.
See O2O attribution →Run analytics with AI in the loop
Claude Code and custom MCP servers wired into the daily workflow — collapsing weeks of attribution analysis into days, without sacrificing rigor or auditability.
See LLM workflow →Featured Case Studies
Interactive deep-dives showcasing analytical methodology, system design, and business impact
Online-to-Offline Attribution
Scenario: Built an end-to-end attribution system connecting digital marketing interactions to physical store transactions at the individual customer level.
Key Finding: Enabled transaction-level marketing measurement, replacing platform-reported metrics with actual revenue contribution for budget allocation.
Payment Method Launch Impact
Scenario: Analyzed the impact of launching a new payment option to determine incremental transaction growth vs. cannibalization across existing payment methods.
Key Finding: 99% cannibalization with minimal incrementality (-0.07%), revealing market share redistribution rather than genuine growth.
LLM-Assisted SQL Query Optimization
Scenario: Quantified development efficiency gains from integrating LLM tools (ChatGPT/Claude) into BigQuery SQL workflows for marketing attribution and analytics queries.
Key Finding: 68% average time savings across 12 query types, with complex multi-source joins showing highest benefit (78%), enabling attribution analysis cycles to compress from weeks to days.
Paid Search Campaign Analysis
Scenario: Comprehensive year-over-year Google Ads performance analysis revealing systematic conversion rate declines across all campaign types despite maintained impression shares.
Key Finding: 39-59% conversion rate drops across Brand, Non-Brand, LIA, and PLA campaigns, indicating critical ad positioning and post-click optimization issues requiring immediate intervention.
Site Friction Impact Assessment
Scenario: Comprehensive analysis of user experience friction points across the platform to quantify conversion barriers and prioritize optimization efforts.
Key Finding: $2.1M annual revenue loss from 6 critical friction points affecting 285K users, with product filtering representing the highest impact area.
Page Speed Performance Impact
Scenario: Comprehensive analysis of Core Web Vitals (TTFB, LCP) impact on conversion rates across device types to identify performance optimization opportunities.
Key Finding: $18.2M annual revenue opportunity from page speed optimization, with mobile PDP performance representing the highest priority at $7.3M impact.
Professional Experience
- Architected and engineered enterprise ecommerce KPI system from scratch, integrating ERP sales data, product data, and web traffic into a unified dbt data lake, delivering interactive real-time dashboards in Streamlit, R Shiny, and HTML that did not previously exist
- Developed ecommerce revenue and KPI forecasting models at monthly, quarterly, and annual horizons, achieving +/- 5% accuracy and providing executives with a data-driven foundation for budget allocation, spend reallocation, and justified investment decisions
- Established A/B testing and marketing holdout experimentation as organizational decision-making standards, replacing opinion-driven changes with statistically validated tests that directly informed conversion rate and revenue optimization priorities
- Delivered analyses quantifying $18.2M in page speed opportunity, $2.1M in site friction loss, and 68% SQL development time savings through LLM integration, all built on the underlying data infrastructure
- Partnered with tagging and data engineering teams to architect online-to-offline attribution, stitching store transaction data to digital marketing channels, delivering direct channel-level attribution to complement existing Media Mix Modeling with transaction-level precision
Digital Analytics Manager (May 2016 – April 2019)
- Deployed enterprise DSP analytics framework using Adobe Advertising with advanced audience targeting and geospatial optimization, achieving 30%+ improvement in campaign efficiency through location-based performance analysis
- Architected comprehensive cross-channel attribution models integrating online and offline customer touchpoints, enabling data-driven budget allocation that improved marketing effectiveness and reduced customer acquisition costs
- Leveraged market penetration analytics and share-of-wallet modeling to identify high-value customer segments, maximizing reach efficiency across diverse regional markets
- Established KPI frameworks connecting website analytics with location-based foot traffic data, providing executive leadership with comprehensive omnichannel performance insights
- Delivered 400,000+ SKU ecommerce platform within a 14-month timeline, hitting industry-leading benchmarks for conversion rates and user adoption
- Managed complex systems integration across product catalog, inventory, and payment processing platforms
- Drove data-informed optimization strategies that produced measurable revenue and efficiency gains post-launch
- Grew online revenue to $2M+ within three years through data-driven marketing and operational decisions
- Designed and built end-to-end ecommerce infrastructure with 100% automated order processing and fulfillment
- Applied early analytics practices to drive customer acquisition, pricing strategy, and inventory management