• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

SQL Query Help - Isolate Recent Posts & Post Trends

ProCom

Well-known member
#1
We've seen a recent uptick in posts the last few days that does NOT correlate to more traffic.
upload_2017-6-23_18-52-42.png

I'd really like to isolate WHERE those posts are happening. Any ideas on the best way to do this?

In a perfect world, I'd have the ability to do a "post count drilldown" like the "content drilldown" in Google analytics. So, I'd start with the high level data over time and doing a deeper dive would get me closer and closer to where the posts are happening... basically in this order:

Forum
- Parent node / category
-- Sub node
--- Individual threads

So, since that's not available (yet ;) ) what's the best way to tease out this data?

I guess the best option would be to have a series of SQL queries that does something like: Total posts per-day per-node, last x days. Maybe the columns would be days and the rows would be nodes (or vice versa)?

Then similarly: In Node z: Total posts per thread, per day, last x days, limit to threads with y posts (so it doesn't get crazy).

So, my questions for you masters:
  1. Is that the best way to tease out this data?
  2. If yes, anybody willing to help a SQL idiot put the queries together? :D