Dark
Based in Caraga, Philippines

JEAN
DELFINADO

Marketing Analytics & Operations

I help teams trust their data. From tracking implementation and debugging to campaign reporting and analysis, I make sure the numbers driving decisions are clean, accurate, and meaningful.

Jean Delfinado

serious mode: dark theme activated

3.5yrs
Agency experience in analytics
20+
Client websites tracked
About Me

From the classroom
to the data layer

I started as a licensed teacher before making a deliberate pivot into digital marketing and analytics. I spent 3.5 years at a digital agency growing from data entry into full tracking implementation, audit, and reporting work across 20+ client websites.

If I don't know a platform, I learn it. If something is broken, I find where it's breaking. That's been the consistent thread across every role I've held.

Google Tag Manager
GA4 Implementation
Conversion Tracking
Pixel & CAPI Setup
Campaign Reporting
Looker Studio
Tracking Audits
Data Analysis
Tools & Platforms
Slack
Trello
ClickUp
Notion
ClickMagick
GoHighLevel
Keap
Zapier
Supermetrics
Power My Analytics
WordPress
Wix
Squarespace
Bubble
Freshworks
HubSpot
ClickFunnels
Convertri
Cometly
Carrot
ChatGPT
Gemini
Claude
Featured Work

Projects & Case Studies

Case Study

Bellabeat Smart Device Analysis

Google Data Analytics capstone. Analyzed Fitbit usage data in R to surface behavioral insights and strategic recommendations for Bellabeat's marketing team.

RRStudioKaggleGitHub
Project

Food Price Checker

An interactive Tableau dashboard built with real DTI and DA government pricing data, cleaned in Google Sheets and enriched with BigQuery SQL helper columns.

TableauBigQuerySQL
Project

Ad Campaign Performance Report

Full-funnel Meta Ads analysis across four simulated campaigns, tracking CPM through ROAS using advanced Google Sheets formulas and benchmark-based interpretation.

Google SheetsMeta AdsAnalytics
From the Blog

Practical writing,
real examples

February 26, 2026

Reading Facebook Ads Data: What the Numbers Actually Mean

A plain-language breakdown of CPM, CTR, CPL, CPA, and ROAS and how to read them together.

Coming Soon

Google Sheets for Marketers: The Formulas You Actually Use

A practical guide to the spreadsheet functions that show up again and again in real reporting work.

Coming Soon

How to Set Up a Meta Pixel the Right Way

Step-by-step walkthrough of implementing the Meta Pixel via GTM and what to check when it breaks.

LET'S WORK TOGETHER

Whether you need tracking set up, a reporting dashboard built, or campaign data analyzed, I can help.

View Services Page
About Me

THE STORY BEHIND
THE DATA

A licensed educator turned analytics specialist, driven by curiosity, self-directed learning, and a genuine interest in making data useful.

I graduated with a degree in Technical-Vocational Teacher Education and passed the Licensure Examination for Teachers in 2019. I spent a year as a college instructor, and that experience of breaking down complex ideas into things people could actually understand and act on still shapes how I approach analytical work today.

In 2021, I made a deliberate pivot into digital marketing. I joined T&T Digital as a Marketing Operations and Analytics Specialist, starting with basic data entry and growing into a role where I was responsible for making sure client tracking actually worked. That meant auditing broken implementations, setting up GTM containers from scratch, managing GA4 across diverse tech stacks, implementing conversion APIs, and building reporting systems that gave media buyers reliable data to work with.

Over 3.5 years I worked with more than 20 clients across platforms like WordPress, Squarespace, Wix, Bubble, GoHighLevel, ClickFunnels, and others. No two setups were the same, and that variety made me adaptable. When a tool was unfamiliar, I figured it out. When something broke, I traced it back to the source.

I'm currently building on that foundation. I completed the Google Data Analytics Professional Certificate in January 2026 and I'm continuing to learn through Coursera. I also share what I know through content on TikTok, Facebook, and LinkedIn, and through this blog.

