1. Help Center
  2. Script Building

Applying the Location Rule from a spreadsheet

A summary on when and how to refer to more than 200 Locations in a script

Applying the Location Rule from a spreadsheet makes it easier to set up location personalisation for many lines - this feature enables you to refer up to 10,000 locations in one script. 

Setting up the Location Rule from a spreadsheet

  1. When a script will utilise this feature the text that is entered into Studio should include a single line for the many Locations that the script will mention. We recommend using the default location line:
  2. Proceed to the Rules view and click on the line where your location personalisation should be applied.
  3. Choose “Apply Location Rule from a spreadsheet” from the menu.
  4. You will then be able to upload a spreadsheet and media files. 
  5. Once the files have been uploaded you'll be able to
    • Download a summary of the rule information and media files that have been uploaded
    • Search for specific lines and preview them individually
      longlistpreview
    • Choose a default line from those uploaded via the spreadsheet.
      Use the individual lines preview field to do so. Type in the label of the line you want to set as the default, then star this line

Creating the spreadsheet before uploading?

It's possible to set the condition for when a specific line should play when using this feature either by providing latitude, longitude and radius or a Zip Code.

To see what data you need to populate in a spreadsheet before uploading it, please check below. 

1. The location data in the spreadsheet should reflect the conditions of when the line should play to the user.

2. Column titles marked with * means the data is required

Using Latitude, Longitude and Radius

You should use this template and below describes each column:

  • label * - the label can be a location name, a store name, or any other reference for the script line
  • latitude *
  • longitude *
  • radius - leaving this blank will mean the media file for the location that is closest to the user will play, otherwise the first line in the list where the user's location matches will play. More information on this is available here.
  • media file name * - Studio uses this in order to match the media file with the rule data so take care to ensure it will match the files to be uploaded later. Please include the file extension (i.e. .mp3)

Using Zip Codes

Use this template and below describes each column:

  • label * - as above, the label can be a location name, a store name, or any other reference for the script line
  • zip code * - the line will play to users with this Zip Code
  • media file name * - Studio uses this in order to match the media file with the rule data so take care to ensure it will match the files to be uploaded later. Please include the file extension (i.e. .mp3)

Limitations

When applying the Location Rule from a spreadsheet consider the following limitations:

  • When applying the Location Rule via a spreadsheet you won't be able to use any other rules to determine when the line should play (date/time, weather, etc.)
  • The maximum number of location lines is 15,000.
  • The Grid view won’t show information about the Rules applied and you won't be able to preview individual files.
  • The media uploaded via this mechanism will not appear in the Media Manager - so you won’t be able to use the “play all” feature for this media.

When should I use this feature?

Applying the Location Rule from a spreadsheet is a great way to manage the personalisation line when the number of locations exceeds 200.

However, as due to the limitations listed above, we still recommend using the Location Rule when there are 1-200 locations in the script.

Feature Location Rule applied via Rules Location Rule applied via a spreadsheet
Max number of locations  200 15000
Compatibility with other rules yes no
Possibility to arrange individual media in the Arrange view yes no
Possibility to play any ad version containing a location line in the dynamic player yes yes
'Playing all' function to include location lines yes no