Download

In this FAQ section, we aim to address the most common queries and concerns you may have about the Suppression of records in DQ for Excel™.

Whether you’re looking to learn more about the capabilities, the data behind the tools, the installation process, or pricing, you’ll find the answers here.

We’re committed to providing you with the information you need to make the most out of this powerful tool and elevate your customer data quality within MS Excel.

What is DQ for Excel™?

DQ For Excel™ is a Microsoft Add-in that works right inside Microsoft Excel, it’s familiar and simple to use! Import data from almost any source, prepare it, master it and perfect it; then upload it back to almost any target. Process hundreds of thousands of records at once and only pay for your usage on a credit based model. 

DQ For Excel™ is powered by DQ on Demand, DQ Global’s Data Quality as a Service (DQaaS) Data Quality Improvement Platform. 

How long does it take to set up suppression of records in DQ for Excel™?

DQ for Excel can be installed to enable suppression in minutes from the Microsoft Office store. 

Where can I install DQ for Excel™ with Suppression capabilities?

DQ for Excel™ can be found in the Microsoft Office store which you can access via heading to the Insert tab within Microsoft Excel and selecting ‘Get Add-ins’. 

A full Installation Guide can be found here. 

How much does a suppression cost in DQ for Excel™?

Billing for DQ for Excel™ is transactional, i.e. each request will consume credits, which can be spent on any of the available services. The application can be installed free of charge from the Microsoft Store. 

What happens when I run out of DQ Credits for Suppression?

You will need to purchase additional credits through your account via the DQ Shop dqshop.dqglobal.com 

How do I top up my Suppression DQ Credits?

You can top up and buy additional credits through your DQ Shop user account please go to dqshop.dqglobal.com

What are DQ Credits and how much do they cost for Suppression?

DQ Credits are a form of digital currency you purchase in advance to consume on a host of data quality improvement services.

Each DQ Credit notionally represents 1/10th or a penny i.e., £0.001 and each service requires a different number of credits 

You can purchase DQ Credits in packs.  The larger the pack, the better the effective discount 

For the individual service costs see our pricing

How long to DQ Credits last i.e., do they expire?

DQ Credits have a life of one yearIf not consumed, they roll off of your stock on a First in First out basis. 

Will I be charged if my Suppression operation isn't successful?

Suppression checks are charged per request. i.e., Deceased, Gone-Away, or Preference checks.

If the operation fails due to a technical reason then no charge will apply.

Does Suppression work on both business and consumer data?

Yes and No.  The Deceased and Gone Away files are consumer-related.  However, the Telephone Preference Service (TPS) is for consumers, and the Corporate Telephone Preference Service (cTPS) is for businesses.

Why is suppressing deceased and gone away records important?

Suppressing deceased and gone away records is crucial because it helps maintain the accuracy and relevance of data.

It ensures that communication efforts are directed toward viable recipients, saving time and resources while preserving the reputation of an organisation.

How can I ensure that my phone numbers are not on the TPS or cTPS list

To ensure your phone numbers are not on the TPS (Telephone Preference Service) or cTPS (Corporate Telephone Preference Service) list in the UK, you can perform a screening or checking process using the phone suppression capability.

We will help you identify and remove any numbers registered on these lists to comply with telemarketing regulations and avoid fines.

Can I TPS and cTPS suppress outside of the UK

At the time of writing, the TPS and cTPS services are restricted to the United Kingdom (UK) which allows individuals and businesses to opt out of receiving unsolicited marketing calls.

Please check however as other phone suppression services from the countries below are planned:

  1. United States: The United States has the National Do Not Call Registry (NDNC) to allow consumers to opt out of telemarketing calls.
  2. Canada: Canada has the National Do Not Call List (DNCL) to prevent unwanted telemarketing calls.
  3. Australia: Australia has the Do Not Call Register (DNCR) to stop unwanted telemarketing calls.
  4. India: India introduced the National Customer Preference Register (NCPR) to reduce unwanted commercial calls and SMS.
  5. Singapore: Singapore’s Personal Data Protection Commission (PDPC) allows individuals to opt out of unsolicited marketing messages and calls.
  6. South Africa: South Africa has the National Opt Out Database (NOOD) for individuals to opt out of unwanted marketing communications.
Can deceased contact records be identified and suppressed?

Yes – you can suppress UK based B2C records who are deceased (passed away) 

Can Gone-Away contact records be suppressed?

Yes – you can suppress UK based B2C records who have moved (gone away) 

Can I suppress phone numbers on the UK’s telephone preference list?

Yes – you can suppress individuals and businesses who have registered the UK’s Telephone Preference Service (TPS) or Corporate Telephone Preference Service (cTPS) 

How long does it take to process Suppressions

Each service has different performance characteristics; however, it is generally very fast, and we continually optimise its performance 

How do I know how many Suppression credits have been used and remain?

Within DQ for Excel you simply check your balance under the account management section.  When you access this area, you will be shown your usage and balances.

 

How often is suppression data updated?

The data is constantly refreshed behind the scenes, so no need to worry about how current the reference data is.

Do you overwrite my existing addresses with the results of the supressed records?

For suppressions the original data remains the same, we simply return flags you to append to your worksheet for suppression purposes.

Who can I contact for support using the application?

If you have any questions, please contact us at support@dqglobal.com and we will get back to you as soon as possible. 

What is the TPS, and why should we suppress TPS records?

The Telephone Preference Service (TPS) is a register that allows individuals to opt out of receiving unsolicited marketing calls. Suppressing TPS records is essential to comply with regulations and avoid legal consequences while respecting the preferences of consumers who do not wish to receive such calls.

Are there legal implications for not suppressing these records?

Yes, failing to suppress these records can result in legal consequences, including fines and damage to your organisation’s reputation.

It’s important to comply with data protection and telemarketing regulations in your region.

How often should I update and suppress TPS records in my database?

The frequency of updating and suppressing records should align with your business requirements and the rate at which your customer data changes.

In the UK, it’s important to note that there’s a legal obligation to screen all marketing calls against the register every 28 days unless you have obtained explicit consent from the individuals allowing you to contact them.

Failure to comply with these regulations can result in penalties, including fines of up to 4% of your global turnover, as enforced by the Information Commissioner’s Office (ICO).

 

Can I re-engage with suppressed customers in the future?

Yes, in some cases, you can re-engage with customers who were previously suppressed, provided you have their consent or the records have been updated to reflect their preferences accurately.

Where can I find more information about record suppression and compliance?

You can find more information about record suppression and compliance from regulatory authorities, industry associations, and legal experts specializing in data protection and marketing regulations in your region.

What is cTPS

CTPS (the Corporate Telephone Preference Service) is the UK’s official ‘Do Not Call’ list for companies.

Similar to the TPS, companies sign up to the cTPS register to opt out of telephone-based marketing calls.

You must therefore screen all telemarketing calls against the cTPS register every 28 days unless the company has given clear consent that you can call them.

Companies that do not comply can face a fine of up to 4% of global turnover by the Information Commissioner’s Office (ICO).

How secure is my data?

DQ for Excel ensures the secure transfer of your data to our DQ on Demand data processing services through an encrypted connection.

We hold the Cyber Essentials Plus certification, which validates our implementation of robust processes and security measures dedicated to safeguarding your data throughout the entire process.

How many phone numbers can be checked at once

The only limit is the number of records you can hold in a single workbook which is just over 1 million rows. 1,048,576 to be precise.

For additional processing, you may use multiple Excel worksheets.

What are deceased and gone-away records?

Deceased records refer to information about individuals who have passed away.  Gone-away records relate to individuals who have moved and left their previous address.

Why are deceased and gone-away records important?

These records are crucial for businesses and organizations to maintain accurate customer databases, prevent fraud, and ensure effective communication.

What is the purpose of checking for deceased records?

It helps prevent sending mail or communication to deceased individuals, which can be insensitive and a waste of resources.

How can businesses use gone-away records?

It helps prevent sending mail or communication to deceased individuals, which can be insensitive and a waste of resources.

What legal considerations are there when using deceased and gone-away records?

Adherence to data protection and privacy laws, such as GDPR is essential when handling such sensitive information.

Is there a cost for matching of deceased and gone-away records?

Yes, there is a fee for each record matched.

How often should businesses update their records for deceased and gone-away individuals?

Regular updates, at least annually, are advisable to maintain data accuracy.

Are there any ethical considerations when handling deceased and gone-away records?

Yes, it’s important to treat such information with respect and ensure that it’s used for legitimate purposes only.

Remember that the availability and handling of deceased and gone-away records can vary by jurisdiction and the specific data source.

Always adhere to relevant laws and ethical guidelines when working with such sensitive information.

What is the TPS (Telephone Preference Service)?

TPS is a free-to-register service provided by the UK government that allows individuals to opt out of receiving unsolicited marketing and sales calls.

Is TPS registration permanent, or does an individual need to renew it periodically?

TPS registration is permanent, and the number will remain on the list until removal is requested.

What types of calls does TPS screening block?

TPS screening primarily blocks unsolicited marketing and sales calls, including telemarketing calls.

Does TPS registration stop all unwanted calls?

TPS screening primarily blocks unsolicited marketing and sales calls, including telemarketing calls.

While TPS registration can significantly reduce the number of unsolicited marketing calls, it may not block all types of unwanted calls, such as scam calls.

Can businesses still call TPS-registered numbers for non-marketing purposes?

Yes, businesses can still call TPS-registered numbers for non-marketing purposes, such as customer service or conducting surveys.

What are the consequences for businesses that call TPS-registered numbers for marketing purposes?

Businesses that make unsolicited marketing calls to TPS-registered numbers may face fines and penalties for non-compliance with data protection regulations of up to 4% of revenue.

How often should businesses update their call lists to ensure TPS compliance?

Businesses should regularly update their call lists using the suppression capability of DQ for Excel against the TPS database to ensure they do not call TPS-registered numbers.

How can I check if any of my database of phone numbers are registered with the TPS?

Businesses can check their data against the TPS database using the suppression capability of DQ for Excel to see if the phone numbers stored are TPS registered.

Is TPS registration effective immediately?

It may take up to 28 days for TPS registration to become fully effective, so business should constantly check their records.

Is TPS registration limited to residential numbers only, or can businesses also register?

Both residential and business telephone numbers can be registered with the TPS.

Business numbers are registered on the Corporate Telephone Preference Service (cTPS)

Is there a cost associated with TPS registration? No, TPS registration is free for individuals and businesses.

No, TPS registration is free for individuals and businesses.

Can TPS registration be done for mobile phone numbers as well?

Yes, mobile phone numbers can be registered with the TPS to block unsolicited marketing calls.

What is the Corporate Telephone Preference Service (cTPS)

The Corporate Telephone Preference Service (cTPS) is a service in the United Kingdom that is designed to help businesses and organizations manage unwanted telemarketing calls. It is like the Telephone Preference Service (TPS), which is for individual consumers.

The cTPS allows businesses to register their phone numbers to indicate that they do not wish to receive unsolicited marketing calls. Once a business’s number is registered with the cTPS, it becomes illegal for telemarketers to call that number for marketing purposes.

This service helps businesses reduce the nuisance of unwanted sales calls and allows them to focus on their operations without interruptions.

Businesses can register for the cTPS for free, and the registration remains in effect for 28 days. After that period, businesses can renew their registration to continue enjoying protection from unsolicited marketing calls.

What is the Telephone Preference Service (TPS)

The Telephone Preference Service (TPS) is a service in the United Kingdom that allows individuals to register their phone numbers to indicate that they do not wish to receive unsolicited telemarketing calls.

The TPS is a free-to-register service provided by the Information Commissioner’s Office (ICO) in the UK.

Here’s how the TPS works:

  1. Registration: Individuals can register their landline and mobile phone numbers with the TPS. Registration can be done online, by phone, or by mail. Once registered, it becomes illegal for companies to make unsolicited marketing calls to those numbers for sales or promotional purposes.
  2. Exemptions: Some types of calls are exempt from the TPS regulations. For example, calls from political parties, charities, and market research organizations are not covered by the TPS. However, these organizations often have their own guidelines for respecting individuals’ preferences.
  3. Protection: After registering with the TPS, individuals should see a reduction in the number of unwanted telemarketing calls they receive. Telemarketers are required to check the TPS list regularly and remove registered numbers from their call lists.
  4. Renewal: TPS registration is not permanent. It typically lasts for 28 days. After that period, individuals can choose to renew their registration to continue receiving protection from unsolicited marketing calls.

It’s important to note that while the TPS can significantly reduce the number of marketing calls individuals receive, it may not eliminate all such calls, as some companies may not comply with the regulations

In such cases, individuals can report violations to the ICO, which may take enforcement actions against non-compliant organizations.

The TPS is a valuable tool for individuals who want to reduce the annoyance of unwanted sales calls and maintain their privacy. It is part of broader efforts to protect consumers from unwanted marketing communications in the UK.

What is the difference between TPS and cTPS?

The Telephone Preference Service (TPS) is a list of consumers (including Sole Traders and Partnerships, except in Scotland) who have registered their wish not to receive unsolicited direct marketing calls.

The Corporate Telephone Preference Service (CTPS) is an extension of this to businesses.

Connect

Written by Martin Doyle

Martin is CEO and founder of DQ Global, a Data Quality Software company based in the UK. With an engineering background, Martin previously ran a CRM Software business. He has gained a wealth of knowledge and experience over the years and has established himself as a Data Quality Improvement Evangelist and an industry expert.

Make an Enquiry

Product and account support