I'm trying to analyze as much data as possible to determine if it's the "head" or "longtail" users that have dropped off, and why.
One thing I thought to do was to run a report of the top 20 members who were posting during the big moths and compare that to the top 20 members posting during the smaller months. Did all my members stop posting, or did I just have a handful of main members that were posting thousands of times but then stopped?
So, can someone help me write a sql query like:
Select id, username, #posts
where month = xyz
sort desc by # posts
From there I can run it on a few months and compare the results!
Ooohh... as long as I'm asking for stuff...
How about a similar query by member, by month, e.g.: Show monthly posts for member #xyz I could plug in my top 20 posting members and see when they dropped off.
Wouldn't it be interesting to discover if a handful all dropped off at the same time and then investigate why!
Thanks for any help you can provide!