Kiwi林奇葦
Back to Projects
實習經驗·2024

Lootex Data Tracking Pipeline

Lootex 資料追蹤與管理儀表板

Frontend and backend tracking pipelines using BigQuery, Google Tag Manager, Google Analytics, and Looker Studio across 10+ heterogeneous data sources.

用 BigQuery、GTM、GA 與 Looker Studio 整合 10+ 異質資料源，建立前後端追蹤與管理層儀表板。

Role:Data Analyst Intern
BigQuery
GTM
Google Analytics
Looker Studio
Analytics
GTM
BigQuery
Lootex Data Tracking Pipeline

The useful part of analytics is not just the dashboard; it is the decision loop it enables. During my internship at Lootex, I transitioned from raw data collection to actionable business insights.

Pipeline Architecture

  • Data Collection: Architected comprehensive tracking pipelines by collecting both frontend and backend metrics via BigQuery, Google Tag Manager (GTM), and Google Analytics (GA).
  • Centralized Dashboards: Engineered a company-wide dashboard using Looker Studio that integrated over 10 heterogeneous sources, including complex on-chain blockchain data and platform telemetry.
  • Business Impact: Delivered weekly reports and visualized data directly to C-level executives, translating complex data into strategic insights for decision-making support.