Align your data sets and attain a single customer view
UDPRN address validation solution
Loqate’s UDPRN solution removes the complex need for address data engineering when matching data within your systems. This allows for speedier data matching and analysis while providing you with much-needed data integrity.
Improve delivery rates
Better match to geocodes, remove duplicates and plan routes efficiently. Also, improve delivery to rural areas, vanity and business addresses.
Identify fraud
Pinpoint households that abuse promotional schemes such as bonus abuse in gaming or discount codes for online retail.
Data consolidation and merging
Fix your existing customer data and merge with new data sets by appending UDPRNs and create an accurate view of your customer base.
Optimise marketing communications
Improve the ROI of your marketing communications by reducing duplicate mailings and generate more accurate insights from your data.
Enhanced data migration
Support migration projects even with multiple legacy systems without significant disruption or cost.
Increase reporting accuracy
Improve reporting accuracy through identification of duplicate customers in your database as well as improved household analytics such as spending per household and household RFV.
What is a UDPRN?
UDPRNs (Unique Delivery Point Reference Numbers) are eight-digit unique numerical codes for delivery points on the Postcode Address File (PAF) that identify specific premises. UDPRNs are assigned to premises until it is deleted or destroyed - at this point, the UDPRN is deleted from the PAF, ensuring that each code in the data set is unique. UDPRNs maintain long-term address records and consistent data across multiple data sets.
UDPRN data will save precious time, money, and resources as it helps to align your data and ensure that your deliveries are always on schedule, and your customers are nothing short of delighted with the service they receive.
How does the process work?
In this example data set, a customer’s address is held three times in differing formats ( this could be on one system or across multiple), and therefore, the matching rules would need to have a degree of tolerance that would create mismatches.
The result is that this customer is not categorised correctly, and they miss out on communications or deliveries first time due to this mismatched data.
Loqate can standardise the data and add the UDPRN to create a more accurate customer view.
After adding the UDPRNs, the different address formats are recognised as the same address, meaning that the customer will receive message first time.
Before UDPRN applied
|
Customer ID |
Address 1 |
Address 2 |
Town |
County |
Postcode |
Source |
Order Value |
Segment Strategy |
|
1 |
flat 3 |
laurel court |
harrogate |
|
HG1 XXX |
Legacy |
£100 |
Build |
|
2 |
flat 3 laurel court |
2 swarcliffe road |
harrogate |
n yorks |
HG1 4NW |
Online Order |
£1000 |
Build |
|
3 |
ft 3, 2 |
swarcliffe road |
harrogate |
north yorks |
hg14nw |
Shop captured |
£10 |
Harvest |
After UDPRN applied
|
Address_Line_1 |
Address_Line_2 |
Address_Line_3 |
Address_Line_4 |
Town |
County |
Postcode |
UDPRN |
|
flat 3 laurel court |
1 swarcliffe road |
|
|
HARROGATE |
North Yorkshire |
HG1 4NW |
111190 |
|
flat 3 laurel court |
2 swarcliffe road |
|
|
HARROGATE |
North Yorkshire |
HG1 4NW |
111190 |
|
flat 3 laurel court |
3 swarcliffe road |
|
|
HARROGATE |
North Yorkshire |
HG1 4NW |
111190 |