Marketing Analytics · Tracking · Dashboards · AI Automation

Scattered data in. Clear decisions out.

I'm Sid Mehandru. I wire your marketing, sales and customer data into one growth system — clean tracking, a real warehouse, dashboards your team trusts, and AI that tells you what to do next. For ecommerce, lead gen, SaaS and agencies.

Taking new projects — US · UK · UAE · Remote

No guesswork 500+ dashboards built US · UK · UAE 200+ clients served 100+ AI automations
The Growth Data System

One pipeline. Raw signal automated action.

Six connected stages. Miss one and the whole thing wobbles — so I build all of them, in order.

0101

Tracking

Clean event capture across web, forms, calls, carts and bookings.

0202

Data layer

One unified warehouse — every source, reporting-ready.

0303

Dashboards

Decision-ready views your team actually opens.

0404

Attribution

True channel value — not platform-inflated numbers.

0505

Insights

What's working, what's wasting money, what to do next.

0606

Automation

Action on autopilot — reports, alerts and follow-ups.

Core Expertise

The full analytics lifecycle. No gaps.

Collect clean data, structure it properly, make it readable, then make it act on its own.

01

GA4, GTM & Tracking Implementation

  • GA4 setup, configuration & event tracking plans
  • Google Tag Manager implementation & debugging
  • Ecommerce, lead, form, call & booking tracking
  • Cross-domain & UTM campaign structure
  • Fixing missing or duplicate conversions
02

Meta Pixel, CAPI & Server-Side

  • Meta Pixel setup, audit & Conversions API
  • Server-side GTM / Stape deployment
  • Google Ads enhanced conversions
  • Offline & CRM-to-platform conversion syncing
  • Event deduplication & match-quality gains
03

Dashboards & BI Reporting

  • Executive & leadership performance dashboards
  • Paid media, ecommerce & lead-funnel dashboards
  • CRM, sales & pipeline dashboards
  • Cohort, retention & creative performance views
  • Standardised multi-client agency reporting
04

Attribution & Performance Analysis

  • Channel attribution & campaign ROI / ROAS
  • CAC, MER & LTV reporting
  • Funnel drop-off & lead-quality analysis
  • New vs returning customer revenue
  • Organic vs paid & offline attribution
05

Data Architecture & Warehousing

  • BigQuery warehouse setup & data modelling
  • Marketing pipelines & connectors (Windsor.ai)
  • Reporting-ready tables across all sources
  • Combining GA4, ads, CRM, ecommerce & finance
  • Custom API & ETL data integration
06

AI & Workflow Automation

  • Automated reporting & AI performance summaries
  • AI dashboard commentary & creative scoring
  • Automated lead qualification & CRM workflows
  • KPI alerts, data cleaning & classification
  • AI-assisted email, WhatsApp & follow-up journeys
Track record

The scoreboard so far.

Delivery numbers — clients, builds and systems shipped. No vanity metrics.

0+
Clients served — ecommerce, lead gen, SaaS & agencies
0+
Dashboards created & shipped
0+
Automations & AI workflows running live
0
Markets served — US · UK · UAE
Deliverables

Dashboards I build. 8 types.

Every one tuned to who's reading it — founder, media buyer, sales lead or agency PM.

Executive 01

Founders, CMOs & leadership — the whole business on one page.

BOARD-READYAI SUMMARY

Paid Media 02

Meta, Google & TikTok — spend, pacing & creative.

CROSS-CHANNELCREATIVE VIEWS

Ecommerce 03

Shopify & DTC — store, customers & lifecycle.

SHOPIFY-NATIVEFULL-FUNNEL

Lead Gen 04

Service & B2B — leads, quality & booked calls.

LEAD QUALITYCALL TRACKING

CRM & Sales 05

Sales teams — pipeline, stages & forecast.

PIPELINE VIEWSFORECASTING

Retention 06

Subscription & lifecycle brands — who stays, who slips.

COHORT VIEWSLIFECYCLE STAGES

Creative Perf. 07

Paid teams & agencies — hooks, angles & assets.

HOOK ANALYSISASSET-LEVEL

Agency 08

Agencies — standardised multi-client reporting.

MULTI-CLIENTWHITE-LABEL
Selected work

Portfolio.

Twelve marketing builds — every shot is an AI-generated recreation with mock data, taped up like evidence. Every card opens into a full case file; live dashboards linked where public.

PAID ADS × CRM — CLICK TO CLOSE2025
CASE 01
LEAD GEN AGENCYPAID + CRM

Paid Ads × CRM Funnel

Meta Ads and GoHighLevel piped into BigQuery; SQL marries spend to pipeline outcomes so the funnel reads clean from click to close.

Meta AdsGoHighLevelBigQueryLooker Studio
PAID × ORGANIC — FULL FUNNEL2025
CASE 02
ECOM AGENCYFULL-FUNNEL

Paid Media, Website + SEO

Meta, Google, Bing and TikTok unified in BigQuery alongside website and SEO — channel comparison and funnel drop-off in one place.

BigQueryAd Platform APIsLooker Studio
META — SPEND TO RETURN2024
CASE 03
PERFORMANCEPAID SOCIAL

Facebook Ads Profitability

Spend to return with the funnel in between — placements, audiences and creative drop-off exposing exactly where efficiency leaks.

Meta Ads APIBigQueryLooker Studio
SEARCH — TERMS TO REVENUE2024
CASE 04
PERFORMANCEPAID SEARCH

Google Ads Revenue Engine

PMax, brand and non-brand compared head to head — search terms, devices and geos tied to conversion value, not clicks.