Outside of analytics, I'm someone who builds things with intention. I'm based in Caraga, Philippines, recently moved into a home I built, and I'm at a point in my career where I want to go deeper into the work I care about.

Career Timeline

WHERE I'VE BEEN

Marketing Operations & Analytics Specialist

T&T Digital  |  Oct 2021 \u2013 Mar 2025

Managed tracking implementation, GTM, GA4, reporting dashboards, and analytics operations across 20+ client websites at a digital marketing agency.

College Instructor

Southway College of Technology  |  Aug 2020 \u2013 Aug 2021

Taught technical-vocational subjects. Developed the ability to break down complex concepts clearly, which continues to inform how I present data and findings.

Licensed Professional Teacher

PRC  |  February 2020

Passed the Licensure Examination for Teachers (December 2019) and received license February 2020.

BTVTED Graduate

Southway College of Technology  |  March 2019

Bachelor of Technical-Vocational Teacher Education, major in Food Service Management. Academic Excellence Awardee. Department President (3rd year).

Projects

BUILT TO LEARN,
DESIGNED TO BE USEFUL

Personal projects where I applied tools and concepts to real or realistic data. No invented metrics, no forced conclusions.

01

FOOD PRICE CHECKER

An interactive Tableau dashboard visualizing food commodity prices across the Philippines using real DTI and DA government data. Sourced as raw tables, converted to CSV, cleaned in Google Sheets, enriched with SQL helper columns in BigQuery, then visualized in Tableau. Built to practice end-to-end data workflow and dashboard design.

TableauBigQuerySQLGoogle SheetsDTI Data
View on Tableau Public ↗
02

AD CAMPAIGN PERFORMANCE REPORT

Full-funnel Meta Ads performance analysis built in Google Sheets using simulated data modeled on real agency work, structured to protect client confidentiality. Covers four campaigns over 31 days from impressions through purchases. Includes CPM, CTR, CPL, CPA, ROAS calculations, campaign summaries, and benchmark-based interpretation guides.

Google SheetsMeta AdsFunnel AnalysisROAS
View in Google Sheets ↗
Case Studies

PROBLEM, PROCESS,
FINDING

A deeper walkthrough of how I approached a problem, what the data said, and what I recommended.

Google Data Analytics Capstone

BELLABEAT SMART DEVICE USAGE ANALYSIS

RRStudioggplot2GitHubKaggle

Bellabeat is a wellness technology company that manufactures health-focused smart devices for women. As the capstone project for the Google Data Analytics Professional Certificate, I analyzed publicly available Fitbit usage data to uncover behavioral trends and surface actionable marketing recommendations for Bellabeat's product team.

The Problem

Bellabeat wanted to understand how consumers use non-Bellabeat smart devices in order to inform their own marketing strategy and product positioning.

The Approach

Analyzed a 30-user Fitbit dataset in RStudio using tidyverse and ggplot2. Cleaned data, explored activity patterns, sleep behavior, and calorie tracking, then visualized findings as an R Notebook with HTML output.

Key Findings

Most users were lightly active with inconsistent engagement. Sleep and activity tracking dropped significantly on weekends. Recommendations focused on engagement nudges, goal-setting features, and weekend habit loops.

View Full Analysis ↗ GitHub ↗ Kaggle ↗
📄 Slide Presentation
↗ Open Full Presentation
Blog

PRACTICAL WRITING FOR
CURIOUS PRACTITIONERS

Tutorials, breakdowns, and thoughts on analytics, marketing operations, and the tools that make the work easier.

Reading Facebook Ads Data: What the Numbers Actually Mean ↗

A plain-language breakdown of CPM, CTR, CPL, CPA, and ROAS and how to read them together to understand what a campaign is actually doing.

Google Sheets for Marketers: The Formulas You Actually Use

