Why You Should De-dupe Your Data

/in , , , , , , , , , , , , , , , , /by

In today’s data-driven marketing, data is not only the most important asset that your company can have but can also make or break your campaign. Having clean data impacts not only marketing activities but also impacts your reputation, operations and decision-making. De-duping is one of the most important aspects of overall data hygiene. Duplicates can be found on many levels of data; they arise at the household level, individual e-mail level or company level. But before you can de-dupe your data, you must make sure you have a clear definition of what a duplicate is. Some businesses de-dupe based on a household address for direct mail campaigns, others on an e-mail basis for e-mail marketing campaigns, and some de-dupe based on the company level. If you are still not convinced that you need to de-dupe, consider the following benefits:

Avoiding Different Offers to the Same Customer

Having direct mail going out to the same household can be costly, and it can also be extremely embarrassing. For example, you send two different direct mail creatives to the same household. As one of the records was a customer, you decided to provide a returning customer 15% off, while the other record was marked as a prospect and only got 10% off. Now the person opening both direct mails will be confused by having two different discounts, and the company also can face a PR nightmare.

Cutting Unnecessary Cost

It goes without saying that having duplicates increases your cost. For example, assume you are doing a direct mail creative which costs you $5 per mailing. Your list contains 10,000 recipients. The total cost of mailings therefore is $50,000. If you decided to de-dupe, you would find out that 10% of your mailing list was duplicated. Therefore, $5,000 was a waste of resources. It would have been much cheaper to de-dupe prior to deploying your campaign.

Good Analytics for Decision-making 

Analytics is important not just from a perspective of understanding how your marketing and sales is performing but also from a decision-making perspective. By having duplicates in your CRM, you are going to be double-counting your list capabilities, miscalculating your true growth rates, and getting the wrong rate of responses. If you are looking to make a decision on future campaigns, basing it on duplicate data will give you the wrong list count, wrong budget and possibly the wrong creative picked (especially if you are basing it on an A/B testing done previously).

Reducing Customer Service Confusions

If there are duplicates in your CRM system, having clients call in, e-mail or come into the store will make it difficult for staff to track down the right individual. For example, Mary Smith is found twice in your CRM with the same phone number. She calls in to your customer support to inquire about her order status. Your customer service rep decides to pull up the customer account by phone number and finds two records. Now she has to put the customer on hold while she checks both accounts to try to locate the last purchase before she can even assist the customer. Not only is it wasting everyone’s time and making customer service inefficient, it also makes the customer have a bad customer service experience.

Preventing Potential Loss of Sales

Finally, the biggest impact that duplicates have on your business is a potential loss of sale. If you have duplicates, you do not have a true view of all prospect or customer activities. Therefore, you could be excluding prospects from a sales call because your lead scoring system indicated that they are not ready. However, if the data from both records was combined, you would have all signals indicating they are ready to be passed on to sales. With duplicates, by the time you figure it out, a customer may have already lost interest and gone with your competitor.

You can easily de-dupe your list by using a de-duping tool that will require less effort to identify duplicates and establish a master record than is required to deal with the consequences of duplicate data. De-duping should be part of your data-cleaning initiative, either prior to any major campaign or on a yearly basis.

If you are interested in data clean-up and use of a de-duping tool, contact guest author Anna Kayfitz, CEO of StrategicDB Corp.

Social Media Pros Predict Wide Range of Changes in 2018

/in , , , , , , , , , , , , /by

Both B2B and B2C marketers are planning on investing more in social media marketing in 2018, per surveys. So AccuList USA’s clients may want to take a look at the trends that social media experts are predicting for Facebook, Instagram, Twitter, LinkedIn, and Pinterest marketing in the year ahead, as recently gathered up by Social Media Examiner.

Video Boom: Moves by LinkedIn and Facebook

Among the more than 33 predictions featured, multiple social media pros stressed the growth and impact of video, as “even simple selfie videos filmed on cell phones are propelling businesses higher than video-less businesses,” to quote one forecaster. B2B marketers will be pleased to know that LinkedIn advertising is expected to roll out video ads for business pages and geofilters for videos, now in test. Facebook, which remains the social media ad leader, is positioning to become a major player in online video. In 2017, Facebook debuted Facebook Watch for select creators (a TV-like option). In 2018, it is forecast that the program will expand to all people and pages on Facebook, and also that Facebook will likely roll out new features for video creators, perhaps including preferential Facebook news feed exposure for original native video, revenue-sharing deals, or even a dedicated video app. With the video boom, metrics will need to get more sophisticated across platforms. Since each platform counts their video views differently (Snapchat at 1 second, Twitter at 2 seconds, Facebook/Instagram at 3 seconds, and YouTube at 30 seconds), watch for marketers to go beyond number of views to data measuring the time spent and the attention held across all screens on all platforms.

