GA4, Excel and SQL for Marketers: The Interview-Ready Toolkit

Most marketers do not fail because they lack data - they fail because GA4, Excel and SQL sit in three separate mental boxes. The misconception is simple: GA4 is for reporting, Excel is for charts and SQL is for tech teams. In reality, these three tools form one decision loop: track the customer, clean the data, answer the business question and improve the next campaign.

The Big Picture: One Marketing Decision Loop

Think of GA4, SQL and Excel as a loop, not a ladder. GA4 captures digital behavior, SQL retrieves and joins deeper business data, Excel turns it into analysis, and the marketer converts that analysis into campaign action. The next campaign then generates fresh data, restarting the loop.

The Core Explanation: What Each Tool Does for a Marketer

GA4 is the observation layer. It tells you how users arrived, what they did, where they dropped, and which actions converted. Unlike older session-heavy analytics, GA4 is built around events - a click, scroll, video view, sign up, add to cart or purchase.

SQL is the retrieval layer. GA4 can show website behavior, but marketers often need more: order value, customer segment, inventory status, coupon use, store visit or repeat purchase. SQL helps pull this from structured tables and join it correctly.

Excel is the thinking and presentation layer. It is where most MBA marketing analytics answers become visible: pivots, formulas, cohort summaries, charts, scenario tables and clean dashboards for a manager.

GA4: What a Marketer Must Know

GA4 matters because digital marketing is no longer judged only by impressions and clicks. A brand wants to know whether paid search users explored products, whether Instagram traffic bounced, whether a coupon campaign created profitable buyers, and whether repeat customers behaved differently from first-time visitors.

The essential GA4 vocabulary is simple:

• Event: Any tracked user action, such as page_view, add_to_cart, sign_up or purchase.
• Conversion: An event marked as valuable to the business, such as a lead, subscription or purchase.
• Session: A group of user interactions during a visit.
• Traffic source: The origin of the user, such as organic search, paid search, direct, referral, email or social.
• Audience: A user segment based on behavior, demographics, source or predicted likelihood.

SQL: The Minimum a Marketer Needs

You do not need to become a database engineer. But you should be able to explain what a query does, read a simple query, and understand why joins can change the answer.

The core SQL commands for a marketer are:

• SELECT: Choose the columns you want.
• FROM: Choose the table where the data lives.
• WHERE: Filter rows, such as a date range or campaign name.
• GROUP BY: Summarize results by segment, campaign, channel or product.
• JOIN: Combine tables using a common key such as user ID, order ID or product ID.

A marketer-friendly query might look like this:

SELECT
  campaign,
  COUNT(DISTINCT user_id) AS buyers,
  SUM(revenue) AS revenue
FROM orders
WHERE order_date BETWEEN DATE '2026-01-01' AND DATE '2026-01-31'
GROUP BY campaign;

The point is not syntax perfection. The point is knowing that this query answers: Which campaigns brought buyers and revenue in January?

Excel: Where Analysis Becomes Manager-Friendly

Excel is still powerful because managers understand it, screenshots travel well, and interviews often test whether you can structure a business problem without hiding behind a tool. For marketing analytics, know these Excel moves cold:

The 6 Marketing Metrics You Should Track Across These Tools

In interviews, metrics are where vague tool knowledge becomes business thinking. Do not just say "I will check GA4." Say which metric you will check, how it is calculated, and what action it drives.

A Small Worked Example: CAC and ROAS

Suppose an Indian D2C skincare brand spends ₹1,00,000 on a paid campaign. The campaign generates ₹3,20,000 in revenue from 400 new customers. The gross margin is 40%.

• CAC = ₹1,00,000 / 400 = ₹250 per new customer.
• ROAS = ₹3,20,000 / ₹1,00,000 = 3.2x.
• Breakeven ROAS = 1 / gross margin = 1 / 0.40 = 2.5x.
• Gross profit before ad cost = ₹3,20,000 x 40% = ₹1,28,000.
• Contribution after ad cost = ₹1,28,000 - ₹1,00,000 = ₹28,000.

The campaign is not automatically brilliant because ROAS is positive. It is attractive because ROAS is above breakeven, CAC is interpretable, and the next question is whether these customers repeat.

Definitions You Can Say in One Breath

Lenskart: Using the Toolkit to Understand an Omnichannel Funnel

Situation: Eyewear is not a pure impulse category. A customer may discover frames through an ad, compare styles online, check price and prescription options, visit a store or book an eye test, and then purchase through a channel different from the first touchpoint. For a brand like Lenskart, the marketing question is not just "Which ad got clicks?" It is "Which journeys produce profitable buyers?"

The move: The right analytics approach is to map the full funnel. GA4-like event tracking captures browsing behavior such as product views, try-on interactions, store locator clicks and checkout steps. SQL-style joins connect those events with customer, order, product and store data. Excel then becomes the decision layer, where marketers compare city-level performance, campaign cohorts, conversion drop-offs and repeat behavior.

Outcome or lesson: The primary driver of this approach is Lenskart's omnichannel model - the journey can start digitally and close through another channel. Supporting drivers include a strong product catalogue, store footprint, technology-enabled customer experience and performance marketing. The strategic lesson is clear: when the customer journey is multi-touch, the marketer who only reads a channel report will misread the business.

How AI Changes GA4, Excel and SQL for Marketers

AI does not remove the need to understand these tools. It raises the expectation that you can ask better questions and verify machine-generated answers.

• GA4 becomes more predictive and diagnostic. Marketers can use automated insights, anomaly detection and predictive audiences where data eligibility allows. The interview caveat: predictions depend on clean events, sufficient volume and consented first-party data.
• Excel becomes a faster analysis workspace. AI-assisted formula writing, summarization and chart suggestions can speed up analysis, but you still need to know whether the metric logic is correct.
• SQL becomes more accessible through natural-language querying. Tools can draft SQL from plain English, but marketers must still validate joins, filters, date ranges and duplicated rows.

For Indian marketers, AI-driven analytics must also be framed with privacy discipline. With the Digital Personal Data Protection Act, 2023, first-party data, consent, purpose limitation and secure handling are not legal footnotes - they shape how marketing analytics is designed.

Interview Relevance

Common Mistake

What to Revise Next

Now that you can connect GA4, Excel and SQL, move from tool fluency to decision fluency. Revise AI in Analytics: GenBI, Natural-Language Querying & Predictive Scoring next, then deepen your metric logic with Turning Data into Decisions: A Metrics Deep-Dive.