End-To-End Conversion Analysis with Google Analytics and Salesforce


Many business models in the online world face one challenge: the modelling of the complete conversion funnel. Through online marketing measures i come into first contact with my customers (Lead-Generation). But i only sell to them later offline – outside of the user session on my site. This poses a problem to most online Tracking tools. Only the first contact is tracked as a success, but not the actual transaction, that brings revenue for my company.

For example at smava.de my team and i had this problem: we were brokering consumer loans online. The customer had to fill out a long online form to apply for a loan. But the deal was only done after the customer also had registered with his local post office (postident) and sent in some papers, which only happened in a fraction of cases. In the tracking tool we could ony see the submitted applications (leads), but not the finally paid out loans (sales).

The setup

viessmann-logoWith a similar challenge German heating manufacturer Viessmann AG contacted us: via diverse online initiatives (e.g. the domain heizung.de) customers become aware of Viessmanns products und can request further information via an online form. This data is then pushed via Javascript to Salesforce, where a CRM Team picks up the Lead, qualifies it and hands it over to a local heating installer. When he does the sale, it becomes visible in Salesforce as well. But how can they now connect costly online marketing measures to the sales? Google Analytics reports the attribution of conversion events to campaigns, but no the sales.

Solution Approach

Our consulting approach aimed at the following solution: At the time of lead generation the websites pushes customer data to Salesforce. Simultaniously, Google Analytics registered a goal completion. The problem with this: Both events cannot be connected after the fact. Whats missing is a Unique identifier, that makes the event traceable in both systems. With the help of a small JS Script we generate the identifier (10digit alpha-numeric string) and push this together with the customer data both to Salesforce and to Google Analytics ecommerce tracking, which allows to collect the so called transactionid.

Salesforce Analytics Tracking Setup

This way, we can rejoin data from both worlds after the fact:
Google Analytics assigns every transactionid to a campaign and channel in a custom report:

ga_custom_report_def Analytics custom ecommerce report

Salesforce tracks all Leads and their status using the unique identifier. So, for each and every lead we can check if a sale happened.

Our tool setup followed: Applicata imports data from both systems and joins it in a meaningful way, to enable ROI analysis. Applicata comes with premade connectors to both Google Analytics and Salesforce, so implementation was a matter of days.

applicata etl setup


The Viessmann marketing team is now able to work with daily automated reports, that show sales success of individual campaigns. This way, on a daily basis, the team makes decisions about campaigns that are more profitable than other and allocates Budget optimally. In addition, based on the available data the CRM team creates Conversion reports, which it uses to monitor their performance and improve. Besides the team in Germany also Marketing staff from other EU countries uses applicata for their Reporting. Each country only has access to its own data.

Leave a Reply

Your email address will not be published. Required fields are marked *