What the Product data model and PIM audit prompt does

Act as a product-information architecture and data-governance auditor.

The prompt will, at minimum:

  • Validate the supplied datasets, definitions, time window, market scope and source-of-truth ownership before assessing product data model and pim audit
  • Examine entity model, identifiers, taxonomy, attributes, localisation, variants, relationships, validation, completeness, lineage, workflows, roles, ERP/PIM/channel integrations and change governance; retain original record identifiers and show how each finding was derived
  • Segment results only where the data supports the split; expose missingness, sample bias, seasonality, policy changes, promotions, migrations and other confounders rather than hiding them in averages
  • Recompute every material metric from supplied values, disclose formulas, denominators, exclusions and scenario assumptions, and never invent benchmarks or competitor performance
  • Turn the evidence into a target data model, ownership matrix and staged remediation plan; assign owner, priority, dependency, expected signal, verification method and human-approval point to each action

Who it is for

Gökhan Güzel's e-commerce prompt for ChatGPT users: marketers, founders, agencies and consultants who need an auditable, evidence-based deliverable instead of generic advice.

What you get

  • Executive summary and data-quality report
  • Product data model and PIM audit methodology and evidence ledger
  • Segmented findings, calculations and scoring
  • Prioritised action backlog with owners and validation criteria
  • Sources, limitations, confidence and QA report

Variables

PlaceholderPurpose
{{attribute_dictionary}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{brand_name}}Verified identifier or text value; state exact spelling, source, status and validity scope
{{channel_list}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{commerce_platforms}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{data_quality_exports}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{erp_system}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{governance_roles}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{identifier_rules}}Approved rule, policy or constraint; state owner, version, scope, jurisdiction and effective date
{{integration_map}}Structured dataset or source file; state fields, data types, period, units, currency, time zone and provenance
{{pim_system}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{product_schema}}Verified identifier or text value; state exact spelling, source, status and validity scope
{{success_metrics}}Numeric value or table; state formula, numerator, denominator, unit, currency, tax treatment, period and source
{{taxonomy}}Required input value; state source, data type, format, unit, period, market and locale where applicable
{{variant_model}}Required input value; state source, data type, format, unit, period, market and locale where applicable

How to use

Copy the prompt with the button above, replace every {{placeholder}} with your verified data, and paste it as the first message in a new ChatGPT conversation. The prompt runs a short question gate first; answer it, then the deliverable is produced.

Run Product data model and PIM audit in ChatGPT

Open a new ChatGPT chat, paste the filled-in Product data model and PIM audit prompt and answer the short question gate. ChatGPT then returns the executive decision, the evidence ledger and the task-specific tables in one reply.

Source

Original file in the multilingual prompt library on GitHub: