CCRM Data Analytics 4 — Questions and Answers
Question 1: Which type of data is most commonly captured in a CRM system to enable behavioral analytics?
- Client ZIP codes and birth dates
- Client interaction logs, purchase history, and support tickets (Correct answer)
- Public social media follower counts
- Industry benchmark reports
Correct answer: Client interaction logs, purchase history, and support tickets
Behavioral analytics relies on first-party interaction data such as purchase history, contact logs, and service records stored in CRM systems.
Question 2: A CCRM analyst identifies that 20% of clients generate 80% of revenue. This pattern is an example of:
- Normal distribution
- The Pareto Principle (80/20 rule) (Correct answer)
- Regression to the mean
- Simpson's Paradox
Correct answer: The Pareto Principle (80/20 rule)
The Pareto Principle states that roughly 80% of outcomes stem from 20% of inputs, commonly observed in client revenue distributions.
Question 3: Which data quality issue occurs when two client records for the same individual exist in the CRM database under slightly different names?
- Data sparsity
- Record duplication (Correct answer)
- Outlier contamination
- Schema drift
Correct answer: Record duplication
Record duplication (also called deduplication issue) creates multiple entries for the same entity, skewing analytics and client counts.
Question 4: A relationship manager wants to understand the sequence of touchpoints that led clients to convert. Which analytical method is most useful?
- Multi-touch attribution analysis (Correct answer)
- RFM (Recency, Frequency, Monetary) segmentation
- Standard deviation calculation
- K-means clustering
Correct answer: Multi-touch attribution analysis
Multi-touch attribution assigns credit to each touchpoint in the client journey, revealing which interactions contribute most to conversion.
Question 5: When presenting analytics findings to non-technical executives, which practice is MOST effective?
- Include all raw data tables so executives can verify results independently
- Lead with the business implication and use simple visuals to support key findings (Correct answer)
- Use technical jargon to demonstrate analytical rigor
- Provide the full model code in the presentation appendix
Correct answer: Lead with the business implication and use simple visuals to support key findings
Effective data storytelling for executives prioritizes business impact and clear visuals over technical detail.
Question 6: An analyst calculates that the average client satisfaction score is 7.2, but the median is 8.5. What does this likely indicate?
- The data is normally distributed with no outliers
- A small number of very low scores are pulling the mean downward (Correct answer)
- The survey instrument is flawed and results should be discarded
- More clients responded negatively than positively
Correct answer: A small number of very low scores are pulling the mean downward
When the median exceeds the mean, negatively skewed outliers (very low scores) are depressing the average.
Question 7: Which dashboard metric would BEST alert a relationship manager to a sudden deterioration in client engagement?
- Total number of clients in the database
- Week-over-week change in login frequency and feature usage (Correct answer)
- Annual revenue compared to prior fiscal year
- Number of new clients acquired this quarter
Correct answer: Week-over-week change in login frequency and feature usage
Short-term changes in product engagement metrics provide early warning signals of disengagement before churn occurs.
CCRM Data Analytics 4
Which type of data is most commonly captured in a CRM system to enable behavioral analytics?