Oh Zapp! The Zazzle Store Royalty Analyzer: Excel Based Data Management Tool

Welcome Zazzlers!

A quick somewhat formal introduction: I am a Professional Data Scientist and Internationally Published Academic Author with a PhD in Biotechnology. I have years of experience in analyzing all kinds of data, from Blog SEO stats to Genetic Code. This here is my blog where I post my ramblings, poems, other writing pieces, research, art/designs and now even my development projects!

For the past few months I have been playing around with an idea to create a Data Analytics tool for the ZStore owner that is easy to use and readily accessible to everyone!

Proper analytical information assist with understanding your store performance, spotting trends in the data and making informed data driven decisions.

Anyone with a Zazzle store is very familiar with the ‘Royalty History’ CSV and that it is not an export that easily translates into store analytics, especially when the orders start adding up. I have used my data expertise and design tricks to convert the data in order to gather meaningful information from it and present it in a visually pleasing way.

Subsequently, it has been converted into an Excel spreadsheet tool available from SpreadSheetNut (links further down below), which literally works as easy as 1-2-3!

  • 1# Data Entry
    • Download your ZStore Royalty Export and paste it in!
  • 2# Data Processing
    • In the background, the tool re-arranges, formats, extracts and converts the data into analyzable numbers and categories!
  • 3# Data Visualization
    • Simply view all your store performance and stats in easy to understand dashboard(s) with interactive tables and graphs!

Free Download: PDF Version of the above Zapp Data Tool ‘How To’ Slides!

Product Levels

The Zapp Data Tool is available as a tier-based product of 5 levels for the Beginner owner to the Master analyzer! The product levels differ in the number of orders (i.e., rows in the CSV export) it analyses and the type of built-in functionality.

NameBeginnerAdvancedIntermediateExpertMaster
Level12345
# Orders100500100015002000
Basic
Dashboard
YesYes + Yes + Yes + Yes +
Advanced
Dashboard
Yes Yes + Yes + Yes +
Royalty
Timeline
Yes Yes + Yes +
Geography
Timeline
Yes Yes +
Product
Timeline
Yes +
Price (USD)$15.00$30.00$45.00$60.00$75.00

(+) = Expanded Analytics (for example; Level 1 has the Basic Dashboard, whereas Level 2 has the Basic Dashboard Plus (+) and Advanced Dashboard…)

I have made the Zapp Data Tool available to the Zazzle community at these discounted prices with the kind request that you’ll assist me in promoting my store products @ All_Natural_Spirit and/or aRtVerse and/or promoting the Zapp Data Tool (using the links below)!

The Zapp Data Tool is available from SpreadSheetNut, the premium reviewed spreadsheet marketplace:

Zapp Beginner: 100 Orders

Zapp, Zazzle, Store, Royalty History, Analyzer, Excel, Data, Management, Analytics, MyVerse, All_Natural_Spirit, aRtVerse, Tanzelle, Oberholster, MindFrameShift, SpreadSheetNut, anddnasci.wordpress.com
Zapp ZStore Royalty Analyzer Beginner Level 1

Beginner Functionality

Zapp Advanced: 500 Orders

Zapp, Zazzle, Store, Royalty History, Analyzer, Excel, Data, Management, Analytics, MyVerse, All_Natural_Spirit, aRtVerse, Tanzelle, Oberholster, MindFrameShift, SpreadSheetNut, anddnasci.wordpress.com
Zapp ZStore Royalty Analyzer Advanced Level 2

Advanced Functionality

Zapp Intermediate: 1000 Orders

Zapp, Zazzle, Store, Royalty History, Analyzer, Excel, Data, Management, Analytics, MyVerse, All_Natural_Spirit, aRtVerse, Tanzelle, Oberholster, MindFrameShift, SpreadSheetNut, anddnasci.wordpress.com
Zapp ZStore Royalty Analyzer Intermediate Level 3

Intermediate Functionality

  • 42 Single Metric/Calculation Values
  • 18 Interactive Tables
  • 18 Interactive Graphs
  • 3 Interactive Timeline Tables
  • 3 Interactive Timeline Graphs
  • Get the Intermediate Zapp Here!

Zapp Expert: 1500 Orders

Zapp, Zazzle, Store, Royalty History, Analyzer, Excel, Data, Management, Analytics, MyVerse, All_Natural_Spirit, aRtVerse, Tanzelle, Oberholster, MindFrameShift, SpreadSheetNut, anddnasci.wordpress.com
Zapp ZStore Royalty Analyzer Expert Level 4

Expert Functionality

  • 42 Single Metric/Calculation Values
  • 18 Interactive Tables
  • 18 Interactive Graphs
  • 7 Interactive Timeline Tables
  • 7 Interactive Timeline Graphs
  • Get the Expert Zapp Here!

Zapp Master: 2000 Orders

Zapp, Zazzle, Store, Royalty History, Analyzer, Excel, Data, Management, Analytics, MyVerse, All_Natural_Spirit, aRtVerse, Tanzelle, Oberholster, MindFrameShift, SpreadSheetNut, anddnasci.wordpress.com
Zapp ZStore Royalty Analyzer Master Level 5

Master Functionality

  • 42 Single Metric/Calculation Values
  • 18 Interactive Tables
  • 18 Interactive Graphs
  • 16 Interactive Timeline Tables
  • 16 Interactive Timeline Graphs
  • Get the Master Zapp Here!

Feedback or questions are also welcome at the shop!

Please ensure that you have the PowerPivot built-in feature for newer MS Excel versions (then your good to go with the Zapp!). Otherwise you simply enable the Add-In in your version of MS Excel (2010+) in order to use the Zapp Data Tool.

Ensure that you filter out empty/blank values (appear as #VALUE!) in the tables and charts! Otherwise you tables/charts won’t make sense 😆

Excel, Table, Chart, Filter, Blank, Empty, #VALUE!
Filter out blank/empty values from your interactive tables/charts.

This Zapp Data Tool (© MindFrameShift) is an unlimited personal use once-off purchasable product, thus there are no monthly re-occurring service/subscription fees. Please refer to MindFrameShift store policies for purchase agreements and terms of use on SpreadSheetNut!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s