Monitoring your sales

[sm1]

Does anyone make use of a dashboard style interface (mainly for online retail) so they login and can see all sorts of statistics such as the most purchased product, amount of new members, total sales etc.?

Not after anything, just interested. Sort of like a KPI dashboard :)

Cheers

[sysops]

Does anyone make use of a dashboard style interface (mainly for online retail) so they login and can see all sorts of statistics such as the most purchased product, amount of new members, total sales etc.?

Not after anything, just interested. Sort of like a KPI dashboard :)


We have, it gives me all the data on one handy page. It also has a bunch of forms at the bottom for generating more detailed reports, for a closer look at any one set of metrics. Our developer spends a lot of time writing new reports :)

But handy as this is, it's nothing compared to my master spreadsheet. This holds and analyses every piece of data available, pulled in from lots of different places (for instance, data from Google Analytics or Adwords isn't available in the dashboard).

[garyk]

Yes but for other people! Most of my work is around financial reporting/KPI/BI work.

[sm1]

Cheers both! I'd originally heard about these a few months back, where I saw one of the founders of lovefilm doing a talk, and he said about how he can access loads of reports instantly.

Sysops - Sounds good. That's exactly what I was thinking about. So is your master spreadsheet taking off all data from the websites and stores, as well as Analytics etc.? Where else do you pull your data from? :)

Gary - Cheers :) I guess if it's your business you have to ;)

Thanks! :)

[sysops]

Sysops - Sounds good. That's exactly what I was thinking about. So is your master spreadsheet taking off all data from the websites and stores, as well as Analytics etc.? Where else do you pull your data from? :)

Data for the master spreadsheet comes from a whole bunch of places, main ones:

1. Web database (custom csv download). This gives me all customer, sales and stock data.

2. Analytics

3. Adwords (spend and conversion)

4. Server logs (to fill in the gaps in Adwords)

5. Accountant (payroll, expenses etc)

6. All other overheads (rent, rates, utilities etc)

One of the best features is the ability to generate purchase orders straight from the web interface. We just wouldn't be able to function without that, given that we have over 200 suppliers and nearly 2000 lines.

[sm1]

Thanks for that - sounds good. Lots of monitoring going on. A bet that's a heavy spreadsheet! The main thing is you're able to integrate various sources of info, and get a calculated response on how everything's working.

Cheers :)

[sysops]

Thanks for that - sounds good. Lots of monitoring going on. A bet that's a heavy spreadsheet! The main thing is you're able to integrate various sources of info, and get a calculated response on how everything's working.


It is pretty huge, and it's the one thing I'd be totally lost without. Backed up in a whole bunch of places (encrypted).

[sm1]

Cheers - good to see you have it backed up :) It's an essential way to see your business!:)

Happy New Year :D