How to Show the Closest Store Location to your Audience

Using the Feed Ad Builder, Ad Serving, and Dynamic Variables, you can create ads that show the closest store location to users from a single dynamic ad.

Main benefits

• Deliver the right information to your target audience.
• You will need only one ad to address this scenario.
• Our system will automatically match the closest store based on the user's location and your list of store locations.

Set up your CSV using Google Sheets

1. Create a spreadsheet in Google Sheets.
2. Input the data in your spreadsheet. For this scenario, the following columns are mandatory.
   • Country - Add the Country/Countries where your stores are located.
   • Latitude - The Northern and Southern coordinates of your stores
   • Longitude - The East and West coordinates of your stores.
   • Location URL - the location of your stores (e.g., Google Maps URL¹)
3. Go to File > Share > Publish to web.
4. On the Publish to web window, go to the Link section.
5. Select the sheet you want to be published.
6. Set the spreadsheet as Comma-separated value (CSV).
7. Copy the link and save it for later.

Link the CSV with the Feed Ad Builder

1. Navigate to the left-hand side of the screen and click on Feed.
2. Click Select Feed.
3. Click Create Feed.
4. Select Upload from my URL and paste the CSV link saved from earlier.
5. Click on the SettingsDropdown icon and set the sections as follows:
   • Sync feed data - Every day.
   • List separator type - Comma (default).
   • Target ID - Country.
6. Click Continue.
7. Link your parameters accordingly; additionally, set the CTA button as follows:
   1. Next to Button, click on Add property.
   2. Select URL.
   3. From the dropdown menu, select URL Google².

Set up & Adjust the Ad Tag Code

1. Enable Ad Serving and set it according to your needs.
2. Set a default Dynamic text³.
   1. Click on Set Variable.
   2. Click on thePlus icon.
   3. Select Country.
   4. Type in the name of the country you're using in your CSV.
3. Obtain the Ad Tag code of your design. Choose one of the two
   • Download as XLS. A Spreadsheet is downloaded to your computer where you can copy the Ad Tag.
   • Copy code. Copy the Ad Tag directly from Creatopy.
4. Before uploading the Ad Tag, adjust the macro code as follows:
   • In the "targetID" column, replace {TARGET_ID} with {COUNTRY}.
5. Copy the adjusted code into your Ad Network of choice as a 3rd party tag.

Note¹: You can find the URL of your store in Google Maps as follows: Identify the location of your store > Click Share > Click Copy Link.

Note²: These steps will make the CTA button show the location of the closest store when clicked/tapped.

Note³: The Dynamic Text is used to indicate a default store in case our system can't find the user's location.

Helpful links:
You can find the CSV used in this scenario here for further analysis.

We've used this website to find longitude and latitude coordinates.