Skip to main content

Market Opportunity Analysis Deep Dive Guide

Table of Contents​

  1. Feature Overview
  2. Use Cases
  3. Data Preparation
  4. Operation Workflow
  5. Result Interpretation
  6. Export Functions
  7. Frequently Asked Questions

Feature Overview​

What is Market Opportunity Analysis?​

Market Opportunity Analysis is one of the three core features of this system, designed to help Google advertising sales teams quickly and accurately identify and analyze business opportunities across different markets (countries/regions) in different product categories.

Core Value​

  1. Efficiency Gains: Reduces manual analysis work from 2 hours to 10 minutes
  2. Standardized Output: Ensures every analysis follows a unified methodology and output format
  3. Deep Insights: Discovers market patterns difficult to detect manually through AI-driven data analysis
  4. Visual Presentation: Intuitively displays analysis results through bubble charts and structured slides

How It Works​

The system receives Excel files or Google Sheet links containing market data, performs deep analysis through Google Gemini AI, automatically identifies market types (Opportunity Market, Challenge Market, Potential Market, Blue Ocean Market), and generates visual reports with strategic recommendations.

Use Cases​

Typical Application Scenarios​

  1. Client Proposal Preparation: Quickly generate professional data analysis reports when presenting market opportunities to clients
  2. Quarterly Market Review: Regularly analyze performance across different markets, identify growth opportunities and risks
  3. New Market Expansion: Evaluate the business potential of new markets, providing data support for market entry strategies
  4. Competitive Analysis: Understand market competition dynamics through CPC (Cost Per Click) and demand data

Applicable Data Types​

  • Category Dimension: Different product categories (e.g., electronics, clothing, food, etc.)
  • Geographic Dimension: Different countries or regions (e.g., United States, Japan, South Korea, etc.)
  • Metric Dimension: CPC, click volume, demand median, competition median, etc.

Data Preparation​

Data Source: Connect Benchmark (CBX)​

The data required for the Market Opportunity Analysis feature comes exclusively from Google's internal Connect Benchmark (CBX) system. You need to export Excel files or Google Sheets containing relevant market data from the CBX system.

CBX exports reports in two formats: single category and multi-category. InsightHub can automatically identify and process both formats, so you don't need to manually distinguish or convert them.

Data Format Requirements​

Core Data Structure​

Whether it's an Excel file or Google Sheet, the core data should be contained in a worksheet named ...Sublocations... (the system will automatically search for it; if not found, it defaults to the second worksheet). The worksheet headers (column names) should be in English and include the following key columns:

Column Name (English)Description
Start Date, End DateStart and end dates of the analysis period
Comparison Start Date, Comparison End DateStart and end dates of the year-over-year comparison period
Query Set Name（Required for multi-category reports） Category name
Geo NameCountry or region name
ImpressionsNumber of ad impressions
Ad DepthAd depth
SpendAd spend
Ad OpportunitiesNumber of ad opportunities
ClicksClick volume
Clicks (PoP)Click volume (year-over-year change)
CPCCost per click

Report Definition Worksheet​

The first worksheet in the file is usually the report definition page (Report Definition and Compliance). The system reads the overall industry name from cell B4 of this worksheet.

A typical CBX report (multi-category) header example:

Start DateEnd DateComparison Start Date...Query Set NameAdvertiser NameGeo Name...ClicksClicks (PoP)CPC

Data Quality Checks​

The system automatically performs the following checks before analysis:

  1. Required Field Validation: Ensures all required columns exist
  2. Data Type Validation: Automatically normalizes numeric and boolean fields
  3. Null Value Handling: Automatically handles missing data, using default values or skipping invalid rows
  4. Duplicate Data Detection: Identifies and handles duplicate category-country combinations

Operation Workflow​

Step 1: Log In to the System​

  1. Access the system URL (provided by administrator)
  2. Click "Sign in with Google"
  3. Authorize the system to access your Google account information (for authentication and Google Sheet access)

Permission Notes:

  • The system needs access to your Google account information (name, email)
  • If using Google Sheets, read-only access to Google Sheets is required
  • All permissions are used only for feature operation and will not be used for other purposes

Step 2: Select Feature​

  1. Click the "Market Opportunity Analysis" card on the system homepage (Dashboard)
  2. Enter the Market Opportunity Analysis page

Step 3: Upload Data​

The system supports two data input methods:

Method A: Upload Excel File​

  1. Click the "Upload Excel File" button
  2. Select your Excel file in the file selection dialog
  3. The system will automatically validate the file format and display file information

File Limitations:

  • File size: Recommended not to exceed 10 MB
  • File format: .xlsx (Excel 2007 and above)
  • Number of worksheets: Supports multiple worksheets, system will automatically merge them
  1. Copy Link: Directly copy the target Google Sheet's URL in your browser.
  2. Paste Link: Paste the link in the InsightHub page input box.
  3. No Sharing Required: Thanks to the Google OAuth permissions you granted during login, the system can directly and securely access spreadsheet data you have permission to view. You don't need to configure any "sharing" settings, such as "Share with anyone who has the link."
  4. Click Load: Click the "Load" button, and the system will begin reading data.

