Marketing does not work in silos.

When the work in the team begins, it evolves with the product, customer support, sales, and operations team and becomes the core of the business.

The reason marketing is still vital because impact in any stage of the funnel increasing sales, attracting new customers, generating potential customers, increasing brand awareness and overall customer satisfaction.

Marketing campaigns always start from a business goal: increase brand awareness, raise new leads, more downloads for an app or reach out to more audience in order to boost your e-commerce sales.

How do you currently achieve these goals?

In the following steps, I'm going to explaining a process to engage better and more customers to uplift your e-commerce revenue.

1. Starting export your Google Analytics Data

Starting from the data we have available is very important to be able to intercept the public most in line with our business. In this guide I'm going to consider the generated data through Google Analytics tracking.

Once you read this guide you can collect all data tracked in order to create the RFM analysis to understand how is your customer base under the hood. Thanks to this algorithm you can create a simple customer segmentation based on their purchasing behaviour based on quantiles calculation. This article allow you easily  generate the clusterization thanks to the sheet attached at the bottom of the page, where you'll find all calculation ready to use inside.

You can enrich your data creating a unique UserID for each customer session and associate his email (ClientID) when prompted, in order to extract all transaction and customer data needs to create the customer base segments and mapping his customer journey.

Pay attention that your privacy policy is compliance to the actual international GDPR laws.

For instance, the following datas that has been generated when you create these custom dimensions (UserID and ClientID) associating to a custom goal.

Exporting data in Big Query or simply on your Google Sheet it's possible to integrate them with other Google Analytics insights, referring as primary key to these custom fields.

User random ID for each sessions / Goal

The link below is used to query data on Google Analytics, using Google Tools, in order to evaluate which combination of dimensions and metrics could be more interesting.

Proceeding in the next step, which concerns the RFM analysis, it's necessary to export all the required fields for the algorithm:

  • transaction ID
  • revenue
  • date
  • ClientID (email)

Google ToolsTransaction info
https://ga-dev-tools.appspot.com/query-explorer/?start-date=2020-09-01&end-date=yesterday&metrics=ga%3Ausers%2Cga%3Atransactions%2Cga%3AtransactionRevenue&dimensions=ga%3AtransactionId%2Cga%3Adate&sort=ga%3Adate

A query example on Google Tools

If you correctly created the ClientID dimension, you can also export the customer email column too, getting all the information in one go.

Enhance data in Google Analytics

Once you exported these data from your CRM, E-Commerce or whatever, you could import Transaction ID with purchased products and demographic information of our customers, in order to enhance and enriching your customer profiles and order insights.

Follow this link to the official Google guide about this topic, for proceeding to import these information.

Importing data on Google Analytics

1.1 Exporting One Time your E-Commerce Data

You could export your e-commerce data, using SQL queries or ETL tool, cleaning and normalizing all values and put them inside a Google Sheet.

If you have a Prestashop, you can use SQL query tool, built inside the e-commerce in the order tables.

If you have a Shopify or Magento 2 you can use their native API connecting them to Integromat for exporting all orders data.

1.2 Exporting Google Analytics data in Big Query with GA4

Upgrade to new GA4 in order to integrate/export your data to Big Query easily to manipulate and normalize them as if you were using the 360 version.

This way it's a little bit more complicated but you can go deep inside your data analytics and extract whatever you need as a pro.

For instance, you can understand for each transaction all related information to what products are most purchased, which products are most purchased together in a specific cluster or for a single customer too.

Big Query

2. Creating Customer Segmentation using RFM

Reporting your data in Google Sheet, you should be able to easily obtain a table similar to the image below, where you can actually understand which are your best customers, those you should pay more attention to and the others.

Yes, I know, It's not an easy task read customer insights in this way... reason why in the next point I'm going to show you how you can represent them in a Data Studio Dashboard.

RFM analysis result from Google Analytics

3. Data Studio Dashboard

Thanks to this product it will be possible to read all the insights that we have previously exported and apply filters to explore the segments in depth.

