1 / 23

AAPG /HGS MEMBERSHIP EXPERIMENT AAPG ANNUAL CONVENTION 2006

AAPG /HGS MEMBERSHIP EXPERIMENT AAPG ANNUAL CONVENTION 2006. Andrea Reynolds. Overview. Purpose of the Houston Membership Experiment Input Data & Database Comparison Process Company Results & Statistics Observations & Learnings Forward Plan Questions?.

gordon
Download Presentation

AAPG /HGS MEMBERSHIP EXPERIMENT AAPG ANNUAL CONVENTION 2006

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. AAPG /HGS MEMBERSHIP EXPERIMENTAAPG ANNUAL CONVENTION 2006 Andrea Reynolds

  2. Overview • Purpose of the Houston Membership Experiment • Input Data & Database Comparison Process • Company Results & Statistics • Observations & Learnings • Forward Plan • Questions?

  3. Why carry out a membership experiment? • To compare how many Houston area geologists are members • of AAPG & HGS, AAPG only & HGS only • To facilitate AAPG age-targeted membership initiative • 3) To understand why HGS members may NOT be AAPG members • & why AAPG members are not HGS members • 4) To allow us to track membership trends • 5) Last, but not least – How to better attract new members to • AAPG & HGS by leveraging each other’s membership base

  4. Input Data • This work is based on a query of the AAPG & HGS • databases from end-August 2005 • The AAPG membership database in this experiment includes ONLY those who are recorded as living in the Greater Houston area • The HGS membership database includes ALL HGS members, including those that live outside the greater Houston area • This was necessary due to the immense size of the AAPG members database

  5. Database Comparison Process (Simplified) • 1) Get both databases in the same format • (Last name, First name, company, phone #, etc) • 2) Add columns to designate AAPG members and HGS members • 3) Sort by Name • 4) Make a Match - Manually compare 12,000+ lines in the master • spreadsheet for same names, duplicate companies/emails/ • phone #, etc • 5) Break out members by company • 6) Interpret the data & break out trends in membership

  6. Database Comparison • The merge created an Excel spreadsheet with 15,710 lines …..not a quick, easy task!

  7. Split out members by Company AGIP-ENI ExxonMobil Shell Amerada Hess Hunt Petroleum Total Anadarko Kerr-McGee Unocal Apache Marathon Oil Baker BHP Newfield CGG bp Noble Fugro Burlington Resources Oxy Halliburton Chevron Paradigm IHSEnergy ConocoPhillips Pioneer PGS Devon Pogo Schlumberger Dominion Repsol TGS-NOPEC El Paso Samson Veritas 27 Exploration/Production Companies 9 Service Companies/Vendors

  8. Key: BLUE text = AAPG member BLACK text = HGS member YELLOW shading = MATCH (AAPG + HGS) PINK shading = Probable match (AAPG + HGS) No shading = Records are not up-to-date Example of a company page (Both AAPG + HGS)

  9. Example of a company (AAPG only + HGS only)

  10. General Statistics

  11. E&P Statistics

  12. All 36 Companies

  13. AAPG + HGS HGS only AAPG only Observations – E&P Company trend Observation # 1: The E&P employees are split in thirds when it comes to membership

  14. Observations – Vendor/Service trend AAPG + HGS HGS only AAPG only Observation # 2: Most Houston service employees are HGS members

  15. Observations – All Company Data (E&P + Vendor) AAPG + HGS HGS only Observation # 3: In the Houston area, more members belong to HGS only AAPG only

  16. Company Statistics

  17. Learnings • There are many records that are not up to date! Members do NOT update profile after changing: • Companies • Addresses – when moving to a new city/state • Phone numbers • Name (due to marriage, divorce) • Email addresses (after corporate merger, etc) Therefore, it is sometimes quite difficult to match members – especially with common given names and surnames.

  18. How can we use this to our benefit? • We have access to a VERY powerful source of information! • Opportunity for greater synergy between national & local • organizations/societies • Large potential as a recruitment tool - who are we missing and why? • Trend data is very important – what does it mean? • Delinquent members – can we understand why they left? Did they stay national/local? Can we get them back?

  19. (Inter)National & Local Synergy HGS Benefits AAPG Benefits Monthly Technical Lunch & Dinner Meetings Annual Meetings & Int’l Conventions Shared Community Outreach Larger sphere for networking Special Interest Groups Divisions – EMD, DPA, DEG HGS Bulletin & website Datapages, Bulletin, Explorer Social & Sporting Events Wide breadth of courses +……. +……. Collaborate & leverage strengths

  20. Unrealized Potential • What can make this even more successful? • Members need encouragement to stay current & update their own records online • Companies can benefit – and can be used to recruit • Replication of this “experiment” in other regions • Age-targeted marketing – available for AAPG members, but not for HGS members (HGS does not collect demographics)

  21. Forward Plan • How are we going to use all this information? • Recruiting “agents” have been identified within each company • The agent compares our list to active employees • AAPG & HGS provide recruiting materials • Agents distribute within the members – first to “AAPG/HGS only” members; then to non-members GOAL: to attract new members (who have only been local/nat’l) and grow both organizations’ membership bases

  22. In Conclusion • The AAPG/HGS Membership experiment has been eye-opening • We have seen interesting trends & statistics • “Agents” are currently at work in Houston • We recommend that AAPG replicate this in other areas • We will fully document the process – it would be ideal to automate the data-crunching to cut down on time • We see this as a success and look forward to final results

  23. Thank you for your time & attention Got Questions?????

More Related