Data & Analytics Flashcards
7 cards from real GMC 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 & Analytics flashcards as text
What is 'multivariate testing' and how does it differ from A/B testing?
Answer: Testing several variables at once vs. changing one variable at a time
Multivariate testing changes multiple elements simultaneously to find the best combination, while A/B testing isolates a single variable to determine its impact.
Which SQL clause would a growth analyst use to filter aggregated data after a GROUP BY statement?
Answer: HAVING
HAVING filters results after aggregation (e.g., after GROUP BY), while WHERE filters rows before aggregation occurs.
What is 'activation rate' in product-led growth analytics?
Answer: The percentage of new sign-ups who reach a meaningful first value moment
Activation rate measures how many new users reach the 'aha moment' — the key action that demonstrates they've experienced core product value.
A funnel shows 10,000 visitors, 2,000 product page views, and 200 purchases. What is the overall funnel conversion rate?
Answer: 2%
Overall funnel conversion rate = final conversions / top-of-funnel entries = 200 / 10,000 = 2%.
What does 'data blending' enable in tools like Looker Studio?
Answer: Combining data from multiple sources into a single visualization
Data blending joins datasets from different sources (e.g., Google Ads + GA4) into one report, enabling cross-channel analysis without a separate data warehouse.
Which growth metric formula is: (New MRR + Expansion MRR - Churned MRR) / Beginning MRR × 100?
Answer: Monthly Recurring Revenue growth rate
This formula calculates MRR growth rate, showing how monthly recurring revenue changed by accounting for new, expanded, and lost revenue.
What is 'sampling' in Google Analytics and when does it occur?
Answer: Collecting data from a subset of users due to high traffic volume, potentially affecting report accuracy
GA applies sampling when queries exceed data thresholds, analyzing only a subset of sessions and extrapolating results, which can introduce inaccuracies.