Reporting - New members for 2010

Discussion in 'Troubleshooting' started by kcarey, Dec 31, 2010.

  1. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    I am using Amember 3.1.8.

    I would like to have a report that shows new members for 2010... not just new payments for 2010. We have several members from prior to 2010 who renewed in 2010. I would like to filter them out to see the number of "true" new 2010 members to our organization... a non-profit.

    Any help would be appreciated!

    Happy New Year!

    KCarey
    kcarey, Dec 31, 2010
    #1
  2. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    Unfortunately, I haven't received any feedback on this question. While I recognize it is not feasible directly in the amember software, would anyone be willing to help with a query I could run in phpMyAdmin?

    Thanks in advance!

    KCarey
    kcarey, Jan 13, 2011
    #2
  3. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Ken Gary has a reporting plugin for amember you can take a look at: amReports: Membership Site Analytics
    I dont think it has reporting for specific time periods yet though- would be a nice feature.

    David
    davidm1, Jan 16, 2011
    #3
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    You can get this info using SQL query from phpMyAdmin:
    Code:
    select * from amember_members where added > '2010-01-01' and status=1;
    alexander, Jan 17, 2011
    #4
  5. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    I forgot, I give my premium members a modified income report in Month 2 of their membership, that lists the number of paid members vs. total signups in a given period. By running it, you can see how many paid new members signed up in a month then manually add them up or copy and paste the data into excel.

    David
    davidm1, Jan 17, 2011
    #5
  6. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    Thanks for the replies! I will use Alex's SQL and modify as needed. Thank you again!
    kcarey, Jan 20, 2011
    #6
  7. kcarey

    kcarey Member

    Joined:
    Dec 27, 2009
    Messages:
    42
    Alex, etal,

    I was successful in using phpMyAdmin to run a query for new members during a period of time.

    Will you please help me with the SQL script to find renewing members (excluding new members) in 2011... meaning members who renewed in 2011 who had a prior active membership in the database.

    Thanks in advance for the additional help!

    K. Carey
    kcarey, Jan 23, 2011
    #7

Share This Page