Download

In this FAQ section, we aim to answer questions commonly asked about Address Verification.

How long does it take to set up DQ for Excel for address verification?

DQ for Excel can be installed in minutes from 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. 

Once installed you can verify your global or local addresses with ease.

How much does Address verification in DQ for Excel™ cost?

Billing for DQ for Excel™ is transactional, i.e. each request will consume DQ Credits, which can be spent on any of the available services.  See this link to the pricing page.

The application can be installed free of charge from the Microsoft Store. 

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

Each response from an address verification request is a billable request, as you will know if the address has been verified or not.

However,  If the operation was not processed by DQ for Excel™ for any technical reason, then no charge will apply.

What is Address Verification?

Address Verification This is the process of referencing your existing location (address) data against reliable and trusted international postal authority data covering 240 Countries, to (a) verify it as postally correct and (b) add attributes like geo-codes and other useful location data.

When I Verify an Address what gets checked and changed?

When checking (verifying) your existing addresses against trusted postal authority reference data, you can be sure they are of the correct localised formats. including:

  1. Street Address: The specific street name and premise number where the recipient resides or the business is located. This may also include premise, apartment, or suite numbers.
  2. City or Locality: The name of the city, town, or locality where the recipient is located.
  3. State, Province, or Region: The state, province, or region within the country. In some countries, this may be referred to as a “county” or “territory.”
  4. ZIP Code or Postal Code: A numerical code used to identify a specific geographic area within a country. ZIP codes are used in the United States, while postal codes are used in many other countries.
  5. Country: The name of the country where the recipient is located. This is particularly important in international addresses.

It’s important to note that the format and order of these elements may vary from country to country.

Different countries have different address standards, and some may have additional components or variations in how the information is presented. Therefore, it’s essential to follow the local postal guidelines when addressing post (mail) or packages (parcels) to ensure accurate and timely delivery.

Why is Address verification important?

Address verification is important for several reasons:

  1. Accurate Deliveries: In e-commerce and logistics, accurate addresses ensure that packages are delivered to the right location. This reduces the risk of misdeliveries or returned shipments, which can be costly and inconvenient for both businesses and customers.
  2. Reduced Fraud: Address verification helps verify the legitimacy of a customer’s or user’s provided information. It can be used as a tool to detect fraudulent activities, such as identity theft or payment fraud.
  3. Compliance: Many industries, such as finance and healthcare, have strict regulatory requirements for verifying customer identities and addresses. Compliance with these regulations is crucial to avoid legal issues and penalties.
  4. Customer Trust: When customers see that a business is verifying their address, it can increase their trust in the company. They are more likely to feel confident in providing their personal information and making purchases.
  5. Data Quality: For businesses, maintaining a clean and accurate customer database is essential. Address verification helps in this regard by ensuring that the data entered into the system is correct and up-to-date.
  6. Cost Savings: By reducing the number of returned mail or undeliverable packages, address verification can lead to cost savings for businesses in terms of postage, shipping, and reprocessing fees.
  7. Marketing Effectiveness: When businesses have accurate addresses for their customers, they can target their marketing efforts more effectively. This leads to higher response rates and a better return on investment for marketing campaigns.
  8. Improved Customer Experience: Accurate addresses lead to smoother and more reliable service, which ultimately improves the overall customer experience. Customers are less likely to be inconvenienced by delivery issues or billing problems.
  9. Global Expansion: For businesses looking to expand internationally, address verification is crucial for ensuring that products and services reach customers in different countries accurately and on time.

Address verification plays a pivotal role in ensuring accuracy, security, and compliance in various industries. It contributes to better customer experiences, reduced operational costs, and increased trust between businesses and their customers.

Can I verify and correct international addresses?

Yes – Addresses can be checked (verified) against international postal authority data obtained from providers including: USPS, Canada Post, the UK’s Royal Mail, Australia Post etc. to confirm it is a postally deliverable address, and format it according to local country standards. 

Does address verification help to detect deduplicate data?

Yes, a verified address which is complete and consistently formatted will definitely assist with duplicate detection.

How long does it take to verify an addresses?

It is generally very quick to address verify records, and we expect an average of 6 records per second per record as a minimum, so 21,600 records per hour.

We continually optimize our services to improve address verification performance.

How do I know how many address verification 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.

 

Can I obtain GeoCode (latitude and longitude) data when I verify an address?

Yes, where available from the address verification data providers, we will return geocoordinates and append them to your spreadsheet’s workbook 

What accuracy (precision) is the Geo Coordinate information?

The default geocoding service will return a latitude and longitude to a central point of a postcode, which is accurate to approximately 100m 

What countries, languages, scripts and formats are coverage are available for address verification?

There are more than 250 continuously changing countries and territories, multiple languages, 139-character scripts and over 130 different address formats covered. 
 
Note: Not all countries have the same postal coverage, however, most major countries have coverage to premise level. 

How often is addressing reference data updated?

The UK’s Postcode Address File (PAF) ® data, is updated around 5,000 times each day to ensure the information you receive is as accurate and current as possible. 

What are the benefits of international Address verification?

Verifying overseas addresses means that any mailings sent to foreign addresses will be in the appropriate format and language, reducing the likelihood of misspellings or causing offense.  With over 120 different address formats globally, and 30 different language scripts, keeping global address data correct is a constant challenge. 

Can I add a postcode from an incomplete address?

