Sales Commission Tracker for Fitness Tech Brand
Speediance Case
Date: 00.00.00
Overview
Client: Speediance (Smart Home Gym Manufacturer)
Problem:
-
Sales from Shopify, Amazon, and reps manually logged in Sheets, causing commission disputes and 10-day delays in payouts.
-
No real-time visibility into individual rep performance.
Goal:
Automate sales tracking and commission calculations by:
-
Syncing Shopify/Amazon sales data to Google Sheets hourly.
-
Matching sales to reps via unique referral codes.
-
Auto-generating weekly commission reports.
Technologies Used:
-
Zapier: Shopify/Amazon to Sheets sync.
-
Google Apps Script: Referral code validation, commission logic.
-
Looker Studio: Rep performance dashboards.
Results (Overview):
Reduced commission processing time from 10 days to 24 hours and eliminated payout disputes.
-
Sales Data Automation: Set up Zapier to pull order details (product, amount, referral code) into Sheets.
-
Rep Matching System: Built Apps Script to validate referral codes against a rep database and flag mismatches.
-
Commission Logic: Added tiered commission rules (e.g., 5% for $0-$10K, 7% for $10K+).
-
Weekly Reports: Auto-emailed PDF summaries to reps every Monday.
Final Solution:
A transparent commission system that:
-
Boosted rep morale with timely, accurate payouts.
-
Helped managers identify top performers (top 3 reps drove 40% of revenue).
Client testimonial
5.0
Lorem ipsum dolor sit amet, 
conse ctetur adipiscing elit. Sed varius ornare turpis, ut luctus lectus efficitur vel. Quisque a ipsum laoreet, porttitor ipsum quis, imperdiet nisi. Sed varius ornare turpis, ut luctus lectus efficitur vel. Lorem ipsum dolor sit amet, conse ctetur adipiscing elit. Sed varius ornare turpis.
John Doe
Co-Founder at Google