Open Data Studio and click on:

  • "New / Report" and from the top menu select "Add Data", which will open a modal with the possibility of integrating many other sources.
  • Select Google Sheet and proceed by selecting the sheet where you worked on the step before and the tab where your RFM is.

To make your job easier, below the link where you will find a ready-to-use dashboard for Google Studio.

Data studio Dashboard

Thanks to the data filter properties present in almost all available charts, it's possible to inspect individual customers or clusters to understand useful and important information about:

  • AOV per each cluster and customer
  • LTV per each cluster and customer
  • How is made up the customer base
  • What are the main cluster where I'm losing money

If your data have information about products bought in a single transaction, you could analyze some more useful insight for your campaigns, understanding customer purchasing behaviour in order to create ad hoc carousel in Facebook, for instance. Some of the information you can extract:

  • Most purchased products from each segment
  • Most common products purchased together with other products

Each segment can be exported for use in marketing campaigns or in marketing automation flows, using the filter feature as shown below in the next section.

[Public] RFM Analysis
Google Data Studio turns your data into informative dashboards and reports that are easy to read, easy to share, and fully customizable.
Click here to DOWNLOAD the Data Studio Dashboard

4. Using data in Marketing Ads Campaigns

I will only address two channels, which I think are the most used to most professional / business owners.

4.1 Facebook Ads

Exporting Champions or Loyals segment, you can create an LAL audience to acquire new audiences that have these characteristics and which potentially be interested in your merchandising.

By selecting the clusters that interest us most, we can subsequently export them:

Export segment in CSV

Once the data has been exported to CSV, you must clean and prepare it for importing into Facebook merging with their default CSV columns, which includes several unused fields, for this example, which should be deleted keeping those present in our data.

Importing Email in Business Facebook
Facebook Example Table

4.2 Google Ads

Similarly, you can import a customer list, as shown below, sharing this asset within the Google Client Center (if available) or simply within in your Google Ads account.

Here, we have two ways:

  • Create a LAL audience in Google Ads;
  • create a custom audience inside Google Analytics.

The first option is simpler and more accurate, since the second depends mainly on the amount of information collected and the sampling set: if you left the default one you will have a low sampling.

You can change it, using Tag Manager, inside the Google Analytics Tag modified as follows, adding siteSpeedSampleRate with a value of 100.

Increasing sample rate in Google Analytics

4.2.1 Create a LAL audience in Google Ads

Logging into your Ads account, clicking on:

  • Tools and settings from the top menu, then in "Shared Library" click on "Manage Audience segments";
  • You will access the audience segments section, with the + button on the left, select "Customer list";
  • Below you can see the screen you should view for loading the exported CSV from Data Studio.

4.2.2 Create a custom audience inside Google Analytics

Log in to your Google Analytics account and entering in the "Audience" section and on top of this view, accessing the section dedicated to the audiences.

There, you can create a new cluster based on demographic data, selecting specific informations of your customer base or data acquired in Google Analytics.

Create custom segment in Google Analytics
PRO TIPS – You could export all demographic data from Google Analytics at the point 2 of this article adding these informations and representing them inside Data Studio when you created the RFM analysis.

Based on your customer behaviours and purchasing data you must select in "Enhanced E-Commerce" tab as follow:

Custom Segments in Google Analytics

NOTE – The subset is sampled, pay attention to the total users number in this bucket, as depending on the filters you selected it may not be so large or suitable as to create a similar audience for Google Ads campaigns.

Once you've saved the segment, you'll need to make it available by clicking on this:

Exporting in Google Ads

A page will open where you can enter the days for the search and the duration of the subscription: these are parameters indicates how relevant the data sample must be - it's your choice.

Once selected these settings, choose a name for this segment and select the account Ads to share with.

By following the first two steps of the previous point, you will see in the table list the newly created audience segment that Google is generating and that will be available shortly for your marketing campaigns with increased ROAS :)


I'm committed to grow companies revenue both large and middle to help improve customer experiences and drive conversion rates upward.

If you’re seeking for actionable ways to improve growth of your business, contact me for a free assessment where I’ll take a close look at your business and identify actionable ways to begin optimizing it for more conversions.

Click here for a free assessment