Application of Spreadsheets in Eastmallbuy’s New Product Promotion: Evaluation and Strategy Optimization

Introduction

In the competitive world of international purchasing (daigou), Eastmallbuy has leveraged spreadsheets to systematically evaluate and optimize the effectiveness of new product promotions. By integrating data points such as promotion channels, costs, exposure, click-through rates, conversions, and sales revenue, Eastmallbuy transforms raw data into actionable insights to refine marketing strategies.

Data-Driven Promotion Evaluation

Collected Metrics: Spreadsheets consolidate key performance indicators (KPIs) including:
- Channel-specific ad spend (e.g., Google Ads, WeChat campaigns)
- Impression-to-click ratios
- Customer conversion rates per platform
ROI Analysis: Formulas calculate cost-per-acquisition (CPA) and ROI by comparing promotion costs against revenue generated.

"Spreadsheets enable real-time tracking of cross-channel performance, eliminating guesswork in budget allocation." — Eastmallbuy Marketing Team

Strategy Optimization Insights

Promotion Tactic	Advantages	Limitations	Optimal Use Case
Social Media Ads	High audience targeting precision	Increasing cost competitiveness	Niche product launches
KOL Collaborations	Strong trust & engagement	Influencer fees vary widely	Luxury/prestige items

By visualizing trends through pivot tables and charts, teams identify underperforming channels to redirect budgets toward high-impact strategies.

Results & Continuous Improvement

Quarterly Adjustments: Reallocate 70% of SEM budgets to Douyin campaigns after spreadsheet analysis revealed 3x higher conversions.
Dynamic Testing: A/B test landing pages by tracking spreadsheet-generated UTM parameters to refine messaging.

As of 2024, Eastmallbuy achieved a 40% reduction in customer acquisition costs while doubling new product sales YoY.