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

Lifestyle

The secret sauce of the bar named NZ's best

08 Jul 10:00 PM
Premium
Small Business

On The Up: From fishing shows to first aid - Parachute First Aid's unique journey

06 Jul 05:00 PM
Premium
Business|small business

'Change their footprint': Kiwi start-up's plan to shave $1200 a year off household power bills

30 Jun 05:00 PM

From early mornings to easy living

sponsored
Advertisement
Advertise with NZME.

Latest from Small Business

The secret sauce of the bar named NZ's best

The secret sauce of the bar named NZ's best

08 Jul 10:00 PM

'I’ve always wanted to be called an institution – that’s my goal.'

Premium
On The Up: From fishing shows to first aid - Parachute First Aid's unique journey

On The Up: From fishing shows to first aid - Parachute First Aid's unique journey

06 Jul 05:00 PM
Premium
'Change their footprint': Kiwi start-up's plan to shave $1200 a year off household power bills

'Change their footprint': Kiwi start-up's plan to shave $1200 a year off household power bills

30 Jun 05:00 PM
Premium
Small Business: Kiwi pickle brand processes 100 tonnes as business booms

Small Business: Kiwi pickle brand processes 100 tonnes as business booms

29 Jun 05:00 PM
Solar bat monitors uncover secrets of Auckland’s night sky
sponsored

Solar bat monitors uncover secrets of Auckland’s night sky

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
  • Newstalk ZB
  • BusinessDesk
  • OneRoof
  • Driven Car Guide
  • 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