Slide 1
Slide 1 text
Copyright © ZOZO Technologies, Inc.
Slide 2
Slide 2 text
© ZOZO Technologies, Inc.
2
Slide 3
Slide 3 text
© ZOZO Technologies, Inc.
3
Slide 4
Slide 4 text
© ZOZO Technologies, Inc.
4
Slide 5
Slide 5 text
© ZOZO Technologies, Inc.
5
Slide 6
Slide 6 text
© ZOZO Technologies, Inc.
6
Slide 7
Slide 7 text
© ZOZO Technologies, Inc.
7
Slide 8
Slide 8 text
© ZOZO Technologies, Inc.
8
ZOZOTOWN
Slide 9
Slide 9 text
© ZOZO Technologies, Inc.
9
ZOZOTOWN
Slide 10
Slide 10 text
© ZOZO Technologies, Inc.
10
Slide 11
Slide 11 text
© ZOZO Technologies, Inc.
11
Slide 12
Slide 12 text
© ZOZO Technologies, Inc.
12
Slide 13
Slide 13 text
© ZOZO Technologies, Inc.
13
Slide 14
Slide 14 text
© ZOZO Technologies, Inc.
14
Slide 15
Slide 15 text
© ZOZO Technologies, Inc.
15
Slide 16
Slide 16 text
© ZOZO Technologies, Inc.
16
Slide 17
Slide 17 text
© ZOZO Technologies, Inc.
17
Slide 18
Slide 18 text
© ZOZO Technologies, Inc.
18
Slide 19
Slide 19 text
© ZOZO Technologies, Inc.
19
Slide 20
Slide 20 text
© ZOZO Technologies, Inc.
20
Slide 21
Slide 21 text
© ZOZO Technologies, Inc.
21
Slide 22
Slide 22 text
© ZOZO Technologies, Inc.
22
Slide 23
Slide 23 text
© ZOZO Technologies, Inc.
23
Slide 24
Slide 24 text
© ZOZO Technologies, Inc.
24
explore: view_1 {
join: view_2 { … }
join: view_3 { … }
join: view_4 { … }
view: direct_derived_view {
derived_table: {
explore_source: view_1 {
column: column_a {}
}
SELECT
view_1.column_a AS view_1_column_a
FROM `〇〇〇〇〇` AS view_1
Slide 25
Slide 25 text
© ZOZO Technologies, Inc.
explore: view_1 {
join: view_2 { … }
join: view_3 { … }
join: view_4 { … }
25
view: big_view {
derived_table: {
explore_source: view_1 {
column: column_a {}
column: column_b {}
column: column_c { field: view_2.column_c }
column: column_d { field: view_3.column_d }
column: column_e { field: view_4.column_e }
}
}
dimension: column_a {…}
dimension: column_b {…}
dimension: column_c {…}
view: indirect_derived_view {
derived_table: {
explore_source: big_view {
column: column_a {}
}
WITH big_view AS (SELECT
view_1.column_a AS column_a,
view_1.column_b AS column_b,
view_2.column_c AS column_c,
view_3.column_d AS column_d,
view_4.column_e AS column_e
FROM `〇〇〇〇〇` AS view_1
LEFT JOIN `▲▲▲▲▲` AS view_2 ON ...
LEFT JOIN `□□□□□` AS view_3 ON ...
LEFT JOIN `◆◆◆◆◆` AS view_4 ON ...
)
SELECT big_view.column_a AS big_view_column_a
FROM big_view
Slide 26
Slide 26 text
© ZOZO Technologies, Inc.
26
filters: {
field: timestamp
value: “{{ _user_attributes[‘start_dt’] }} to
{{ _user_attributes[‘end_dt’] }},
{{ _user_attributes[‘end_dt’] }}
for 1 days”
}
start_dt: 2020-01-01
end_dt: 2020-01-21
explore: pppp
explore: qqqq
explore: rrrr
explore: ssss
Slide 27
Slide 27 text
© ZOZO Technologies, Inc.
27
Slide 28
Slide 28 text
© ZOZO Technologies, Inc.
28
Slide 29
Slide 29 text
© ZOZO Technologies, Inc.
29
Slide 30
Slide 30 text
© ZOZO Technologies, Inc.
30
Slide 31
Slide 31 text
© ZOZO Technologies, Inc.
31
Slide 32
Slide 32 text
© ZOZO Technologies, Inc.
32
Slide 33
Slide 33 text
© ZOZO Technologies, Inc.
33
view: users {
sql_table_name: `base_sys.users` ;;
dimension: userid {
label: “会員ID”
view: member {
sql_table_name: `marketing.member` ;;
dimension: id {
label: “会員ID”
view: ga_sessions {
sql_table_name: `9999999.ga_sessions` ;;
dimension: custom_dimension3 {
label: “会員ID”
Slide 34
Slide 34 text
© ZOZO Technologies, Inc.
34
view: users {
sql_table_name: `base_sys.users` ;;
extends: [user_id]
view: member {
sql_table_name: `marketing.member` ;;
extends: [user_id]
view: ga_sessions {
sql_table_name: `9999999.ga_sessions` ;;
extends: [user_id]
view: user_id {
dimension: user_id {
label: “会員ID”
sql: {% if data_source._parameter_value == ‘BASE’ %}
${users.userid}
{% elsif data_source._parameter_value == ‘MA’ %}
${member.id}
{% elsif data_source._parameter_value == ‘GA’ %}
${ga_sessions.custom_dimension_3}
{% endif %} ;;
}
parameter: data_source {
type: unquoted
allowed_value: {
label: “基幹DBシステム”
value: “BASE”
}
allowed_value : {
label : “マーケティングシステム”
value: “MA”
}
allowed_value : {
label: “Google Analytics”
value: “GA”
Slide 35
Slide 35 text
© ZOZO Technologies, Inc.
35
意味付け
Slide 36
Slide 36 text
© ZOZO Technologies, Inc.
36
Slide 37
Slide 37 text
© ZOZO Technologies, Inc.
37
Slide 38
Slide 38 text
No content