Bret Lawson headshot

Bret Lawson

Senior Analytics Leader · Ecommerce & Retail

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.

Analyst · Data Scientist · Data Engineer · Data Architect

Sample Visuals & Dashboards

Examples of the visualizations and interactive dashboards I build — click any card to view full-size.

Visual
View Full-Size

Mobile TTFB × Conversion

Visual
View Full-Size

AOV YoY Decomposition

Dashboard
Open Interactive

Marketing Attribution

Dashboard
Open Interactive

Conversion Funnel

Dashboard
Open Interactive

Traffic Mix Over Time

Technologies

Data Modeling & Warehouse
dbt BigQuery GCP Semantic Layer Dimensional Modeling ETL / ELT
Languages
SQL Python R HTML / CSS / JS
Analytics & BI
Adobe Analytics (CJA) Google Analytics ContentSquare Tealium Tableau Looker Studio Streamlit R Shiny
Marketing & Optimization
Google Ads Adobe Advertising Google Campaign Manager Optimizely Adobe Target
Agentic AI
Claude Code MCP Servers (built & consumed) Claude ChatGPT LangChain OpenAI API
Research & Behavior
SimilarWeb Foursquare FullStory eSpatial

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

Digital Identity Store $
View Analysis

Online-to-Offline Attribution

Attribution Architecture | Identity Stitching | Revenue Impact

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.

Attribution BigQuery dbt Identity Stitching
View Analysis

Payment Method Launch Impact

Causal Impact Analysis | BSTS Methodology | Market Share Analysis

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.

Causal Impact Python/R BSTS Data Viz
View Analysis

LLM-Assisted SQL Query Optimization

BigQuery Development | AI-Enhanced Workflows | Time Efficiency Analysis

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.

LLM Integration SQL Optimization Development Efficiency Time Analysis
View Analysis

Paid Search Campaign Analysis

Google Ads Optimization | YoY Performance | Campaign Assessment

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.

Google Ads YoY Analysis Optimization Performance Assessment
View Analysis

Site Friction Impact Assessment

UX Analysis | Revenue Impact | Friction Mapping

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.

UX Research Revenue Impact Bubble Chart Prioritization
View Analysis

Page Speed Performance Impact

Core Web Vitals | Performance Optimization | Revenue 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.

Core Web Vitals Performance Mobile Priority Revenue Impact

Professional Experience

Senior Manager, Digital Analytics
Mattress Firm  |  Houston, TX
May 2020 – Present
Built the ecommerce analytics practice from the ground up, defining KPIs, architecting the data infrastructure, and engineering the pipelines that power executive decision making. Leads cross-functional analytics projects spanning performance, marketing, and customer 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
Director of Customer Engagement & Digital Analytics
Stage Stores  |  Houston, TX  |  Omni-Channel Associate of the Year, 2018
May 2016 – April 2020
Director of Customer Engagement & Digital Analytics (Promoted April 2019)
Digital Analytics Manager (May 2016 – April 2019)
Led omnichannel analytics strategy and data-driven media optimization for a retail chain with 800+ locations, implementing advanced attribution modeling to maximize marketing ROI across TV, digital display, and search campaigns.
  • 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
Digital Project Lead
Hisco, Inc.  |  Houston, TX
Dec 2013 – Mar 2016
Led enterprise ecommerce platform implementation for a major industrial supplier, managing cross-functional teams of 20+ members across development, merchandising, and operations.
  • 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
Founder & Owner
VectorTec  |  Spring, TX
Jan 2003 – Sep 2013
Built a specialty ecommerce retailer from the ground up, growing it to become the nation's third-largest distributor in its sector. Personally engineered a fully automated ecommerce system covering invoicing, fulfillment, and reporting, without outside development help.
  • 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

Education & Certifications

Bachelor of Science, Life Sciences
Texas A&M University  |  College Station, TX
Python for Data Science Automation (DS4B 101P-A)
Business Science University
Python Automation | Predictive Modeling | Marketing Analytics | Interactive Visualization | AI-Assisted Development
Data Science for Business (DS4B 101P)
Business Science University
Data Science with R & Python | Forecasting, Modeling, and ROI Optimization