Instagram Gains Ground With Marketers

Instagram is forecast to keep surging after fast growth in 2017, with 15 million businesses using Instagram by July 2017 (nearly double the 8 million businesses that used Instagram in March 2017), with 80% of Instagram accounts now following at least one business, and with global advertising set to reach $4 billion for 2017 year-end. One reason is that Instagram has been improving its tools for marketers, including InstaStories promoted within the  “news feed,” the Story Highlights feature that allows pages to host static collections of previously disappearing story posts on profiles, “swipe up” calls-to-action, posts that click through to online stores, and soon the ability to follow hashtags.

Rising Ad Costs Force Smarter Targeting, Metrics

The bad news for marketers is that the popularity of social media will translate into rising ad costs in 2018, with pricing of Facebook and Instagram advertising predicted to rise over the next 12 months. However, that cost trend should actually spur businesses hesitating to invest; marketers who commit to social media ads now will generate awareness, build audience (particularly via e-mail subscribers) and gain a competitive advantage in the increasingly crowded market. Given the rising cost to gain the attention of prospects and acquire customers, more businesses also are urged to hone ad effectiveness beyond generating leads followed with automated e-mail—for example using retargeting, AI and other techniques to ensure prospects see the most relevant messaging for their point in the customer journey. And, as cheap organic reach declines in effectiveness and paid ad costs climb, the importance of ad metrics increases. Whether on Facebook, Instagram, LinkedIn or Twitter, marketers will need to track the metrics of each ad or promoted post, combining a paid acquisition model with historical data and personalized content if they hope to translate social media marketing into real revenue results in 2018, warn the social media mavens.

For more predictions, see https://www.socialmediaexaminer.com/social-media-predictions-2018/?utm_source=Newsletter&utm_medium=NewsletterIssue&utm_campaign=New

Use Key Direct Marketing KPIs to Gird 2018 Plans

/in , , , , , , , , , , , , , , , /by

The busy year-end holiday season, especially for fundraisers and retailers, should not distract direct marketers from the working on the analytics they need to finalize next year’s marketing plans and ROI. A recent post by the Digital Dog Direct agency helpfully offers a checklist of basic marketing Key Performance Indicators (KPIs).

Spending and Lead Generation

Marketing ROI is about effective spending and requires tracking results by channel and campaign. KPIs use actual annual outlay for direct mail marketing (lists, print, lettershop, creative, postage), digital marketing (e-mail, SEO/SEM, landing pages, social media and creative), as well as spending on PR/events/brand/content marketing.  Marketers must keep a tally of the number of outbound leads attributed to direct mail or e-mail campaigns, as well as the inbound leads generated by efforts such as SEO, blog content or PR. Then a cost per lead acquired can be calculated by dividing annual expenditure by the number of leads generated. Since the ultimate goal is sales not merely leads, the percentage of leads that become paying customers and the dollar sales per lead are key measures.

Multi-channel Performance Rates

Beyond evaluating general performance, marketing planners should use measurement to fine-tune future marketing plans and budgets. This means identifying the response rates and conversion rates for each channel, for each direct mail and digital campaign, and for tests of creative, timing, frequency, lists and segments. Performance rates should be measured not only for campaigns to acquire new leads/customers but also targeting of existing customers and reactivation of dormant customers. Website traffic reports from Google Analytics can not only show online ad and SEM effectiveness but also track spikes around direct mail or e-mail promotions to give a fuller picture of response. A simple ratio of the annual return on marketing investment, or ROI by channel and campaign, can be calculated by adding up incremental sales from marketing and subtracting marketing amount spent, and then dividing the result by amount spent on marketing.

Long-term Growth of High-Value Customers

But remember that a focus on annual or campaign results can be myopic since these do not necessarily deliver long-term growth–for example if attrition is high so more customers are lost than added. Marketers need to look at customer and prospect databases to make sure they are growing year-over-year. Because acquiring a single sale per lead also is less profitable long-term than acquiring a repeat customer, measuring average customer lifetime value is a vital KPI and is calculated by multiplying average dollar sale per customer by the average number of purchases per year and the average retention time in years.

See the full article for the KPI checklist.