Home Mail MemberMap Chat (0) Wallpapers
Go Back   ChiefsPlanet > The Lounge

Reply
 
Thread Tools Display Modes
Old 08-16-2013, 05:11 PM  
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 
Join Date: Aug 2000
Location: Austin
Casino cash: $10622
Need feedback on webpage (RainMan this means you!)

Ok, I am working on a new web service for people in the Texas bar industry(may expand to other states eventually). I have a prototype that is about 40% finished for the map reporting tool and would like to get some feedback before I go much further. There are still a number of small bugs that I am working on and the style will need a ton of work as well but overall I think the basics should function.

I'd mostly like to get feedback on the reporting itself and anything you guys think of that it may need added.

One thing that is being added but isn't yet showing is the ability to show sales data as it relates to Facebook activity(likes, checkin, events, etc) and Yelp reviews.

ok here is the site... Have at it!

http://barsalesmap.com/map.php
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-16-2013, 09:21 PM   #16
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $10622
Quote:
Originally Posted by Rain Man View Post
I'm not a big design guy, but when I think about functionality and how people would use the site, I would see them using the site for:

1. Sleuthing a particular bar, in which case they'd want a search function and the map function. The map function seems good.

2. Looking at overall market trends, in which case it would be nice to do a "select all" and see their sales summed. And maybe be able to select different time periods.

3. Looking at particular groups of bars, such as all bars in an area or all bars that include restaurants or all bars that have dancing or whatever. It seems like a search function by bar attribute would be nice.

How do you anticipate this site being used?

Also, I'm intrigued with where you would get the data for this. Is it something that the state publishes related to liquor licenses?
AH! This is EXACTLY the feedback I needed!

The market trends idea is a good one... I have the bars broken down by category (sports, dive, restaurant, etc) and also by subregions and other factors.. I did this so that you could filter results but didn't consider aggregating dating by those same factors. So you could get a report of dive bars sales in austin vs sports bars or warehouse district sales per bar vs eastside sales per bar... great idea but a lot of work.. unfortunately it's too good an idea so I'll have to do it... asshole! Would it be sufficient to run reports like this or would you think it would need to also be integrated into mapping somehow? (basically color coding entire ares of the map and overlaying the data)

The two main uses for the site as I see are

#1 for current bar owners to look at other bars not only in their region or district but by category or square footage or max occupancy then compare their sales with other factors such as Facebook activity and hopefully give them an idea of their place in the market and what they can do to improve

#2 for people looking to open a bar (or a 2nd or 3rd) to give them an idea of what sales to expect based on the various factors and help them pick a location

and that is just off the top of my head, I can't imagine that more uses for the data won't present themselves. All I know is that the bar owners I know have all said they'd want this.

The data is a mix of state(alcohol sales) and city data(sq ft / max occupancy) mixed in with Facebook and Yelp data. The database is actually a bitch to build but pretty easy to maintain. The hardest part is getting city data... most of the city officials I have dealt with are borderline retarded.
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-16-2013, 10:47 PM   #17
Rain Man Rain Man is online now
No known superpowers
 
Rain Man's Avatar
 

Join Date: Jul 2001
Location: In A World Few See
Casino cash: $8983
VARSITY
Quote:
Originally Posted by AustinChief View Post
AH! This is EXACTLY the feedback I needed!

The market trends idea is a good one... I have the bars broken down by category (sports, dive, restaurant, etc) and also by subregions and other factors.. I did this so that you could filter results but didn't consider aggregating dating by those same factors. So you could get a report of dive bars sales in austin vs sports bars or warehouse district sales per bar vs eastside sales per bar... great idea but a lot of work.. unfortunately it's too good an idea so I'll have to do it... asshole! Would it be sufficient to run reports like this or would you think it would need to also be integrated into mapping somehow? (basically color coding entire ares of the map and overlaying the data)
I wouldn't think that it needs to be integrated into the mapping. Honestly, I see the mapping as being of much less value than the search by name with the graphics at the bottom. It's a nice visual, but bar owners will know who they're looking for.

Maybe the mapping would be good for your potential bar owner market, though. Those folks will be less hooked in.

Quote:
Originally Posted by AustinChief View Post
The two main uses for the site as I see are

#1 for current bar owners to look at other bars not only in their region or district but by category or square footage or max occupancy then compare their sales with other factors such as Facebook activity and hopefully give them an idea of their place in the market and what they can do to improve

#2 for people looking to open a bar (or a 2nd or 3rd) to give them an idea of what sales to expect based on the various factors and help them pick a location

and that is just off the top of my head, I can't imagine that more uses for the data won't present themselves. All I know is that the bar owners I know have all said they'd want this.
If I may ask, what's your revenue model?