A practical guide to the spreadsheet functions that show up again and again in real reporting work. No filler, just the formulas that matter.

How to Set Up a Meta Pixel the Right Way (via GTM)

Step-by-step walkthrough of implementing the Meta Pixel through Google Tag Manager and a checklist of things to confirm before going live.

How to Audit a GTM Container You Didn't Set Up

A systematic approach to walking into an unfamiliar GTM account, figuring out what's there, what's broken, and what needs to be cleaned up.

How to Build a Simple Website Using Wix Studio

A beginner-friendly walkthrough of building a clean, functional website using Wix Studio, from choosing a template to publishing your first page.

Services

WHAT I CAN
DO FOR YOU

Analytics, tracking, reporting, and data work. If it involves making sense of marketing data, I can help.

🔍

TRACKING & IMPLEMENTATION

Setting up and fixing tracking across your website, landing pages, and ad platforms so your data reflects what's actually happening.

  • GTM setup and configuration
  • GA4 event tracking
  • Meta Pixel and CAPI
  • Conversion tracking
  • Tracking audit and fix
📊

CAMPAIGN REPORTING & ANALYSIS

Turning raw campaign numbers into structured reports and clear insights, whether that's a one-time analysis or an ongoing reporting setup.

  • Meta Ads funnel analysis
  • Channel attribution analysis
  • Lead quality analysis
  • Google Sheets dashboards
  • Looker Studio / Tableau reports

MARKETING WORKFLOWS & OPERATIONS

Setting up and managing marketing automation workflows and operational processes so campaigns run cleanly from start to finish.

  • GoHighLevel, ActiveCampaign, Make
  • CRM data audit and cleanup
  • UTM strategy and audit
  • Spreadsheet automation
  • Data cleaning and structuring
Ad Testing

Looking for a structured ad testing sprint?

I offer a focused ad testing service for Facebook campaigns. Visit my dedicated services page for details on how it works.

View Ad Testing Sprint Page ↗
Contact

LET'S START A
CONVERSATION

Whether you have a project in mind, a question, or just want to connect, feel free to reach out.

I'm currently open to full-time roles in web analytics, marketing operations, and data analysis, as well as freelance projects in tracking implementation and campaign reporting. If you think there's a fit, I'd love to hear from you.

📍
Location
Caraga, Philippines
📅
Availability
Open to opportunities

Find Me Online

SEND A MESSAGE

This will open your email client.

Tech Stack

TOOLS I'VE
WORKED WITH

Platforms and tools across 3.5 years of analytics and operations work — from daily drivers to platforms I've touched for tracking and reporting.

DAILY TOOLS
Tools I used hands-on, regularly, as part of my core workflow.
Slack
Slack
Communication
Trello
Trello
Project Mgmt
ClickUp
ClickUp
Project Mgmt
Notion
Notion
Documentation
ClickMagick
ClickMagick
Click Tracking
GoHighLevel
GoHighLevel
CRM & Automation
Keap
Keap
CRM
Zapier
Zapier
Automation
Supermetrics
Supermetrics
Data Connectors
Power My Analytics
Power My Analytics
Data Connectors
PLATFORMS I'VE WORKED WITH
Platforms I've encountered for tracking implementation and reporting — not my daily stack, but familiar territory.
WordPress
WordPress
CMS
Wix
Wix
Website Builder
Squarespace
Squarespace
Website Builder
Bubble
Bubble
No-Code
Freshworks
Freshworks
CRM
HubSpot
HubSpot
CRM
ClickFunnels
ClickFunnels
Funnel Builder
Convertri
Convertri
Funnel Builder
Cometly
Cometly
Ad Attribution
Carrot
Carrot
Real Estate Sites
AI TOOLS
Tools I use to move faster, think better, and occasionally question my career choices.
ChatGPT
ChatGPT
Text & Analysis
Gemini
Gemini
Text & Analysis
Claude
Text & Analysis