User Tools

Site Tools


crm_attribution

This is an old revision of the document!


CRM Attribution

General Overview

This article will guide you on how to match the conversions from Google Analytics to your CRM data. As prerequisite you will need to have a common join key from both your GA and CRM data. A frequently used approach of bringing hashed email address into Google Analytics can be found in our article How to connect Google Analytics to your CRM system?. Of course if you already have a custom dimension in place with an identifier you can use this dimension for the join.

Sample query to get data from Salesforce

https://connectors.windsor.ai/salesforce?api_key=[your API key]&date_preset=last_7d&fields=contact_firstname,contact_lastname,contact_email,contact_phone 

Sample query to get data from HubSpot

https://connectors.windsor.ai/hubspot?fields=contact_firstname,contact_lastname,contact_email,contact_company,contact_phone,contact_lifecyclestage&api_key=[your API key]

The data can then be joined in SQL Lab with the data in the conversions table

crm_attribution.1625561355.txt.gz · Last modified: 2021/07/06 09:49 by windsor_ai