Quote:
Originally Posted by AustinChief View Post
The data is a mix of state(alcohol sales) and city data(sq ft / max occupancy) mixed in with Facebook and Yelp data. The database is actually a bitch to build but pretty easy to maintain. The hardest part is getting city data... most of the city officials I have dealt with are borderline retarded.
Interesting.
__________________
Welcome to NFL Sunday! At 11:00 see Peyton Manning flip off the top rope and clothesline Clay Matthews! At 2:00 Drew Brees will hit Terrell Suggs with a chair! Buy your Andrew Luck jersey and let's get reeeeeady to rummmmmble!
Posts: 77,611
Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.Rain Man is obviously part of the inner Circle.
  Reply With Quote
Old 08-16-2013, 11:14 PM   #18
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $10622
Quote:
Originally Posted by Rain Man View Post
I wouldn't think that it needs to be integrated into the mapping. Honestly, I see the mapping as being of much less value than the search by name with the graphics at the bottom. It's a nice visual, but bar owners will know who they're looking for.

Maybe the mapping would be good for your potential bar owner market, though. Those folks will be less hooked in.
I tend to agree except that I have found a number of bar owners that simply can't keep up with all the bars in their area. (That's probably a purely Austin problem though.) The real value of the map for me is the "at a glance" data that you can then drill down into.

Quote:
Originally Posted by Rain Man View Post
If I may ask, what's your revenue model?
Monthly subscription website(that's how often the data is updated). I'm not certain on pricing though. I have a general idea of what to charge but I have to keep in mind that this service will be offered "free" when bundled with an entire bar/restaurant marketing suite I am developing... so I may "overcharge" for this service to try to promote the value of the suite. Not sure on that yet. Still have time to work that out.

Quote:
Originally Posted by Rain Man View Post
Interesting.
What's going to be REALLY interesting is when/if I expand outside of Texas. Every state has there own unique take on alcohol control and taxation. A number of states simply won;t have the data at all others will require creative means to obtain it. For example, Pennsylvania has a state monopoly on wholesale liquor sales... so in theory I could do a public records request on the sales they make to each licensee(bar). While it doesn't represent sales numbers it would be analogous enough.
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-27-2013, 04:01 AM   #19
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $10622
Quote:
Originally Posted by cdcox View Post
In Chrome, Arlington and Downtown Austin look like the ocean (all blue) until you select a bar.

If you make the font size too big, you lose parts of the graph.

When you have the maximum font size to see the whole graph there is too much black space between the map and the graph.
OK I have fixed the "ocean" problem and added a bunch of new functionality. The DIVS are still whacky but those won't get fixed until the very end probably. I have to wait a few weeks before the FaceBook/Yelp data can go in so I'll probably put the map on hold soon and get to work on the tabular custom report building section until then.

If anyone has a few seconds.. test it out and tell me what is still broken and give me any other feedback you might have!

Thanks!

http://barsalesmap.com/map.php
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-27-2013, 06:15 AM   #20
TribalElder TribalElder is offline
Central Missouri Mules!
 
TribalElder's Avatar
 

Join Date: Oct 2012
Location: National Champions
Casino cash: $22915
If possible could you link to the menu and or specials for each location? Maybe tequila is a hot ticket item on taco Tuesday or some other unbelievable special helps make up for anomaly in the map. Just a thought
__________________

Quote:
Originally Posted by kcpasco View Post
All us Mizzou fans knows how this ends
Quote:
Originally Posted by petegz28 View Post
holy **** that was a bullshit call
Quote:
Originally Posted by Tacoman View Post
Being the resident Tacoman, I feel obligated to point out that TribalElder knows what's up.
Posts: 11,506
TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.TribalElder has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-27-2013, 12:32 PM   #21
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $10622
Quote:
Originally Posted by TribalElder View Post
If possible could you link to the menu and or specials for each location? Maybe tequila is a hot ticket item on taco Tuesday or some other unbelievable special helps make up for anomaly in the map. Just a thought
Well the map data only updates monthly so daily fluctuations won't matter. BUT along that same line of thinking... the FB data that is now being aggregated for each location will do something similar. You'll be able to see if a bar's sales correspond with FB activity (likes, checkins, events posted, overall activity etc...)
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Old 08-31-2013, 01:03 AM   #22
AustinChief AustinChief is offline
Administrator
 
AustinChief's Avatar
 

Join Date: Aug 2000
Location: Austin
Casino cash: $10622
OK, bunch of new stuff on the site, DIVS still are wonky but that's tomorrow's project. Anyone wants to check it out and tell me what is broken, that would be helpful!

http://barsalesmap.com/map.php
Posts: 15,106
AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.AustinChief has enough rep power to blowy ou to bits.
  Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump




All times are GMT -6. The time now is 09:01 PM.


This is a test for a client's site.
A new website that shows member-created construction site listings that need fill or have excess fill. Dirt Monkey @ https://DirtMonkey.net
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.