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

Subscriptions

  • Herald Premium
  • Viva Premium
  • The Listener
  • BusinessDesk

Sections

  • Latest news
  • New Zealand
    • All New Zealand
    • Crime
    • Politics
    • Education
    • Open Justice
    • Scam Update
    • The Great NZ Road Trip
  • 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
  • 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
    • 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
    • Cooking the Books
  • Cartoons
  • Photo galleries
  • Today's Paper - E-editions
  • Photo sales
  • Classifieds

NZME Network

  • Advertise with NZME
  • OneRoof
  • Driven Car Guide
  • BusinessDesk
  • Newstalk ZB
  • What the Actual
  • 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 / Technology

Avoid database stress

By Adam Gifford
21 Nov, 2006 06:19 AM5 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

KEY POINTS:

Christmas is approaching and thoughts turn to business relationships.

Customer databases are being turned into Christmas card lists, arcane calculations are being made as to whether one customer should get a beach umbrella or another the desk set.

Things that were in the 'to do' file suddenly have to be done, yesterday, if deadlines are to be met.

Deidre Ross, the general manager of mail fulfillment company Mailshop, says the last quarter of the year gets frantic as the final direct marketing pushes of the year overlap with the mailing out of millions of corporate Christmas cards, gifts and invitations to end of year functions.

"We do 40 per cent of our turnover in these three months, with another peak around Easter," Ross says.

While a lot of effort can be put into the development of the printed material, it's often the mailing lists themselves where the problems crop up.

Lists drawn from contact databases or customer relationship management systems need to be purged and post coded.

"The postal coding scenario is a mammoth task for the customer, because if you are mailing out to more than 1000 people, you need the proper post codes to get the discounts from New Zealand Post," Ross says.

Fortunately New Zealand Post is still accepting the old post codes this season.

Firms can wait until the New Year to go through their databases and switch to the new post codes and address standards. That will be a significant IT project for many firms, and could show up the deficiencies in many customer management systems.

"We are telling clients not to panic, they have nearly two years to make the transition," Ross says.

She says clients seem more organised this year, and most have booked their jobs well in advance.

"The data is a mixed bag. Some is clean, some needs lots of work."

Mailshop runs the lists through a range of tools, matching names against New Zealand Post's database of new movers, the gone no addresses, the Direct Marketing Association's list of people who don't want to receive unsolicited mail.

It can also pull information out of the data to personalise the communications.

"We can clean up the data and report back the the customer, so they can update their own systems. We can also monitor returned, so we do the return on investment study."

Ross says while much of the work is large runs, they are also able to handle small volumes.

"Anything over 1000 would give you a reasonably good discount in bulk mailing, but if you are doing this at home or in a small business, you know that anything over 500 is a pain in the neck to process. We're even doing a job at the moment for a list of 20."

As well as cards, gifts have become big business.

Mike Williamson from TLC Marketing says when his company started selling corporate gifts 10 years ago, firms might give a bottle of wine to favoured customers or suppliers.

Now a wide variety of products, branded and unbranded, get shoved in the stocking.

"We usually clear out our showroom in Eden Terrace about August or September and put up the range so people can come and choose," Williamson says.

More than half the items get branded, but by this time of the year it may take up to three weeks to get a logo or message printed or embroidered on the item.

"There seems to be a trend towards not branding, particularly with items of a perceived higher value. A customer may not use a hammock or picnic bag is it has a logo all over it.

"It comes down to the relationship our customers have with their customers."

Williamson says there seems to be competition to find the next best gift.

"For some firms the gift is quite a big part of the annual marketing spend, so if they do a large item, the next year they look for something as big or better, as expectations increase."

Gifts can range from items under $10 to several hundred dollars.

"We sometimes see multiple tiers. Some customers may get something costing less than $10. There will be another tier at $20 or so, some at $50, and a few key suppliers or customers get something worth $200."

Popular items include leisure products which people can use over the summer, IT products, including a wide range of USB flash drives disguised as other things, office items like desk clocks and pen sets, and food hampers.

"Wine, nicely packaged, is still popular," Williamson says.

Then there is the question of when to send the gifts out. Send them too early and they seem odd. Send them too late and the recipient may have taken off for the beach, and that basket of fruit sits on the doorstep liquefying.

Williamson is also seeing a move to philanthropy, where people tell their customers they are giving to charities rather than sending out gifts.

Advertisement
Advertise with NZME.
Advertisement
Advertise with NZME.
Save

    Share this article

Latest from Technology

Premium
Technology

Spark confirms jobs will go as it outsources to AI, networking partner

16 May 04:00 AM
Premium
Technology

Kiwi startup lands TikTok as a client

16 May 02:00 AM
Premium
Business

Xero cracks $2 billion revenue for first time but subscriber growth slows

14 May 11:51 PM

Deposit scheme reduces risk, boosts trust – General Finance

sponsored
Advertisement
Advertise with NZME.

Latest from Technology

Premium
Spark confirms jobs will go as it outsources to AI, networking partner

Spark confirms jobs will go as it outsources to AI, networking partner

16 May 04:00 AM

Restructure comes on top of contract to outsource roles to Infosys.

Premium
Kiwi startup lands TikTok as a client

Kiwi startup lands TikTok as a client

16 May 02:00 AM
Premium
Xero cracks $2 billion revenue for first time but subscriber growth slows

Xero cracks $2 billion revenue for first time but subscriber growth slows

14 May 11:51 PM
Premium
The big lessons for NZ in Australia's under-16 social media ban

The big lessons for NZ in Australia's under-16 social media ban

14 May 05:32 AM
Gold demand soars amid global turmoil
sponsored

Gold demand soars amid global turmoil

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