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 others
  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 Apa
che Marathon Oil Baker BHP Newfield CGG bp
Noble Fugro Burlington Resources Oxy Hallibu
rton Chevron Paradigm IHS Energy ConocoPhillips
Pioneer PGS Devon Pogo Schlumberger Domini
on Repsol TGS-NOPEC El Paso Samson Veritas
27 Exploration/Production Companies 9 Service
Companies/Vendors
8
Example of a company page (Both AAPG HGS)
9
Example of a company (AAPG only HGS only)
10
General Statistics
11
EP Statistics
12
Vendor Statistics
13
All 36 Companies
14
Observations EP Company trend
Observation 1 The EP employees are split in
thirds when it comes to membership
15
Observations Vendor/Service trend
AAPG HGS
HGS only
AAPG only
Observation 2 Most Houston service employees
are HGS members
16
Observations All Company Data (EP Vendor)
AAPG HGS
HGS only
Observation 3 In the Houston area, more
members belong to HGS only
AAPG only
17
Company Statistics
18
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.
19
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?

20
(Inter)National Local Synergy
HGS Benefits
AAPG Benefits
Monthly Technical Lunch Dinner Meetings
Annual Meetings Intl 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
21
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)

22
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/natl) and grow both organizations
membership bases
23
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

24
Thank you for your time attention Got
Questions?????