Companies are now striving to process and analyze data about customers, product and advertising. This helps you build the right strategy and run your business.
Large infrastructure relies on Python and SQL queries. And not only analysts need to understand this, but also product managers, entrepreneurs and other representatives of the product team.
1.
, , . , .
, . , : , , . , , , , , , .
โโ , coarse grained - , . ( ) , .
โ โ, , , , . โ , , retention. , , . , , .
, . , ยซ ยป. , , , , CJM , . .
.
: Python, Google Analytics, Tableau, Amplitude, SQL, SimilarWeb, ClickHouse.
2.
: CRM, , .
, , , .
, , , KPI . , :
: Facebook . SEO. Booking, TikTok.
, , AirBnb, Instagram.
, . Expedia, Pinterest.
: Google Analytics, A/B-, R Python, Power BI Tableau, ., Power View, Power Pivot, Power Query. : .
3.
- : , , , .
: , ( ), , , , .
, .
. , . , . . . , . , .
. , . . . : ; ; Push-; . , . .
+ . . . .
: Firebase Analytics, Flurry, AppAnnie, Mixpanel, Facebook nalytics, AppMetrica, Amplitude Adjust.
4.
. , . : ROI (return on investments), CPO (cost per order), CPA (cost per action), CTR (click through rate).
. . email- , email-. client id, utm-. Client id - , cookies .
- .
, , F5, . .
client id. . utm-. () , . 50 . ., , . ( , -) . , , . , . : , , . , . CRM, . โ , , . . CRM amoCRM, RetailCRM ยซ24ยป. . . , CRM , . , ? UTM-, - CRM.
, CRM, , , . , . , 20 . . 30 . . โ 30 . . 5 . . .
: , - CRM, Google BigQuery, BI-, : LTV, ROMI, Google BigQuery, Google Data Studio Microsoft Power BI.
, , โ -โ OTUS - .