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.

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.

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

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

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.

__________________
My ancestors fought cave bears so I could make this 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

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

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.

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!

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

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...)