Posted 1h ago
Loading this job…
Marketing Analytics Intern - Campaign Reporting
Posted 2h ago0 views
Our growth team spends a real budget across LinkedIn, Google and a newsletter list of eighty thousand job seekers, then reports on all of it with a spreadsheet that breaks every second Tuesday.
Fixing the reporting
You will spend three months in our Delhi NCR office rebuilding how marketing measures itself. First you map every campaign source onto a consistent UTM convention. Then you rebuild signup attribution in SQL so a channel is credited on the same basis every time. The output is a weekly channel performance view in Metabase with cost per qualified candidate as the headline number.
Beyond the dashboard
Reporting is only half of the job. You will run the numbers behind live decisions: which subject lines lift open rates on the Friday jobs digest, whether city targeted ads actually reach candidates in that city, what a paused campaign really costs us. Expect to present a finding to the marketing lead most weeks and be asked how confident you are in it.
What you need
A final year student or recent graduate who is genuinely quick in Excel, willing to learn SQL properly, and comfortable saying out loud that a campaign is not working. Marketing analytics rewards people who are stubborn about definitions, and you will get plenty of practice.
Responsibilities
- Map every paid and organic campaign onto a consistent UTM naming convention
- Rebuild signup attribution in SQL so each channel is credited on the same basis
- Publish a weekly channel performance view with cost per qualified candidate
- Analyse subject line performance across the Friday jobs digest
- Check whether city targeted ad spend reaches the candidate pool it was meant for
- Present one finding to the marketing lead each week and take questions on it
Requirements
- Final year student or recent graduate with strong spreadsheet skills
- Willing to reach a working level of SQL within the first month
- Able to state a conclusion clearly, including when a campaign is failing
- Available for a hybrid schedule from our Delhi NCR office
Skills
Benefits
- Certificate + Letter of Recommendation
- Direct exposure to the marketing lead and a weekly review of your analysis
- A documented attribution model you can walk any future interviewer through