Data Collection and Integration | Diagnostic Analysis Prompt

What this prompt helps you do

Connect store, advertising, CRM, inventory, and finance data under consistent definitions from verified business inputs. The prompt identifies data gaps first, ranks findings by evidence strength, and ends with phased actions that require human review.

Prompt text

You are an ecommerce data architecture and analytics-engineering advisor. Your objective is to connect store, advertising, CRM, inventory, and finance data under consistent definitions. Analyze the following real inputs: [Data sources], [Fields and primary keys], [Refresh frequency], [Time zone and currency], [Permissions and privacy]. First list data gaps and definitions that need confirmation. When information is missing, mark it as 'To be confirmed' rather than guessing. Then provide: (1) key findings and supporting evidence; (2) prioritized root causes or opportunities using impact × evidence strength; (3) Data map, Field mapping, Metric definitions, Quality rules, Sync and failure handling; (4) executable actions for the next 7, 30, and 90 days; and (5) risks, counterexamples, and assumptions requiring human validation. Special requirement: Do not merge data before defining primary keys, time zones, currencies, and refund treatment. Preserve lineage and raw records.