Ringgold Webinar Series: 4. 30-Minute Workout - Quick Tips for Better Customer Data Health

100 %
0 %
Information about Ringgold Webinar Series: 4. 30-Minute Workout - Quick Tips for Better...

Published on February 27, 2014

Author: ringgoldinc

Source: slideshare.net


The final session took place on Wednesday 26 February and we offered concrete, simple take-aways that will allow you to quickly improve the state of your most valuable customer and prospect records. Also, we discussed how our auditing service may help those needing a more robust solution:
- 3 Quick Tips to improve the state of your most valuable client records - all of which you can do on your own
- Ringgold’s Audit service: outsourcing the standardization of your subscriber records

Ringgold Webinar Series Session 4 February 26 2014

Today’s topic, in context Your Business Data Governance Program Healthy Records IDs

Agenda 1. Get Ready to Clean 2. Tidy Your Data in Three Steps 3. What to do Next 4. Ringgold’s Audit Service

One: Get Ready • What problem are you trying to solve? • Service issues, new journal, system migration? • Prioritize your records. • Geo, type of customer, scope of records? • Gather tools & resources. • People, information sources, time, money.

Remember……  Back up your original data, and work from a copy.  Make any changes there, then re-import.  Keep a copy of the pre-cleaned data in case you experience problems.

Two: Tidy Your Data in Three (Easy) Steps Really.

Step 1: Create a Data Policy Document A. Decide which elements are required Which must be filled in now as part of the cleanup effort, or for the creation of any new records B. Define each data element Make a list including all fields of a record, and define what each means (and what it doesn’t)

C. Set naming conventions To abbreviate or not to abbreviate? UCL:  University College London (UK)  Université Catholique de Louvain     (Belgium) Universidad Cristiana Latinoamericana (Ecuador) University College Lillebælt (Denmark) Centro Universitario Celso Lisboa (Brazil) Union County Library (USA) English or Native Language?

Tip #1: Don’t reinvent the wheel Use existing authority files where possible when defining data elements or setting naming conventions  ISO Country Code List (ISO 3166)  UN/LOCODE for Cities  Carnegie Classifications Data File  Standard Identifiers (ISNI, Ringgold ID)  Europa World of Learning for institution names

Tip #2: First draft only, for now.

Step 2: Fill in what is missing

Step 3: Put everything in its proper place ID 55897 Title Lt. FirstName Address 2 City 90044 State Jean LastName Company Worf High Altitude Warfare School Luc Picard 587 Capt. 55632 57741 Address1 778 North Ring Road, Gulmarg University of Birmingham Shakespeare Institute Katholieke Univ Leuven 5963 Central Departement University Road Molecularie Celbiologie Star Fleet 1 Ellipse Way Edgbaston on-Avon Dr. Beverly Crusher Leuven Com. William T. Riker Main Library Stratford Postal UK 3000 San Franisco Calif Country Title India Weaponry Weekly United States Leadership Quarterly Belgium Journal of Interspecies Bioengineering Leadership Quarterly

Three: Next Steps 1. Evangelize the data policy document 2. Encourage & enforce good data governance practices where you can 3. Keep the ball rolling….

….and maintain good data hygiene  Review new records on a regular basis  Determine if additional data sets need attention  Educate new staff  Show tangible ROI

Outsourcing Data Normalization

Going beyond a quick “spring clean”  Multiple accounts for each customer  Multiple internal IT systems, different divisions, methods of data capture, etc.  Lack of information about which accounts are related  Missing key pieces of information  Lack of standard identifiers

What goes into a Ringgold audit? Database Regional & Language Expertise Defined Process Data & IT Professionals Identify

Audit Process Receive files from client Normalise data (de-duplication and automatching) Researcher checks and matches to Ringgold IDs, hierarchy etc. Researcher creates new IDs for unidentified organizations Data split into countries Data assigned to appropriate country expert Data uploaded to Identify system Client sent encrypted file via FTP with IDs and metadata

Global Research Team

Audit deliverables Lots & lots of definitive, clean, structured data about your subscribers.  A series of files which provide the complete Identify details for each of your accounts  Unique Ringgold ID number  Institutional hierarchy  Additional metadata: size, tier, industry sector, consortia membership, alternative names, etc.

Data: Before Customer Account 39824 3994 86101 98897 90438 57700 51648 20466 79256 88279 63641 Customer Name Swets Antoni Van Leeuwenhoekhuis Christchurch School of Medicine Pohjois Karjalan Keskussairaala Keskusairalaa Pohojois Karl WFH St Joseph Torbay Hospital MHH Serials Dept. Osaka Prefectural Medical Center Osaka Furitsu Seijinbyou Ctr Address 1 Address 2 City State Info Services Aberdeen Plesmanlaan 121 Amsterdam 2 Riccarton Ave Christ Church Tikkamäentie 16 Jeonsu Tikkamäentie 16 Joensuu P.O. Box 284 Milwaukee Wisc. Newton road, Devon, Torquay, TQ2 7AA Great Britain Saueramferweg 5 Hannover 1-11-18 Chiharacho Izumi 1-9-10 Kyomachibori Habikino 1-1-50 Fukushima Nishiku Osaka Osaka PostCode AB24 3FX 1006 BE 80210 Finland 53210-9988 Country Scotland Holand New Zealand Finland 30625 Deutschland 594-1101 Japan 583-8588 JP 537-8511 Japan

