Track user acquisition source data from Google Analytics: Overview

Note: The process below does not support GoogleUniversal Analytics.

The ability to segment your data by user acquisition source is critical to effectively managing your marketing plan. Knowing the acquisition source of new users shows which channels yield the top returns, and allows your team to allocate marketing dollars with confidence.

If you are not already tracking user acquisition sources in your database, RJMetrics can help you get started: 

Tracking user acquisition source

We recommend two methods to track referral source data based on your setup:

(Option 1)  Track order referral source data via Google Analytics E-Commerce (Including Shopify Stores)

If you leverage Google Analytics E-Commerce to track your order and sales data, you can leverage our GA E-Commerce Connector to sync each order's referral source data. This will allow you to segment revenue and orders by referral source (e.g. utm_source, utm_medium, etc.) and also get a sense of customer acquisition sources via RJMetrics custom dimensions such as "User's first order source".

Note for Shopify users: Please turn on GA E-Commerce tracking in Shopify before connecting your GA E-Commerce account to RJMetrics.

(Option 2) Saving Google Analytics acquisition source data in your database

In this article we will explain how to save Google Analytics (GA) acquisition channel information into your own database - namely the sourcemediumtermcontentcampaign, and gclid parameters that were present on a user's first visit to your website. For an explanation of these parameters, check out the Google Analytics documentation. Then, we will explore some of the powerful marketing analyses that can be performed with this information in RJMetrics.

Why?

If you're just looking at the default Google Analytics conversion and acquisition metrics, you aren't getting the whole picture. While seeing the number of conversions from organic search versus paid search is interesting, what can you do with that information? Should you spend more money on paid search? That depends on the value of customers coming from that channel, which is not something Google Analytics provides. [Note: Google Analytics eCommerce Tracking does mitigate this problem by storing transaction data in GA, but this solution doesn't work for non-eCommerce sites, and certain tools like cohort analysis are not easy to do in the GA interface].

What if you want to email a follow-up deal to all customers acquired from a certain e-mail campaign? Or integrate acquisition data with your CRM system? This is impossible in GA - in fact, it is against the Terms of Service for Google Analytics to store any data that identifies an individual.  But that doesn't mean you can't store this data yourself.

The Method

Google Analytics stores visitor referral information in a cookie called __utmz. After this cookie is set (by the Google Analytics tracking code), its contents will be sent with every subsequent request to your domain from that user. So in PHP, for example, you could check out the contents of $_COOKIE['__utmz'] and you would see a string that looks something like this:

 

100000000.12345678.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=rj metrics

 

There is clearly some acquisition source data encoded into the string, and we tested to confirm that this is the visitor's latest acquisition source and associated campaign data. Now we just need to know how to extract the data. Luckily, Justin Cutroni has previously described how this encoding works, and shared some javascript code to extract the key bits of information.

We took this code and translated it into a PHP library hosted on github.   To use the library, include a reference to ReferralGrabber.php and then call

 

$data = ReferralGrabber::parseGoogleCookie($_COOKIE['__utmz']);

 

The returned $data array will be a map of the keys sourcemediumtermcontentcampaigngclid and their respective values.

We recommend adding a new table to your database called, for example, user_referral, with the columns like: id INT PRIMARY KEY, user_id INT NOT NULL, source VARCHAR(255), medium VARCHAR(255), term VARCHAR(255), content VARCHAR(255), campaign VARCHAR(255), gclid VARCHAR(255). Whenever a user signs up, grab the referral information and store it to this table.

How to use this data

Now that we're saving user acquisition source, how can we use it?

Lets suppose we are using a SQL database and have a users table with the following structure:

 

IDEMAILJOIN_DATEACQ_SOURCEACQ_MEDIUM
1 john@abc.com 2012-01-24 google organic
2 jim@abc.com 2012-01-24 google cpc
3 joe@def.com 2012-01-25 direct -
4 jess@ghi.com 2012-01-26 referral techcrunch.com
5 jen@ghi.net 2012-01-30 other organic
... ... ... ... ...

 

For starters, we can count the number of users coming from each referral channel by running the following query against your database:

 

SELECT acq_source, COUNT(id) as user_count FROM users GROUP BY acq_source;

 

The result will look something like this:

 

ACQ_SOURCEUSER_COUNT
google 294
direct 156
referral 55
other 16

 

This is interesting, but of limited use. What we would really like to know is the growth rate of these numbers over time, the amount of revenue generated by each acquisition source, a cohort analysis of users coming from each source, and the probability that a user from one of these channels will return as a customer in the future. The queries required to do these analyses are complex - which is why we built RJMetrics. Armed with this information we can determine our most profitable acquisition channels and focus our marketing time and money accordingly.

Related

 

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Thomas Pool

    Is it possible to do this if your data source is Shopify?

  • Avatar
    Sharon Nguyen

    Hi Thomas,

    You could potentially save the the source data, and tag your customers via the API.  Please see the following documentation from Shopify!:

     

  • Avatar
    Sharon Nguyen

    Hi Thomas,

    Please see the updated article, option (2), in order to track order referral source data via Google Analytics eCommerce!

    Thanks,

    Sharon

  • Avatar
    Rob Caruk

    Where can I find the Acquisition Source Grabber extension? It seems to be missing from Magento Connect.

Please sign in to leave a comment.