CRM CRM Analytics and Reporting 1 — Questions and Answers
Question 1: What is a 'sales pipeline report' in CRM analytics?
- A visual representation of deals at each stage of the sales process (Correct answer)
- A financial statement showing company revenue
- A list of all customers sorted by purchase date
- A report comparing CRM vendor pricing options
Correct answer: A visual representation of deals at each stage of the sales process
A sales pipeline report shows the distribution and value of deals across each stage of the sales process, helping managers forecast revenue and identify bottlenecks.
Question 2: What does 'win rate' measure in CRM sales analytics?
- The percentage of opportunities that result in a closed sale (Correct answer)
- The number of new leads generated per month
- The average time it takes to close a deal
- The total revenue from all closed deals in a period
Correct answer: The percentage of opportunities that result in a closed sale
Win rate is the percentage of sales opportunities that are successfully closed as won, calculated by dividing won deals by total closed deals.
Question 3: What is 'average deal size' as a CRM metric?
- The average revenue value of closed-won opportunities (Correct answer)
- The number of contacts associated with each deal
- The average number of emails sent per sales cycle
- The average time a deal spends in the pipeline
Correct answer: The average revenue value of closed-won opportunities
Average deal size is the mean revenue value of closed-won deals, calculated by dividing total revenue by the number of won opportunities in a period.
Question 4: What is a 'funnel report' in CRM analytics used to identify?
- Where prospects are dropping out of the sales process (Correct answer)
- Which marketing channels generate the most website traffic
- The geographic distribution of the customer base
- Monthly subscription revenue trends over time
Correct answer: Where prospects are dropping out of the sales process
A funnel report shows conversion rates between each pipeline stage, revealing where prospects are lost and which stages have the highest drop-off rates.
Question 5: What does 'sales velocity' measure in CRM reporting?
- How quickly revenue is being generated through the pipeline (Correct answer)
- The speed at which CRM pages load for sales reps
- The number of calls made per hour by a sales team
- The rate at which new contacts are added to the CRM
Correct answer: How quickly revenue is being generated through the pipeline
Sales velocity measures the rate at which deals move through the pipeline and generate revenue, combining deal count, win rate, deal size, and cycle length.
Question 6: What is a 'cohort analysis' in the context of CRM customer reporting?
- Grouping customers by a shared characteristic or time period to analyze behavior patterns (Correct answer)
- Sorting all contacts alphabetically for bulk email campaigns
- Comparing two competing CRM platforms side by side
- Filtering records by geographic region for territory planning
Correct answer: Grouping customers by a shared characteristic or time period to analyze behavior patterns
Cohort analysis groups customers who share a common attribute — such as acquisition month — to track and compare their behavior, retention, or revenue trends over time.
What is a 'sales pipeline report' in CRM analytics?