By Timur Kuchushev, 19 July 2016

RFM Analysis in Google Sheets Upload to Google Analytics — Readymade Recipe

Start working
Open the spreadsheet and make a copy. Now this copy is your working tool.
Insert data
Insert data to tab "1orders" from your CRM:

  • Date of transaction
  • Transaction ID
  • User ID
  • Transaction revenue
Customize charts
Fill green cells with your values, charts will help you choose the correct value.

Add custom fields
To import RMF to Google Analytics add custom fieds in google analytics and paste its value in the table #5
Preview and analyse

You will find RFM report at "2rfm" tab.
Stream data into Google Analytics
Use OWOX BI Data Upload addon for Google Sheets, stream data to Google Analytics.

Back to the list