Question 1

Google Ads says a campaign drove a lot of conversions, but the CRM shows far fewer new customers. How do you figure out what's going on?

Accepted Answer

Platform numbers never match the CRM, and this is the conversation you'll have most often in the job. They want to see whether you know why, not just that it happens. Name the usual causes: different attribution windows, view-through conversions, and each platform counting a sale it only touched Check the conversion definition in the ad account against what the CRM counts as a new customer Look for tracking breaks, such as a tag that fires twice or a form that doesn't pass UTM parameters Say which number you'd report upward and how you'd label the gap so nobody is surprised

Question 2

Walk me through how you'd set up an A/B test for a new email subject line.

Accepted Answer

Testing is where analysts either earn trust or burn it. They're checking whether you plan the read before the send, not after. Pick one primary metric up front, usually clicks or conversions rather than opens, since open tracking is unreliable Split the audience randomly and keep everything else the same Decide the sample size and how long the test runs before it starts Explain what you'd do if the result is flat: report it as flat, not as a small win

Question 3

What attribution model would you use for a business with a long sales cycle, and why?

Accepted Answer

This separates people who've read about attribution from people who've had to defend a model to finance. There's no right answer, so they're watching your reasoning. Say why last-click undercounts early channels like paid social and content when deals take a while to close Compare a position-based or data-driven model and name the trade-off of each Mention that any rule-based model is a convention, and incrementality tests are how you check it Tie the choice back to the decision it supports, such as how to split next quarter's budget

Question 4

Write a query that shows cost per acquisition by channel for last month.

Accepted Answer

It's a basic SQL check wrapped in marketing vocabulary. They want clean joins and a clear definition of acquisition. Ask what counts as an acquisition before writing anything: first purchase, signup or qualified lead Join spend by channel to acquisitions by channel on a shared key and date range Handle channels with spend but no acquisitions so they show up instead of silently dropping out Sanity check the totals against the finance number for ad spend

Question 5

Tell me about a time your analysis changed how a marketing team spent money.

Accepted Answer

The job exists to move budget. They want proof you've done it, or come close. Set up the situation briefly: the channel, the question, who owned the budget Say what you found and how sure you were Describe how you presented it, including any pushback Give the outcome, even if it was partial or the team only ran a smaller test first

Question 6

Conversions dropped sharply overnight. What do you check first?

Accepted Answer

Tracking breaks happen all the time. They want someone who suspects the plumbing before blaming the campaign. Check whether the drop shows up in every source or only one, such as Google Analytics but not the CRM Ask whether anything shipped: a site release, a new checkout page, a Google Tag Manager change Look at traffic and spend to see whether volume fell or only the conversion count did Tell the team early, with what you know and what you're still checking

Question 7

How would you decide which customer segments to target for a new product launch?

Accepted Answer

Segmentation is a core marketing analyst task, and it shows whether you think in terms of value or just demographics. Start from existing customers who bought something similar and look at what they share Use behavior and value, such as purchase frequency and lifetime value, not only age or location Keep segments few enough that the team can actually build campaigns for them Propose a small test on the top segments before committing the full budget

Question 8

A campaign manager asks you to report only the metrics that make their campaign look good. What do you do?

Accepted Answer

This happens. They want to know you'll protect the numbers without making an enemy. Acknowledge what the campaign did well, since there's usually something Explain that leadership will compare it against the same metrics as every other campaign Offer to add context, such as a note that it was built for awareness rather than sales Keep the full picture in the report and talk to your manager if the pressure continues

Question 9

How do you explain a finding to someone who doesn't care about statistics?

Accepted Answer

Most of your audience is marketers and executives. A correct answer nobody understands doesn't change anything. Lead with the recommendation and what it means for budget or targeting Use one chart that answers the question, not five that describe the data Translate uncertainty into plain terms, such as "likely but not certain, so test before scaling" Keep the method in an appendix for anyone who asks

Question 10

Which dashboards have you built, and how did you know people used them?

Accepted Answer

Plenty of dashboards get built and never opened. They want to see if you care about adoption, not just output. Name the tool, such as Tableau, Looker Studio or Power BI, and who the audience was Explain how you chose the handful of metrics on the top row Describe how you checked use: view counts, questions in meetings, requests for changes Mention something you removed or simplified after feedback

Question 11

Tell me about a mistake in a report you sent out.

Accepted Answer

Everyone ships a wrong number eventually. They want to hear how you caught it and what you changed. Own the mistake plainly without long excuses Explain how it was caught and how fast you corrected it Describe the check you added afterward, such as reconciling totals against the source before sending Keep it short and move to what's different now

Marketing analyst interview questions, and what they're really testing

The 8 questions you will almost certainly get

A forgettable answer, and a better one

"Google Ads says a campaign drove a lot of conversions, but the CRM shows far fewer new customers. How do you figure out what's going on?"

"Walk me through how you'd set up an A/B test for a new email subject line."

Questions to ask them

Need more Marketing Analyst interviews to prep for?

The question	What they want to know	Your angle
Google Ads says a campaign drove a lot of conversions, but the CRM shows far fewer new customers. How do you figure out what's going on?	Platform numbers never match the CRM, and this is the conversation you'll have most often in the job. They want to see whether you know why, not just that it happens.	Name the usual causes: different attribution windows, view-through conversions, and each platform counting a sale it only touched
Walk me through how you'd set up an A/B test for a new email subject line.	Testing is where analysts either earn trust or burn it. They're checking whether you plan the read before the send, not after.	Pick one primary metric up front, usually clicks or conversions rather than opens, since open tracking is unreliable
What attribution model would you use for a business with a long sales cycle, and why?	This separates people who've read about attribution from people who've had to defend a model to finance. There's no right answer, so they're watching your reasoning.	Say why last-click undercounts early channels like paid social and content when deals take a while to close
Write a query that shows cost per acquisition by channel for last month.	It's a basic SQL check wrapped in marketing vocabulary. They want clean joins and a clear definition of acquisition.	Ask what counts as an acquisition before writing anything: first purchase, signup or qualified lead
Tell me about a time your analysis changed how a marketing team spent money.	The job exists to move budget. They want proof you've done it, or come close.	Set up the situation briefly: the channel, the question, who owned the budget
Conversions dropped sharply overnight. What do you check first?	Tracking breaks happen all the time. They want someone who suspects the plumbing before blaming the campaign.	Check whether the drop shows up in every source or only one, such as Google Analytics but not the CRM
How would you decide which customer segments to target for a new product launch?	Segmentation is a core marketing analyst task, and it shows whether you think in terms of value or just demographics.	Start from existing customers who bought something similar and look at what they share
A campaign manager asks you to report only the metrics that make their campaign look good. What do you do?	This happens. They want to know you'll protect the numbers without making an enemy.	Acknowledge what the campaign did well, since there's usually something