Data Analyst Intern
Product Goal
Instrument tracking pipelines and visualize usage analytics to make data-driven decisions for CampusConnect.
Tech Stack & Tools
Weekly Deliverables
The AARRR Metric Framework
Author a data strategy doc mapping specific business questions to Pirate Metrics (Acquisition, Activation, Retention, Referral, Revenue).
The Event Taxonomy Spreadsheet
Author a definitive data dictionary specifying exact tracking naming conventions (e.g., item_clicked, properties: item_category, price).
The Tech Implementation Map
Deliver an explicit technical tracking guide to the Dev intern showing exactly where to embed the Mixpanel/GA4 tracking initialization scripts.
The Data Stream Audit
Run live debugger checks on the incoming test data streams to verify that properties are tracking cleanly without duplicating user records.
The Core KPI Dashboard
Build a live analytics dashboard featuring charts for Daily Active Users (DAU), conversion rates from landing page to sign-up, and popular categories.
The Marketing Attribution Tracker
Configure custom tracking links (UTM codes) for the Growth Marketing team's campaigns to accurately track user acquisition sources.
The Soft Launch Funnel Drop-off Analysis
Run a product funnel query to isolate exactly where users drop off during onboarding, presenting findings to the UI/UX designer.
The User Cohort Retention Graph
Build an N-day retention matrix visualizing whether users who signed up in Week 7 return to the app during Week 8.
The Product Insights Data Deck
Deliver the definitive analytical case study presentation summarizing beta traction, viral coefficients, and clear recommendations for scaling.