Skip to content

PranavNagrecha/AwesomeSalesforceSkills / skills/admin/analytics-dataset-management

analytics-dataset-management

Verified

Use when creating or managing CRM Analytics datasets: configuring dataflows, scheduling refreshes, selecting fields, handling date types, managing row-count growth, or troubleshooting stale or broken datasets. Triggers: 'dataset creation', 'dataflow schedule', 'dataflow quota', 'date field not filterable', 'dataset row limit', 'CRM Analytics data refresh', 'field type mismatch in dataset'. NOT for making an existing dataset smaller or faster — use data/analytics-dataset-optimization. NOT for choosing between Reports, CRM Analytics and Tableau in the first place — use admin/einstein-analytics-basics.

templates/analytics-dataset-management-template.md

View on GitHub
# Analytics Dataset Management — Work Template

Use this template when building, updating, or troubleshooting a CRM Analytics dataset.

---

## Scope

**Skill:** `analytics-dataset-management`

**Request summary:** (describe what was asked — e.g., "Schedule nightly Opportunity dataset refresh" or "Fix CloseDate showing as Text in pipeline dataset")

---

## Context Gathered

Answer these before starting work:

| Question | Answer |
|---|---|
| How many dataflows and recipes are currently active in this org? | |
| What is the current estimated total runs per 24-hour window? | |
| Are there managed-package dataflows (Revenue Intelligence, Service Analytics, etc.)? | |
| Which Salesforce objects will feed this dataset? | |
| Which fields are Date or Datetime and must support SAQL filtering? | |
| What is the approximate row count per object per day? | |
| Is this a new dataset or a change to an existing one? | |
| Is the dataset currently append-mode or full-replace? | |

---

## Quota Assessment

Fill in before scheduling any new or changed dataflow:

| Dataflow Name | Runs per Day | Source |
|---|---|---|
| (existing custom flow 1) | | Custom |
| (existing custom flow 2) | | Custom |
| (managed package flows) | | Managed |
| **NEW: (this dataflow)** | | Custom |
| **Total** | | |

**Quota headroom:** `60 - [total] = [headroom]`

If headroom drops below 10, raise a scheduling concern before proceeding.

---

## Date Field Inventory

List every Date or Datetime field that will be loaded into the dataset:

| Field Name | Source Object | SAQL Usage (timeseries / filter / group-by) | Schema Node Added? |
|---|---|---|---|
| | | | [ ] |
| | | | [ ] |
| | | | [ ] |

---

## Dataflow Design

**Flow name:**

**Objects included:**

| Object | sfdcDigest Node Name | Fields Pulled |
|---|---|---|
| | | |
| | | |

**Transformation nodes (in order):**

1. `sfdcDigest` — (object name)
2. `schema` — date field type declarations
3. (additional augment/join/filter nodes if needed)
4. `sfdcRegister` — dataset name: ___________

**Dataset mode:** [ ] Full-replace  [ ] Append

If append-mode: rolling window filter: _______________________ (e.g., last 13 months on ActivityDate)

**Scheduled run window:** _____________ UTC

---

## Validation Steps

After the first successful run, confirm each item:

- [ ] Dataset appears in Data Manager with correct name and alias
- [ ] All date fields show column type `Date` (not `Text`) in the dataset column list
- [ ] Ran a test SAQL query with a date range filter — confirmed data returns correctly
- [ ] Ran a `timeseries` SAQL expression against at least one date field — confirmed non-empty result
- [ ] Dataset row count is within expected range
- [ ] For append-mode: trim filter is present and verified in the dataflow JSON
- [ ] Failure notification is configured in Data Manager > Notification Settings
- [ ] Dataflow owner and escalation contact are documented

---

## Row-Count Projection (for append-mode datasets)

| Metric | Value |
|---|---|
| Rows added per day (estimate) | |
| Rows after 6 months | |
| Rows after 12 months | |
| Org-wide current total rows | |
| Projected org total after 12 months | |
| Action required if > 400M org-wide? | |

---

## Notes

Record any deviations from the standard pattern and why:

(free text)
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 119kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall
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: 118kUpdated Claude CodeCodexVerifiedInstall