Permission Check:

  • The system will automatically check whether your currently logged-in Google account has access to that Sheet.

Step 4: Configure Analysis Parameters​

  1. Set Query Language: Select the query language you want Gemini AI to use
  2. Set Output Language: Select the language for the final report
  3. Select Markets: Select the target markets or countries you want to analyze

Step 5: Start Analysis​

  1. Confirm VPN: If your network environment requires it, check the VPN confirmation box
  2. Click Analyze: Click the "Start Analysis" button to launch the analysis process
  3. Wait for Results: The analysis process may take a few minutes, please wait patiently

Results Page Details​

The Market Opportunity Analysis results page is carefully designed to present complex data insights in a clear, intuitive, and deliverable slide format. The entire page simulates the final slide (Slide) style delivered to clients, achieving a "what you see is what you get" preview effect.

1. Page Layout​

The results page uses a multi-tab layout, with each tab corresponding to a Category you provided in the data. Each category's results include the following core elements:

  • Slide Canvas: The entire content area is designed as a 16:9 slide canvas, containing all standard elements such as titles, charts, insight summaries, and footnotes.
  • Left: Bubble Chart Visualization
    • Axes:
      • X-axis: Represents Year-over-Year Growth Rate (YoY Growth), reflecting market growth potential.
      • Y-axis: Represents Average Monthly Searches for Category, reflecting the current market size.
    • Bubbles:
      • Size: Represents Market Share, intuitively showing the relative importance of each sub-category in the market.
      • Color: Used to distinguish different sub-categories and corresponds to the legend on the right.
    • Quadrants: The chart is divided into four quadrants, helping quickly locate sub-categories with different characteristics (e.g., "high growth, high volume" star markets or "low growth, small volume" niche markets).
  • Right: AI Insight Summary:
    • Core Insights: Two-level priority analysis (Priority 1 & Priority 2) automatically generated by Google Gemini AI.
    • Core Highlights: Summarizes the core findings for that priority.
    • Strategy Recommendations: Based on core highlights, proposes specific market entry or growth strategies.
  • Footer: Clearly labels the data period on which this analysis is based.

2. Interactive Features and Highlights​

The results page is not just a static display but also provides rich interactive features to enhance usability and flexibility.

  • In-Place Content Editing:
    • Design Philosophy: We understand that while AI-generated content is efficient, it sometimes needs fine-tuning combined with human expert experience. Therefore, all text elements on the results page—from main titles, subtitles, to every insight summary and strategy recommendation—support click-to-edit.
    • Implementation: Achieved through the EditableText component, users can directly modify text on the page. Modified content will update in real-time and be reflected in the final exported files. This feature greatly enhances the professionalism and customization level of the final output.
  • Rich Export Options:
    • Download Session (ZIP): Packages and downloads all outputs from this analysis (including raw data, result data, images, PPTX files, and metadata) for easy archiving or sharing with others to import.
    • Export as PPTX: One-click download of the current category's slides as a .pptx format file, preserving almost identical layout and styling as the page.
    • Export as Google Slides: Through "template replacement" mode, automatically fills results into a preset Google Slides template and saves it to your Google Drive.
    • Export as Image (PNG): Downloads the slide canvas or individual bubble chart as high-resolution PNG images.
    • Copy to Clipboard: Quickly copies slide or chart images to the system clipboard for pasting into other applications.
  • Chart Interactions:
    • Hover Tooltips: Hovering the mouse over any bubble displays detailed data for that sub-category, including search volume, year-over-year growth, market share, and CPC (Cost Per Click).
    • Legend Toggle: Clicking the legend on the right can highlight or hide corresponding sub-categories, facilitating focused analysis.

Result Interpretation​

Bubble Chart Interpretation​

The bubble chart displays market distribution in two-dimensional coordinates:

  • X-axis: Market Demand (Median Demand)
  • Y-axis: Market Competition (Median Competition)
  • Bubble Size: CPC (Cost Per Click)
  • Bubble Color: Market Type
    • 🔵 Blue: Opportunity Market (High demand, low competition)
    • 🟡 Yellow: Challenge Market (High demand, high competition)
    • 🟢 Green: Potential Market (Low demand, low competition)
    • 🟠 Orange: Blue Ocean Market (Low demand, high competition)

Key Interpretation Points:

  • Top right (High demand, high competition): Intense competition, requires differentiation strategy
  • Top left (Low demand, high competition): Market saturation, requires cautious entry
  • Bottom right (High demand, low competition): Best opportunity, prioritize resource investment
  • Bottom left (Low demand, low competition): Potential market, requires demand cultivation

Slide Content Interpretation​

Each category's slide includes the following sections:

1. Title Area​

  • Subtitle: Category name + "Market Opportunity Analysis"
  • Main Title: AI-generated insight title summarizing the core findings for that category

2. Priority 1 (First Priority)​

  • Title: Editable priority title (default: "First Priority")
  • Description: Editable priority description (default: "Based on high demand, low competition market characteristics")
  • Core Highlights: The most important market opportunities for this category identified by AI
  • Strategy Recommendations: Specific action recommendations for these highlights

