Updating the Market Definitions
Note: If multiple users edit simultaneously, the last save will override other unsaved changes. Coordinate with your team to avoid conflicts.
To make minor edits:
- You can edit content directly by clicking any cell
- Click "Add Row" to create a new entry
- You can delete markets (it will also delete the isochrone)
- Click "Save Changes" to persist all edits to the CSV file
To make bulk edits:
- Download the csv for proper formatting
- Uploaded an updated .csv (must match format, don't change the headers)
Active Markets
Reflexer and Retail Location counts are aggregated from the tables on data tab
| Market | Cities | State(s) | Coordinates | Retailers | Reflexers |
|---|
Market Isochrones
Zips, cities, and counts are all tied to the isochrone boundary.
| Market | Zips | Cities | Retailers | Reflexers | Origin | Boundary | GeoJSON | Timestamp |
|---|
Updating the User Tables
Note: If multiple users edit simultaneously, the last save will override previous changes. Coordinate with your team to avoid conflicts.
To reimport bulk updated data:
- Use the Metabase link to download as formatted csv
- Use the Upload .csv to import new data
Active Reflexer Locations
Metabase: https://metabase.reflex.careers/question/6372-active-reflexer-locations-logged-in-within-last-year
Filters are applied, view the query for active filters
| Zip Code | Count | Lat | Lon | City | State |
|---|
Active Retail Locations
Metabase: https://metabase.reflex.careers/question/6379-active-retailer-location
| ZIP Code | Count | Lat | Lon | City | State |
|---|