Marketing analyst role in India: spend, attribution and honest CAC
In this article (9 sections)
- The number marketing wants and the number finance trusts
- What a working week involves
- Attribution without self-deception
- Scorecard for the role
- Performance marketers, agencies and the CRM owner
- Marketing analyst versus digital marketing executive
- Attribution, MMM and campaign reporting in postings
- Reconcile first, optimise later
- Growth analytics, marketing science or performance lead
Related programme: the Data Analytics with Generative AI course (3–4 months; ₹90,000 (inclusive of GST) · EMI from ₹4,000/month).
A marketing analyst measures how marketing spend turns into leads, customers and revenue, and recommends how to reallocate budget. In practice most of the job is reconciling numbers that disagree: the ad platform's conversions, the website analytics tool's sessions and the CRM's actual sales.
The number marketing wants and the number finance trusts
Every ad platform reports its own conversions, and each tends to credit itself. Finance only trusts customers who paid. The marketing analyst's central deliverable is a table that connects the two. Here is one for a hypothetical education company for a single month, all figures invented for illustration.
| Channel | Spend | Platform-reported leads | CRM leads (deduplicated) | Paying customers | Revenue per customer |
|---|---|---|---|---|---|
| Search ads | ₹3,00,000 | 420 | 360 | 12 | ₹60,000 |
| Social ads | ₹2,00,000 | 900 | 610 | 5 | ₹60,000 |
| Organic and referral | ₹0 | not applicable | 240 | 9 | ₹60,000 |
Now the calculations the analyst actually presents:
- Cost per CRM lead: search ₹3,00,000 ÷ 360 = ₹833; social ₹2,00,000 ÷ 610 = ₹328. Social looks three times cheaper.
- Paid CAC per channel: search ₹3,00,000 ÷ 12 = ₹25,000; social ₹2,00,000 ÷ 5 = ₹40,000. The ranking flips.
- Blended CAC: total spend ₹5,00,000 ÷ all 26 customers = ₹19,231. This looks flattering because organic customers cost nothing in ad spend; never present it without the paid figure.
- Return on ad spend: search 12 × ₹60,000 ÷ ₹3,00,000 = 2.4; social 5 × ₹60,000 ÷ ₹2,00,000 = 1.5.
The social platform reported 900 leads; the CRM had 610 after removing duplicates and junk. That gap is itself a finding worth a line in the monthly review.
One more caution. If the sale usually happens weeks after the lead, this month's customers came partly from last month's spend. A careful analyst reports CAC by lead cohort (customers from leads created in August, whenever they paid) rather than by calendar month.
What a working week involves
Monday is usually the performance pull: spend and results from each platform, sessions from GA4, and leads and sales from the CRM, joined in SQL or a spreadsheet. Midweek brings questions from the performance marketing team, for example whether a new audience is producing worse leads or just cheaper ones. Thursday might go on fixing tracking: a landing page lost its UTM parameters after a redesign, so a chunk of paid traffic now looks direct. Friday is the budget recommendation, written for someone who will not read your SQL.
Attribution without self-deception
Last-click attribution, platform attribution and data-driven attribution will give different answers, and none is ground truth. A marketing analyst earns trust by stating which model a number uses, showing where the models disagree, and proposing a test when the disagreement matters, such as pausing a channel in some regions to see what actually changes. When consent requirements limit tracking, some conversions go unobserved; say so rather than pretending the data is complete.
Scorecard for the role
Expect to be judged on the accuracy of the spend-to-revenue reconciliation, turnaround of the weekly performance view, the quality of budget recommendations, and whether tracking breaks are caught before they distort a month.
Performance marketers, agencies and the CRM owner
Usually a head of marketing, growth lead or analytics manager. You work with performance marketers, the content or brand team, sales or inside-sales managers who own the CRM, and finance for revenue figures.
Marketing analyst versus digital marketing executive
The confusion is common because Indian postings often bundle both. If the JD says "manage Google and Meta campaigns, optimise bids", the job is campaign execution. If it says "build attribution reports, join CRM with ad data", it is analysis. Some roles genuinely combine them; ask what share of the week is spent inside the ad platforms.
Attribution, MMM and campaign reporting in postings
- "GA4, GTM, UTM governance" — you will own tracking hygiene.
- "Marketing mix modelling" — a statistics-heavy, often senior role.
- "Lead quality analysis with sales" — the CRM join is central.
- "Run campaigns on Google Ads and Meta" — execution, not analysis.
- "ROI dashboards for leadership" — BI work plus commercial judgement.
Reconcile first, optimise later
In the first month, reproduce last month's spend-to-customer table yourself and document every mismatch. In the second, agree a single lead definition and deduplication rule with sales. In the third, run one controlled test that answers a budget question the team has been arguing about.
Growth analytics, marketing science or performance lead
Senior marketing analyst, growth analyst, marketing science or analytics manager, or product analyst. Some move into performance marketing leadership with a stronger analytical edge. The Data Analyst programme covers the SQL joins, cohort logic and careful reporting this role depends on; the free skill check shows which of these your CV already evidences.
Frequently asked questions
Is a marketing analyst the same as a digital marketing executive?
No. A digital marketing executive runs campaigns: creatives, bids, budgets and audiences. A marketing analyst measures what those campaigns produced, usually by joining ad platform data with CRM and sales data, and advises where the next rupee should go.
Which tools does a marketing analyst use?
Commonly GA4, the ad platforms' own reporting, a CRM, spreadsheets, SQL and a BI tool. Larger teams add marketing mix modelling or experimentation tools, but the joins between spend and actual customers remain the core skill.
Pankit Kumar has 10 years in Data Science & AI, building and shipping production systems in regulated pharma and clinical environments. He is a freelance trainer at Boston Institute of Analytics, AnalytixLabs and Scaler, and has taught this material to thousands of working professionals.
This article is part of our Data Analytics with Generative AI programme — 3–4 months. The full analyst stack — Excel, SQL, Power BI and Python pipelines — then a generative-AI layer you can prove is right.
Explore Data Analytics with Generative AI