Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.
Core to the job
Chapter 2
Web analytics
Pull website traffic figures and build a one-page dashboard
What you'll learn
Events and conversions
Tracking checks
Useful dashboards
Attribution limits
Practice
Diagnose a Traffic Drop Using a GA4-Style Data Extract25 min
Design a Marketing Analytics Stack for a 20-Person Company35 min
Chapter 2
Marketing analytics
Spot a pattern in social data, explain falling email opens
What you'll learn
Conversion event
Marketing funnel
Attribution limit
Vanity metric
Practice
Read a paid campaign report and pick the one change worth making30 min
Work out lifetime value and payback for two channels30 min
Chapter 4
SQL
Write queries that filter and summarise data and join tables
What you'll learn
Query output shape
Join logic
Grouping level
Query plan
Practice
Write Five Basic SQL Queries on a Real Dataset15 min
Chapter 4
Spreadsheets
Build a spreadsheet summary that updates when filters change
What you'll learn
Formula references
Lookup logic
Pivot tables
Auditable workbook
Practice
Answer 3 manager questions with a pivot table20 min
Chapter 5
Campaign planning
Plan a small campaign and design a fair test
What you'll learn
Campaign brief
Outcome metric
Health check metric
Campaign hypothesis
Post-campaign retro
Incrementality
Modelled contribution
Practice
Reverse-engineer a real ad you were shown20 min
Predict an A/B Test Winner and Design the Test15 min
Chapter 5
Attention to detail
Check words, links and images before a piece is published
What you'll learn
Pre-launch checklist
Tracking parameters
Audience segment
Campaign naming
Cold read
6 more in the plan
Data cleaningClean a messy data set and note each fixCh 4
What you'll learn
Tidy table shape
First data profile
Missing value choice
Repeatable cleaning steps
Practice
Clean a Messy Dataset and Document Your Fixes10 min
Critical thinkingSpot a weak assumption and ask where numbers come fromCh 6
What you'll learn
The hidden assumption
Argue the other side
The base rate
Fact vs inference
Wanting it to be true
Practice
Spot the Weak Link in an Argument10 min
Problem solvingTest each possible cause of a problem instead of guessingCh 6
What you'll learn
Problem vs symptom
Clean problem splits
Root cause
Deciding under uncertainty
Practice
Separate the Problem from the Symptom10 min
CommunicationRewrite an update for two different readers, cutting extra linesCh 8
What you'll learn
Lead with the point
Match detail to the reader
Said versus heard
Specific feedback
Practice
Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 8
What you'll learn
Early team friction
Clear ownership
Challenge ideas, not people
Lead or follow
Practice
Navigate a Disagreement Without Damaging the Relationship20 min
Adapting to changeTry a new tool and describe how you handled changeCh 8
What you'll learn
Change vs your response
The messy in-between
Not there yet
Real change vs a feeling
Your plan
Chapter by chapter.
11 chapters, in this order. Chapter 1 is free.
1~1 wk
See marketing analyst work up close
StartFree
21–2 wks
Read your marketing numbers in analytics tools
Skills
31–2 wks
Build a funnel and channel check
Project
41–2 wks
Pull and clean the data you need
Skills
51–2 wks
Plan campaigns and get the details right
Skills
61–2 wks
Find the cause before you fix it
Skills
7~1 wk
Talk to two working marketing analysts
People
81–2 wks
Communicate and work together through change
Skills
91–2 wks
Decide how you will get in
Decide
101–2 wks
Answer the questions interviewers ask
Interview
11on your timeline
Send your first applications
Apply
The job
What a Marketing Analyst does
Measures marketing and customer data to explain what is working, what is not, and how to improve results.
The work
Analyze campaign results across channels and explain what drove performance
Build dashboards and weekly reports for marketing and business partners
Design experiments like A/B tests to improve ads, emails, and landing pages
Segment customers to find high value groups and growth opportunities
Track key metrics like conversion rate, CAC, and retention over time
Diagnose data issues and align tracking with analytics and product teams
Recommend budget and message changes based on evidence and goals
A typical day
Check dashboards for spikes or drops and flag issues to the team
Pull data with SQL or spreadsheets and update a recurring report
Meet with marketers to clarify goals, audiences, and success metrics
Run an A/B test readout and suggest next actions for the next sprint
Tools
Spreadsheets: Excel, Google SheetsDatabases: SQLWeb analytics: Google AnalyticsDashboards: Tableau, Power BI, LookerExperimentation: A/B testingTagging: Google Tag Manager
Ways in
There is more than one route.
Ways to study
Bachelors in marketing, business, economics, statistics, or analytics
Diploma or certificate in data analytics or digital marketing
Online courses in SQL, statistics, and marketing analytics with a portfolio
Masters in marketing analytics or business analytics for deeper specialization
How people get their first job
Apply for marketing analytics internships or campaign reporting roles
Start in digital marketing operations and take on reporting and testing work
Build a portfolio with dashboards, cohort analysis, and A/B test writeups
Earn a practical certificate in SQL and analytics reporting
Volunteer to analyze results for a student club, nonprofit, or small shop
How long does it take to become a marketing analyst with Welica?
The plan is 11 chapters, 2–4 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.
Do I need a degree?
Not always. Common routes are bachelors in marketing, business, economics, statistics, or analytics, diploma or certificate in data analytics or digital marketing, online courses in SQL, statistics, and marketing analytics with a portfolio, or masters in marketing analytics or business analytics for deeper specialization.
What is free?
Chapter 1, See marketing analyst work up close, is free for good. Premium unlocks the rest of the plan.