It is week 2 of your marketing internship. Your manager just said “pull the conversion numbers for the campaign and segment by channel” and you smiled and nodded. Now you have until Friday to actually do it. This is the no-fluff plan to make you genuinely useful with marketing analytics in 30 days.
Who this is for
Marketing interns (or junior marketing hires) who keep getting asked for data work they do not know how to do. You can use Excel for basic stuff. You have heard of GA4 and SQL but you would panic if asked to use either.
The four tools you actually need
Forget the “20 must-know marketing analytics tools” lists. At an intern level, your team uses some combination of these four, and you need to be functional in all:
- Google Analytics 4 (GA4) — web traffic, conversions, attribution
- Google Sheets / Excel pivot tables — every data request lands here eventually
- SQL (basic SELECT, WHERE, GROUP BY, JOIN) — for anything beyond what GA4 hands you
- Looker Studio or Tableau Public — for the dashboards your manager will inevitably ask you to “make pretty”
Week 1: GA4 from zero to dangerous
GA4 is the single most-requested skill in marketing internships and the single most-confusing tool. The trick: do not try to learn the interface. Learn the five reports you will be asked for.
The five reports to memorize: (1) traffic acquisition by source/medium, (2) conversions by source/medium, (3) landing pages report, (4) funnel exploration, (5) user attributes.
Week 2: Sheets and pivots
This is the silent skill that separates competent marketing hires from struggling ones. Your manager exports a CSV from HubSpot and says “tell me the top 5 campaigns by CAC.” You will do this 200 times.
Master: pivot tables (building, filtering, sorting), VLOOKUP/XLOOKUP, SUMIFS/COUNTIFS, QUERY function, conditional formatting.
Week 3: SQL — the part everyone fears
Marketers do not need to write production SQL. They need to read a query someone wrote, modify it slightly, and not break anything. The bar is low and reachable.
Real-world exercise: ask your team\’s data person if they can give you read-only access to one marketing-relevant table. Write three queries: top 10 campaigns by spend, CAC by channel, weekly conversion count for last 12 weeks. Sending these to your manager unprompted is a career-accelerating move at the intern level.
Week 4: Dashboards (the visible artifact)
Dashboards are how your manager\’s manager sees that you exist. Pick Looker Studio (free, integrates with GA4 in one click). Build one dashboard with: one scorecard (headline metric), one time series (last 90 days vs previous period), one channel breakdown (bar chart), one funnel, one table (top 10 landing pages).
Adjacent skills (after the first 30 days)
Once you have the four tools above, broaden into the marketing-vocabulary side. These are the courses that take you from “intern who pulls reports” to “intern with opinions.”
The metrics vocabulary you must know cold
By day 30 you should be able to define each in one sentence and calculate when given inputs: CAC, LTV, LTV:CAC ratio, CTR, CVR, CPC/CPM/CPL/CPA, ROAS, MRR/ARR, churn rate, attribution model. Make flashcards. Quiz yourself in the shower.
The Friday request playbook
When your manager asks “can you tell me which channels worked best this quarter?”:
- Clarify before pulling. “Best by what — conversions, revenue, CAC, or LTV?” Asking once saves hours.
- Pull from GA4 first, then verify with the source tool. Numbers will not match exactly — disclose the source.
- Always include the time period. “In Q1 2026 (Jan 1 – Mar 31)…”
- Show your work. Share the Sheet or query. Lets them verify; lets you get credit.
- Suggest one next step. “Email and Organic were the top channels. Want me to look at LTV by channel?” — interns who do this get hired.
What to skip
- Python and pandas. Useful eventually, irrelevant for month 1.
- R. Almost no marketing team uses R.
- CDP deep dives. Way too senior for intern work.
- All of GA4. Hundreds of features; you will use 20. Stick to the five reports.
- ML attribution models. Do not even open that rabbit hole. Just know it exists.
Your 30-day calendar
- Days 1–7: GA4 course + cert + practice the five reports in the demo account
- Days 8–14: Sheets pivot/lookup/QUERY mastery + build one practice dashboard from a CSV
- Days 15–21: Basic SQL + run three queries on real company data
- Days 22–28: Build one Looker Studio dashboard you would be proud to ship
- Days 29–30: Memorize the metrics vocabulary, run through the Friday playbook
By day 30 you will be able to
- Pull the 5 most-asked GA4 reports without help
- Build a pivot-table analysis from a HubSpot CSV in 30 minutes
- Write and modify a basic SQL query on marketing data
- Ship one Looker Studio dashboard your manager actually uses
The honest takeaway
Marketing analytics is one of the highest-leverage skills in any business team because the people running campaigns usually cannot do the analysis themselves. As the intern who can, you become indispensable fast. Six months in, the same skill set unlocks Marketing Analyst, Growth Analyst, or Lifecycle Marketing roles paying $75–$95K out of college.
Ready to apply for Marketing roles in the UK?
Browse current Marketing vacancies from trusted UK employers, recruiters, and job platforms on UKJobsAlert — our partner site curating live UK roles.
Browse UK Marketing jobs →A small editorial collective of working data professionals, software engineers, career coaches, and former hiring managers. We have collectively taken 200+ of the courses listed on this site. We do not use AI to generate course reviews or rankings.
Comments