Home > ItaoBuy: Building a Multi-Agent Comparison Dashboard

ItaoBuy: Building a Multi-Agent Comparison Dashboard

2026-03-02

In the world of Pandabuy, Sugargoo, and other shipping agents, data-driven decisions are key. For savvy users of ItaoBuy, creating a personalized comparison spreadsheet is a powerful way to visualize performance. This guide will walk you through building a multi-tab comparison table to analyze handling time, refund rate, and QC accuracy

Why Build an ItaoBuy Comparison Spreadsheet?

While individual agent reviews are helpful, a side-by-side spreadsheet

Setting Up Your Spreadsheet Framework

Create a new spreadsheet (Google Sheets, Excel, or Airtable work well). Name it "Agent Performance Dashboard". We will create three core data tabs plus a summary dashboard.

  • Tab 1: Summary Dashboard
  • Tab 2: Handling Time Comparison
  • Tab 3: Refund Rate & QC Accuracy
  • Tab 4: Raw Data Log

Tab 1: The Summary Dashboard

This is your homepage. Use tables and conditional formatting to create a quick visual overview.


| Metric          | ItaoBuy | Agent B | Agent C | Notes                 |
|-----------------|---------|---------|---------|-----------------------|
| Avg. Handle Time| 2.1 days| 3.5 days| 1.8 days| From order to storage|
| Refund Rate     | 4.2%    | 6.8%    | 3.9%    | Last 30 days          |
| QC Accuracy     | 98.5%   | 95.0%   | 97.8%   | Detail match to PSPs  |
| Overall Score   | 9.0/10  | 7.5/10  | 8.8/10  | Weighted formula      |
        

Tab 2: Handling Time Deep Dive

This tab tracks the speed from submitting a purchase order to the item arriving in the agent's warehouse. Create columns for: Date Ordered, Item, ItaoBuy (Days), Agent B (Days), Agent C (Days), Notes (e.g., holiday delays). Calculate averages at the bottom. Use a line chart to visualize trends over time.

Tab 3: Refund Rate & QC Accuracy

This tab focuses on agent reliability and service quality.

  • Refund Rate:(Number of Refunds Requested / Total Items Purchased) * 100.
  • QC Accuracy:

This dual-focus tab highlights which agents best prevent problems (refunds) and best document your items (QC).

Tab 4: Raw Data Log & Maintenance

This is your data backbone. Log every transaction in a single table with columns: Date, Agent (ItaoBuy/Pandabuy/etc), Item Cost, Shipping Cost, Handle Time, Refund Needed? (Y/N), QC Rating, Issue Notes. The other tabs will use FILTERPIVOT TABLE

Pro Tips for Effective Comparison

  1. Use Consistent Time Frames:
  2. Normalize Your Data:
  3. Leverage Charts:
  4. Update Regularly:

Conclusion

By building this multi-agent comparison spreadsheet, you transform subjective impressions into objective, actionable data. You'll no longer wonder, "Is ItaoBuy faster?"—you'll know

Start your spreadsheet today and take control of your agent performance analysis!