Take a look at Cuebiq’s COVID-19 Mobility Insights – see how mobility patterns are changing across the United States daily.
How-to: Upload a Store List - GeoJSON CSV
Cuebiq Support Team
  • Updated
Follow

Table of Contents

This article covers how to upload a store list (GeoJSON CSV). Below you will find step by step instructions to accomplish this.

Instructions to Upload a Custom Store List

1. After logging into the Clara's Measurement Platform, you will find yourself on the home page. On the left side of the page, you will find a tab labeled "My Stores". Please click on this to proceed. 

Screen_Shot_2020-05-04_at_4.10.03_PM.png

2. On the screen you should find "Your Geosets". To create a new Geoset, click on the button in the upper right corner labeled "Add Geoset". This will take you to the creation pop-up menu where you can upload a list of stores. 

Screen_Shot_2020-05-04_at_4.27.25_PM.png

 

3. Now that the menu is open, you can start filling in all the information required:

  • Geoset Name: This is the name that you will use to refer to this Geoset. This can be whatever is most useful to help identify this geoset.
  • Upload File: Please refer to the last section on this page to find instructions on proper formatting and instructions to upload your places list.
  • *Dwell Time: This is the minimum and maximum amount of minutes that a device needs to be seen in a location in order to attribute the device to a visit. For example, the default values are 10 and 150. This means a device must be seen in a specific location from any amount of time from 10-150 minutes in order to be measured.
  • *POI Radius: Distance (in meters) measured around the central latitude and longitude of the location that a device is allowed to be see in. For example, if the radius selected is 30 meters, then if a device is seen in that radius for the specified dwell time, we can safely say that device was seen in that POI.
  • *Opening Times: Here you can select the opening and closing hours for the POI's.

*Note: These parameters won’t be considered by Audience Builder’s targeting engine. Therefore, changes to the fields below will be valid for Measurement purposes only.

 

Uploading Places File

Before you upload your Places file, we recommend you download our CSV templates in order to see how the POI list should be formatted. When uploading a CSV please ensure that the file has the necessary headers included below.

Screen_Shot_2020-05-04_at_5.21.28_PM.png

CSV Mandatory Requirements

  • Placename: Name of the store location
  • Placeaddress: This should be in the format of Street Address, City, State, Zipcode
  • Country: Country where the POI is located, the two letter code representing the country
  • Geometry: a string in GeoJSON format; (if not present it is derived from the address)
placename placeaddress country geometry
Yeshua's Yoga 130 Lancaster Crescent, St. Albert CA {"type":"Point","coordinates":[-113.650857,53.642035]}
Snap Fitness 220 Sandy Springs Circle, Atlanta US {"type":"Point","coordinates":[-84.383845,33.925232]}
Cross Fit Provo 1106 South State Street # 11, Provo US {"type":"Point","coordinates":[-111.639585,40.219409]}
The Quarry Swimming and Fitness Centre Priory Road, Shrewsbury GB {"type":"Point","coordinates":[-2.760318,52.70883]}
FTA Gym,F- 1900 East Howard Lane #3, Pflugerville US {"type":"Point","coordinates":[-97.633381,30.40208]}
zClub 100 Factory Street, Nashua US {"type":"Polygon","coordinates":[[ [ -71.47052764892578, 42.760209737020645 ], [ -71.47010922431946, 42.76024715336716 ], [ -71.47013872861862, 42.76038303359335 ], [ -71.47057056427002, 42.760337740217714 ], [ -71.47052764892578, 42.760209737020645 ] ]]}
The Good Life Studio Nine Music Square South #95, Nashville US {"type":"Point","coordinates":[-86.79314,36.147105]}
Better Bodies Gym Nene Enterprise Centre, Freehold Street, Northampton GB {"type":"Point","coordinates":[-0.896301,52.250635]}
New Gym Dennstedt Place, El Cajon US {"type":"Polygon","coordinates":[[ [ -116.98532804846764, 32.78283113952347 ], [ -116.98535218834877, 32.782667651104106 ], [ -116.98516845703126, 32.78260112814404 ], [ -116.9849605858326, 32.78271162388094 ], [ -116.98497131466866, 32.7828367770498 ], [ -116.98510140180588, 32.782946144990184 ], [ -116.98532804846764, 32.78283113952347 ] ]]}
Yoga Haven Studio 1130 North Main Street, Algonquin US {"type":"Point","coordinates":[-88.287367,42.176321]}

 

Optional Columns

  • placeOpeningDate: a date in format YYYY-mm-dd (e.g., 2020-01-10); if not present, we consider the place with unknown opening date. 
  • placeClosingDate: a date in format YYYY-mm-dd (e.g., 2020-01-10); if not present, we consider the place as currently active. 
  • placeDwellTimeMin and placeDwellTimeMax: the dwell time information is added in the SMS frontend through a form as a default for all the places in the CSV file; if the information is known for some of the places, then it can be set directly in the file
  • placeRadiusMeters: the radius information is added in the SMS frontend through a form as a default for all the places in the CSV file; if the information is known for some of the places, then it can be set directly in the file

4. Press start import and then wait until your geoset has been fully uploaded before you use it in the Measurement platform or the Audience Builder. 

The application will perform a validation for each POI, and if one or more POIs have some kind of problem (e.g., there is no geometry and the address is invalid) then they are removed from the final geoset, while all the others are correctly loaded.  The SMS will give you a report of the failed rows of the CSV file in the popup window where the final number of correct/failed POIs are written. Example below:

Screen_Shot_2020-11-17_at_10.06.46_AM.png

Step-by-Step Video

For a step by step video, please see below:

Related articles

Comments

0 comments

Please sign in to leave a comment.