Hiu Lam Janna C.

I build the dashboards and reports that tell you what's actually working in your ad spend, and I back them with statistics you can defend. I'm Janna, a data analyst and statistician (BS Statistics, University of the Philippines, Magna Cum Laude) with 4.5+ years of freelance experience. Most of my current work is for ecommerce and DTC brands. WHAT I'VE BEEN BUILDING LATELY ✔ Multi-channel paid media dashboards combining Meta, Google, TikTok, Amazon and Shopify in Looker Studio, Power BI, Google Sheets and Excel ✔ True ROAS and CAC reporting. I join ad campaign data to actual store orders. On one account this showed platform-reported ROAS overstated by 11–76%. ✔ Daily spend pacing trackers with weekday-matched projections, automated refresh, and stale-data email alerts (Google Apps Script) ✔ Automated data pipelines with Windsor, Funnel and Supermetrics, so reports update without manual exports ✔ GA4 and attribution analysis: channel path breakdowns, checkout abandonment analysis, multi-touch attribution, and client-ready slide decks ✔ Weekly stakeholder reports: executive talking points, Amazon performance reports, and demand reports HOW I USE AI I build with Claude as a working partner. It drafts formulas, calculated fields, scripts and metric logic from plain-language descriptions, and I test and validate every piece against the source data before delivery. You get faster turnaround, more revisions within your budget, and documented logic your team can maintain. The judgment calls (method, metric definitions, what the numbers mean) stay with me. STATISTICS AND RESEARCH SUPPORT ✔ Survey analysis, thesis and academic data analysis (SPSS, R, Python) ✔ t-tests, ANOVA, Welch ANOVA, regression, chi-square, weighting, ARIMA/SARIMA forecasting ✔ APA-formatted results with reproducible syntax WHY CLIENTS HIRE ME ✔ Top Rated Plus, perfect Job Success Score, 16 completed projects ✔ 0–4 hour response time ✔ I catch problems others miss: inflated platform metrics, budget double-counting (about 7x in one case), timezone and currency mismatches ✔ Plain-English explanations, no jargon