By Timur Kuchushev, 19 July 2016

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

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

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

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

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

Back to the list