Data: After Customer Account Customer Name RIN Number RIN Name RIN City RIN State RIN Country Swets 1019 University of Aberdeen 3994 Antoni Van Leeuwenhoekhuis 1228 1006 BE Netherlands www.nki.nl 86101 Christchurch School of Medicine 2494 Nederlands Kanker Instituut - Amsterdam Antoni van Leeuwenhoek Ziekenhuis University of Otago Christchurch Christchurch School of Medicine and Health Sciences 98897 Pohjois Karjalan Keskussairaala 4152 90438 Keskusairalaa Pohojois Karl 57700 RIN Type RIN Number RIN Name next level up next level up A4 academic/hos academic pital H5 1229 Institute for Research in Extramural Medicine 8140 New Zealand www.chmeds.ac. academic/me academic nz dsch M3 58994 University of Otago Faculty of Medicine Pohjois-Karjalan sairaanhoito- Joensuu ja sosiaalipalvelujen kuntayhtyma 80210 Finland www.pkssk.fi public/health public P2 4152 Pohjois-Karjalan sairaanhoito- Joensuu ja sosiaalipalvelujen kuntayhtyma 80210 Finland www.pkssk.fi public/health public P3 WFH St Joseph 5509 Wheaton Franciscan Healthcare - Saint Joseph Milwaukee 532109988 United States www.mywheaton hospital .org/stjoseph hospital H2 5510 Wheaton Franciscan Healthcare 51648 Torbay Hospital 7993 Torquay TQ2 7AA 53247 South West Strategic Health Authority 9177 79256 Serials Dept. 13608 H5 183158 Osaka Furitsu Byoin Kiko 88279 Osaka Prefectural Medical Center 13615 www.sdhct.nhs.u k www.mhhannover.de www.mch.pref.os aka.jp www.ra.opho.jp H2 MHH United Kingdom Germany hospital 20466 South Devon Healthcare NHS Foundation Trust Medizinische Hochschule Hannover Osaka Furitsu Boshi Hoken Sogo Iryo Center Osaka Furitsu Kokyuki Allergy Iryo Center H2 183158 Osaka Furitsu Byoin Kiko 63641 Osaka Furitsu Seijinbyou Ctr Osaka Furitsu Seijinbyo Center Osaka H2 183158 Osaka Furitsu Byoin Kiko WI NI 30625 Izumi 594-1101 Japan Habikino 583-8588 Japan Osaka 537-8511 Japan www.abdn.ac.uk academic RIN Sector RIN Tier academic Hannover AB24 3FX United Kingdom RIN Url 39824 53312 Aberdeen RIN Zip hospital academic/me academic dsch hospital/childr hospital en hospital hospital www.mc.pref.osa hospital ka.jp hospital M3

Auditing Use Cases  Understand & analyze your customer base  Disambiguate institutions & find duplicate accounts  Reveal institutional relationships with hierarchies  Enhance customer records with Identify metadata  Support pricing decisions & policies  Your audited records can act as an authority file of institutions in any system: editorial, MSS submissions, CRMs, financial, fulfillment, etc.

To sum up: It’s absolutely worth it You can do it …But you may not want to do it alone

Questions? We’d love to hear from you, and help you develop your roadmap to better data health.

Jay Henry Chief Marketing Officer www.ringgold.com Christine Orr Sales Director

Add a comment

Related presentations

Related pages

Webinars | Ringgold Inc

Ringgold Webinar Series ... Data health plan: ... Session 4: 30-Minute Workout: Quick Tips for Better Customer Data Health.
Read more

Customer Bulletin Winter 2013 | Ringgold Inc

... and information about our new webinar series for ... Workout: Quick Tips for Better Customer Data Health ... Ringgold Inc (USA), ID 94176 4 ...
Read more

Series 4 | LinkedIn

... (3 Series, 4 Series, M3, M4, X3, X4, Z4) ... Ringgold Webinar Series: 4. 30-Minute Workout - Quick Tips for Better... ... Data Modeling - Series 4 X ...
Read more

Ringgold Webinar Series: 1. Taking Stock – Commitment to ...

Ringgold Webinar Series: ... 2.Good data health 3.Standard identifiers 4.Ringgold’s data ... Workout: Quick Tips for Better Customer Data Health ...
Read more

Free Car Insurance Quotes with Low Cost Policies for Your ...

Deal to everytone you know it's a 30 minute drive from the services collection ... star health insurance ... cannot pay Tips on finding advice webinar: ...
Read more

Ringgold Webinar Series: Session 2 29 January 2014. - ppt ...

Ringgold Webinar Series: Session 2 29 January 2014. Upload Log in. My presentations; Profile; Feedback; Log out; Search Download presentation. We ...
Read more

Land line magazine july 2015 by Augusto Dantas - issuu

... Augusto Dantas, Name: land_line_magazine_july_2015 ... Owners can contact Kenworth customer ... Services & Equipment 4 State Trucks Better ...
Read more

Natural Awakenings - Greater Lehigh Valley & Far West New ...

... Natural Awakenings - Greater Lehigh Valley ... It is a day to focus and nurture the self to better health ... Expires 4/30/15 One coupon per customer ...
Read more