Commission Reporting in Zoho Analytics (for both Zoho Books and Zoho CRM!)
Think About Your Commission Structure
Ask Yourself These Questions About Your Commissions Structure
What Is Your Business Model?
Map Out All Your Criteria!
Sync Your Data to Analytics
Build Your First Commission Report
Use Case #1—A Simple Cut of the Sales
Formula Columns for Conditional Commission Rates
Aggregate Formulas for Cumulative Conditional Commissions
What If My Commissions Structure Is More Complex?
Planning Out Our Commissions Use Case
Our First SQL Query, Calculating the Commissionable %
Understanding the Invoice and Customer Payments Data
Calculate Commissions Awarded for Payments
Understanding Credit Note Refunds and How They Play into Our Report
Calculate Your “Negative” Commissions Using Refunds
Consolidate Code and Finish Your SQL Query
Commissions Review
Previous Topic
Next Topic

What Is Your Business Model?

Commission Reporting in Zoho Analytics (for both Zoho Books and Zoho CRM!) Think About Your Commission Structure What Is Your Business Model?

Large, but few, closed deals?

Thousands of small sales/transactions?

One-time sale or recurring revenue?

Previous Topic
Back to Lesson
Next Topic
Commission Reporting in Zoho Analytics (for both Zoho Books and Zoho CRM!) Think About Your Commission Structure What Is Your Business Model?
close
  • Pricing
  • Get Help With Zoho
  • Free Zoho Learning Paths
  • Zoho Resources
    • Zoho Codebase
    • Zoho App Guides
Login
Previous Topic
Back to Lesson
Next Topic