SNS Operations Analytics Platform

A data analytics platform for regularly collecting reviews and social data, then surfacing trends and improvement themes by location or service.

Challenge

Reviews, social posts, and website data were scattered, making regular monitoring and improvement planning time-consuming.

Solution

Built a scheduled analytics workflow with Vertex AI Pipelines for data collection, preprocessing, analysis, and reporting. Vectorized reviews so repeated complaints and positive patterns could be grouped and tracked.

Result

Weekly reports made it easier to compare locations and services, then prioritize improvement themes.

Team

1 member, 2 months

Platform building & analytics model creation

Role

Analytics platform building & data analysis

Handled PoC on Vertex AI Workbench, production migration to Pipelines, scraping, and analytics logic implementation.

Tech Stack

PlatformGoogle Cloud (Vertex AI)
PipelineVertex AI Pipelines / Kubeflow
AI / LLMGemini Pro / Gecko Embeddings
SearchVertex AI Vector Search
DatabaseSupabase / BigQuery

Key Features

01

Stable data collection from Google Maps and portal sites using ScrapingBee

02

Workflow orchestration for data collection, preprocessing, and analysis via Vertex AI Pipelines

03

Grouping of similar reviews and recurring complaints through vector search

04

Multi-axis review scoring across trust, affection, functionality, and novelty

Technical Highlights

Continuous Improvement with MLOps

Adopted Vertex AI Pipelines to automate the entire process from data collection to analysis and reporting, rather than one-off analysis. Built an environment for weekly model improvement cycles.

Quantifying Qualitative Data

Structured free-form reviews into scores and similar groups, making them easier to compare over time.