How to Show the Closest Store Location to your Audience

Using Feed, Ad Serving, and Dynamic Variables, you can create ads that show the closest store location to users from a single dynamic ad. For this scenario, we've used Google Sheets to create a feed table, but you can work with any software as long as you can obtain a CSV link.

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.

Import the Feed into Creatopy

1. Head over to the left sidebar and select Feed.
2. Click on Create feed.
3. Click on Import feed.
4. A pop-up window will open, where you can select Sync from URL.
5. Paste the CSV link saved from earlier.
6. Click on Confirm link.
7. From the feed settings window, set the Target ID to Country.
8. Click Import content.
9. Click Apply feed.

Bind the CSV with your Creative

Proceed to bind your creative as needed, but pay close attention to your CTA, and bind it as follows:

1. Select the CTA.
2. Head over to the Properties bar
3. Go to Actions.
4. Turn on On click actions.
5. Click the  Diamond icon next to URL and select Location URL column from your feed.

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.