This site uses cookies and other tracking technologies to make possible your usage of the website, assist with navigation and your ability to provide feedback, analyse your use of our products and services, assist with our promotional and marketing efforts, and provide better user experience.

By using the website, you agree to our Privacy policy

Accept and continue

Report a bug

5886 10
PPC 8 min read October 11, 2017

How To Marry Up Your CRM With Google Analytics

10 Black Hat SEO Techniques to Kill Your Search Engine Visibility

Marina Prihodko
Senior Web Analyst at OWOX
Your company's internal database, such as an ERP or CRM system, may store a lot of valuable information that you can use to increase sales.

In this post, I'll cover how you can benefit from combining the data from your CRM system with the user behavior data from your website.

What is there in your CRM and ERP systems that is missing in Google Analytics?

#1: Detailed information about your customers

Firstly, CRM systems can be used to store the detailed information about your customers: their gender, age, interests, marital and parental statuses, pets, car ownerships, and a lot more.

One could argue that Google Analytics also provides information about the age, gender, and interests of website visitors. That's true, but this information isn't bound to a particular user, their Client ID or User ID. In addition, you can use the information in your internal system for RFM analysis and create customer segments based on the recency of their latest purchase, buying frequency, and the total amount of money spent by each customer.

The additional data about the customers and the results of RFM analysis can be sent to Google Analytics and used to create new custom reports, segments, and remarketing audiences.

For example: you can offer a loyalty program or special discounts to your best customers who buy often and spend a lot; send out some interesting promo emails to return those who haven't bought from you for a while; and offer accessory products to those who often make small purchases. Speaking of segments, take a look at how boodmo, India's largest online marketplace for auto components, managed to optimize advertising spend and improve the LTV thanks to cohort analysis.

#2: Detailed info about the products you're selling

Your CRM also stores the detailed information about the products you're selling: internal classification that is often different from the one you have on the website, suppliers for particular items, and other product specifications. By adding this data to your Google Analytics reports, you'll be able to track, for example, how many purchases you're getting for products from each particular supplier, via different traffic sources.

It's also clear that you're not showcasing your product margins on the website. However, having this information brought into Google Analytics and structured in reports, you'll be able to quickly compare profits with revenues and understand which channels are driving the most profitable traffic.

It's also important to remember that the information about purchases in Google Analytics may not coincide with the information in your ERP system. This happens because Google Analytics doesn't provide any information about order cancellations, returns, offline transactions and purchases made over the phone. Also, Google Analytics may fail to track some of the purchase and transaction data on website pages, because of the JavaScript not rendered in the browser.

If sent from the CRM directly into Google Analytics, this data may be distorted, as Google Analytics doesn't support data reprocessing. In other words, once the data is processed, it cannot be modified — you can't change any numbers or add transactions from previous periods.

Sending data about customers and margins into Google Analytics directly from your website is not the best option either, and here's why:
Business information from your internal system may be disclosed to website visitors in the page code.
Google Analytics prohibits collecting any personally identifiable information of website visitors.
It may take lots of time and effort to tell your developers exactly what data, and where to send.
How can you tackle this problem and use for analysis all the data that is stored in your CRM? Here's the solution: upload the data from your internal system into Google BigQuery, and transfer the data from Google BigQuery to Google Analytics using OWOX BI Pipeline.

How to send data from CRM / ERP systems into Google Analytics?

Step #1:
Set up data transfer from your internal system into Google BigQuery

There's a number of ready-made libraries and applications you can use to send the data from your CRM into Google BigQuery. The upload can be automated, i.e., the data in Google BigQuery will always be timely and relevant.

Another benefit is that, your company's programmers won't have to make changes to the website, as there are ready-made integrations. In addition, you can retrieve all the necessary information, instead of having to choose what you need now and redo the settings every time you need something else.

Step #2:
Make the necessary settings in Google Analytics

In Google Analytics, create user-level custom dimensions for the information you need. To do this, navigate to Admin — Property — Custom Definitions — Custom Dimensions, and click +New Custom Dimension. Make sure to select the User scope in the dropdown list.

Step #3:
Create an SQL query

The query will retrieve the data you need in the "key — value" format. For example, user number 2346 — owns a car. Save this query in your OWOX BI project — you'll be able to simply select it when automating the data transfer into Google Analytics

Step #4:
Set up the automatic data transfer from Google BigQuery to Google Analytics using OWOX BI Pipeline

OWOX BI Pipeline allows you to automatically import the data retrieved by the query into Google Analytics. You only configure the data transfer once, and all the future data uploads will be performed without your direct participation.
As a result, your data will be integrated as shown on the flowchart below:

Benefits of the solution

The data can be uploaded to Google BigQuery in the structure you need, saving the time of your programmers.
You can pre-validate the data before sending it to Google Analytics, which makes it quicker and easier to pinpoint possible errors.
OWOX BI Pipeline monitors the limits of the Google Analytics Management API. Should anything go wrong during the data transfer, the service will notify you and provide recommendations on how to fix the issue.
Upon uploading the data from your internal system into Google BigQuery, you can not only import it into Google Analytics, but also create any custom reports you need, based on this and other data you have in Google BigQuery.
You can control the data you send, without ever having to involve the development team. For example, you can easily add a new field to the table in case you only uploaded color specifications for a product, and now also need to upload materials. Or, you can add another Google Analytics property if you decide to collect data simultaneously in multiple properties.
As a result, you'll obtain additional data in Google Analytics, which will allow you to create custom reports and segments of your visitors. You'll also be able to create remarketing audiences, using detailed information about your customers, and never offer irrelevant products to your customers. Showcase diapers to families with babies, and cat food to cat lovers. Just don't get those two
mixed up ;)
How do you create remarketing audiences? Comment and share your experience and thoughts about this post!

Rate the article on a five-point scale

The article has already been rated by 2 people on average 4 out of 5
Found an error? Select it and press Ctrl + Enter to tell us
Subscribe to our newsletter
Keep up to date with our latest news, events and blog posts!

Share this article with your friends

Sign In Free Sign Up

You’ve reached your query limit.

Or email
Forgot password?
Or email
Back To Login

Don’t worry! Just fill in your email and we’ll send over your password.

Are you sure?


To complete your registration you need to enter your phone number


We sent confirmation code to your phone number

Your phone Resend code Queries left

Something went wrong.

Contact our support team
Or confirm the registration using the Telegram bot Follow this link
Please pick the project to work on

Personal demonstration

Serpstat is all about saving time, and we want to save yours! One of our specialists will contact you and discuss options going forward.

These may include a personal demonstration, a trial period, comprehensive training articles & webinar recordings, and custom advice from a Serpstat specialist. It is our goal to make you feel comfortable while using Serpstat.




We are glad of your comment
Upgrade your plan

Upgrade your plan

Export is not available for your account. Please upgrade to Lite or higher to get access to the tool. Learn more

Sign Up Free

Спасибо, мы с вами свяжемся в ближайшее время

View Editing


You have run out of limits

You have reached the limit for the number of created projects. You cannot create new projects unless you increase the limits or delete existing projects.

I want more limits