Recruiting / Major job site
3 months to payback
Payback on a redesign worth tens of millions of yen cut to 3 months
As lead analyst, I set things up so the site could be compared before and after the redesign. By continually proposing fast PDCA cycles, the budget expected to take six months to recover was recovered in three.
Before/after comparison / Impact testing / Improvement proposals
Hotels and lodging / Annual revenue over ¥100 billion
Tableau Data integration and visualization
Integrated data from every property in the group and built a Tableau dashboard
Designed a data mart from multiple tables, including sales, bookings, guest counts and rate plans. I helped build an environment where the whole group's situation can be followed on a single screen.
Data mart design / Tableau / Dashboard build
Ecommerce / Tens of millions of yen in monthly sales
200% of prior year in a peak month
A month at 200% of the prior year through ongoing monitoring
I built the measurement foundation with additional GTM tracking and BigQuery integration, visualized it in Looker Studio (now Data Studio), and stayed with the team from prioritized proposals through implementation instructions.
GTM implementation / BigQuery integration / Looker Studio / Ongoing support
E-commerce / Across multiple sites
A ⇄ B Cross-sell analysis
Analyzed how products are bought together to improve recommendations
Tested product affinity in both directions: "Do people who buy A also buy B?" and "What about from B to A?" Based on these two-way relationships, on-site ads and recommendation slots were reviewed.
Cross-sell analysis / BigQuery integration / Recommendation improvements / On-site ads