[{"id":5,"city_slug":"castres","city_name":"Castres","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":9,"city_slug":"laval","city_name":"Laval","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":2,"city_slug":"montpellier","city_name":"Montpellier","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":6,"city_slug":"orleans","city_name":"Orléans","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":7,"city_slug":"pau","city_name":"Pau","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":3,"city_slug":"perpignan","city_name":"Perpignan","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":1,"city_slug":"poissy","city_name":"Poissy","status":"terminé","brand_name":"L'Écho de Poissy","tagline":"Poissy, vu d'ici","short_description":"Votre newsletter locale gratuite. L'essentiel de la vie pisciacaise, chaque semaine dans votre boîte mail.","tone_description":"Semi-formel, chaleureux et ancré. Comme un voisin bien informé qui vous raconte ce qui se passe en ville. Vouvoiement. Humour léger et pince-sans-rire. Curieux, bienveillant, fier sans chauvinisme.","tone_good_examples":"• \"Le marché de Poissy a un nouveau fromager. On y est allé, on a goûté, on vous raconte.\"\n• \"Si vous êtes passé devant la Collégiale cette semaine, vous avez peut-être remarqué les échafaudages. Voici ce qui se prépare.\"\n• \"Le pont sur la Seine va être en travaux tout l'été. Voici les alternatives pour ne pas perdre 45 minutes chaque matin.\"\n• \"Trois restos ont ouvert en centre-ville ce mois-ci. On fait le point.\"\n• \"La Villa Savoye accueille une expo temporaire qui vaut le détour — même si vous l'avez déjà visitée cinq fois.\"\n• \"Le budget de la ville vient d'être voté. On a épluché les chiffres pour vous.\"\n• \"Ce week-end à Poissy : une brocante, un concert gratuit, et le retour du vide-grenier de l'île de la Loge.\"","tone_bad_examples":"• \"INCROYABLE !!! Le marché de Poissy va vous CHOQUER 🤯🔥\" (racoleur/clickbait)\n• \"La municipalité a une fois de plus démontré son incompétence flagrante.\" (trop éditorialisant)\n• \"Nous vous informons par la présente que des travaux de réfection du pont seront entrepris…\" (trop administratif)\n• \"Poissy, joyau des Yvelines, perle de la Seine…\" (trop promotionnel/office de tourisme)\n• \"Alors les gars, ça déchire ce nouveau resto !!\" (trop familier)\n• \"Breaking news : un chat a été retrouvé rue du Pain.\" (anglicisme + insignifiant)\n• \"Selon nos sources proches du dossier, des manœuvres seraient en cours…\" (ton grand média national)","tone_rules":"• Phrases courtes : 15-20 mots max en moyenne\n• Paragraphes courts : 2-3 phrases max\n• Voix active toujours\n• Concret avant abstrait : faits d'abord, analyse ensuite\n• Utiliser les noms que les habitants utilisent (\"le marché\", \"la Collégiale\")\n• Toujours citer d'où vient l'info\n• Vouvoiement systématique","color_primary":"#1B4F72","color_secondary":"#C0392B","color_accent1":"#D4A017","color_accent2":"#27AE60","color_accent3":"#7F8C8D","color_background":"#FAFAFA","color_text":"#2C3E50","typo_heading":"Source Serif 4","typo_body":"Inter","typo_heading_size":36,"typo_body_size":17,"illustration_description":"Illustrations vectorielles semi-flat avec des détails fins, style \"editorial illustration\" moderne. Ambiance chaleureuse, lignes épurées, palette limitée aux couleurs de la charte. Pas de photoréalisme, pas de clipart, pas de cartoon exagéré.","illustration_ai_prompt":"Editorial illustration in a semi-flat vector style with subtle texture and fine line details. Warm and inviting palette using deep blue (#1B4F72), brick red (#C0392B), golden (#D4A017), and soft green (#27AE60) on a light cream background. Clean composition with architectural elements from a French riverside town: Gothic church spires, modernist architecture, tree-lined parks, river views. Style inspired by Monocle magazine illustrations and French editorial art. No text, no watermark. Aspect ratio 16:9.","illustration_gallery":[],"illustration_local_elements":["Collégiale Notre-Dame","Villa Savoye (Le Corbusier)","Seine et berges","Vieux pont de Poissy","Marché de Poissy","Parc Meissonier","Île de la Loge","Prieuré royal"],"illustration_colors":["#1B4F72","#C0392B","#D4A017","#27AE60","#FAFAFA"],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":"1. OBJET DU MAIL (< 50 caractères)\n2. HEADER (logo + date + numéro)\n3. ÉDITO / ACCROCHE (2-3 phrases)\n4. L'ESSENTIEL (3-5 actus majeures, 100-150 mots chacune)\n5. EN BREF (3-5 brèves de 30-50 mots)\n6. LE BON PLAN (1 recommandation)\n7. L'AGENDA (événements de la semaine à venir)\n8. FOOTER (liens, désabonnement, info légale)","newsletter_target_length":"800-1200 mots, 4-6 minutes de lecture","newsletter_frequency":"Hebdomadaire, mardi 7h30","newsletter_subject_examples":["Nouveau resto en centre-ville, travaux du pont, expo à la Villa Savoye","Le budget 2026 de Poissy décrypté","Ce week-end à Poissy : 5 idées de sorties","Le marché de Poissy change d'horaires","3 ouvertures, 1 fermeture, et une bonne surprise","Rentrée à Poissy : ce qui change"],"newsletter_footer":"L'Écho de Poissy — Poissy, vu d'ici.\nVotre newsletter locale, chaque mardi.\n\n📩 Une info, une réaction ? Répondez à ce mail.\n🔗 lechodepoissy.fr\n\nL'Écho de Poissy fait partie du réseau Brève.","social_bio_instagram":"📰 L'Écho de Poissy\nPoissy, vu d'ici.\nL'essentiel de votre ville, chaque semaine.\n🔗 lechodepoissy.fr","social_bio_facebook":"L'Écho de Poissy — Poissy, vu d'ici.\nVotre newsletter locale gratuite. L'essentiel de la vie pisciacaise, chaque semaine dans votre boîte mail.\n📩 Inscription : lechodepoissy.fr","social_frequency":"3-4 posts/semaine Instagram, 2-3 posts/semaine Facebook","social_hashtags":["#Poissy","#Yvelines","#LechodePoissy","#VieLocale","#IleDeFrance","#ActuLocale","#Pisciacais","#BorddeSeine"],"social_tone":"Légèrement plus décontracté que la newsletter. Vouvoiement maintenu. Tournures plus directes : \"Ça se passe ce week-end\", \"On vous en dit plus dans la newsletter\".","website_style_notes":"Mobile-first. Fond Blanc Craie (#FAFAFA). Header Bleu Seine (#1B4F72) avec logo blanc. Boutons Terre de Poissy (#C0392B), coins arrondis 8px. Contenu centré, largeur max 680px pour la lecture. Animations minimales.","website_structure":"ACCUEIL : Hero (nom + tagline + inscription email) → Dernière newsletter → 3 articles récents → Témoignages → CTA inscription\nARCHIVES : Liste newsletters + filtres + recherche\nÀ PROPOS : Qui sommes-nous + Contact + Mentions légales","created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-04-01T07:50:59.203Z"},{"id":4,"city_slug":"rennes","city_name":"Rennes","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":8,"city_slug":"troyes","city_name":"Troyes","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"},{"id":10,"city_slug":"valence","city_name":"Valence","status":"à faire","brand_name":null,"tagline":null,"short_description":null,"tone_description":null,"tone_good_examples":null,"tone_bad_examples":null,"tone_rules":null,"color_primary":"#0f1a2e","color_secondary":"#e8734a","color_accent1":"#f0956f","color_accent2":"#fdf6f0","color_accent3":"#64748b","color_background":"#ffffff","color_text":"#1a1a1a","typo_heading":"Inter","typo_body":"Inter","typo_heading_size":32,"typo_body_size":16,"illustration_description":null,"illustration_ai_prompt":null,"illustration_gallery":[],"illustration_local_elements":[],"illustration_colors":[],"logo_main_url":null,"logo_favicon_url":null,"newsletter_structure":null,"newsletter_target_length":null,"newsletter_frequency":null,"newsletter_subject_examples":[],"newsletter_footer":null,"social_bio_instagram":null,"social_bio_facebook":null,"social_frequency":null,"social_hashtags":[],"social_tone":null,"website_style_notes":null,"website_structure":null,"created_at":"2026-03-31T09:46:08.227Z","updated_at":"2026-03-31T09:46:08.227Z"}]