Data Collection and Integration | Audit and Experimentation Prompt

What this prompt helps you do

Audit an existing page, process, dataset, or asset, separate facts from assumptions, and turn the highest-priority issues into tests with baselines, metrics, and stop conditions.

Prompt text

Act as a ecommerce data architecture and analytics-engineering advisor and audit the current [Page/Process/Data/Asset] related to the objective: connect store, advertising, CRM, inventory, and finance data under consistent definitions. Materials: [Data sources], [Fields and primary keys], [Refresh frequency], [Time zone and currency], [Permissions and privacy]. Classify findings as Blocking, Major, Moderate, or Optimization, and quote the evidence that triggers each finding. Provide: (1) an issue list; (2) Data map, Field mapping, Metric definitions, Quality rules, Sync and failure handling; (3) at least four improvements or experiments prioritized by impact versus effort; (4) for each experiment, the hypothesis, change, primary metric, guardrail metrics, observation period, and stopping rule; and (5) required human approvals before publishing or execution. Special requirement: Do not merge data before defining primary keys, time zones, currencies, and refund treatment. Preserve lineage and raw records.