Harsh Mistry
I'm a marketing analytics student in Magdeburg. I turn messy channel data into clear answers about where the budget should go.
- Studying
- B.Sc. International Business and Economics, OVGU Magdeburg, graduating 2027
- Looking for
- An internship or Werkstudent role in marketing analytics
- Where
- Magdeburg. Berlin first, open to Munich and abroad
- Languages
- English (C1), German (B1), Hindi, Gujarati and Marathi (native)
LunaGlow: where should a skincare brand spend its next euro?
A 90-day marketing analytics simulation for a direct-to-consumer skincare brand advertising on Meta, Google and TikTok. I built the data model, the analysis and the dashboard end to end.
The data is synthetic (modelled GA4 and ad-platform exports), so the findings show my method, not a real company's results.
95%
gap in customer acquisition cost (CAC) between Google and TikTok
+17%
modelled conversion lift from reallocating the budget
How it works
- Synthetic data90 days of GA4, Meta, Google and TikTok data
- PostgreSQLKPI views that compare channels on the same terms
- Python and pandasCleaning, analysis and the reallocation model
- Power BIA dark-theme dashboard that shows the gap at a glance
n8n handles the automation around it. The project grew out of an earlier end-to-end pipeline: three Kaggle datasets, PostgreSQL KPI views, a two-page Power BI dashboard and a weekly n8n refresh.
About
I grew up in India, studied English literature in Vadodara, and now study International Business and Economics at Otto von Guericke University Magdeburg. My background spans India, Germany and Lithuania, and my work history is in logistics, retail and hospitality, so I know what the operations behind the numbers look like.
At the Rann Utsav festival in Kutch I ran food operations for 500+ staff and built a guest-feedback loop that cut recurring complaints by about 75%. It's the same habit I bring to marketing data: find the pattern in the feedback, then fix the cause.
What I enjoy most is building: SQL views, Python analyses, dashboards and automations that save someone a repetitive task. I'm a quick learner, and I use Claude Code to build and maintain my own websites and tools.
My earlier research looked at how film and TV characters who break the fourth wall create parasocial relationships with viewers. Away from the screen I play chess and strategy games, dance forró, run and listen to classical music.
What I'm looking for
Internships and Werkstudent roles in marketing analytics, digital and performance marketing, marketing and growth operations, consumer and customer insights, Voice of Customer and customer experience, and strategy and operations (go-to-market).
Berlin is my first choice. I'm also open to Munich, to other cities within about three hours of Magdeburg, and to relocating abroad for the right role, for example to Brussels or Amsterdam.
Other projects
-
Mažoji Himalaja, Vilnius
Marketing and operations support for my family's Nepali-Indian restaurant: Google Business Profile setup, an n8n review automation pipeline, and menu management on Wolt and Bolt Food.
-
JobFill
A Chrome extension concept that autofills job application forms.
-
Claude skills
Two skills I built for Claude: prompt-improver, which rewrites rough prompts into clear ones, and explain-ladder, which explains a concept one difficulty level at a time.
-
More side tools
AgentGate, Hushproof and rustflow.
Experience and education
-
Apr 2026 to now
Kitchen Assistant
ALEX, Mitchells & Butlers Germany
Supporting daily kitchen operations in a fast-paced restaurant, in a German-speaking team.
-
Jul 2024 to Nov 2025
Logistics Support Assistant
Freiburger & Schäfers, via Actief, Magdeburg
Supported fulfilment across sorting, packaging and dispatch in a team of 15 to 30. Flagged bottlenecks to management and supplied accurate operational data for daily KPI reviews.
-
Jan to Jun 2024
Inventory & Fulfillment Coordinator
HelloFresh, via Manpower, Barleben
Supported inventory tracking and quality control. Spotted discrepancies in inventory and process data and escalated them for correction.
-
Dec 2022 to Sep 2023
Retail Operations Associate
EDEKA, Marburg
Managed perishable stock with a FIFO system, improving turnover and reducing waste.
-
Sep 2021 to Feb 2022
Food Logistics & Operations Assistant Manager
Lallooji & Sons, Rann Utsav Festival, Kutch, India
Ran food operations for 500+ staff, coordinating teams in real time through Excel. Built a guest-feedback loop that cut recurring complaints by about 75%.
-
2023 to now
B.Sc. International Business and Economics
Otto von Guericke University Magdeburg
Marketing Performance Management, Business Decision Analysis, Statistics & Econometrics. All finance modules and the project seminar completed.
-
2022 to 2023
North American Studies (M.A. coursework)
Philipps-Universität Marburg
Media & Audience Research, Visual Storytelling, Cultural Impact in North America.
-
2019 to 2022
B.A. (Hons.) English Literature
Maharaja Sayajirao University of Baroda, India
Media, Culture & Communication, Linguistics, Introduction to Cinema, Behavioural Psychology.
Skills
- Marketing and analytics
- Campaign performance tracking, CAC and conversion analysis, CRM analysis (HubSpot), marketing automation (n8n), SEO and PPC basics, Google Business Profile, email marketing, audience and competitor research
- Data and tools
- SQL (PostgreSQL), Python (pandas), Power BI, Excel, Google Analytics, Google Ads, HubSpot, n8n, Claude Code for websites and frameworks, custom Claude skills, Canva, Figma (basic)
- Customer and operations
- Feedback synthesis (Voice of Customer), onboarding and retention analysis, D2C operations, churn reduction, process improvement, spotting bottlenecks, real-time team coordination
- Learning now
- Deeper SQL, econometrics (OLS), German. Next: marketing mix modeling with PyMC-Marketing and Google Meridian
- Languages
- English (C1), German (B1), Hindi, Gujarati and Marathi (native)
Certificates
Contact
Open to internships and Werkstudent roles. If you're hiring for marketing analytics, write to me.