SL Statistics [Open Beta]

New tool being created, a statistics tool for your sales on various sites and sources (planed).

Currently has a number of the key functions that it will have when it gets more and more done and adjusted.

Key elements in current beta progress:
- Import from SL Botique
- Import from SL Exchange
- Viewing of items
- Viewing of customers
- Recent sales
- Graphs and history

Custom imports and sources are in the works, mainly focusing on getting diffrent tools up and going.

There is planned a import tool which can import from source seperated by commas, tabs or cvs style. Also filtering for prices, names, descriptions, date and so on.

I invite now people to come beta test it and try things out, see how it runs for diffrent users and systems.

To register you click a object in SL, it's located under my profile (Nightwalker Shatner), check the picks and teleport to my shop location, click the object there and you will recive a comfirmation shortly and a password, after that you will be given a link to the web site. Which is located at: https://revoken.dyndns.org:8080/

Preview is avilable here

Location: Dagger (231, 48, 102)

TERMS OF USE
============
This service shall not be used to conduct or involve illegal activity in any way
or portion.

Information submitted to this server will never be resold, copied or in any form
transferred away from this server besides backups of the database.

The information or data submitted to this server will never be handed, sold,
copied or in any other form transferred or viewed to a 3rd party or Linden Lad.

This site does not have any relations with Linden Lad or it's employers.

Weekly statistics of user activity and visits might be stored on a later date,
but people using this site will remain anonymous.

Use common sense and do not try to temper with the system, anyone caught
attempting to do something they are not suppose to do intentionally, will lose
their access to this site and in the future.

The usability of the site might change from browser to browser, currently
suggest people to use Opera which is free and supports the international standards
and being a very clean and low resource browser.

Please direct all questions or comments to me (Nightwalker Shatner) by IM in
Second Life.

If you want a custom format for the parser you can submit the specifications of this format to Nightwalker Shatner on a notecard.

Note: There will be added support for importing data from the transactions page on secondlife.com and also a general import format in cvs like and xml like format.

These are the data specifications of the sales database:

Column  Length  Type    Comment
======  ======  ====    =========
Buyer	16+16 	text	(16 first name, 16 last name)
Item    64      text    No quotes, " <-- this sign
Price   12 		number	No "." or "," (period or comma)
Time    Nolimit date	YYYY-MM-DD HH:MM:SS (24 hour system)
TrasID	12      number  Transaction ID (from your system)
ItemID  12      number  Item ID (from your system)

Prefered listing:
<time>,"<buyer>","<item>",<price>,<trasid>,<itemid>[newline]
<time>,"<buyer>","<item>",<price>,<trasid>,<itemid>[newline]
<time>,"<buyer>","<item>",<price>,<trasid>,<itemid>

Example:
2006-05-17 20:00:29,"Nightwalker Shatner","Clothing - Blue",200,31234,1312

Yes this is what SL needs. Very cool.
We want more

Nice very useful service. Something I'd gladly pay for, but...

The issue I see with something like this is what confidentiality agreement do you offer that the collected information will not be used by you or sold? I don't see any terms on the site and I realize this service is just starting but that issue alone will keep me from using it.

I'll get a agreement going in the writing, collected information would be private ofcorse and only viewed by the user.

Only way you can get a password is via SL, which should be enough to validate your name clicking on a object. I'm also going to setup a SSL layer on the site, to get a bit more security going on, besides the other security messures done

Site moved to: https://revoken.dyndns.org:8080/
This to get the use of the SSL layer for more security.

Updated with a Terms of use, please check this out and understand a non-english person wrote it

Fixed a bug with the registration system, some users were unable to register today, should be fixed now.

I like itThank you

SL Exchange importing is now more or less fail prof, thanks to the users who have used the system so far and contributed to make things run smooth

Improved the design and item name links to support any characters.

Also installed a better hardware router to manage the traffic better and faster.

Comparison of items has been added, compare by price total and sold count.

Various fixes and improvments on the activation part and other things.

- Added a popup window for the item compare section to make it more accessible
and also make the site faster for people with many items.

- Added some initial limits on the item pages, so you dont get all items or sales
history at once.

- Added a pie chart for the items page, only items who sell over 1% will be shown.

very cool, but is this useless if you dont use SL Boutique or SL Exchange?

Custom imports and sources are in the works, mainly focusing on getting diffrent tools up and going.

There is planned a import tool which can import from source seperated by commas, tabs or cvs style. Also filtering for prices, names, descriptions, date and so on.

Added a new stats page, that allows you to get a month by month information of your sales, earnings, max-, min-, avg price.

Earnings are listed in: L$, dollars, EUR, GBP, NOK, CNY, THB, JPY currency.
Below it is a listing of items sold, their earnings and sales count.

Added some specifications on the data in the sales database, this can be used to request data import tools for a specified source or a tool of choice.

Please if people have suggestions to the site, please submit them to me in IM's in SL via notecards

very cool!