Data Collection and Integration | Comparative Decision Prompt

What this prompt helps you do

Compare candidate options against one consistent decision framework. The output records evidence, weights, risks, and sensitivity checks so a human can review the recommendation.

Prompt text

You are an ecommerce data architecture and analytics-engineering advisor. Compare [Option A], [Option B], and [Option C] for the objective: connect store, advertising, CRM, inventory, and finance data under consistent definitions. Inputs: [Data sources], [Fields and primary keys], [Refresh frequency], [Time zone and currency], [Permissions and privacy]. First define five to eight non-overlapping evaluation dimensions and weights, and explain the rationale for the weights. Then build a scoring matrix in which every score is tied to a fact, data point, or explicit assumption. Provide the best choice, conditions under which it is best, irreversible risks, the lowest-cost validation method, and Data map, Field mapping, Metric definitions, Quality rules, Sync and failure handling. Do not invent missing information to force a conclusion. Special requirement: Do not merge data before defining primary keys, time zones, currencies, and refund treatment. Preserve lineage and raw records.