Welcome
Easy to follow, step-by-step instructions with screenshots and links
Assumptions and Guide
Index of links to all tabs
Support links to private Facebook group question threads
General assumptions & Recommendations on how to use the file
Your Zazzle Earnings CSV download
Your Zazzle Royalty CSV download
Your Zazzle Referral CSV download
Royalty and Referral Forecasting
Yearly Forecast
Monthly Forecast
Track Forecast vs. Actuals
Forecast Dashboard
Lifetime Earnings
Zazzle ProDesigner Level Achieved
Earnings needed to level up. Based on total lifetime earnings from Zazzle's U.S. domain (Zazzle.com)
Total Earnings Forecast vs Actual by Year Chart
Royalty Forecast vs Actual by Year Chart
Referral Forecast vs Actual by Year Chart
Helpful Hints & Tips to Analyze each chart
Monthly Dashboard - STORE & USD/INTERNATIONAL SLICERS
Total Earnings by Month & Year Chart
Total Royalty, Referral, and Volume Bonus by Month Chart
Total Transactions by Month Chart
% of Total Earnings by Month Chart
Avg $ per Transaction by Month Chart
MoM % Change in Earnings Chart
Helpful Hints & Tips to Analyze each chart
Yearly Dashboard - STORE & USD/INTERNATIONAL SLICERS
Total Earnings by Month & Year Chart
Total Royalty, Referral, and Volume Bonus by Year Chart
Total Transactions by Year Chart
% of Total Earnings by Year Chart
Avg $ per Transaction by Year Chart
YoY % Change in Earnings Chart
Helpful Hints & Tips to Analyze each chart
Whether you're a Zazzle Affiliate or a Zazzle Designer, you will visually be able to determine your top selling designs and products - so you can sell more
Customer Behavior Dashboard - STORE & USD/INTERNATIONAL SLICERS
Unique Number of Customers
Total Royalty & Referral Earnings
Average $ Spent Per Customer
Total Royalty by Hour and Day of Week Chart
Total Royalty by Country and State Chart
Total Referral by Day, Hour, and Source Chart
Total Royalty by Referral Source Chart
Total Referral by Tracking Code Source Chart
Count of Referred Transactions by month and Year Chart
Customized Transactions by Month and Year
Helpful Hints & Tips to Analyze each chart
Top 20 Royalty by Date Comparison Dashboard - STORE & USD/INTERNATIONAL SLICERS
All-time top 20 product title and type by royalty
Compare Side-by-Side any date ranges
Helpful Hints & Tips to Analyze the charts
Top 10 Royalty Dashboard - STORE & USD/INTERNATIONAL SLICERS
All-time top 10 product title and type by royalty
Last 12 Months - top 10 product title and type by royalty
Last 3 Months - top 10 product title and types by royalty
Last Month - top 10 product title and types by royalty
Helpful Hints & Tips to Analyze the charts
- Top 10 Referral Dashboard
All-time top 10 product title and type by referral
Last 12 Months - top 10 product title and type by referral
Last 3 Months - top 10 product title and types by referral
Last Month - top 10 product title and types by referral
Helpful Hints & Tips to Analyze the charts
Store Slicers allow you to view all the charts by the individual or combination of your stores
USD/International Slicers allow you to view all the charts by either USD or International sales
All pages, charts, and pivots are printer friendly
Support via DanielleFernandezDesigns@gmail.com
Support via private Facebook group
Access to future workbook updates