3. Priority 2 (Second Priority)​

  • Title: Editable priority title (default: "Second Priority")
  • Description: Editable priority description (default: "Based on other market characteristics")
  • Core Highlights: Secondary market opportunities identified by AI
  • Strategy Recommendations: Specific action recommendations for these highlights
  • Analysis Period: Displays the time range of the data (extracted from raw data)

Strategic Recommendations Interpretation​

Strategic recommendations are based on comprehensive analysis of all category data and typically include:

  1. Overall Market Trends: Common characteristics across categories
  2. Resource Allocation Recommendations: How to allocate resources across different markets
  3. Risk Warnings: Market risks to be aware of
  4. Action Priorities: Markets and categories recommended for priority attention

Export Functions​

Export Options​

The system supports multiple export formats:

1. Download Session ZIP​

Contents:

  • YAML configuration file (contains all analysis metadata)
  • XLSX detailed data tables (one worksheet per category)
  • PPTX presentation (contains slides for all categories)
  • PNG image files (bubble charts and slide images)
  • Original data file (if Excel was uploaded)

File Naming Convention:

InsightHub-YYYYMMDD-HHmmss-{sessionUUID}-{fileTypeLabel}-{languageLabel}.zip

Use Cases:

  • Complete backup of analysis results
  • Share with team members
  • Archive storage

2. Export PPTX​

Contents:

  • One slide per category
  • Bubble charts (maintaining original proportions)
  • Complete priority analysis content

Use Cases:

  • Direct use for client presentations
  • Integration into existing presentations

3. Export Images​

Contents:

  • Bubble chart PNG images
  • Slide PNG images (one per category)

Image Quality:

  • Resolution: Automatically optimized based on screen resolution
  • Format: PNG (supports transparent background)
  • Clarity: Suitable for printing and presentation use

Use Cases:

  • Insert into other documents
  • Use for social media sharing
  • Print output

4. Copy to Clipboard​

Supported Formats:

  • Images (PNG format)
  • HTML code (for web embedding)

Use Cases:

  • Quick paste into other applications
  • Insert images in emails
  • Insert content in documents

Export Operation Steps​

  1. On the results page, find the content to export (bubble chart or slides)
  2. Click the corresponding export button ("Download," "Copy," etc.)
  3. Complete the operation according to prompts

Notes:

  • Exporting large amounts of data may take some time, please wait patiently
  • If export fails, the system will display error information; please retry according to prompts

Frequently Asked Questions​

Q1: Why did my Excel file upload fail?​

Possible Reasons:

  1. Incorrect file format (must be .xlsx format)
  2. File size exceeds limit
  3. File is corrupted or unreadable

Solutions:

  1. Confirm file format is .xlsx
  2. Try re-saving the file in Excel
  3. Check if the file is being used by another program

Possible Reasons:

  1. Incorrect link format
  2. No access permissions
  3. Sheet has been deleted or moved

Solutions:

  1. Confirm link format is: https://docs.google.com/spreadsheets/d/...
  2. Check the Sheet's sharing permissions
  3. Try logging in to the system again

Q3: What if the analysis results are inaccurate?​

Possible Reasons:

  1. Poor input data quality
  2. Incorrect prompt configuration
  3. AI understanding deviation

Solutions:

  1. Check the completeness and accuracy of input data
  2. Try editing the prompt to provide clearer guidance
  3. Contact system administrator to report the issue

Q4: How do I save analysis results?​

The system automatically saves analysis results to browser local storage (IndexedDB). You can:

  1. View History: View all historical analyses in the Dashboard
  2. Export ZIP: Download the complete analysis results package
  3. Reload: Click on history records to view results again

Note: Data stored in browser local storage may be lost after clearing browser data. It's recommended to regularly export ZIP files for backup.

Q5: Can I analyze multiple categories simultaneously?​

Yes. The system supports:

  • Single Excel file containing multiple category data
  • Automatic merging of data from multiple worksheets (Sheets)
  • Independent bubble charts and slides generated for each category

Recommendation: If there are too many categories (>10), it's recommended to analyze in batches to ensure optimal performance.

Technical Details (Optional Reading)​

Data Processing Workflow​

  1. File Parsing: Uses XLSX library to parse Excel files, or reads data through Google Sheets API
  2. Data Normalization: Automatically cleans formatting characters, unifies field names, validates data types
  3. Data Validation: Checks required fields, handles null values, identifies duplicate data
  4. AI Processing: Performs data analysis and insight generation through Google Gemini API
  5. Result Storage: Saves results to browser local storage (IndexedDB)

AI Analysis Mechanism​

The system uses Google Gemini 2.5 Pro model for the following analysis:

  1. Data Understanding: Understands data structure and business meaning
  2. Market Classification: Categorizes markets into four types based on demand-competition matrix
  3. Priority Identification: Identifies the most important market opportunities
  4. Strategy Generation: Generates specific action recommendations for each priority

Visualization Technology​

  • Bubble Charts: Rendered using ECharts library, supports interaction and export
  • Slide View: Rendered using HTML/CSS, simulates Google Slides styling
  • Image Export: Uses html-to-image library to convert HTML to PNG images

Related Documentation: