Importing RFM-analysis results to Google Analytics allows:
- to build new custom reports and segments in the Google Analytics interface for deeper analysis of the audience, using additional information about users.
- to use results of RFM-analysis for creating the remarketing audiences in Google Ads (please note that Query Time import doesn't work with the remarketing audiences)
Setting up of RFM-analysis data import in Google Analytics from Google BigQuery consists of several stages:
- Set up a web property in Google Analytics
- Set up streaming in OWOX BI Pipeline
Google Analytics Web-property setting
- Create user level Custom Dimensions results of RFM-analysis (Custom Definitions -> Custom Dimensions -> + New Custom Dimension):
- Create a new data set for data import to Google Analytics (Data Import -> NewData Set):
- Choose data set type โ User data<
- Select Query Time import behavior. It helps to combine historical and imported data; Otherwise data will be combined only with hits which were collected into Google Analytics after importing RFM-analysis results. Please note that Query Time import is available only for Google Analytics 360 users
- Choose data set type โ User data<
- Select data set name and specify the list of views in which imported data will be available
- Specify the data set schema and save this data set:
- Google Analytics Web-property settings for data import are completed.
Set up streaming in OWOX BI Pipeline
- Prepare SQL-query, that returns data in valid structure
- Create streaming in OWOX BI Pipeline, following this instructions
Wait until you see the data in Google Analytics:
0 Comments