2023指标平台白皮书 -指标平台方法论与实践指南.pdf

?2023??01?2023??02?割?封?封?去?封?去?割模?割?封?割?研?研?研?封?去?封?2023?务?匹?2023??03?.?4 4?1.1?.?5?1.2?.?7?1.3?.?10?1.4?.?14?.?1515?2.1?.?16?2.2?.?25?2.3?.?28?.?3333?3.1?.?34?3.2?.?36?3.3?.?46?2023??04?2023??05?1 1.1.1?n?务?封?务?封?封?种?割?封?封?封?n?封?去?封?1?研?封?2023??06?研务?吗?研务?研?研?吗?吗?割?研?AI?研 BP?研?研?2?研?研?研?研?研?研?研?研?研?封?研?研?研?研?研?2023??07?1 1.2 2?n?3?研?务?务?匹?封?研?割?模?割?够?导?PDCA?n?2023??08?千?千?WWBRBR?千?撑?Weekly?Business?Review?WBR?WBR?务?盟?千?告?WBR?Colin?Bryar?/?Bill?Carr.?千?去?务?研?研?4?副?务?副?2023??09?研?历?副?封?太?2023??010?1 1.3 3?割?导?告?务?割模?5?n?1 1?研?模?告?务?割?历?KPI?KPI?历?历?封?割?割?割?割?割?割?割?2023??011?n?2 2?割?封?务?研?割?割?覆?割?副?割?割?撑?封?务?割?割?研?封?告?副?BI?研?割?割?副?n?3 3?封?研?模?封?吗?研?封?研?研?封?吗?研?封?研?模?研?封?务?封?告?研?割?研?2023??012?6?研?研?BI?告?模?研?BI?塔 SQL?研?覆?研?封?研?BI?割?研撑?n?4 4?务?确?研?副?研?封?务?封?研?副?撑?副?副?OLAP?空?研?割?割?务?OLAP?空?割?2023??013?7?OLAP?空?n?5 5?封?研?历?研?研?研?研?2023??014?1 1.4.4?副?研?务?研?封?8?2023??015?2023??016?模?9?2 2.1?.1?n?10?2023??017?研?研?研?研?研?研?封?导?模?割?匹?导?割?封?n?1?尽?11?务?T0?2?副?11务?T3?3?副?4?尽?务?尽?2023??018?11?模?n?1 1?尽?导?尽?尽封?研?割?导?尽?务?6?1?历?务?MySpace?割?导?MySpace?割?历?MySpace?2?导?MySpace?Facebook?MAU?Facebook?MySpace?副?3?割?尽?封?LinkedIn?告?封?2023??019?4?割?Airbnb?LinkedIn?撑?模?对?割?5?ARPU?割?SaaS?6?割?尽?割?割?尽?割?割?割?封?SaaS?尽?割?封?割?12?SaaS?尽?务?尽?封?2 2?T0?T3?2023??020?T0?T1?尽?尽?T2?尽?T3?T1?T2?T3?13?够?a?封?b?副?割?研?研?够?研 RFM?副?够?AIPL?够?够?割?研?TOP?20%?SKU?A?band?20%?40%?SKU?B?band?够?C?D?E?band?0?SKU 够?F?band?务?研?2023??021?14?c?务?13?GMV?UV?割?副?务?告?割?UV?GMV?割?确?15?15?2023??022?研?割?割?绩?尽?尽?16?绩?v?吗?绩?尽?吗?绩?割?绩?17?绩?2023??023?绩?确?3 3?够?尽?18务?撑?撑?OSM?O 去?Object?S 去?Strategy?M 去?Measure?够?GMV?封?研?副?20%?割?够?务?OSM?务?割?OSM?割?割?GMV?OSM?割?18?OSM?副?*?OSM?2023??024?割?T3?OSM?尽?4 4?副?告?尽?割?封?尽?太?尽?研?割?研?务?19?2023??025?2 2.2?.2?n?20?研?研?研?割?封?封?封?封?BI?2023??026?n?21?封?1 1?模?ETL?研?务?研?2 2?封?封?研?模?封?副?副?封?封?撑?3 3?模?封?研?研?封?4 4?研?n?模?空?1 1?模?模?副?封?模?够?研?空?封?2023??027?务?研?API?SQL?MDX?22?2 2?空?空?空?空?OLAP?空?空?OLAP?空?PB?研?封?研?OLAP?空?ClickHouse?Doris?Kylin?Greenplum?Druid?TiDB?OLAP?空?副?空?3 3?去?去?撑?case?when?撑?确?匹?2023??028?2 2.3?.3?n?23?模?研?割?去?研?n?2023??029?24?映?割?去?研?封?务?务?n?封?OA?1 1?研?CTO/CFO?研?去?研?2023??030?25?T2/T3?T1/T2?研?研?研?封?/?割?/?务?割?割?副?2023??031?26?2 2?封?封?封?映?副?封副?封?覆?研?封?务?封?映?务?割?副?2023??032?27?封?研?封?模?研?封?3 3?撑?撑?务?副?务?务?映?研?务?副?封?封?务?研 BP?研?研?研 BP?研 BP?务?封?2023??033?28?研 BP?2023??034?2023??035?3 3.1?.1?研?研?空?裂?套?务?务?研?AI?研?研?研?AI?XDP?MA?封?2023??036?3 3.2.2?研?割?研?对?对?29?HyperMetrics?HyperMetrics?封?/?封?封?割?塔 SQL?研?确?Excel?API?API?研?务?割?2023??037?30?HyperMetrics?HyperMetrics?研?研?研?研?API?研?研?研?研割?研?RESTful?API?Java?API?SQL?MDX?割?副?研?匹?撑?研?31?HyperMetrics?吗?研?HyperMetrics?对?对?2023??038?n?APIAPI?33?吗?研?研?研?研?研?研?研?研?研?研?研?研?研?研?研?封?研?封?务?模?研?研撑?研?研?研?撑?割?研?研?研?割?研?研?研?研?研?割?割?32?研?HyperMetrics?研?封?研?DWD?映?研?封?研撑?研?研?2023??039?研撑?BI?研?API?研?务?33?HyperMetrics?研?n?对?对?34?研?BI?BI?割?研?封?BI?务?封?研?研?研?割?封?BI?务?研?割?割?2023??040?研?务?模?割?封?研?35?BI?吗?BI?研?对?BI?映?excel?务?塔 sql?模?研?导塔?副?研?确?研?研?n?DorisDoris?1 1?研?研?研?研?空?Hyper?Metrics?Engine,?HME?研?研?空?吗?研?务?研?研?研?研?塑?研?研?2023??041?研?研?研?务?研?研?研?36?研?研?研?/?Semantic?model?研?,?封?研?Single?Source?of?Truth?Define?metrics?once,?use?them?everywhere?/BI?研?撑?研?封?2 2?DorisDoris?空?空?O OLAPLAP?空?空?OLAP?空?HyperMetrics?Doris?空?空?的?2023??042?37?Doris?OLAP?空?3 3?H HMEME?Doris?空?副?HyperMetrics?研?38?HME?空?研?割?研?去?去?研?够?2023??043?割?割?研?研?空?塔 SQL?研?的?割?去模?去?研?割?去?4 4?H HMEME?HME?副?39?HME?HME?研?务?Join?ReSharding?研?研?够?研?太?割?务?rollup?研?研?/?merge?研?撑?研?2023??044?cache?5 5?割?割?割?撑?CountDistinct?API?HME?务?40?n?1 1?HyperMetrics?研务?研?HyperMetrics?研务?封?封?研?研?研?割?塔?2023??045?HyperMetrics?/?务?AI?41?2 2?GPT?3.5?去?去?研?封?确?研?Chat-?Excel 务?Excel 务?研?映割?模?割?匹?确?务?2023??046?3 3.3?.3?n?匹?know-how?套?套?套?套?尽?映?务?务?套?尽?2021?务?包?务?包?套?尽?研?研?务?套?尽?研?务?研?告?模?研?务?研?研?告?Excel?盟?K KYCYC?Know?Your?CustomerKnow?Your?Customer?撑?模?撑?模?套?2023??047?研?研?套?的?know-how?套?尽?模?KYC?Know?Your?Customer?模?务?API?研?研?KYC?模?43?尽?尽?务?导?AUM?AUM?KY+?Know?Your?Customer?Know?Your?Product?Know?Your?Employee?Know?Your?Branch?CRM?务?2023??048?44?套?尽?务?KYC?模?撑?K KYCYC?务?务?套?尽?套?尽?撑?务?KYC?套?尽?2A3R?套?Awareness?3A3R?Awareness?Acquisition?Activation?Retain?Revenue?Refer?模?OSM?模?务?4K?绩?45?KYC?2023??049?KYC?KYC?导?务?研?映?研?研?模?模?50%50%?套?尽?900+?95%?50%?尽?100?尽?尽?研?5 50%0%?务?100?套?尽?去?导?导撑?去?确?2023??050?n?副?封?封?去?研?盟?2022?66?15,000?22?3,000?务?研?O2O?2020?映?研?研务?BI?研?撑?务?42?尽?研?确?2023??051?的?研?研?研?研?研?盟?告?务?研?包?研?研?研?研?研?研?撑?撑?研?研?撑?研?研?撑?研?研?研?研?模?研?POC?1?2?研?研?空?研?研?研?3?模?研?API?BI?BI?研?4?研?务?SOP?去?2023??052?43?研?BI?Excel?API?研?研?研?去?研?研?务?研?对?研?研?A APIPI?研?研?务?研?API?研?研?务?研?研?2023??053?研?API?研?3000?研?200?500?研?研?200?BI?BI?务?300?研?API?模?研?80%?API?研?撑?研?撑?研?研?去?研?2023??054?n?务?的?撑?撑?研?模?研?研?BI?研?研?研?研?务?研?盟?研?研?研?务?研?研?研?模?撑?覆?务?研?研?618?研?告?ROI?研?映?2023??055?模?模?务?尽?够?模?研模?研 BPBP?去模?去模?44?模?导?尽?尽?45?2023??056?O2O?46?研?务?研 BP?研?模?研 BP?务?导?研?务?CM?0.8%+?160?2023??057?研?研?研?研?2023??058?