How to orient your customers to the nearest store, using Email Studio & Content Builder
Sézane,1RUE SAINT FIACRE 75002 PARIS
Have you ever been to your favorite store, just to realize once there that it had moved? Well, very often, it moves but only to remain in the same area…However, you could not guess that since no communication on the new address was shared via email, SMS or even social media.
We will see here how to take care of your customers by giving them the right information and guaranteeing an enjoyable shopping experience.
First, we can communicate the address of the store closest to their home by email. To do this we will need:
1- Data extension sendable with customer information (email, first name, address)
1 –Data extension not sendable with store codes and their addresses.
And also, the basics of the LOOKUP function of the AMPscript code.
A-Our sendable data extension for sending emails to the customer
B-Our non-sendable data extension with stores attributes
Here the corresponding code that will be displayed in your email sending with the store address closest to the customer.
Dear %% First Name %%
Your return request has been taken into account.
Thank you for returning your item in its original condition to the nearest store:
%%[
Var @StoreAddress, @ Address1
Set @ Address1 = [Address1]
Set @StoreAddress = Lookup( “Data_ExtensionB”, “ City ”, “Address2”, @ Address1)
]%%
%%=v(@StoreAddress)=%%
See you soon for an upcoming article!
Live with pleasure!
Cornelia
