NZ Herald
  • Home
  • Latest news
  • Herald NOW
  • Video
  • New Zealand
  • Sport
  • World
  • Business
  • Entertainment
  • Podcasts
  • Quizzes
  • Opinion
  • Lifestyle
  • Travel
  • Viva
  • Weather

Subscriptions

  • Herald Premium
  • Viva Premium
  • The Listener
  • BusinessDesk

Sections

  • Latest news
  • New Zealand
    • All New Zealand
    • Crime
    • Politics
    • Education
    • Open Justice
    • Scam Update
  • Herald NOW
  • On The Up
  • World
    • All World
    • Australia
    • Asia
    • UK
    • United States
    • Middle East
    • Europe
    • Pacific
  • Business
    • All Business
    • MarketsSharesCurrencyCommoditiesStock TakesCrypto
    • Markets with Madison
    • Media Insider
    • Business analysis
    • Personal financeKiwiSaverInterest ratesTaxInvestment
    • EconomyInflationGDPOfficial cash rateEmployment
    • Small business
    • Business reportsMood of the BoardroomProject AucklandSustainable business and financeCapital markets reportAgribusiness reportInfrastructure reportDynamic business
    • Deloitte Top 200 Awards
    • CompaniesAged CareAgribusinessAirlinesBanking and financeConstructionEnergyFreight and logisticsHealthcareManufacturingMedia and MarketingRetailTelecommunicationsTourism
  • Opinion
    • All Opinion
    • Analysis
    • Editorials
    • Business analysis
    • Premium opinion
    • Letters to the editor
  • Politics
  • Sport
    • All Sport
    • OlympicsParalympics
    • RugbySuper RugbyNPCAll BlacksBlack FernsRugby sevensSchool rugby
    • CricketBlack CapsWhite Ferns
    • Racing
    • NetballSilver Ferns
    • LeagueWarriorsNRL
    • FootballWellington PhoenixAuckland FCAll WhitesFootball FernsEnglish Premier League
    • GolfNZ Open
    • MotorsportFormula 1
    • Boxing
    • UFC
    • BasketballNBABreakersTall BlacksTall Ferns
    • Tennis
    • Cycling
    • Athletics
    • SailingAmerica's CupSailGP
    • Rowing
  • Lifestyle
    • All Lifestyle
    • Viva - Food, fashion & beauty
    • Society Insider
    • Royals
    • Sex & relationships
    • Food & drinkRecipesRecipe collectionsRestaurant reviewsRestaurant bookings
    • Health & wellbeing
    • Fashion & beauty
    • Pets & animals
    • The Selection - Shop the trendsShop fashionShop beautyShop entertainmentShop giftsShop home & living
    • Milford's Investing Place
  • Entertainment
    • All Entertainment
    • TV
    • MoviesMovie reviews
    • MusicMusic reviews
    • BooksBook reviews
    • Culture
    • ReviewsBook reviewsMovie reviewsMusic reviewsRestaurant reviews
  • Travel
    • All Travel
    • News
    • New ZealandNorthlandAucklandWellingtonCanterburyOtago / QueenstownNelson-TasmanBest NZ beaches
    • International travelAustraliaPacific IslandsEuropeUKUSAAfricaAsia
    • Rail holidays
    • Cruise holidays
    • Ski holidays
    • Luxury travel
    • Adventure travel
  • Kāhu Māori news
  • Environment
    • All Environment
    • Our Green Future
  • Talanoa Pacific news
  • Property
    • All Property
    • Property Insider
    • Interest rates tracker
    • Residential property listings
    • Commercial property listings
  • Health
  • Technology
    • All Technology
    • AI
    • Social media
  • Rural
    • All Rural
    • Dairy farming
    • Sheep & beef farming
    • Horticulture
    • Animal health
    • Rural business
    • Rural life
    • Rural technology
    • Opinion
    • Audio & podcasts
  • Weather forecasts
    • All Weather forecasts
    • Kaitaia
    • Whangārei
    • Dargaville
    • Auckland
    • Thames
    • Tauranga
    • Hamilton
    • Whakatāne
    • Rotorua
    • Tokoroa
    • Te Kuiti
    • Taumaranui
    • Taupō
    • Gisborne
    • New Plymouth
    • Napier
    • Hastings
    • Dannevirke
    • Whanganui
    • Palmerston North
    • Levin
    • Paraparaumu
    • Masterton
    • Wellington
    • Motueka
    • Nelson
    • Blenheim
    • Westport
    • Reefton
    • Kaikōura
    • Greymouth
    • Hokitika
    • Christchurch
    • Ashburton
    • Timaru
    • Wānaka
    • Oamaru
    • Queenstown
    • Dunedin
    • Gore
    • Invercargill
  • Meet the journalists
  • Promotions & competitions
  • OneRoof property listings
  • Driven car news

Puzzles & Quizzes

  • Puzzles
    • All Puzzles
    • Sudoku
    • Code Cracker
    • Crosswords
    • Cryptic crossword
    • Wordsearch
  • Quizzes
    • All Quizzes
    • Morning quiz
    • Afternoon quiz
    • Sports quiz

