YANIV
KAPTSAN
I turn data into strategy and
the story that drives decisions.
Data & Marketing Analyst who works across all kinds of data. I turn messy, cross-channel data into measurement and insights teams can act on, and I stay close to the strategy behind it: defining what success looks like up front and setting the standards that keep the work reliable as it scales.
What sets my work apart is that I architect the systems behind the analytics, not just the reports. Using Python and Google Apps Script, I build the data pipelines, quality checks, and reporting automation that keep the numbers accurate as everything scales — tools that started on my own team and were adopted by other teams. That lets me take ownership beyond my scope and connect the data to the decisions it should drive.
Numbers only matter when they change a decision. I focus on the strategic layer: defining what success looks like up front, then turning the data into moves that shift budget, messaging, and results.
Measure what matters
Define success metrics and learning agendas before anything launches, so every campaign has a clear question to answer and a bar to clear.
Turn insight into decisions
Translate cross-channel data into clear recommendations people can act on, so analysis shapes strategy instead of sitting in a dashboard.
Tie it to the goal
Connect every metric back to the business objective, so data-driven decisions move real KPIs like revenue, efficiency, and growth, not vanity numbers.
Data-quality & Slack alerting engine
Problem Siloed client accounts let data errors slip through and stalled cross-team handoffs.
System An automated data-quality and Slack alerting pipeline in Python and Google Apps Script that enforces a clear ownership model and catches issues at the source.
Impact Campaign numbers stay accurate without manual babysitting, and it was reliable enough that other teams adopted it beyond the one it was built for.
Reusable BI reporting system
Problem Reporting was inconsistent and rebuilt by hand every cycle.
System A reusable reporting system of standardized templates and self-serve dashboards, so the numbers come from one consistent source.
Impact Removed the manual rebuild each cycle and became the measurement backbone across healthcare accounts.
Cross-channel performance optimization
Turned display, site, and social data into targeted optimizations worth a 23% gain in efficiency and a 36% CTR lift, packaged into clear weekly and monthly stakeholder narratives.
Partner go-to-market & SEO
Optimized multi-channel partner campaigns for ROI at Dassault Systèmes, mining lead-gen data for trends, auditing partner sites for SEO/SEM, and shaping go-to-market strategy with sales and digital teams.
The automation layer in the middle is the part I build: the connective tissue, in Python and Apps Script, that keeps sources, dashboards, and decisions in sync.
Analytics & Insight
- Campaign & performance analysis
- Social, creator & influencer analytics
- Measurement strategy & frameworks
- Data storytelling & insight generation
- Data pipelines, QA & automation
- A/B testing & market research
Platforms & Tools
- Python
- Google Apps Script
- BI tools & dashboards
- Snowflake
- Google Analytics (GA4)
- Adobe Analytics
Marketing & Strategy
- AI-driven reporting & automation
- SEO / SEM
- Go-to-market & creative briefs
- Cross-functional collaboration
- Stakeholder communication
- Project management
Years of turning data into insight by hand taught me what good measurement actually looks like. Now I build AI into the workflow, automating the reporting and QA that used to eat entire days.
Building AI systems, not just using them
Engineered an automated data-quality & Slack alerting system in Python and Google Apps Script, plus reusable BI reporting. It's AI-driven QA that keeps data accurate and frees the team for higher-value strategy.
The data-quality engine →AI enters the workflow
At BPD, I started embedding AI into reporting and QA, automating the manual, repetitive work that used to eat entire days.
The reporting system →Analysis at agency scale
Owned cross-channel performance analysis and built weekly and monthly reports and briefs manually, driving +23% efficiency and +36% CTR. Learned to turn data into story.
Cross-channel work →Learning the fundamentals
Ran multi-channel campaign analysis, SEO/SEM audits, and lead-gen reporting by hand, building the instinct for what good measurement actually looks like.
GTM & SEO →Analytical judgment
Analytics, measurement, campaign strategy, and data storytelling: the judgment that makes AI output actually good.
10× the output
Automated QA, self-serve reporting, and pipelines I built myself that other teams picked up too.
Foundation: B.S. Data Analytics & Marketing, University of New Hampshire · English (native) · Russian (fluent)
Let's talk data & marketing.
Always happy to trade notes on measurement, analytics, and creative work, or just connect.