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
- Create a spreadsheet in Google Sheets.
- 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¹)
- Go to File > Share > Publish to web.
- On the Publish to web window, go to the Link section.
- Select the sheet you want to be published.
- Set the spreadsheet as Comma-separated value (CSV).
- Copy the link and save it for later.
Link the CSV with the Feed Ad Builder
- Navigate to the left-hand side of the screen and click on Feed.
- Click Select Feed.
- Click Create Feed.
- Select Upload from my URL and paste the CSV link saved from earlier.
- Click on the Settings
Dropdown icon and set the sections as follows:
- Sync feed data - Every day.
- List separator type - Comma (default).
- Target ID - Country.
- Click Continue.
- Link your parameters accordingly; additionally, set the CTA button as follows:
- Next to Button, click on Add property.
- Select URL.
- From the dropdown menu, select URL Google².
Set up & Adjust the Ad Tag Code
- Enable Ad Serving and set it according to your needs.
- Set a default Dynamic text³.
- Click on Set Variable.
- Click on the
Plus icon.
- Select Country.
- Type in the name of the country you're using in your CSV.
- 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.
- Before uploading the Ad Tag, adjust the macro code as follows:
- In the "targetID" column, replace {TARGET_ID} with {COUNTRY}.
- 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.