We’re very excited to announce support for Geckoboard widgets from OrderPipe. This means you can now display your OrderPipe metrics such as revenue, orders or units (current or 30-day history) as Geckoboard custom widgets. You can also show OrderPipe sales locations on a map on your Geckoboard dashboard. As a bonus, using our other new feature, tags, you can even show pie charts which break down your tag revenue, units or orders metrics for the day so far. Can you tell we’re very excited about this?! We’ve been using a ‘pre-alpha’ (read: in-development) version of the our widgets on a Geckoboard LCD in our office and it’s totally cool to see the metrics on a big screen. The projector I’m told, sadly, has to wait until the numbers are a bit higher! The good news for merchants selling on Amazon, Magento or Shopify is that you can now effortlessly show key ecommerce metrics alongside your Google Analytics, Salesforce, Facebook or Twitter interactions or server performance monitoring widgets with Geckoboard - too easy.
What is Geckoboard?
Geckoboard is a hosted, real-time status board serving up business indicators such as metrics for web analytics, CRM, support, infrastructure, project management, and sales.
Geckoboard dashboards are perfect for display on a big screen in your office showing real time, automatically-updated, the key metrics to keep track of your business. For e-commerce businesses key metrics include orders, revenue, top-selling products and sales trends. What’s the best source of metric data to display on a geckoboard dashboard? OrderPipe.
How does it work?
There’s only two steps, one on the OrderPipe side to enable Geckoboard and one on the Geckoboard side to grab the Orderpipe metrics into a custom widget.
1) In OrderPipe go to your settings and enable Geckoboard by clicking the button, surpisingly labeled ‘Enable Geckoboard’ as shown below.
Once enabled, the Geckoboard settings section will reveal the wide range of available widgets, and each will have a specific URL beside it.
2) In Geckoboard create a new custom widget with the following settings:
- Widget type : Custom - Feed format : XML - Request type : GET - Reload time : this can be whatever you want but 3 minutes is quite nice. - Label : whatever you want.
And obviously the URL is one of the URL’s that you copy-paste from OrderPipe.com - chosen depending on which actual metric you want to see.
That’s all there is to it, the Geckoboard widget will use the special URL we generated and grab your metrics, graphs, maps or pie charts for display along side any other dashboard data. That has to be the easiest way to get Amazon, Magento and Shopify hooked up to Geckoboard? Whoop! We think so too.
Is this Secure?!
Each Geckoboard URL is uniquely generated using two 128 bit keys - if you are reading the section on security you may care to know they’re cryptographically strong pseudo random numbers but more importantly, with two of them combined, you have 2 to the power of 256 possible key pairs (that’s about 7-with-68-zeros-after-it years to break the key at 5 attempts per second). So the URL’s themselves are strong, no-one will guess yours that’s for sure. But if you give it to someone, and then later decide you do not want them to have access to your data, you can refresh your keys by clicking the button on the settings screen. This will invalidate your previous Geckoboard URL’s and only your newly generated ones will work.
What Widgets can I use?
At the moment there are 15 available widgets to choose from. There are five types of widgets each of which can be used with one of three metrics; revenue, units or orders.
This widget shows the current days value for Revenue, Units or Orders. This is very useful for seeing how your daily sales have been going. This is a Custom Widget of type ‘text’ in Geckoboard.
30 Day Line Graphs
This widget shows the last 30 days values for Revenue, Units or Orders. This is very useful in seeing the trend for you sales over the past 30 days. This is a Custom Charts of type line chart in Geckoboard.
Top SKU Table
This widget shows you your top SKU’s that have been selling today. It will automatically place any other sales not in your top SKU’s in an other category. This is useful to see what SKU’s have been selling well today. This is a Custom Widget of type text in Geckoboard.
This widget shows you where orders have been coming in from today. It also shows bigger points for bigger sales in that city, either more revenue, units or orders. This is a Custom Widget of type Map in Geckoboard.
Tag Pie Charts
This widget shows a pie graph of your sales today, based on custom tags you configure. You can find out more about tags in our other blog post announcing the feature. It will use the colour you chose for each tag, or an arbitrary colour if you choose “don’t care”. If you define tags for brand, or product category than you can visualize what percentage of revenue is being made by members of those categories or brands. This is a Custom Chart of type pie in Geckoboard.
Note: Since an item can match more than one tags the pie charts can reflect more than the total amount of revenue, orders or units in a day - so be careful about how you set up your tags, or reconsider using a pie chart if your data does not fit well to the pie chart assumptions.
Stay tuned we’ll have a blog post shortly about how to setup and define tags, and also how you can best use them with your order data.
If you have any questions or comments on how these widgets work, please do not hesitate to contact us.