This quick guide will get you familiar with the Data Cube tool in the Sales section of the Tradable Bits platform.
Note: Before you read the “how to do it” make sure you understand the “what and why to do it”. Get caught up on the capabilities of Data Cube, by reading up on the Introduction to Sales Reporting
Head to Sales>Data Cube to get started. First off, let’s dive into some definitions:
Definitions:
-
Date: This is the period you want to analyze
-
Venue: Where your event is taking place, or in the case of merchandise, where your fan collects the item or makes the purchase.
Note: Venue names are initially pulled from your ticketing integrations, but you can create new venues/ match multiple venues to one in “cleanup”.
1. Idol: Idols represent brands, musicians, celebrities, athletes and influencers that fans interact with on Spotify & Facebook. All of your idols are set up within the “Idols” section of “Know your Fans.” Our system will automatically match the artist_name field from your ticketing provider to “idol”. If you wish to add a new idol within Tradable Bits, read "How to create a new idol"
2. Price Code (SKU): These are the “price-sets” your tickets/items are grouped in. The classic example is General Admission vs VIP.
Price Codes are pulled from your ticketing integrations, so make sure that your venues use the same naming conventions across the board. (I.e. if you’re searching for VIP tickets, and one of your venues has named them “PRIMO tickets instead, they will not show up in your search). Should you run into an issue with inconsistent price code names, you can match multiple price codes to one in “cleanup”
To view all price codes for your business, simply select “price code” and click search !
3. Source: Where your purchasing information is coming in from. Source will show you which ticketing integrations are pulling, so it’s a great field to look for if you want to double-check your integrations during on-sale. For example, you will be able to see that 8000 tickets were sold from Eventbrite (Source) at an amount of CAD 300,000.
4. Event Name: The name of your event. This name is also pulled from your ticketing integration. Our system automatically combines “event date” with “event name” on display to showcase exactly when your event took place, but when you are using “event name” as a field elsewhere, make sure to exclude the date.
The definitions above are how your data is organized within Tradable Bits, and as a result, are the fields that you can pull when you want to analyze your purchasing data.
How to Pull a "Breakdown" Report on your Purchasing Data:
Now that you know what each field represents, it’s fairly easy to pull a report. Simply select your date range, choose the breakdowns you would like to filter by (i.e. venue name, idol etc) and click “search”.
Please note: You can choose up to 3 breakdowns/fields for each search