Regions

  • Northland
    • All Northland
    • Far North
    • Kaitaia
    • Kerikeri
    • Kaikohe
    • Bay of Islands
    • Whangarei
    • Dargaville
    • Kaipara
    • Mangawhai
  • Auckland
  • Waikato
    • All Waikato
    • Hamilton
    • Coromandel & Hauraki
    • Matamata & Piako
    • Cambridge
    • Te Awamutu
    • Tokoroa & South Waikato
    • Taupō & Tūrangi
  • Bay of Plenty
    • All Bay of Plenty
    • Katikati
    • Tauranga
    • Mount Maunganui
    • Pāpāmoa
    • Te Puke
    • Whakatāne
  • Rotorua
  • Hawke's Bay
    • All Hawke's Bay
    • Napier
    • Hastings
    • Havelock North
    • Central Hawke's Bay
    • Wairoa
  • Taranaki
    • All Taranaki
    • Stratford
    • New Plymouth
    • Hāwera
  • Manawatū - Whanganui
    • All Manawatū - Whanganui
    • Whanganui
    • Palmerston North
    • Manawatū
    • Tararua
    • Horowhenua
  • Wellington
    • All Wellington
    • Kapiti
    • Wairarapa
    • Upper Hutt
    • Lower Hutt
  • Nelson & Tasman
    • All Nelson & Tasman
    • Motueka
    • Nelson
    • Tasman
  • Marlborough
  • West Coast
  • Canterbury
    • All Canterbury
    • Kaikōura
    • Christchurch
    • Ashburton
    • Timaru
  • Otago
    • All Otago
    • Oamaru
    • Dunedin
    • Balclutha
    • Alexandra
    • Queenstown
    • Wanaka
  • Southland
    • All Southland
    • Invercargill
    • Gore
    • Stewart Island
  • Gisborne

Media

  • Video
    • All Video
    • NZ news video
    • Herald NOW
    • Business news video
    • Politics news video
    • Sport video
    • World news video
    • Lifestyle video
    • Entertainment video
    • Travel video
    • Markets with Madison
    • Kea Kids news
  • Podcasts
    • All Podcasts
    • The Front Page
    • On the Tiles
    • Ask me Anything
    • The Little Things
  • Cartoons
  • Photo galleries
  • Today's Paper - E-editions
  • Photo sales
  • Classifieds

NZME Network

  • Advertise with NZME
  • OneRoof
  • Driven Car Guide
  • BusinessDesk
  • Newstalk ZB
  • Sunlive
  • ZM
  • The Hits
  • Coast
  • Radio Hauraki
  • The Alternative Commentary Collective
  • Gold
  • Flava
  • iHeart Radio
  • Hokonui
  • Radio Wanaka
  • iHeartCountry New Zealand
  • Restaurant Hub
  • NZME Events

SubscribeSign In
Advertisement
Advertise with NZME.
Home / Business / Small Business

<i>Debbie Mayo Smith</i>: Database mining will generate new busines

NZ Herald
7 Mar, 2010 02:45 PM4 mins to read

Subscribe to listen

Access to Herald Premium articles require a Premium subscription. Subscribe now to listen.
Already a subscriber?  Sign in here

Listening to articles is free for open-access content—explore other articles or learn more about text-to-speech.
‌
Save

    Share this article

How do you keep the bank manager happy and your cashflow in the black? Most of us rely on doing great work to spur referrals to generate new customers. However sometimes that isn't enough.

You can advertise more. You can try to develop new customers. Or you can turn to
one of your most underutilised assets - your database.

I've been a vocal fan of database marketing for years. You know the benefits of having one, so I won't bore you with the rationale. Instead, I'd like to share seven success secrets for working with your database to turn it into your private Yellow Pages of past, present and future clients.

Let me stress the most important point. You have to keep the correct information to allow you to make your communications pertinent and valuable. Like you, your customers are overloaded with information. If what they receive from you in any form (print, email, web, audio) is not pertinent, does not add value to them, they won't digest it. You'll lose your permission to send them your marketing communications.

To add value, you cannot treat every "row" of your database the same. Each row of data represents an individual. You wouldn't try to sell meat to a vegetarian, nor a motorcycle to a 12-year-old. If you don't have customer service and relationship-building information stored, now is a good time to start.

Here are seven tips to help you profit from your customer information:

Keep it centralised

Make sure your data is easy to work with and in one place. If you have data all over (in several computers, in your email program, Excel, online) here are three tips to centralise and combine it:

* Outlook contacts can be exported to Excel, Access or a .tab, .csv file. Simply go to the File menu, select "Import and Export" and follow the instructions.

* Have only a handful to move? Simply highlight, then copy your contacts (choose a view where the details are in a row such as by phone or company) and then paste into an Excel spreadsheet.

* Using Access? The Data menu /Ribbon has an export to Excel function. One click. That's it. You have a copy of the data created in Excel.

Don't blind carbon copy (BCC)

Do a personalised email merge instead, using either Outlook Contacts or any data file. They merge through Word and create individually personalised emails incorporating the data fields you select.

