{
    "product": "reference_territory_pilot_profiles",
    "status": "profile_builder_ready",
    "generated_at": "2026-07-07T22:13:12+00:00",
    "schema_count": 16,
    "output_count": 3,
    "rule_count": 4,
    "builder": "scripts/build_reference_territory_pilot_profiles.php",
    "input_scores": "sources/reference-territory-kpi-scores.csv",
    "input_template": "sources/reference-territory-pilot-profiles-template.csv",
    "schema": [
        {
            "column": "territory_key",
            "description": "Cle territoire canonique."
        },
        {
            "column": "territory_label",
            "description": "Libelle public derive de la cle territoire."
        },
        {
            "column": "territory_grain",
            "description": "Maille du profil."
        },
        {
            "column": "profile_level",
            "description": "Niveau public du profil."
        },
        {
            "column": "profile_score",
            "description": "Score moyen des scorecards disponibles."
        },
        {
            "column": "confidence_score",
            "description": "Confiance moyenne des scorecards disponibles."
        },
        {
            "column": "scorecard_count",
            "description": "Nombre de scorecards disponibles."
        },
        {
            "column": "scorecards",
            "description": "Liste des scorecards incluses."
        },
        {
            "column": "sources",
            "description": "Sources contributrices."
        },
        {
            "column": "periods",
            "description": "Periodes sources."
        },
        {
            "column": "public_title",
            "description": "Titre public du profil."
        },
        {
            "column": "copy_headline",
            "description": "Phrase courte copiable."
        },
        {
            "column": "copy_block",
            "description": "Bloc public copiable."
        },
        {
            "column": "caveats",
            "description": "Caveats source consolides."
        },
        {
            "column": "next_action",
            "description": "Prochaine action publication."
        },
        {
            "column": "generated_at",
            "description": "Horodatage generation."
        }
    ],
    "outputs": [
        {
            "key": "profiles_csv",
            "path": "sources/reference-territory-pilot-profiles.csv",
            "description": "Profils pilotes selectionnes depuis les scores territoire."
        },
        {
            "key": "profiles_markdown",
            "path": "sources/reference-territory-pilot-profiles.md",
            "description": "Version markdown des 20 premiers profils pilotes."
        },
        {
            "key": "summary",
            "path": "sources/reference-territory-pilot-profiles-summary.csv",
            "description": "Resume de generation."
        }
    ],
    "rules": [
        {
            "key": "min_two_scorecards",
            "label": "Deux scorecards minimum",
            "rule": "Un profil pilote doit avoir au moins deux scorecards pour eviter une fiche mono-signal."
        },
        {
            "key": "confidence_visible",
            "label": "Confiance visible",
            "rule": "Le score moyen est toujours accompagne de la confiance moyenne."
        },
        {
            "key": "caveats_preserved",
            "label": "Caveats preserves",
            "rule": "Les caveats source sont conserves dans chaque profil."
        },
        {
            "key": "no_fake_name",
            "label": "Pas de nom invente",
            "rule": "Le libelle public reste derive de la cle territoire tant qu un referentiel nom n est pas branche."
        }
    ],
    "source_products": [
        "reference_territory_kpi_score_table",
        "reference_territory_scorecard_public_bundle",
        "reference_publishable_territory_page_pack"
    ],
    "publication_caveat": "Pilot profiles are generated from current local score outputs. They do not imply DB import, endpoint validation, verified public names or final publication approval."
}