AAPG /HGS MEMBERSHIP EXPERIMENT AAPG ANNUAL CONVENTION 2006

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?????