tony
Week 49
25
16
Week 48
25
53
Week 45
25
9
Week 44
25
2
Week 37
25
1
Week 19
25
1
Week 51
24
1
Week 41
24
2
Week 25
24
1
Week 20
24
2
Week 13
24
1
Week 11
24
1
Week 09
24
1
Week 08
24
1
Week 07
24
2
Week 06
24
1
Week 03
24
3
Week 02
24
4
Week 01
24
7
Week 52
23
7
Week 51
23
5
Week 50
23
7
Week 49
23
3
Week 48
23
4
Week 47
23
7
Week 46
23
9
Week 45
23
10
Week 44
23
7
Week 43
23
5
Week 42
23
7
Week 41
23
8
Week 40
23
10
Week 39
23
10
Week 38
23
22
Week 37
23
5
Week 36
23
1
Week 34
23
2
Week 32
23
1
Week 28
23
1
Week 25
23
1
Week 24
23
1
Week 21
23
2
Week 20
23
1
Week 19
23
3
Week 18
23
6
Week 17
23
1
Week 16
23
2
Week 15
23
5
Week 14
23
5
Week 13
23
1
Week 12
23
7
Week 11
23
10
Week 10
23
2
Week 09
23
1
Week 08
23
4
Week 07
23
2
Week 05
23
1
Week 04
23
4
Week 03
23
1
Week 02
23
2
Week 01
23
9
Week 52
22
5
Week 51
22
3
Week 50
22
19
Week 49
22
3
Week
45
No Contact Eng
Nov 07
-
Data Setup
-
Explanations
-
Fivetran: This is not a data source. It's a tool we use to move data from external sources (App Store Connect, RevenueCat) into a postgres database.
-
App Store Connect: This is Apple. So it knows about installs, conversions and revenue.
-
RevenueCat: Tool we use to track our revenue
-
Superwall: Tool we use for Paywalls
-
Product Database: This is the app's backend. So we can use if for usage data (e..g how many people created a pledge or used chat), but it's also useful for registered users and active subscriptions.
-
Analytics Database: This is a postgres database we created solely to pipe data into using Fivetran, so that we could get our App Store Connect data in postgres.
-
Misc Database: We built a simple internal tool to track Video views across all of our creators. It's called "Misc" because we use it for various things.
-
-
Data Flow
-
