FUNNEL REPORT · CANDIDATE VIEW
period: 2015 – present

Steve Rogers

Marketing Analyst · Vienna, Austria
steve.rogers@example.com ☎ +43 555 0148 ◉ steverogers.example.com ⌖ Vienna, AT

Summary

// read me first

I run acquisition and retention analytics for subscription products. Over 6 years I have cut average cost per activated user by 41% across two companies and built the attribution model that now decides where a 2.4M EUR annual budget goes. I like a clean funnel and I get slightly protective of my dashboards.

2.4M€
annual spend I model
-41%
cost per activation
▼ improved
6 yrs
in growth analytics
18
live dashboards owned

Career Funnel

// stage conversion, applicant lens
Aware of role1,000
Applied742
74.2% pass
Screened518
69.8% pass
Interview327
63.1% pass
Hired188
57.5% pass

Illustrative model of a hiring funnel I built as an interview take-home. Overall Aware to Hired rate: 18.8%.

Cohort Retention

// weekly, % active
CohortW0W1W2W4W8
2024-Q110061483729
2024-Q210064524133
2024-Q310068554436
2024-Q410071594738

W8 retention rose 9 points across four cohorts after onboarding email changes I ran and measured.

Channel Attribution

// share of activated users
Paid search
34%
Organic / SEO
27%
Referral
18%
Email lifecycle
13%
Social / paid
8%

Experience

// event log
Nordlicht Media · subscription publishing
2021 – present
Senior Marketing Analyst
  • Built a multi-touch attribution model in dbt and BigQuery that reallocated 340K EUR of a 2.4M EUR budget and dropped blended CAC from 58 EUR to 42 EUR.
  • Own 18 Looker dashboards read weekly by growth, finance, and 2 product squads; cut manual reporting time by roughly 11 hours per week.
  • Ran 24 A/B tests on paid landing pages, lifting trial-to-paid conversion from 4.1% to 5.6%.
Kessler & Voss GmbH · D2C retail
2018 – 2021
Marketing Analyst
  • Rebuilt the weekly cohort retention model, which exposed a 12-point drop at week 4 and led to an onboarding fix that recovered about 6 points.
  • Set up event tracking across web and app with 90+ tagged events, closing a data gap that had left 22% of sign-ups unattributed.
Fahrwerk Digital · agency
2015 – 2018
Junior Data Analyst
  • Reported on paid campaigns for 7 client accounts with a combined 900K EUR monthly spend.
  • Automated a daily performance export in Python, replacing a 90-minute manual task.

Toolset

// active tags
SQL BigQuery dbt Python Looker GA4 Amplitude Segment Metabase Airflow Sheets

Details

// meta
EducationBSc Statistics,
Uni Wien, 2015
LanguagesGerman, English
CertsGA4, dbt Analytics