MAC Data Collection & Management 3

Question 1

Which SQL clause is used to filter aggregated results in a marketing data query?

Accepted Answer

HAVING

Answer

The HAVING clause filters the results of aggregate functions (like SUM or COUNT), whereas WHERE filters individual rows before aggregation.

Question 2

What is 'clickstream data' most commonly used to analyze?

Accepted Answer

The sequence of pages and actions a user takes on a website

Answer

Clickstream data records every page visit, click, and interaction a user makes, revealing navigation paths and behavior patterns.

Question 3

A marketing team wants to understand the incremental impact of paid search ads. Which method is most appropriate?

Accepted Answer

Holdout testing (geo or user-based experiments)

Answer

Holdout tests withhold ads from a control group to measure the true incremental lift driven by paid search versus organic behavior.

Question 4

Which of the following is a key challenge when integrating data from multiple ad platforms into a single analytics warehouse?

Accepted Answer

Inconsistent naming conventions and metric definitions across platforms

Answer

Different platforms define metrics like 'impressions' or 'conversions' differently, requiring normalization before cross-platform analysis.

Question 5

What is a 'lookup table' used for in marketing data pipelines?

Accepted Answer

Mapping coded values (like campaign IDs) to human-readable labels

Answer

Lookup tables translate coded or abbreviated identifiers into descriptive labels, making data more interpretable across reporting tools.

(MAC) Marketing Analytics Certification Practice Test