The only drawback is you can't personalise the subject line or add attachments.

Not all fancy schmancy

I've written previously about how colour and graphics work against you with spam filters and graphics blocking in Outlook and Gmail. In fact, more of your emails will get through the heavy filtering corporates have when you send out plain text communications.

Use personalisation sparingly

Just because you can "Dear John" everyone doesn't mean you should do it three times within the same communication. People know about personalisation now - use it sparingly, like pepper.

Split first and last names apart

You want to "Dear John", but your database has the first and last names together. Don't have a staff member spend countless hours manually splitting them apart one by one.

Text to columns is a function that will split names out from one column. Tell it what to look for to separate the first and last name - such as a comma or a space. You'll find it in the Data menu/ribbon. For people with double or triple last names, use the concatenate function (in formulas/ functions) to put them back into one column.

Not just sales

Use the collective knowledge of your database to ask questions, solve problems, find new staff, even as a focus group to test before you go to market. I've gone to my database to suggest names for several of my books.

Profit now. And later

While most look at their database to generate sales in the short term, it's also exceedingly valuable for the future value of the business when it's for sale. Which business would be worth more to a potential buyer? One that has a well-stocked database and can be worked? Or one that doesn't?

Debbie Mayo-Smith is a bestselling author and international speaker. Twitter mseffective

www.debbiespeaks.co.nz

Discover more

Opinion

<i>Debbie Mayo Smith:</i> Poor service sinks sales

22 May 09:30 PM
Advertisement
Advertise with NZME.
Advertisement
Advertise with NZME.
Save

    Share this article

Latest from Small Business

Small Business

From foster care to own boss: How a teen mum defied the odds

31 May 05:00 PM
Premium
Small Business

Small Business: Service with a smooch at Purrs & Beans

25 May 05:00 PM
Small Business

‘Dream a bit more‘: Whanganui tea company partners with Air New Zealand

25 May 05:00 PM

Explore the hidden gems of NSW

sponsored
Advertisement
Advertise with NZME.
Recommended for you
Exploring NZ's flax industry: A glimpse into the past
The Country

Exploring NZ's flax industry: A glimpse into the past

31 May 05:00 PM
Morning quiz: What was the name of the green Teletubby?
New Zealand

Morning quiz: What was the name of the green Teletubby?

31 May 05:00 PM
'Praise the lord!' Trainer's joy as Whiskey 'N Roses back on top
Racing

'Praise the lord!' Trainer's joy as Whiskey 'N Roses back on top

31 May 05:00 PM
King of the Grill: How Charles could win Kiwi hearts (and stomachs)
Opinion

King of the Grill: How Charles could win Kiwi hearts (and stomachs)

31 May 05:00 PM
Tenor Chris McRae shares his favourite spots in Auckland
Entertainment

Tenor Chris McRae shares his favourite spots in Auckland

31 May 05:00 PM

Latest from Small Business

From foster care to own boss: How a teen mum defied the odds

From foster care to own boss: How a teen mum defied the odds

31 May 05:00 PM

At 36, Alicia McKay is an internationally successful consultant, author and speaker.

Premium
Small Business: Service with a smooch at Purrs & Beans

Small Business: Service with a smooch at Purrs & Beans

25 May 05:00 PM
‘Dream a bit more‘: Whanganui tea company partners with Air New Zealand

‘Dream a bit more‘: Whanganui tea company partners with Air New Zealand

25 May 05:00 PM
Premium
KiwiSaver changes 'a burden' for small businesses and self-employed

KiwiSaver changes 'a burden' for small businesses and self-employed

22 May 08:00 PM
‘No regrets’ for Rotorua Retiree
sponsored

‘No regrets’ for Rotorua Retiree

NZ Herald
  • About NZ Herald
  • Meet the journalists
  • Newsletters
  • Classifieds
  • Help & support
  • Contact us
  • House rules
  • Privacy Policy
  • Terms of use
  • Competition terms & conditions
  • Our use of AI
Subscriber Services
  • NZ Herald e-editions
  • Daily puzzles & quizzes
  • Manage your digital subscription
  • Manage your print subscription
  • Subscribe to the NZ Herald newspaper
  • Subscribe to Herald Premium
  • Gift a subscription
  • Subscriber FAQs
  • Subscription terms & conditions
  • Promotions and subscriber benefits
NZME Network
  • The New Zealand Herald
  • The Northland Age
  • The Northern Advocate
  • Waikato Herald
  • Bay of Plenty Times
  • Rotorua Daily Post
  • Hawke's Bay Today
  • Whanganui Chronicle
  • Viva
  • NZ Listener
  • What the Actual
  • Newstalk ZB
  • BusinessDesk
  • OneRoof
  • Driven CarGuide
  • iHeart Radio
  • Restaurant Hub
NZME
  • About NZME
  • NZME careers
  • Advertise with NZME
  • Digital self-service advertising
  • Book your classified ad
  • Photo sales
  • NZME Events
  • © Copyright 2025 NZME Publishing Limited
TOP
search by queryly Advanced Search