Product Performance Analysis with Google Analytics
E-commerce Manager, Merchandising Manager, EC Growth Manager, Marketing Manager, Business Owner
Before
Your analysis was limited to the standard reports in Google Analytics, which mostly showed top-selling products by revenue or quantity. To understand why certain products sold well while others didn't, you had to perform complex analysis. Answering questions like "Which products are most popular with users from Instagram?" or "Which products have a high view rate but low add-to-cart rate?" required creating custom segments, exporting data to spreadsheets, and manually calculating metrics like Buy-to-Detail Rate. This process was so cumbersome that you likely only did it once a quarter, missing out on timely insights.
After
Kocoro becomes your expert e-commerce analyst. You can now ask sophisticated questions about your product performance in plain language. Kocoro directly queries your Google Analytics e-commerce data, performs complex segmentations on the fly, and calculates key ratios automatically. You can go from wondering which products to promote to having a data-backed list in minutes. By uploading a simple file with your product costs (COGS), you can even ask about profitability, not just revenue, enabling truly business-savvy decisions.
Use Case Scenarios
1. Identifying "Hidden Gem" Products for Promotion
Scenario: You're planning the next email marketing campaign and want to feature products that have a high potential to sell, rather than just promoting the same old bestsellers. The ideal products are those that people love and buy once they see them, but currently don't get enough visibility.
How Kocoro Helps: You can ask Kocoro to find these opportunities for you. Prompt it: "Identify products from our 'Apparel' category that have a high Buy-to-Detail rate (over 8%) but low product page views (fewer than 500 views) last month." Kocoro will analyze your catalog and produce a short, actionable list of "hidden gems." These are the perfect candidates for your next marketing push because you have data showing that once customers see them, they are highly likely to buy.
2. Diagnosing Underperforming "Leaky" Products
Scenario: You see that a particular product is getting a lot of page views, perhaps from an ad campaign or a blog feature, but it's not translating into sales. You need to figure out if the problem is the price, the product description, the photos, or something else on the page.
How Kocoro Helps: You can ask Kocoro to pinpoint these "leaky" products. For example: "Show me my top 5 products by page views that have a very low 'Add to Cart' rate (below 3%) over the last 30 days." Kocoro will instantly list the products where customer interest is dropping off. This allows you to focus your optimization efforts on improving the product pages that are getting traffic but failing to convert, plugging a significant leak in your sales funnel.
3. Optimizing Marketing by Analyzing Channel-Product Fit
Scenario: Your marketing team is driving traffic from different channels like Instagram, TikTok, and Google Search. You need to understand which types of products resonate best on each platform to make your ad spend more efficient and your content more relevant.
How Kocoro Helps: You can ask Kocoro for a direct comparison: "What were the top 3 selling products last month for traffic from 'Instagram' compared to traffic from 'Google Search'?" Kocoro can analyze the data and reveal powerful insights, such as: "Users from Instagram are primarily buying your 'Limited Edition Graphic Tees' and 'Colorful Sneakers', while users from Google Search are buying 'Men's Classic Leather Belts' and 'Formal Work Shoes'." This tells you to focus your visual, trend-based marketing on Instagram and your functional, intent-based marketing on Google, maximizing the ROI for each channel.
How to Create
Connect Your Data Source: Ensure your Google Analytics (GA4) account is connected in Kocoro's Workspace Settings. For this use case, it's critical that you have Enhanced Ecommerce tracking properly implemented in GA.
Use a Dedicated Agent: Create or select an agent named something like
E-commerce Analyst. Grant it access to the Google Analytics tool.Ask Product-Specific Questions: Start a chat by asking a clear question about your products. Reference key e-commerce metrics like "Buy-to-Detail Rate," "Add to Cart Rate," "Product Revenue," or "Quantity Sold."
Best Practice
Recommended User Prompt
For finding underperforming products:
For profitability analysis (requires COGS file upload):
For category-level performance:
For analyzing channel performance:
For a quick performance snapshot:
Recommended Agent System Prompt:
Instruction：
Model:
The Claude series is highly recommended for its ability to handle the structured data and logical calculations inherent in e-commerce analysis.
Tools:
Artifacts: For crafting a full dashboard.
Chart Generator: Useful for visualizing sales trends for a specific product or category over time.
Link Reader: Will be able to read your online product page content with given URL.
Knowledge Base:
To enhance analysis, attach documents like your product catalog (with categories and attributes), inventory level data, and your promotional calendar. This allows the agent to provide more context-aware insights, such as correlating a sales spike with a specific marketing campaign.
Data Sources:
Google Analytics
User-Uploaded Files
Meet a new era of work,
with AI made easy for everyone.
Effortlessly uncover deep customer insights and free your team from routine tasks, so they can focus on what they do best: creative, high-impact work that drives results.
Kocoro
English
Kocoro. All rights reserved. © 2025