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

XF 1.5 How do I get a report of the number of members visiting each month?

Discussion in 'XenForo Questions and Support' started by Stuart Wright, Jan 8, 2016.

  1. Stuart Wright

    Stuart Wright Well-Known Member

    Simple report. How many members (not guests) visit each month. How do I get that report please?
  2. Daniel Hood

    Daniel Hood Well-Known Member

    /admin.php?stats/monthly "Users Active" -- should do it, I would think.
  3. Mike

    Mike XenForo Developer Staff Member

    Unfortunately, that report isn't exactly what you think. At best, you divide by the number of days to get the average daily information, but that differs from "what users were active this month".

    We only track the last time a user was active, so the only way to get a list of users (or aggregate number) of users active in a given month is to check if the last activity is within the current month (when checked at the end of the month). This would need to be stored then to track further information over time.
  4. Stuart Wright

    Stuart Wright Well-Known Member

    I hope there is better reporting functionality in Xenforo 2. This stuff is really important for gauging where to focus resources. And for reporting to potential customers.
    Not being able to tell people how many members visit each month is shockingly bad, really.
    It's not even easy to get this data out of Google Analytics even with Digital Point's enhanced analytics addon.
  5. Chris D

    Chris D XenForo Developer Staff Member

    It's there in a roundabout way. You could use the Search Users page and set the criteria accordingly including the "last activity" date fields for the required period.

    This will return a list of users and at the footer of that list should be a number.

    Not exactly what you want in the format you want but should be the right number at least.
  6. Daniel Hood

    Daniel Hood Well-Known Member

    It doesn't let you notice a trend of any sort or anything though. It does give you the number of users active in the past x days though.
  7. Chris D

    Chris D XenForo Developer Staff Member

    Yeah as Mike says, it would need monitoring for anything more useful.

    By no means a solution but if you want that number for now it's a start.
    Daniel Hood likes this.
  8. Stuart Wright

    Stuart Wright Well-Known Member

    This can't be correct, Chris. Is last activity really the same as any activity?
    I ran this for December and it returned only 112 members.
    132 in November.
  9. HWS

    HWS Well-Known Member

    Ours looks correct.

    "Search Users", give "2015-12-01" as the start and "2015-12-31" as the end in "Last visited between" and it gets you the count.

    But it does NOT count any members who were last online AFTER that period.

    So it can't be used really if the end date is not today...
  10. Mike

    Mike XenForo Developer Staff Member

    That's roughly what I was referring to. You can only use it relative to right now to get a meaningful number. If you you look for last activity in November, it won't match anyone who was active in December or January.
    HWS and Daniel Hood like this.
  11. Chris D

    Chris D XenForo Developer Staff Member

    Indeed. So the most accurate thing to do right now is to run it from the 9th December 2015 to 8th January 2016. I've done this for you Stuart at AVF and it comes out at a much bigger number than 130. I also ran it for December and November and still got a much bigger number than you. Are you sure you didn't select any other criteria?
  12. Stuart Wright

    Stuart Wright Well-Known Member

    16,512 when I run it from December 8 to January 7. Hmmm. What I'm after is a monthly report for 2015. Is there an SQL statement I can run?

    So users is members and not just people using the site? 'Cos it's not clear. It's the number of members I'm after.
    Last edited: Jan 8, 2016
  13. Mouth

    Mouth Well-Known Member


Share This Page