PranavNagrecha/AwesomeSalesforceSkills / skills/admin/crm-analytics-app-creation
crm-analytics-app-creation
VerifiedUse when creating or configuring a CRM Analytics (Einstein Analytics) app — including app containers, lenses, datasets, data source connections, app sharing, and the row-level security that gates whether users see any data. NOT for choosing Reports vs CRM Analytics vs Tableau — use admin/einstein-analytics-basics. NOT for security predicate syntax, sharing inheritance or Analytics license assignment — use admin/analytics-permission-and-sharing.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 14.7 KB |
| references/examples.md | markdown | 8.4 KB |
| references/gotchas.md | markdown | 9.8 KB |
| references/llm-anti-patterns.md | markdown | 6.2 KB |
| references/well-architected.md | markdown | 5.2 KB |
| scripts/check_crm_analytics_app_creation.pyexecutable | script | 14.6 KB |
| templates/crm-analytics-app-creation-template.md | markdown | 1.8 KB |
references/well-architected.md
View on GitHub# Well-Architected Notes — CRM Analytics App Creation
## Relevant Pillars
- **Security** — CRM Analytics has three independent security layers (permission set, app sharing, row-level predicate) none of which inherit from Salesforce OWD. All three must be explicitly configured. Skipping the row-level security predicate gives all app Viewers access to all dataset rows regardless of Salesforce object-level sharing.
- **Performance** — Dataset refresh schedules and recipe/dataflow run times directly affect how current the data is and how long dashboard loads take. Large datasets with no column pruning or excessive row counts slow query times. Use aggregation in recipes rather than pushing raw row-level data to lenses. Index dataset dimensions used frequently in dashboard filters.
- **Operational Excellence** — Scheduling dataset refresh (recipe/dataflow) after each data sync and monitoring for failed refresh jobs prevents stale data from silently persisting in dashboards. Prune unused template app assets to reduce scheduler load.
## Architectural Tradeoffs
**Template app vs. blank app:** Template apps provide pre-built datasets and dashboards for common use cases (Sales, Service) but include unused assets that consume dataflow/recipe run quota. Blank apps require more initial setup but produce a leaner, purpose-built analytics solution. For proof-of-concept or standard use cases, templates are faster; for custom or complex reporting, blank apps with hand-crafted recipes are more maintainable.
**Recipe vs. dataflow:** Data Prep recipes are admin-friendly with a visual canvas but have fewer node types than dataflows. Dataflows (JSON) support more transformation types and are required for complex multi-object joins or computeRelative expressions. Recipes are the preferred starting point; escalate to dataflows only when recipes cannot achieve the required transformation.
## Anti-Patterns
1. **Stopping at permission set assignment** — Granting a CRM Analytics permission set without also configuring app sharing and row-level security produces blank apps from the user's perspective. All three security layers must be configured.
2. **Using connected objects as datasets** — Connecting Data Sync to a Salesforce object produces a connected object (staging replica), not a dataset. Attempting to create a lens or dashboard step directly on a connected object fails. Connected objects must be materialized into a registered dataset via a recipe or dataflow.
3. **Relying on faceting for cross-dataset filtering** — Building dashboards that mix datasets and expecting faceting to propagate filters across them. Faceting is dataset-scoped. Cross-dataset filtering requires bindings.
## Official Sources Used
Read for this revision (2026-10-03):
- Analytics Platform Setup Guide (Spring '26): https://resources.docs.salesforce.com/262/latest/en-us/sfdc/pdf/bi_admin_guide_setup.pdf. App access note (Viewer access), Data Sync limits, Recipe and Dataflow limits, Lens and Dashboard limits, Sales and Service Analytics app limits.
- Analytics Security Implementation Guide (Spring '26): https://resources.docs.salesforce.com/262/latest/en-us/sfdc/pdf/bi_admin_guide_security.pdf. Security predicates (editing on the dataset, no-RLS warning, predicate syntax and 5,000-character limit), sharing inheritance (time trade-off, backup predicate, Setup and Data Manager steps).
- CRM Analytics REST API Developer Guide (Summer '26): https://resources.docs.salesforce.com/262/latest/en-us/sfdc/pdf/bi_dev_guide_rest.pdf. Replicated Dataset Resources (connected objects as a cache), Dataset Versions List Resource, Security Coverage Dataset Version Resource.
- Analytics Dashboard JSON Developer Guide (Summer '26): https://resources.docs.salesforce.com/262/latest/en-us/sfdc/pdf/bi_dev_guide_json.pdf. `dataSourceLinks` and cross-dataset faceting pointer, `broadcastFacet`, `receiveFacetSource`, bindings.
- Metadata API Developer Guide, Version 67.0: https://resources.docs.salesforce.com/262/latest/en-us/sfdc/pdf/api_meta.pdf. WaveApplication, WaveDashboard, WaveDataset, WaveLens, WaveRecipe, WaveDataflow, FolderShare.
Listed in the original version and not re-read:
- CRM Analytics REST API Developer Guide (atlas page), https://developer.salesforce.com/docs/atlas.en-us.bi_dev_guide_rest.meta/bi_dev_guide_rest/bi_rest_overview.htm (same guide read as PDF above).
- Trailhead Quick Start: Create an App and a Lens, https://trailhead.salesforce.com/ (page retired).
- Salesforce Help: Connect and Sync Your Data to CRM Analytics, https://help.salesforce.com/s/articleView?id=sf.bi_integrate_connecting_to_salesforce.htm&type=5 (Salesforce Help does not fetch).
- Salesforce Help: Add Row-Level Security with a Security Predicate, https://help.salesforce.com/s/articleView?id=sf.bi_security_dataset_predicate.htm&type=5 (same content read in the Security Guide PDF).
- Salesforce Well-Architected Overview, https://architect.salesforce.com/docs/architect/well-architected/guide/overview.html
- Object Reference, https://developer.salesforce.com/docs/atlas.en-us.object_reference.meta/object_reference/sforce_api_objects_concepts.htm
- Metadata API Developer Guide (atlas page), https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_intro.htm
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics. | Stars: 472k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |