CFC Member Stats

[Hugh Brodie]

Re: CFC Member Stats

We could do what other organizations do - the "membership fee" is a percentage of the tournament entry fee - e.g. 10%. If the entry fee is $40, the CFC gets $4 from everyone. No more need to process memberships and keep track of expiry dates - if you enter a tournament - you are automatically a CFC member (the organizer will still have to send the CFC the money - but they would be sending the rating fees anyways).

[John Brown]

Re: CFC Member Stats

I don't even know why we have a Junior Membership fee. Just reduce the Adult fee to $45 and Increase the Junior fee to $45 and that is CFC Membership fee.

I don't mind giving a Family discount. Or Keeping a one time tournament fee, but as Juniors are playing in Adult mixed events then just have one fee $15.

Just make the membership to join the CFC one price then everyone would just be a number and would not have to be segregated by age.

[John Brown]

Re: CFC Member Stats

Can't you just run a program that looks at expiry dates. If they expire after say Sept. 1, 2017,then 2018 or never(Life) then you'll have current members.
All the rest would be either expired or one time tournament players.

[Neil Frarey]

Re: CFC Member Stats

Ah, now I understand. Yes, a big majority of the expired memberships on the TD list will be juniors who have never paid membership dues. Juniors only pay for memberships when they either play in the CYCC or join in adult tournaments. I don't have any relevant stats on this at my finger tips, but we are currently developing some data mining programs that may shed some light in the near future.

What kind of 'data mining' programs are you 'currently' developing? And in which language are they written, Bob G.? Excel data > JavaScript Arrays, then target some variables? Perhaps simply by using some Microsoft Excel formulas?

And exactly what do you mean when you say 'may' shed some light?

Maybe, kinda, sorta, 'near' future?

[Paul Bonham]

Re: CFC Member Stats

Ah, now I understand. Yes, a big majority of the expired memberships on the TD list will be juniors who have never paid membership dues. Juniors only pay for memberships when they either play in the CYCC or join in adult tournaments. I don't have any relevant stats on this at my finger tips, but we are currently developing some data mining programs that may shed some light in the near future.

Bob, are the rumors true? Has Neil Frarey been instated as the "canary in the data mine"?

[Bob Gillanders]

Re: CFC Member Stats

Sorry, I didn't put them side by side questioning why they didn't match. I'm just wondering how more memberships expire than were even paid for. I'm not sure how many members are "new" and how many are "renewals" in the CFC financial documents. I guess there are 1000's of youth playing in a single tournament for free to get on the TD list and then not "renewing". 2/3 of expiring players are rated under 1200.

Ah, now I understand. Yes, a big majority of the expired memberships on the TD list will be juniors who have never paid membership dues. Juniors only pay for memberships when they either play in the CYCC or join in adult tournaments. I don't have any relevant stats on this at my finger tips, but we are currently developing some data mining programs that may shed some light in the near future.

[Brent Golem]

Re: CFC Member Stats

Brent, there is no reason these two numbers would match.
For example, your figure of 1,576 memberships for 2016 ( per note 5 ) only include specific membership types, but most of those would now have expiry dates of 2017 or 2018 as many of them have since renewed.

Sorry, I didn't put them side by side questioning why they didn't match. I'm just wondering how more memberships expire than were even paid for. I'm not sure how many members are "new" and how many are "renewals" in the CFC financial documents. I guess there are 1000's of youth playing in a single tournament for free to get on the TD list and then not "renewing". 2/3 of expiring players are rated under 1200.

[Bob Gillanders]

Re: CFC Member Stats

I also looked at expiry of the TD list and it's tough to wrap your head around. How can there be such a difference between "expiring" dates and annual membership? It does not appear that there are duplicate names in the TD list.

Expiry - TD List - CFC Membership
2016 --- 1307 --- 1576
2015 --- 1254 --- 1390
2014 --- 2123 --- 1428
2013 --- 2098 --- 1411
2012 --- 1744 --- 1412

Edit: Presumably it has something to do with single tournament memberships, but that seems high.

Brent, there is no reason these two numbers would match.
For example, your figure of 1,576 memberships for 2016 ( per note 5 ) only include specific membership types, but most of those would now have expiry dates of 2017 or 2018 as many of them have since renewed.

[Fred McKim]

Re: CFC Member Stats

I also looked at expiry of the TD list and it's tough to wrap your head around. How can there be such a difference between "expiring" dates and annual membership? It does not appear that there are duplicate names in the TD list.

Expiry - TD List - CFC Membership
2016 --- 1307 --- 1576
2015 --- 1254 --- 1390
2014 --- 2123 --- 1428
2013 --- 2098 --- 1411
2012 --- 1744 --- 1412

Edit: Presumably it has something to do with single tournament memberships, but that seems high.

I'm not sure you can do much with your 3 variables.

Where are the 2017 and 2018 Expiring dates ?

When someone purchases a tournament "membership" they may get the first of the month of the tournament as their expiry date or they may keep their last expiry date. All junior tournaments don't require a CFC membership (think of it as a Free tournament "membership").

Tournament membership do not count toward regular membership (nor do non CFC members in Junior only tournaments)

[Brent Golem]

Re: CFC Member Stats

I am looking at the current "td list" via Excel. What is the difference between expiration dates of 31/12/2099 and 01/12/2099 (and the four that have 01/01/2099)? I'm assuming they are Life Members. There are also some with expiry dates in the 1950's and 1940's - what do they represent? How do you treat deceased members? There are also some with expiry dates in the 1980's that are current FQE members - shouldn't these be coordinated somehow?

Re: Quebec Life Members:

1) I don't think Renier Castellanos has lived in Canada for some years.
2) Pascal Charbonneau has lived in NYC for some years.
3) Graham Glen hasn't lived in QC for many years. Now in AB.

Others:

1) Smilja Vojosevic (ON) is deceased.
2) Danny Kopec (US) is deceased.
3) Peter Biyiasis (BC) should be FO.

I also looked at expiry of the TD list and it's tough to wrap your head around. How can there be such a difference between "expiring" dates and annual membership? It does not appear that there are duplicate names in the TD list.

Expiry - TD List - CFC Membership
2016 --- 1307 --- 1576
2015 --- 1254 --- 1390
2014 --- 2123 --- 1428
2013 --- 2098 --- 1411
2012 --- 1744 --- 1412

Edit: Presumably it has something to do with single tournament memberships, but that seems high.

[Neil Frarey]

Re: CFC Member Stats

You want to blow out your numbers - use "organized players" or "active players" and start counting everyone playing in the tournaments of CFC/FQE/CMA and others.
Use "members" who support your purposes.

Yep! That would def blow out the N^o!

I want to know the exact data as deep as it can go. Who (all their vitals, not just personal stuff but also game stuff. Tourney section(s), rating fluctuation, etc) Where (not only where they reside, but also where they play, if/when they travel to play) When (TTP, one time, only club, weekend, etc). All of that goodness has to be sorted out; and then create email campaigns targeted to those brackets.

Not just for membership email prompts or even the fresh new "Bring a Chess Friend" campaign ... but rather campaigns which will benefit the existing member in a lot more ways than one!!!

Targeted growth is all data driven ... key part of the future CFC.

Sh*t load of work, but well worth it!

[Roger Patterson]

ps:

ps: It is something you could easily add to automatic inquiries of the database as per the earlier discussion on making changes or additions to the existing database inquires.

[Roger Patterson]

Re: CFC Member Stats

It would probably take a bit of work, but it should be possible to produce a number of tournament participants (Regular / Quick) in the fiscal year. Whether it would be worth the manpower is the question. Using the word members for these people is not accurate as some are past members and some purchased single tournament "passes".

Someone proficient with Access and Excel can figure out the number of active players (regular and TM) in about 15 minutes. I know, I've done it on occasion,

Step one: In the CFC Access database filter the entries in the Tournaments by the date range required.

Step two: copy those entries to Excel.

Step three: Use a pivot table to get CFC #s versus total number of games played in the period.

Step four: Filter out those whose total number of games is too small to be considered active.

Done.

Not sure that it is worth doing except insofar as it provides a better picture of active players than the membership list. (the membership list includes inactive players, excludes those with TMs, excludes all those junior events for which membership is not required. On the other hand, those all junior scholastic events might not be representative of the picture of chess activity you desire either.)

[Fred McKim]

Re: CFC Member Stats

Could the terminology be changed so that tournament members would be included as a member for the calendar year for stats purposes? Our current regular membership could be called "full membership" and that would include the newsletter. The number would be a better indicator of those who played chess in Canada. (Not sure if there are that many tournament members - but just curious).

It would probably take a bit of work, but it should be possible to produce a number of tournament participants (Regular / Quick) in the fiscal year. Whether it would be worth the manpower is the question. Using the word members for these people is not accurate as some are past members and some purchased single tournament "passes".

[Egidijus Zeromskis]

Re: CFC Member Stats

Participant Member, perhaps?

I do agree Chris, that the current 'types' of Memberships need to be more fluid.

You want to blow out your numbers - use "organized players" or "active players" and start counting everyone playing in the tournaments of CFC/FQE/CMA and others.
Use "members" who support your purposes.