My Locations allows you to manage your current location data; from sales performance, lease expiry dates, franchisee contact information, and more. Any custom attributes regarding your store locations can be added, and then uploaded locations allow you to quickly find sites by their unique store IDs, categorize locations, show high performing sites, and their associated trade areas.
In this User Guide, there are two ways to update your data. Check out in-depth instructions below for updating either via:
- CSV Import; overwriting any existing dataset loaded into your account, or
- On the Fly Updates; updating your location set as the network changes with additions, closures, etc.
1. CSV Imports
If you're uploading your locations in one go, all store data needs to be consolidated into an excel sheet and downloaded to CSV format. Each column header in your excel sheet becomes a component of your location set in PiinPoint:
To upload your locations, there are a few required fields you'll need to include, and then some optional fields for other data you'd like to associate. Start by gathering the following information in an excel sheet:
- Location Names/Unique IDs: This is what we use to distinguish your different locations from one another. Whether it's "Queen and Spadina", "Toronto Location", or "1", as long as each name is unique, we can work with it.
- Address: This must be a latitude and longitude coordinate. If your data does not have coordinates, contact your Customer Success Manager for assistance in geocoding.
- Category: Assign a certain category of to each of your locations, e.g. In Development, Closed, etc. This allows you to toggle different categories of locations ON/OFF on the map view. If you only have one category of store, that's okay too! Just make sure to include a column for it.
- Performance Metric: This may be last year's total / average sales, the number of customers, annual growth rates, etc. This metric will be used to rank each store location from top to bottom and shown on each location's pop-up:
You can include any other metadata in your columns that you'd like to show:
- Secondary Performance Metric: Any other column in your spreadsheet can be used as a secondary performance metric. This might be YTD sales, % change in sales, lease end dates, etc.:
- Custom Attributes: Any other information can be brought into the table, such as store hours, phone number, district manager, franchise, the number of tables/seats, landlord, square footage, lease ends dates, etc.
Including sales data in your location set? Awesome! Just make sure that you include a duplicated value in your spreadsheet of your sales in plain text form, with the column header showing your timestamp by YYYY-MM-DD.
Uploading your Data to PiinPoint
- Export your location set from the spreadsheet to a CSV file
- Go to app.piinpoint.com/current-locations/upload
- Drag and drop or click to upload your file into the upload box:
Matching your Location Set Fields
Each column from your spreadsheet will be shown as a field to match. Simply match the fields to the relevant headers based on the previews provided in the upload state. Start with your Required Fields and then just fill the rest in as Custom Fields.
1. Address - If you don't have an address field, just pick some other value that has a geographic component e.g. City:
2. Unique ID - This will be how you query your locations in PiinPoint, label them on the map, and show them in Reports:
3. Category - This will be how you distinguish different type locations by their symbology on the map:
4. Sales - This will be the value we show on each Location pop-up and in Report:
5. Secondary Performance - This is your chance to set something else up as the other item on each location pop-up. Pick any field you'd like to see quickly when querying your locations, like Lease End date:
👉Keep in Mind
In order to continue to next page of assigning logos, you must have matched headers for all the required fields.
Once all these fields have been properly matched, select the option to "set all remaining to Custom Field" at the bottom of the page:
Then click Continue to upload your own unique logos for each Category type.
Regularly Overwriting your Locations 📅
Once your spreadsheet is assembled, you're ready to upload it to PiinPoint! To keep your PiinPoint locations regularly updated, share your spreadsheet with PiinPoint either via Google Drive or set up an SFTP so that any changes you make in your master location list is automatically updated in PiinPoint. Or, manage your location updates on the fly as outlined below.