AAPG /HGS MEMBERSHIP EXPERIMENT
This presentation is the property of its rightful owner.
Sponsored Links
1 / 23

AAPG /HGS MEMBERSHIP EXPERIMENT AAPG ANNUAL CONVENTION 2006 PowerPoint PPT Presentation


  • 66 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Aapg hgs membership experiment aapg annual convention 2006

AAPG /HGS MEMBERSHIP EXPERIMENTAAPG ANNUAL CONVENTION 2006

Andrea Reynolds


Aapg hgs membership experiment aapg annual convention 2006

Overview

  • Purpose of the Houston Membership Experiment

  • Input Data & Database Comparison Process

  • Company Results & Statistics

  • Observations & Learnings

  • Forward Plan

  • Questions?


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

Database Comparison

  • The merge created an Excel spreadsheet with 15,710 lines

…..not a quick, easy task!


Aapg hgs membership experiment aapg annual convention 2006

Split out members by Company

AGIP-ENIExxonMobilShell

Amerada HessHunt PetroleumTotal

AnadarkoKerr-McGeeUnocal

ApacheMarathon OilBaker

BHPNewfieldCGG

bpNobleFugro

Burlington ResourcesOxyHalliburton

ChevronParadigmIHSEnergy

ConocoPhillipsPioneerPGS

DevonPogoSchlumberger

DominionRepsolTGS-NOPEC

El PasoSamsonVeritas

27 Exploration/Production Companies

9 Service Companies/Vendors


Aapg hgs membership experiment aapg annual convention 2006

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)


Aapg hgs membership experiment aapg annual convention 2006

Example of a company (AAPG only + HGS only)


Aapg hgs membership experiment aapg annual convention 2006

General

Statistics


Aapg hgs membership experiment aapg annual convention 2006

E&P

Statistics


Aapg hgs membership experiment aapg annual convention 2006

All 36

Companies


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

Observations – Vendor/Service trend

AAPG +

HGS

HGS

only

AAPG

only

Observation # 2: Most Houston service

employees are HGS members


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

Company Statistics


Aapg hgs membership experiment aapg annual convention 2006

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.


Aapg hgs membership experiment aapg annual convention 2006

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?


Aapg hgs membership experiment aapg annual convention 2006

(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


Aapg hgs membership experiment aapg annual convention 2006

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)


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

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


Aapg hgs membership experiment aapg annual convention 2006

Thank you for your time & attention

Got Questions?????


  • Login