PranavNagrecha/AwesomeSalesforceSkills / skills/admin/analytics-requirements-gathering
analytics-requirements-gathering
VerifiedUse this skill to elicit, document, and validate CRM Analytics requirements — covering data source mapping (Salesforce object sync vs external connector vs Data Cloud), transformation needs, audience-specific lens or dashboard views, and drill-down path specifications — before any dataset or dashboard is built. Trigger keywords: CRM Analytics requirements, analytics data source mapping, CRM Analytics audience requirements, analytics visualization requirements. NOT for the formula and target behind each KPI — use admin/analytics-kpi-definition. NOT for building the dashboard once requirements are agreed — use admin/analytics-dashboard-design.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 13.6 KB |
| references/examples.md | markdown | 6.1 KB |
| references/gotchas.md | markdown | 8.3 KB |
| references/llm-anti-patterns.md | markdown | 7.7 KB |
| references/metadata-examples.md | markdown | 5.6 KB |
| references/well-architected.md | markdown | 4.9 KB |
| scripts/check_analytics_requirements_gathering.pyexecutable | script | 3.7 KB |
| templates/analytics-requirements-gathering-template.md | markdown | 2.7 KB |
templates/analytics-requirements-gathering-template.md
View on GitHub# Analytics Requirements Gathering — Work Template
Use this template to capture CRM Analytics requirements before any dataset or dashboard is built.
## Scope
**Skill:** `analytics-requirements-gathering`
**Project Name:** (fill in)
**Primary Stakeholder(s):** (fill in)
**CRM Analytics License:** Confirmed / Not confirmed
**Decision:** CRM Analytics required / Standard Reports sufficient — Rationale: ______
---
## CRM Analytics vs Standard Reports Decision
| Factor | Applies? | Notes |
|---|---|---|
| More than 2 objects must be joined | Yes / No | |
| External data (Snowflake, BigQuery, S3) needed | Yes / No | |
| Predictive scoring or trend forecasting needed | Yes / No | |
| Row-level security beyond standard sharing | Yes / No | |
| Dataset aggregates exceed 2,000 rows | Yes / No | |
| **Decision** | **CRM Analytics / Standard Reports** | |
---
## Data Source Mapping Matrix
| Data Source Name | Source Type | Connection Mechanism | Fields Needed | Refresh Frequency | Incremental? |
|---|---|---|---|---|---|
| | Salesforce Object Sync / External Connector / Data Cloud / CSV | Named Credential / Direct sync | (list fields) | Daily / Hourly / On-demand | Yes / No |
---
## Transformation Requirements
| Transformation | Description | Source Fields | Target Field |
|---|---|---|---|
| Join | Account + Opportunity on AccountId | Account.AccountId, Opportunity.AccountId | (joined dataset) |
| Computed field | FiscalQuarter from CloseDate | CloseDate | FiscalQuarter__c |
| Field rename | Normalize display names | | |
| Filter | Exclude inactive accounts | IsActive__c == false | (filtered) |
---
## Audience Matrix
| User Role | Data Rows Accessible | Row-Level Security Mechanism | Dashboard View |
|---|---|---|---|
| | All / Own records / Team records / Custom | Sharing inheritance / SAQL predicate / Separate dashboard | Same as others / Unique layout |
**SAQL predicates (if applicable):**
- Role: Sales Rep → `'OwnerId' == "$User.Id"`
- Role: Manager → `'Region__c' == "$UserAttribute.Region__c"`
---
## Drill-Down Path Requirements
| Summary Visualization | Drill-Down Level 1 | Drill-Down Level 2 |
|---|---|---|
| Revenue by Region | Revenue by Owner within Region | Opportunity list for that Owner |
---
## Review Checklist
- [ ] CRM Analytics vs standard Reports decision documented
- [ ] CRM Analytics license confirmed
- [ ] All data sources documented with type and connection mechanism
- [ ] Field-level requirements captured for each data source
- [ ] Transformation requirements specified (joins, computed fields, renames)
- [ ] Audience matrix complete with row-level security mechanism
- [ ] Drill-down paths documented
- [ ] Refresh cadence and incremental refresh requirements specified
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks. | Stars: 119k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |