Articles & field feedback

Expertise & field insights

Technical articles and field experience on Adobe Campaign, Salesforce, Imagino and CRM integration. By Pierre Frin, independent CRM consultant.

Guide
Salesforce Marketing Cloud: the technical guide
The starting point: twelve field articles on data views, SQL, imports, AMPscript and consent.
September 2026Read →
fenêtre écrite dans la requête : 270 jours données réellement lues : 6 mois rien ici _Open chargée par Apple Mail _Click suivi par un antivirus abonné classé actif Marketing Cloud Engagement · data views système
Salesforce Marketing Cloud
Marketing Cloud data views: what they actually tell you
Six months of retention, a US time zone, opens loaded by Apple and clicks from antivirus software. What a data view lets you conclude, and what it …
September 2026 Read →
une même requête, trois résultats dans la table cible Overwrite vide la table, puis écrit même à zéro ligne Update met à jour et ajoute ne supprime jamais Append ajoute à la suite jamais de mise à jour adhérent à jour, relancé tous les matins Marketing Cloud Engagement · Query Activity
Salesforce Marketing Cloud
Overwrite, Update, Append: the SQL queries that succeed while writing the wrong data
The write mode of a Query Activity decides what stays in the target table. Picking the wrong one does not fail the automation: the gap shows up in …
September 2026 Read →
automation planifiée à 7 h, heure de Paris hiver · 7 h à Paris serveur : 0 h, jour J été · 7 h à Paris serveur : 23 h, jour J-1 CAST(GETDATE() AS DATE) comparé au jour de naissance anniversaires de la veille Marketing Cloud Engagement · heure système UTC-6, sans heure d'été
Salesforce Marketing Cloud
Dates and time zones in Marketing Cloud: why your birthday emails go out a day late
Marketing Cloud system time runs at UTC-6, with no daylight saving. A query that treats the server date as today's date in Paris gets it wrong for …
September 2026 Read →
durée d’une même requête, mois après mois 4 min 12 min 25 min limite 30 min activité interrompue volume de commandes multiplié par six · requête inchangée Automation Studio · Query Activity
Salesforce Marketing Cloud
Slow SQL in Marketing Cloud: staying under the 30 minute limit
A Query Activity stops after 30 minutes, with no execution plan and no index to create. How to measure, rewrite the conditions and split a query th…
September 2026 Read →
douze mois d’événements d’envoi hors fenêtre données perdues si rien n’a été copié _Sent · _Open · _Click six mois, fenêtre glissante Historique_Envois · Historique_Ouvertures · Historique_Clics aujourd’hui
Salesforce Marketing Cloud
Keeping data view history beyond six months
Marketing Cloud data views only go back six months. How to build a history of sends, opens and clicks that survives reruns, pauses and late events.
September 2026 Read →
quatre sources, une table, une population R1 statut R2 désabo BU R3 plaintes R4 hard bounces R5 Exclusions un motif, une date R6 clics humains R7 score R8 Population_A_Reactiver envoi et export lisent cette table Marketing Cloud Engagement · une requête par étape, toutes en Overwrite
Salesforce Marketing Cloud
Eight ready-to-use SQL queries for Marketing Cloud
Consolidated exclusions, human clicks, engagement scoring and a reactivation audience: eight annotated queries to drop straight into your Marketing…
September 2026 Read →
un client sans conseiller, deux issues envoi de 400 000 rendu en cours RaiseError(msg) job arrêté, 0 email parti RaiseError(msg, true) un destinataire écarté, l'envoi continue journal Marketing Cloud Engagement · AMPscript · garde-fous d'envoi
Salesforce Marketing Cloud
RaiseError: skipping one recipient without stopping 400,000 emails
In Marketing Cloud Engagement, RaiseError halts the whole send by default. How to skip a single recipient, keep a record of the ones you drop, and …
September 2026 Read →
trois fonctions, trois garanties Lookup une valeur, une ligne quelconque à réserver aux clés uniques LookupRows un rowset sans ordre garanti 2 000 lignes au plus LookupOrderedRows le tri que vous demandez le nombre de lignes voulu Row(rowset, 1) est la première ligne · RowCount borne la boucle Marketing Cloud Engagement · AMPscript · lecture de data extensions
Salesforce Marketing Cloud
Lookup, LookupRows, LookupOrderedRows: picking the right function
Three AMPscript functions that look alike, three different guarantees on order, case and volume. How to choose, how to walk a rowset, and where the…
September 2026 Read →
barre d'adresse de la page de coordonnées /coordonnees?id=482173 un chiffre modifié /coordonnees?id=482174 coordonnées d'un autre adhérent Marketing Cloud Engagement · CloudPages · violation de données personnelles
Salesforce Marketing Cloud
CloudPages: the URL parameter that exposes your customers' data
A plain identifier in the address of a CloudPage is enough to browse a customer file. How to build an encrypted link, check access at the top of th…
September 2026 Read →
un seul lien dans le pied de page Me désabonner CloudPage passerelle de sécurité GET automatique clic humain POST du formulaire désabonné choix daté Marketing Cloud Engagement · CloudPages
Salesforce Marketing Cloud
Preference centre and GDPR: when antivirus gateways unsubscribe your customers
An unsubscribe page that acts on load ends up obeying security gateways. How to build a Marketing Cloud preference centre that writes only on POST …
September 2026 Read →
fichier des résiliés, dépôt du mardi 14 lignes au lieu de 9 000 IMPORT Overwrite table de production relance envoyée aux contrats résiliés statut de l'automation : exécution réussie Automation Studio · exécution quotidienne de 5 h
Salesforce Marketing Cloud
Automation Studio: the import that chased 9,000 former customers
A file with 14 rows instead of 9,000, an Overwrite import onto the production table, and an automation showing green. How to place volume checks be…
September 2026 Read →
une seule personne lea.martin@example.com cliente depuis 2021 SubscriberKey = CLI-88421 statut : désabonnée SubscriberKey = lea.martin@… statut : active envoi parti Marketing Cloud Engagement · All Subscribers
Salesforce Marketing Cloud
Subscriber Key : pourquoi un désabonné continue de recevoir vos emails (FR)
Une même adresse sous deux clés, ce sont deux personnes : détecter les doublons en SQL, bloquer les envois, corriger la source.
September 2026 Read →
source.csv 412 Mo ✓ ⚡ destination.csv 412 Mo ✓ mais tronqué Vérif : ✓ Data : ✗ SFTP . AZURE BLOB . INTÉGRITÉ . CRM
CRMAdobe CampaignSalesforceInfrastructure
Silent corruption: why checking file size is not enoughNew
A truncated file can pass all size checks and silently corrupt your CRM data. Field feedback on SFTP, Azure Blob, Adobe Campaign Datahub and Salesforce Data Cloud.
September 2026 Read →
Bonjour, je suis une IA. Article 50, AI Act Applicable depuis le 2 août 2026 Adobe Campaign : 0 fonctionnalité native Salesforce : 0 fonctionnalité native AI ACT . ARTICLE 50 . CRM . CHATBOT . CONFORMITÉ 2026
CRMAI Act
AI Act Article 50 and CRM: what teams need to do nowNouveau
Since 2 August 2026, your customer service chatbots must identify themselves as AI. Neither Adobe Campaign nor Salesforce handle this natively. Practical guide.
September 2026 Read →
Metier Urgence CNIL PO / PM Roadmap gelee Dev CRM 6 semaines de dev Recommandation CNIL Consentement pixel obligatoire Applicable : 14 juillet 2026 Adobe + Salesforce : zero natif CNIL . PIXEL TRACKING . GESTION DE CRISE CRM . IMPLEMENTATION
CRMRGPD
Email tracking pixel: organisational crisis, silent tools and CRM implementation
CNIL 2026 triggered a crisis in CRM teams. Neither Adobe Campaign nor Salesforce do anything natively. Complete guide.
July 2026 Read →
(FR)
TEST ENV Données anonymisées Base whitelistée QA / STAGING Recette métier Validation approbation PRODUCTION Base réelle 27 000 000 contacts Sauter les étapes = Test en prod à 27M clients QA · TEST · STAGING · PRODUCTION · CRM
CRMQA
CRM QA and environments: best practices that prevent production disasters
Test/production separation, approval workflow: everything a CRM project must have before touching production.
June 2026 Read →
(FR)
Dev Sandbox Full Sandbox Staging / UAT Production SALESFORCE · DEPLOYMENT · SFDX
Salesforce
Deploying on Salesforce without breaking everything: Change Sets, SFDX and best practices
Change Sets or SFDX/CLI? Classic mistakes before a go-live and the deployment checklist.
June 2026 Read →
(FR)
Dev Recette ⚠ Trop courte Production Bug en prod SALESFORCE · RECETTE · QUALITE
Salesforce
Why Salesforce projects fail their UAT, and how to avoid it
UAT too short, wrong people testing, acceptance criteria undefined. The 5 systematic mistakes.
June 2026 Read →
(FR)
Sales Cloud Opportunites · Pipeline Leads · Forecasting vs Service Cloud Cases · Knowledge SLA · Omni-Channel SALESFORCE · LICENCES · ARCHITECTURE
Salesforce
Sales Cloud vs Service Cloud: what nobody tells you before you sign
Real differences, licences, retrofitting cost, decision grid. Everything a CIO needs to know before choosing.
June 2026 Read →
(FR)
POSTURE · CONSULTANT · CRM
CRMConsulting
The CRM consultant's posture when facing client resistance
When the client decides the opposite of your recommendation. How to hold your position without losing the relationship.
June 2026 Read →
Salesforce Sales Cloud Data Cloud Unification · Activation Salesforce CDP Snowflake Data Warehouse ZERO-COPY · DATA SHARE · NEAR REAL-TIME Ingestion Data Share
SalesforceCRM
Salesforce Sales Cloud and Snowflake: how to synchronise in 2026
Zero Copy, Data Cloud, native connectors vs ETL. Synchronisation options and trade-offs.
May 2026 Read →
Apex CODE · COMPLEXE Flow NO-CODE · STANDARD Process Builder DÉPRÉCIÉ LOGIQUE COMPLEXE · TESTS · BULKIFICATION AUTOMATISATION · DÉCLARATIF · 2024+ FIN DE SUPPORT ANNONCÉE
Salesforce
Apex vs Flow vs Process Builder: which to choose in 2026?
Process Builder is deprecated. Between Apex and Flow, the choice depends on complexity and available skills.
May 2026 Read →
Salesforce Sales Cloud Platform Events pub/sub · asynchrone Outbound Messages SOAP · workflow Webhooks (Apex) HTTP · custom Subscriber (ESB · MQ · App) Endpoint SOAP (Système tiers) Endpoint HTTP (REST · custom) Garanties de livraison PE : 72h rétention, at-least-once OM : retry natif Salesforce WH : aucune garantie native SALESFORCE · INTÉGRATION TEMPS RÉEL
Salesforce
Salesforce Platform Events, Outbound Messages and webhooks
When to use Platform Events vs Outbound Messages vs webhooks? Use cases, limits and pitfalls.
May 2026 Read →
Utilisateur Profil Rôle Permission Set 1 Permission Set 2 Perm. Set Group + additive Sharing Rules Visibilité des enregistrements SALESFORCE · SÉCURITÉ & HABILITATIONS
Salesforce
Salesforce profiles, roles, permission sets and sharing rules
How Salesforce manages access rights. The difference between profiles, roles, permission sets and sharing rules.
May 2026 Read →
SOQL Queries 80% DML Statements 95% CPU Time 50% 100 SOQL max 150 DML max 10k SOQL rows 10s CPU Apex sync System.LimitException: Too many SOQL queries: 101 SALESFORCE · GOVERNOR LIMITS · APEX
Salesforce
Salesforce Governor Limits: understanding and anticipating the caps
Governor Limits hit without warning. How to identify, work around them and architect your code.
May 2026 Read →
V7 CLASSIC V8 CLASSIC On-premise FDA · FFDA CHECKLIST MIGRATION Audit des schémas de données Révision des workflows techniques Tests de charge et non-régression Plan de rollback
Adobe CampaignCRM
Migrating Adobe Campaign Classic V7 to V8: complete guide
FDA, FFDA, Snowflake, workflows to review: everything to anticipate before migrating.
May 2026 Read →
imagino CDP CRM E-commerce Web / App Segmentation Campagnes Analytics SOURCES DE DONNÉES ACTIVATION
CRMImagino
Imagino CDP: technical deployment and CRM integration
Architecture, connectors, use cases and field feedback on deploying Imagino in a CRM context.
May 2026 Read →
Client Django (hébergé client) Interface préférences ☑ opt-in email ☑ opt-in SMS ConsentLog email · nom · prénom optin_email · optin_sms post_save signal API Python POST /consents imagino Tables standard optin_email ✓ optin_sms ✓ Table custom errorLogConsentAPI error_code · error_msg resolved · created_at si erreur → HÉBERGÉ CHEZ LE CLIENT IMAGINO (SaaS)
CRMImagino
Python Django API and Imagino: consent management
How to connect a Django API to Imagino to centralise consent management.
May 2026 Read →
Workflow technique ⚙ SQL JS Administration Planifié · Permanent · Infrastructurel VS Workflow de campagne Cible Filtre Diffusion Ciblage · Envoi · Marketing
Adobe Campaign
Technical workflow vs campaign workflow in Adobe Campaign
When to use a technical workflow rather than a campaign workflow? Behaviour, logs and execution.
May 2026 Read →
broadLogRcp Envois · Statuts · Erreurs trackingLog Ouvertures · Clics · Web auditTrail Modifications · Droits wfLog Workflows · Erreurs Adobe Campaign Classic (ACC) LOGS DIFFUSION LOGS SYSTÈME
Adobe Campaign
Reading and using Adobe Campaign Classic logs
iStatus, iErrorCode, broadLogRcp: how to read delivery logs to diagnose errors and optimise deliverability.
May 2026 Read →
Adobe Campaign Classic (ACC) API REST/SOAP Workflow technique ESB MDM Snowflake Data Warehouse FDA / FFDA ADOBE CAMPAIGN CLASSIC SYSTÈMES TIERS DATA PLATFORM
Adobe Campaign
Adobe Campaign integration: API vs technical workflows
REST API or technical workflow? The latency criterion, use cases and pitfalls to avoid.
May 2026 Read →