How to make GDS for Cohort Analysis
Tealbox Digital
30 steps
4 minutes
Looker
1
Go To Cohort Analysis | Turquoise Moose GDS and Click "File"
2
Click "Make a copy..."
3
Click "Copy Report"
4
Click "Turquoise Moose" and change the name to Client specific.
5
Click this icon. And go the next page.
6
Click here. And select the table.
7
Click here. And edit the data source and delete the data source.
8
Click "Select Data Source" and select the desire data source.
9
Click your desire "data source" or Click Add data source and add data source thorough google sheet
10
Click "Add dimension"
11
Click "Date"
12
Click the 'pencil'
13
Click this button.
14
Click "Date & Time"
15
Click "Year Month"
16
Click here.
17
Click here. and select "Cohort_id"
18
Click here.
19
Click "Select Data Source"
20
Click "order_cohort (3) - order_cohort (3)"
21
Click "Add dimension"
22
Click here.
23
Click here.
24
Click this button.
25
Click "Date & Time"
26
Click "Year Month"
27
Click "Add dimension"
28
Select "Month_diff" And in Metric Select "Orders"
29
In Sorting Section under Row 1 select "cohort_id"
30
And in column 1 select "month_diff"
How to make GDS for Cohort Analysis
Tealbox Digital
30 steps
4 minutes
Looker
1
Go To Cohort Analysis | Turquoise Moose GDS and Click "File"
2
Click "Make a copy..."
3
Click "Copy Report"
4
Click "Turquoise Moose" and change the name to Client specific.
5
Click this icon. And go the next page.
6
Click here. And select the table.
7
Click here. And edit the data source and delete the data source.
8
Click "Select Data Source" and select the desire data source.
9
Click your desire "data source" or Click Add data source and add data source thorough google sheet
10
Click "Add dimension"
11
Click "Date"
12
Click the 'pencil'
13
Click this button.
14
Click "Date & Time"
15
Click "Year Month"
16
Click here.
17
Click here. and select "Cohort_id"
18
Click here.
19
Click "Select Data Source"
20
Click "order_cohort (3) - order_cohort (3)"
21
Click "Add dimension"
22
Click here.
23
Click here.
24
Click this button.
25
Click "Date & Time"
26
Click "Year Month"
27
Click "Add dimension"
28
Select "Month_diff" And in Metric Select "Orders"
29
In Sorting Section under Row 1 select "cohort_id"
30
And in column 1 select "month_diff"
