Historical reporting

Discussion in 'Customization & add-ons' started by kcarey, Aug 9, 2011.

  1. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    I have 3 annual membership types. I need a mysql query to determine the number of paid members of each type in 2010 (01/01/2010 - 12/31/2010)... regardless if they are current or expired members today.

    Any help would be greatly appreciated!

    Thanks,

    ~kcarey
    kcarey, Aug 9, 2011
    #1
  2. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    Also... I'm using version 3.1.8. I'll be upgrading to 4.0 when it becomes available.
    kcarey, Aug 9, 2011
    #2
  3. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    You should at least move to 3.2.4 for security and other updates. 4 will be a bit.

    Ken Gary has an analytics plugin you can use, and I also give my premium members an improved income report in their 2nd month of membership that you can select a single product to be displayed.

    David
    davidm1, Aug 10, 2011
    #3

Share This Page