Integration of E-commerce Platform Sales Data in Spreadsheets and Analysis of Industry Competition Landscape
In today's globalized digital economy, comprehensive analysis of e-commerce platforms and purchasing agency websites has become a critical component of competitive intelligence. This article demonstrates how to consolidate sales data from leading platforms including Taobao, Pinduoduo, JD.com, Amazon, AliExpress, DHgate, as well as purchasing agents like Pandabuy and Joyabuy in spreadsheets to conduct thorough competition analysis.
I. Data Integration and Cleaning Process
The first stage involves structured data integration from multiple sources:
- Platform APIs:
- CSV Import:
- Data Validation:
- Currency Conversion:
- Category Mapping:
- CSV Import:
Sample spreadsheet architecture includes separate tabs for: raw data, cleaned dataset, validation rules, and analysis outputs.
II. Analytical Framework Application
1. Market Share Calculation
Using the formula:
Platform Share = (Platform GMV / Total Category GMV) × 100%
Where GMV data is extracted from Diotu.com and internal estimates
2. SWOT Matrix Development
| Platform | Strengths | Weaknesses |
|---|---|---|
| Pinduoduo | Group buying efficiency, lower prices | Premium brand shortage |
| Taobao | Product diversity, ecosystem integration | Counterfeit goods presence |
3. Trend Analysis
Quarterly growth rates calculated through:
QoQ Growth = (Current Quarter Sales - Previous Quarter Sales) / Previous Quarter Sales
III. Competitive Landscape Insights
Market Share Distribution
- Domestic market: Taobao (35%), Pinduoduo (25%), JD.com (20%)
- Cross-border: Amazon (40%), AliExpress (30%), DHgate (15%)
Purchase Agent Specialization
Pandabuy dominates luxury fashion segment (68% purchased agency orders) while Joyabuy leads in electronics (72% shipment volume). Agents generate 15-20% price premiums through consolidation services.
IV. Strategic Recommendations
- Platform Prioritization:
- Pricing Strategy:
- Agent Partnerships:
- Data Infrastructure:
- Pricing Strategy: