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.
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.
There are currently three capabilities: Acquire, Enrich, and Refresh. Each has different uses:
You will need to purchase additional credits through your account via the DQ Shop dqshop.dqglobal.com
You can top up and buy additional credits through your DQ Shop user account please go to dqshop.dqglobal.com
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
DQ Credits have a life of one year. If not consumed, they roll off of your stock on a First in First out basis.
If the operation was not processed by DQ on Excel then no charge will apply.
Yes – Our MarketBase offerings: Acquire, Enrich and Refresh all reference data from over 20 trusted UK data providers. You can define a filtered query and buy businesses and marketable contact to improve your marketing coverage here
You can match and Enrich your existing customer data back to the MarketBase database which contains up to 5 million Companies and Employee Contacts for enrichment.
Using this insight you can identify why your best customers are the best and then using that insight identify new (look-alike) prospects with the same characteristics.
Yes – You can refresh your database and overwrite it with the latest and most current data. And only be charged for the records that have changed since the last time the data was acquired or refreshed.
Note: Please restrict your refresh query to only where there is new data, or you will be charged for each refresh request.
Duplicate detection is made easier using any combination of ID’s returned. i.e., CompanyID, SiteID, and PersonID can be used to identify duplicate records matched from your data to the MarketBase reference data.
The following variables are returned when the initial Match and Append phase of Enrich is initiated.
Please refer to the MarketBase Enrich documentation to assist in the appending of data attributes to your existing marketing data.
Each of the MarketBase services has different performance characteristics; however, it is generally very fast, and we continually seek to optimize its performance.
Within DQ for Excel, you simply check your DQ Credits balance under the account management section. When you access this area, you will be shown your usage and balances.
Not from MarketBase, however, they are available from our address verification service where we will return geocoordinates and append them to your spreadsheet’s workbook.
The default geocoding service will return a latitude and longitude to a central point of a postcode, which is accurate to approximately 100m
Currently, MarketBase is UK-based. It is a B2B Company and key decision-making Employee reference data set.
It is made up of over 20 trusted data suppliers and aggregated to form a unified master database. There are constant refreshes of data that are made online so you can be sure the data is complete and up to date.
Because the data is constantly updated you can be sure when you refresh your records you are getting the latest and most compete data.
Verifying your marketing data against MarketBase ensures it is complete, up to date, and can be trusted for better decision-making.
Once matched back to MarketBase, you will have Company, Site, and Contact ID’s which are invaluable for de-duplication, record refresh, and acquisition of selected contacts by role and level from companies you want to trade with.
This depends on your mapping of the output, whilst we do not recommend overwriting the original fields it is possible.
A better solution is to append the matched data attributes into new columns to the right of the addresses you currently have or place them into a fresh worksheet.
If you have any questions, please contact us at firstname.lastname@example.org and we will get back to you as soon as possible.
“MarketBase leverages Experian’s BusinessView reference data, which is the result of Experian’s extensive expertise in acquiring, analyzing, and consolidating prominent B2B datasets from the UK, Ireland, and other regions for nearly four decades.
MarketBase embodies three key principles:
In the UK in particular, the range of commercially available sources includes:
The data collected by us is the foundation of the goods and services we offer and, as with the combination of data sources, the combination of individual items of information and human analytics can create data outputs for specific use cases (such as modeling, segmentations) which are more powerful than the individual items provided by our suppliers.
For a more detailed explanation of our sources please refer to Experians’ marketing transparency notice which can be found here: https://www.experian.co.uk/business-information/marketing-transparency-notice.
DQ Global using Experian data relies on Legitimate Interests as our lawful basis for processing B2B email data and fully complies with both the GDPR and PECR (Privacy and Electronic Communications Regulations).
Sole Traders and some partnerships are treated as individuals – so you can only email or text them if they have specifically consented, or if they bought a similar product from you in the past and didn’t opt out from marketing messages when you gave them a chance.
You can email or text ANY corporate body (a company, a Scottish partnership, a limited liability partnership, or a government body) just as long as you offer that company the chance to opt-out and keep a suppression list of any opt-outs you receive so that you can screen those companies out of future campaigns.
Using targeted lists provided by MarketBase will help to ensure that you have a legitimate interest in contacting those companies included in campaigns you do contact.
Yes, you may select from the following regions:
Yes, you may select from over 300+ criteria, including SIC codes.
For a list of SIC Codes, please refer to https://resources.companieshouse.gov.uk/sic/
Yes, you can select by postcode area, these are the first one or two characters of a UK postal code. Some examples include:
Not at the time of writing. This may become a feature in the future.