How about targeting your Salesforce Marketing Cloud subscribers by zip code? All it takes is a zip code data and a query. There’s a few bits and pieces in the SFMC documentation about it (you’ll need to scroll down to the Geo-Targeting section). I thought it would be helpful to see a use-case. This example calculates the closest store for each subscriber.
- A subscriber data extension that includes a zip code column
- A store data extension that includes a zip code column
- A zip code data extension that includes X, Y, and Z-axis columns
- A query that writes to a new data extension
Target Data Extension
This query pulls it all together. The round function and case statements do the dirty work of the calculations between the two zip codes. The ranking and partition part picks out the closest store per subscriber.