Yes, address verification can help you to append a postcode from a partial address, you will normally need the premise number and the street, town and the country to achieve this. 

When my address data is incomplete or poorly formatted, will the address verification capability help me cleanse it?

Yes, where possible, our address verification (cleansing) capability takes the input you provide, pre-processes it and compares (verifies) it against trusted postal authority data.  
 
Where match can be made, with a high enough level of certainty, we will return a consistently formatted and complete address which is fit for postal use. 
 
Where a match cannot be made a reason code/description is reported 

Do you overwrite my existing addresses with the results of the verified (cleansed) address?

This depends on your mapping of the output, whilst we do not recommend overwriting the original address it is possible. 
 
A better solution is to append the matched address into new columns to the right of the addresses you currently have, or place in a fresh worksheet. 

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. 

Are there any factors that may affect the verification speed?

While we strive to maintain high-speed verification, factors such as the complexity of the address data, network conditions, and the size of the dataset being verified can impact performance.

However, we continually optimize our services to ensure the fastest possible address verification.

How do you optimize address verification performance?

We are committed to delivering high performance and quality verification.

Our optimization efforts include fine-tuning algorithms, enhancing hardware infrastructure, and staying up-to-date with the latest technological advancements.

These ongoing improvements help us maintain a high level of address verification speed and accuracy.

Can I rely on consistent performance for large address datasets?

Absolutely! Our service is designed to handle both small and large datasets efficiently.

Whether you have a few records or thousands, you can trust us to provide speedy and reliable address verification services.

What benefits does high-speed address verification offer my business?

High-speed address verification brings several benefits to your business.

It ensures quick processing of customer data, reduces delays in delivery and communication, enhances customer satisfaction, and contributes to cost savings by optimizing operational efficiency

Do you offer real-time address verification as well?

Yes, we offer real-time address verification solutions, however, not within MS Excel as the verification process is designed to batch (bulk) cleanse your records.

Please contact sales@dqglobal.com for alternate options for interactive real-time address searches to discuss your requirements.

How is address verification typically performed?

Address verification can be done through various methods, including:

  • Manually checking postal databases and address directories.
  • Sending a verification code or mail to the provided address.
  • Utilising DQ for Excel’s address verification services.
What information is needed for successful address verification?

The information needed for address verification as a minimum includes, the premise number and postal/zip code.

More usually a full address including, the premise number, street address, city, county/state/province, postal code or ZIP code, and sometimes additional details like apartment numbers or building names.

Using the above in DQ for Excel will help return a fully verified and formatted address.

Is address verification the same as identity verification?

No, address verification and identity verification are not the same.

Address verification focuses solely on confirming the accuracy of a physical address, while identity verification aims to confirm the identity of an individual or entity.

Who should use address verification services?

Address verification services are for anyone who needs a complete and verified postal address.

This is important for a wide range of organizations, including: e-commerce companies, financial institutions, government agencies, and businesses in industries such as logistics, hospitality, recruitment, and healthcare.

What are the benefits of address verification?

Some benefits of address verification include:

  • Reducing shipping errors and ensuring accurate deliveries.
  • Preventing fraud and identity theft.
  • Complying with legal and regulatory requirements.
  • Enhancing customer trust and satisfaction.
Are there privacy concerns with address verification?

Yes, there can be privacy concerns with address verification, especially if sensitive personal information is collected and stored.

Organizations should have privacy policies in place and adhere to data protection regulations when handling address data.

What happens if an address cannot be verified?

If an address cannot be verified, it may lead to delivery issues or concerns about the accuracy of the provided information.

Is address verification always necessary?

Address verification is not always necessary, however, it is typically used when the accuracy and validity of an address are critical, such as in shipping and financial transactions.

The necessity depends on the specific use case and industry.

What is geocoding?

Geocoding is the process of transforming human-readable addresses or location descriptions into geographical coordinates, typically latitude and longitude, to enable location-based services and mapping.

How does geocoding work?

Geocoding is performed in DQ for Excel by matching the input addresses against a database of known locations, or postal codes and returning the corresponding geographic coordinates to the worksheet.

What are the applications of geocoding?

Geocoding is used in various applications, including mapping and navigation, location-based services, business intelligence, urban planning, and more.

What is reverse geocoding?

Reverse geocoding is the process of converting geographic coordinates (latitude and longitude) into a human-readable address or location description.

Is geocoding always accurate?

The accuracy of geocoding can vary depending on the quality and completeness of the underlying data.

It may not always be 100% accurate, and results can vary based on the service or dataset used.

Are there any privacy concerns with geocoding?

Yes, geocoding can raise privacy concerns, especially when dealing with sensitive or personal location data.

It’s important to handle and store such data responsibly and in compliance with relevant privacy regulations.

Can you batch process (bulk) process records and geocode them?

Yes, You can geocode multiple rows in DQ for Excel, which is useful for handling large datasets efficiently

How much does geocoding cost?

The cost of geocoding services is shown in the DQ Credits pricing.

What are the common geocoding challenges?

Some common challenges in geocoding include handling ambiguous or incomplete addresses, dealing with non-standard location descriptions, and maintaining up-to-date geocoding databases.

For best results, addresses should be verified in advance, or postal codes/zip codes should be correct for geocode lookup purposes.

Can I perform geocoding in my Excel Workbook?

Yes, you may address verify and append geocodes, or use the postcode/zip code and country to return Latitude and Longitude coordinates.

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