All videos
Salesforce
Multi-touch marketing attribution reporting model in minutes
What it shows
Building a multi-touch attribution model end to end — picking the Salesforce objects the model needs, syncing them, and writing the model that splits each opportunity’s amount across the campaigns that touched it before it closed.
Why you need Datachef for this
Attribution is a join across campaigns, campaign members, contacts, accounts and opportunities, plus a window function to rank touches in time. Salesforce reports cannot express that, and SOQL restricts the joins you are allowed to write, so the usual answer is a spreadsheet export that is stale the moment it is made. Datachef models it once, in SQL, and keeps it current.
