Part 1: Project Overview
1.0 Project Overview
CSA 3A (InsightHub) is an AI-powered market analysis and slide creation tool that transforms complex data into actionable business insights in seconds.
Project Positioning
This project is designed specifically for Google's advertising sales teams, aiming to free team members from tedious data processing and report creation through automated data analysis and content generation. This allows them to focus more energy on higher-value strategic thinking and client communication.
Core Capabilities
- AI-Powered Intelligent Analysis: Leverages the powerful capabilities of Google Gemini AI to automatically analyze market data, user behavior signals, and audience profiles, generating deep business insights.
- Automated Content Generation: Automatically converts analysis results into professional slide reports, including visualizations, strategic recommendations, and actionable plans.
- Deep Google Ecosystem Integration: Seamlessly integrates with Google Workspace (Sheets, Slides, Drive), making data flow and content delivery smoother.
- Standardized Output Quality: Built-in analysis frameworks and prompt templates from experienced analysts ensure every analysis meets professional standards.
1.1 The Birth of the Project: A Real Story
The story of CSA 3A (InsightHub) began with a pain point in the daily work of a Google Digital Marketing Strategist (DMS) and a bold vision.
At Google, our CSA teams need to provide professional market insights and marketing strategies for clients every day. Among these, "market opportunity analysis," "audience signal analysis," and "audience personas" are the three most frequent, core, and time-consuming work scenarios. Behind each report lies a tedious process of data extraction, cleaning, cross-analysis, insight extraction, and finally manual creation of dozens of slides. A typical "audience signal analysis" report often takes an analyst 2 hours or more.
Time is our most precious resource. When significant time is invested in these repetitive, standardized processes, the time we truly have for deep thinking, strategic innovation, and client communication is severely squeezed.
The project's founder, Helen Qian, deeply understands this as a team member. She realized that these standardized analysis processes have fixed core logic that is perfectly suited for automation. Thus, an idea emerged: Could we leverage the latest AI technology to create an intelligent tool that frees analysts from complex data processing, allowing them to focus more energy on higher-value strategic thinking?
With this vision, Helen used her spare time, driven by her passion for coding and deep understanding of the business, to independently develop the prototype of InsightHub from scratch.
This project did not come from management task assignment, but rather from spontaneous innovation by frontline employees, created to solve our own most real and urgent problems.
1.2 What Core Pain Points Do We Solve?
CSA 3A (InsightHub) directly targets three "time sinks" in our workflow:
- Extremely High Repetitive Labor: In the three core scenarios (market opportunity analysis, audience signal analysis, audience personas), over 80% of the work involves repetitive data processing and chart creation. This project fully automates this work through standardized processes and automated AI analysis.
- Efficiency Bottlenecks: Traditional manual analysis models create an insurmountable ceiling for each analyst's output efficiency. A complex client request often requires hours of investment, limiting our ability to serve more clients.
- Inconsistent Insight Quality: The depth and quality of analysis depend to some extent on the analyst's personal experience. For new colleagues, quickly producing high-quality insight reports presents certain challenges.
1.3 Our Goals and Value
The core goal of CSA 3A (InsightHub) is very clear: Empower every DMS to return creativity and time to strategy itself.
Through this project, we've achieved the following core values:
- Extreme Efficiency Gains: Reduced the time required to create an audience signal analysis report from 2 hours to 10 minutes. This is not just time savings, but a transformation of productivity models.
- Standardized Quality Assurance: The project incorporates analysis frameworks from experienced analysts (implemented through sophisticated prompt engineering), ensuring every analysis produces high-quality, standardized insights, providing a "safety net" for the team's overall professional level.
- Inspire Deep Thinking: When analysts no longer need to worry about "how to create charts," they can devote 100% of their energy to higher-level thinking such as "What are the business opportunities behind the charts?" and "What unique strategies should we propose for clients?"
- Accumulate Team Wisdom: The project is not just a tool, but also a knowledge base. We've embedded excellent analysis logic and prompt templates into the tool, continuously optimizing through version iterations, allowing the entire team's wisdom to accumulate and be passed down.
This project began with Helen's personal efforts, but its vision is to serve the entire team. We hope it can become every CSA's "intelligent co-pilot," helping us serve clients faster and better, ultimately creating greater impact in the broader APAC market.
1.4 Target User Profile
Google DMS (Digital Marketing Strategist)
Role Positioning: Google DMS is the core user group of the project and also the role of project founder Helen Qian. DMS are strategy experts in Google's advertising sales teams, responsible for providing professional market insights and marketing strategy recommendations to clients.
Core Responsibilities:
- Analyze client market data and advertising performance to identify business opportunities
- Develop personalized advertising strategies for clients
- Create professional analysis reports and presentation materials to showcase insights and recommendations to clients
- Communicate with clients and answer strategy-related questions
Use Cases:
- When preparing client proposals, need to quickly generate market opportunity analysis reports
- Conducting quarterly market reviews, analyzing performance and growth opportunities across different markets
- Recommending audience tags and targeting strategies for clients, need to generate audience signal analysis reports
- Creating persona slides to showcase target audience characteristics to clients
Core Pain Points:
- Data analysis work is time-consuming and highly repetitive, taking up significant time
- Report creation process is cumbersome, requiring manual data organization and chart creation
- New colleagues need considerable time to master high-quality analysis methods
Expected Value:
- Reduce analysis time from 2 hours to 10 minutes
- Obtain standardized, high-quality analysis outputs
- Have more time to focus on strategic thinking and client communication
1.5 Core Features Overview
CSA 3A (InsightHub) provides three core features that cover the most critical and time-consuming work scenarios for Google's advertising sales teams.
Market Opportunity Analysis (Geo Analysis)
Feature Description: Intelligently analyzes market data across different countries/regions, automatically identifying blue ocean markets, opportunity markets, potential markets, and challenge markets through "demand" and "competition" dimensions, and generating strategic recommendations.
Core Value:
- Reduces manual analysis work from 2 hours to 10 minutes
- Discovers market patterns difficult to detect manually through AI-driven data analysis
- Automatically generates visual reports including bubble charts and structured slides
Use Cases: Client proposal preparation, quarterly market reviews, new market expansion evaluation, competitive analysis.
Audience Signal Analysis
Feature Description: Deeply analyzes user search behavior data, automatically categorizing search queries by intent and clustering by topic, providing precise audience recommendations and targeting strategies for advertising campaigns such as UAC, PMax, and Demand Gen.
Core Value:
- Generates recommendation plans for multiple advertising products simultaneously, improving work efficiency
- Based on real big data analysis results from Google Ads, ensuring recommendation accuracy
- Generated tags can be directly added to the Google Ads platform for use
Use Cases: Client proposal preparation, advertising optimization, new product launch support, quarterly reviews.
Persona Slide
Feature Description: Fully automated generation of beautiful user persona slide reports. Simply provide raw data, and the system automatically analyzes and generates complete Google Slides reports containing multiple user personas.
Core Value:
- Reduces manual creation work from 2 hours to 10 minutes
- Uses Google Imagen 4.0 to automatically generate scenario illustrations, no manual design required
- Automatically generates bilingual content (Chinese-English), meeting internationalization needs
Use Cases: Client proposal preparation, creative strategy development, media consumption habit analysis, multilingual delivery.
Feature Interconnections
The three features are interconnected, forming a complete workflow:
- Market Opportunity Analysis helps identify target markets, providing geographic dimensions for subsequent audience analysis and persona development
- Audience Signal Analysis deeply explores user behavior in target markets, providing data foundations for persona development
- Persona Slide transforms analysis results into presentable materials, completing the cycle from data to insights to delivery
1.6 Technology Stack Overview
CSA 3A (InsightHub) adopts a modern technology stack, balancing development efficiency, code robustness, and future scalability.
Frontend Technology Stack
| Technology | Description |
|---|---|
| React 18 | Currently the world's most popular frontend framework, using component-based development to improve code reusability and maintainability |
| Vite | A modern frontend build tool that provides extremely fast development experience and efficient build performance |
| TypeScript | A superset of JavaScript that provides static type checking, improving code quality and development efficiency |
Backend Technology Stack
| Technology | Description |
|---|---|
| Node.js | Enables JavaScript to run on the server side, achieving language unification between frontend and backend |
| Express.js | A lightweight Node.js web framework that provides clean API services |
AI Capabilities
| Technology | Description |
|---|---|
| Google Gemini API | The core AI capability source for the project, used for data analysis, content generation, and insight extraction |
| LangChain | Provides multi-turn conversation and chained invocation capabilities, supporting complex workflow orchestration |
UI Component Libraries
| Technology | Description |
|---|---|
| Semi Design | UI component library, currently used by the three core features |
| Ant Design | UI component library, future new pages will gradually migrate to this |
Google Ecosystem Integration
| Service | Description |
|---|---|
| Google OAuth 2.0 | User authentication, supports login with Google accounts |
| Google Sheets API | Read and analyze Google Sheets data |
| Google Slides API | Automatically generate and edit Google Slides presentations |
| Google Drive API | File storage and management, supports exporting results to user Drive |
| Google Apps Script | Serves as a powerful supplement to backend services, securely handling interactions with Google Workspace |
Technology Selection Philosophy
- Frontend-Backend Separation: Frontend and backend code are completely separated, improving development and maintenance efficiency
- Unified Language Stack: Both frontend and backend use JavaScript/TypeScript, reducing learning costs
- Deep Google Ecosystem Integration: Fully leverages Google Workspace capabilities to provide seamless user experience
- Modern Toolchain: Chooses the latest and most stable technologies to ensure long-term project maintainability
1.7 Project Vision and Future Plans
Short-Term Goals
Serve the Entire CSA Team: Transform the project from Helen's personal tool into a "intelligent co-pilot" used by the entire CSA team. Through continuous feature optimization and user experience improvements, help every team member improve work efficiency and invest more time in strategic thinking and client communication.
Medium-Term Vision
Expand to APAC Markets: As the project matures and team feedback accumulates, we hope InsightHub can serve Google advertising sales teams in the broader APAC (Asia-Pacific) market. Through multilingual support and localization optimization, enable teams in more regions to benefit from this tool.
Long-Term Vision
Continuously optimize and iterate to create greater value for the team. We will continuously improve features and enhance user experience based on user feedback and business needs, making InsightHub an indispensable intelligent assistant in team work.
Technology Evolution Direction
- AI Capability Enhancement: As Google Gemini API continues to upgrade, we will continuously optimize prompt engineering to improve analysis quality and insight depth
- User Experience Optimization: Based on user feedback, continuously improve interface design and interaction workflows to make the tool more user-friendly and efficient
- Feature Expansion: Explore new analysis scenarios and automation capabilities based on team needs, covering more work scenarios