Practice Test Geeks(MAC) Marketing Analytics Certification Practice Test
← All MAC Flashcard Decks

Data Collection & Management Flashcards

7 cards from real MAC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Collection & Management flashcards as text

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

    Answer: HAVING

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

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

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

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

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

    Answer: Holdout testing (geo or user-based experiments)

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

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

    Answer: Inconsistent naming conventions and metric definitions across platforms

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

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

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

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

  6. In the context of marketing data governance, what is 'data stewardship'?

    Answer: Assigning ownership and accountability for data quality and compliance to specific individuals

    Data stewardship involves designating responsible parties who manage data quality, usage policies, and compliance within an organization.

  7. Which of the following best describes 'event-based tracking' in digital analytics?

    Answer: Capturing specific user interactions such as button clicks, video plays, or form submissions

    Event-based tracking fires a data capture call whenever a defined user action occurs, enabling granular behavioral analysis beyond simple page views.