Google Ads APIBigQueryLooker Studio
EMAIL — REVENUE PER SEND2025
CASE 05
ECOM BRANDLIFECYCLE

Email Revenue + Engagement

Campaigns vs flows, list health and revenue per send — engagement and monetisation in one view so volume decisions stop being guesses.

KlaviyoLooker Studio
STORE × ADS — MARGIN VIEW2024
CASE 06
DTC STOREECOM + PAID

Shopify × Facebook Revenue

Storefront truth next to ad spend — products, discounts and refunds against campaign performance for margin-safe scaling.

ShopifyMeta AdsLooker Studio
LOYALTY × FREQUENCY — RFM2024
CASE 07
SHOPIFY STORERETENTION

Customer Loyalty Matrix

Customer-level Shopify data scored on loyalty and frequency; the matrix exposes exact pockets of buyers to re-target with programs.

ShopifySQLLooker Studio
COHORTS — D1 TO D302025
CASE 08
MOBILE APPGROWTH

App Growth + Monetisation

Acquisition to LTV in one loop — installs, onboarding, D1–D30 retention cohorts and revenue by cohort, wired across Meta and Google.

FirebaseMeta AdsGoogle AdsLooker Studio
LOCAL — RANKINGS TO CASES2025
CASE 09
LAW FIRM NETWORKLOCAL SEO

SEO, Local + Lead Performance

Rankings, Google Business Profile interactions, reviews and PPC across multi-location firms — visibility tied to actual case inquiries.

Search ConsoleGBPGoogle AdsLooker Studio
PIPELINE — STAGE BY STAGE2024
CASE 10
SALES TEAMCRM FUNNEL

Pipeline + Deals Performance

Six-stage funnel from Pipedrive with advisor comparisons and loss-reason analysis — separating lead-quality problems from execution ones.

PipedriveLooker Studio
ACCOUNTS — SPEND TO DEALS2025
CASE 11
COACHING BRANDGYMS

Paid Ads → Revenue Funnel

Ad spend traced through leads, appointments and closed deals per client account — media efficiency meets sales execution in one view.

Meta AdsCRMBigQueryLooker Studio
THE WHOLE BUSINESS — ONE PAGE2025
CASE 12
MARKETING AGENCYBUSINESS PERF

End-to-End Business Performance

Marketing, sales, finance, operations, HR and payroll in one leadership view — funnel cost per stage through project variance and labour cost.

BigQueryLooker StudioSQL

AI-GENERATED PREVIEWS MOCK DATA ONLY NDA BUILDS MARKED PRIVATE

That's me →
Sid MehandruFounder — Growth Data SystemsMarketing analytics · Tracking · Dashboards · AI automationBased in Dubai · Clients across the US, UK & UAE
About

Who's behind the system?

Most businesses don't have a marketing problem — they have a visibility problem. Data scattered across ad platforms, websites, CRMs and spreadsheets. Nobody fully trusts the numbers, so decisions run on gut feel.

I bring that whole system together: clean tracking in, a unified warehouse in the middle, decision-ready dashboards and AI automation out. Cross-market experience with ecommerce, lead gen, SaaS and agency clients across the US, UK and UAE.

"I don't just build dashboards. I build the measurement and reporting systems that show what's working, what's wasting money, and where the next growth opportunity is."
EcommerceLead GenSaaSAgencies USUKUAEGlobal
The Shift

Before me / After me

Fragmented & Manual

  • Data scattered across platforms
  • Manual, time-consuming reporting
  • Unclear, untrusted attribution
  • Missing or duplicate conversions
  • Poor lead-quality visibility
  • No clear view of revenue impact
  • Slow, gut-feel decision-making

Connected & Decision-Ready

  • Clean, reliable tracking
  • Centralised data layer
  • Dashboards teams actually trust
  • Clear, dependable attribution
  • True revenue-based reporting
  • Automated insights & alerts
  • Faster, more confident decisions
The Engagement

How it runs. 5 phases.

01

Audit

Review current tracking, data sources, dashboards, attribution gaps & key business questions.

02

Measurement Plan

Define events, KPIs, funnel stages, naming conventions, tracking rules & reporting needs.

03

Implementation

Build tracking, tags, pixels, CAPI, data connectors, warehouse tables & sources.

04

Dashboard Build

Decision-ready dashboards for leadership, marketing, sales, ecommerce & lifecycle.

05

Automate & Optimise

Automated insights, alerts, AI summaries, workflow automation & ongoing analysis.

Toolkit

The stack. 5 layers deep.

Live feed: raw signal drops in at the top, automated action fires out the bottom. Hover a layer to inspect it.

Raw signal in
01

Tracking & Analytics

Capture
GA4Google Tag ManagerMeta PixelMeta CAPIGoogle AdsTikTok Pixel / CAPIAppsFlyerFirebasePostHog
02

Data & Warehousing

Warehouse
BigQuerySQLAPIsCloud FunctionsWindsor.aiFivetranAirbyteGoogle Sheets
03

BI & Dashboards

Visualise
Looker StudioPower BITableauLookerExcelGoogle Sheets
04

Marketing & CRM

Activate
ShopifyKlaviyoStripeXeroGoHighLevelPipedriveHubSpotWebflowWordPress
05

Automation & AI

Automate
OpenAI / ChatGPTAI AgentsZapierMakeCRM AutomationsReporting AutomationsSlack AlertsGoogle Workspace
Automated action out
Say hello

Stop guessing.
Start knowing.

Tell me what you're tracking (or failing to track) and I'll show you what your growth data system could look like. Usually a 30-minute call is enough to map it.

★ Book a call →
Or send an inquiry

This opens your email app with everything pre-filled — or write directly to siddhantmehandru@gmail.com