For students and early-career professionals

Marketing Analyst

Analyzes campaign performance and customer data to improve marketing results.

11 chapters · About 2–4 months · 15–30 min a day

Start this plan free →

Chapter 1 is free.

Skills

12 skills, and what you'll learn in each

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

  1. Check dashboards for spikes or drops and flag issues to the team
  2. Pull data with SQL or spreadsheets and update a recurring report
  3. Meet with marketers to clarify goals, audiences, and success metrics
  4. 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 the work is changing

What AI is doing to this role

How AI is changing this role · one of 6 tasks we track

Build and maintain marketing performance dashboards

Sped up a lot

What AI does

Looker, Tableau, and GA4 write the dashboard narrative for you.

Still yours

You design the data model and pick which metrics matter.

Reviewed September 2026

In the app · Premium

The rest is in the app

  • How AI affects the other 5 tasks
  • Whether this job is growing or shrinking
  • How hard the first job is to get
  • Similar roles that are easier to get into
  • Updated every month, with sources
See it in the app →

How we rate a job →

Already working

Already a Marketing Analyst?

Plan your move to Senior Marketing Analyst: 14 chapters that end with a strong case for your next review.

Grow in the role →

Other roles in Marketing & Communications

Questions

Questions about this plan

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.

Start the Marketing Analyst plan.

Chapter 1 free. About 15 to 30 minutes a day.

Start on web Continue your session Download for MacMac Get the iPhone appiPhone Get it on Google PlayAndroid