Skip to content
View GlitchG's full-sized avatar

Block or report GlitchG

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
GlitchG/README.md

Hi, I'm Gleb

Marketing data analyst, 12+ years in. Based in Madeira, Portugal — working remotely with teams across Europe.

I spend most of my time turning messy ad and product data into things people actually act on. Attribution models that tell you which channels work. Dashboards that surface the right metric at the right grain. Pipelines that make the analysis possible at all.

The signature project on my CV: unifying two completely separate post-acquisition data ecosystems into a single BigQuery warehouse, then building traffic-source-specific attribution on top of it. The dashboards from that work drove product decisions for over a year.

Stack

GA4 + BigQuery (where most of my SQL lives), server-side GTM, AppsFlyer, dbt, Looker Studio, Power BI. Meta Ads, Google Ads, Yandex Direct on the buying side. n8n for the glue work.

Things on this profile

  • ga4-attribution-models — eight attribution models in BigQuery SQL: last-click, first-click, linear, time decay, position-based, last non-direct, data-driven (BQ ML), and a cross-model comparison. Runs on Google's public GA4 sample.
  • bigquery-meridian-mmm — marketing mix model using Google's Meridian library. Bayesian inference, full posterior distributions, geo-level support, MCMC diagnostics.
  • simple-marketing-mix-model — the OLS + adstock + Hill saturation version, for when full Bayesian is overkill.
  • marketing_analytics_sample_reporting — dbt project unifying Facebook, Google, and TikTok ad spend into a clean reporting mart.
  • landing-page-ab-testing — SQL templates for AB analysis: frequentist t-test, Bayesian, SRM detection, sample-size calculator, guardrail checks.
  • cohort-log-predict — predict day-30, day-90, day-365 retention from just two data points using a power-law fit.

Outside GitHub

I run portugalevents.eu — a small platform helping local events in Portugal get found. n8n + GA4 + BigQuery + Looker Studio.

Open to marketing data analytics roles, remote. LinkedIn.

Pinned Loading

  1. bigquery-meridian-mmm bigquery-meridian-mmm Public

    Marketing Mix Modeling with Google Meridian on GA4 data. Bayesian inference, full posterior distributions, PyMC-powered. Applied to real GA4 ecommerce data with step-by-step guide.

    Python

  2. cohort-log-predict cohort-log-predict Public

    Cohort retention prediction from 2 data points using logarithmic extrapolation + BigQuery SQL

    Python

  3. ga4-attribution-models ga4-attribution-models Public

    GA4 Attribution Models using BigQuery with sample ecommerce data

  4. landing-page-ab-testing landing-page-ab-testing Public

    Landing Page AB Testing - BigQuery Portfolio with Hypothesis Templates & Guardrails