Page 2 of 4

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 12:17 am
by monkeymaximus
that is def do-able.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 7:07 am
by Skelator03
Sounds like a great idea. Seems to be a lot of traffic. Even deank put a mention to brewology in his newest update.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 10:25 am
by The Cookie Monster
We should compile a list of all the users we want then..

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 11:27 am
by monkeymaximus
Or criteria that we can do a sql query with.

For example: users that signed up between 2007-2009, that had 100+ posts.

--nik

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 11:42 am
by deroad
that can be a good idea nik!

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 11:53 am
by The Cookie Monster
monkeymaximus wrote:Or criteria that we can do a sql query with.

For example: users that signed up between 2007-2009, that had 100+ posts.

--nik


Well, you're admin, so you get to choose.
Whatever you choose, the sooner the better!

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Dec 31, 2012 2:31 pm
by monkeymaximus
haha. Ill think about it but I want your guys input :) and then we can join them together.

I think for the first one active users are better. So 50+ / 100+? Opinions?

Depending on teh size of that set we can add more things.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Tue Jan 01, 2013 5:48 am
by The Cookie Monster
monkeymaximus wrote:haha. Ill think about it but I want your guys input :) and then we can join them together.

I think for the first one active users are better. So 50+ / 100+? Opinions?

Depending on teh size of that set we can add more things.


100+ seems a lot better than 50+ tbh, I don't think if someone had about 51 posts, they're coming back anyway.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Tue Jan 01, 2013 11:54 am
by Skelator03
I would love to see the database and play around with the SQL Query. What kind of info is logged? Last activity date? Last post date?

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Wed Jan 02, 2013 5:44 pm
by monkeymaximus
Sounds good! Its the phpBB database. So if you take a look at the schema for their user table its all that info. The db is all sandboxed so it cant be accessed from the outside but I can run ideas you guys come up with.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Wed Jan 02, 2013 7:22 pm
by Skelator03
It would be really cool if there was a way to export the raw data in some delimited fashion. csv or whatever it may be. We could run some analysis through tableau and i bet you could see who would be more likely to come back and post more. I don't know if your familiar with tableau but check it out. I use it often at work.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Wed Jan 02, 2013 9:29 pm
by monkeymaximus
ooo sweet. Ill def take a look

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Sat Jan 05, 2013 5:58 am
by The Cookie Monster
AdventWolf
ace
airplanes18
Alex Finlay
brentbizzle
BKFraiders7
crait
DarkPacMan77
Devil May Cry
fallen
False_chicken
gman
irishdragon85
JustinWoodypond
Kanadier
light_alistor
Puncharger
que13x
Slick
.Vault
.Yunoko

The people from my time at the brew, I've probably missed some, but that's a start I guess if this is needed.

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Sat Jan 05, 2013 10:55 am
by D3ViLsAdvocate
Add to your list.

Vault
.Yunoko
ace
AdventWolf
alimobeer
arto14
asddasit
bclowe
blackzmage
CLMT
crait
Danopoly
Darksleem
fallen
Figz
FireFoxx
im_on_teh_computer
in_da_house
Jay-Jay
jtwright
JustinWoodypond
Kanadier
light_alistor
Mailas
monkeymaximus
Necrophiliac
nemesis91101
newpspdude
notjy
psicryptor
PSP_man
Puncharger
roxfox64
shadox
Slick
Supashay91
Surenix
Terdinglage
TK421
Yumiko

Re: Dec 25 - Brewology should get some new traffic in ...

PostPosted: Mon Jan 07, 2013 2:18 am
by monkeymaximus
niiice.