SPOTLIGHT - Importing Files

You can import various file types into SPOTLIGHT to create custom areas. Below, you will find step-by-step guides based on your file type.

Importing Addresses to Create Areas
Importing Coordinates to Create Areas
Importing Geographic Codes to Create Areas
Importing Spatial Files to Create Areas

________________________________________________________________________________________________________________ 

Importing Addresses to Create Areas
You can import large location files using address information. Examples of location files include stores, branches and dealers. 

Inputs Required:

  • A location file with address information in CSV format

mceclip0.png

1. From the Reporting page, select the report(s) you want to run by clicking the check mark. To select all the reports in a bundle, click the check mark next to the name of the bundle. If you would only like to select individual components of a bundle, click the check mark next to that page.

mceclip0.png

2. Once you have selected your report(s), click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step. 

mceclip4.png

3. Click Create New Areas.

mceclip6.png

4. In the Select an Area Creation Method section, click Import.

mceclip7.png

5. In the Select Type of File to Upload section, click Batch Locations > Geocode Address.

558B8A03-4213-4352-ACED-8E572EF707A4.GIF

6. In the What type of Areas would you like to create? section, please select one of the following options:

  • Distance
  • Time 

mceclip11.png

7. In the Units list, select the appropriate unit of measurement. This will only appear if you selected Distance in the previous step.

8. In the Type list, click a method of measurement.

  • Distance
    • Linear Distance will create a radius around the location
    • Drive Distance will create an area around the location based on how far a car could drive
  • Time 
    • Drivetime will create a trade area based on an average amount of traffic
    • Drivetime (Heavy Traffic) will create a trade area based on heavy traffic
    • Drivetime (Night) will create a trade area based on low traffic
    • Walking will create a trade area based on an average walking speed

9. In the Sizes box, enter up to three distances, separated by commas. To create bands or donuts, enter two distances separated by a dash (e.g. 5 to 10 miles would be entered as 5-10).

Note: Ensure that there are no spaces between the distances (e.g. 1,3,5).

mceclip12.png

10. In the Minutes box, select the appropriate minute bands separated by commas. This will only appear if you selected Time in the previous step.

mceclip13.png

 11. Click Next.

12. In the Drop files to upload section, you can either click and drag the file(s) or click the Add button.

mceclip14.png

13. Browse to find the list you wish to upload. Once you select the file, the Add button changes to an Upload button. Click the Upload button to proceed.

mceclip15.png

14. In the Properties section, select a column that contains an identifier for each location. This could be a unique ID or the name of the location. This example will use the Name column. (It is recommended to use an identifier column but if you do not have one, you can choose one of your coordinate columns.)

mceclip0.png

15. Click Next.

16. In the Address Information section, specify the fields that contain the Street Address, City, State and ZIP Fields

mceclip1.png 

17. Click Finish.

Depending on the size of the file, this may take some time. Once the import is complete, you will be automatically directed to the next page, where all recently imported locations will be checked off for use.

18. Once you have selected your Trade Area and Benchmark, click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step.

Note: There is a limit of 40 analysis areas per one report, so if you import a list that contains more than 40 addresses, SPOTLIGHT will only take the first 40 in the list.

19. Navigate to the Results page to download your report.

mceclip8.png

________________________________________________________________________________________________________________ 

Importing Coordinates to Create Areas
You can import large location files using coordinates (longitude and latitude). Examples of location files include stores, branches and dealers. 

Inputs Required

  • A location file with coordinates (longitude and latitude) in CSV format

mceclip1.png

1. From the Reporting page, select the report(s) you want to run by clicking the check mark. To select all the reports in a bundle, click the check mark next to the name of the bundle. If you would only like to select individual components of a bundle, click the check mark next to that page. 

mceclip0.png

2. Once you have selected your report(s), click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step. 

mceclip5.png

3. Click Create New Areas.

mceclip6.png

4. In the Select an Area Creation Method section, click Import.

mceclip7.png

5. In the Select Type of File to Upload section, select Batch Locations > Coordinates.

FEBC9D33-0A24-4522-A3C8-567674A7BF51.GIF

6. In the What type of Areas would you like to create? section, please select one of the following options:

  • Distance
  • Time 

mceclip11.png

7. In the Units list, select the appropriate unit of measurement. This will only appear if you selected Distance in the previous step.

8. In the Type list, click a method of measurement.

  • Distance
    • Linear Distance will create a radius around the location
    • Drive Distance will create an area around the location based on how far a car could drive
  • Time 
    • Drivetime will create a trade area based on an average amount of traffic
    • Drivetime (Heavy Traffic) will create a trade area based on heavy traffic
    • Drivetime (Night) will create a trade area based on low traffic
    • Walking will create a trade area based on an average walking speed

9. In the Sizes box, enter up to three distances, separated by commas. To create bands or donuts, enter two distances separated by a dash (e.g. 5 to 10 miles would be entered as 5-10).

Note: Ensure that there are no spaces between the distances and time bands (e.g. 1,3,5).

mceclip12.png

10. In the Minutes box, select the appropriate minute bands, separated by commas. This will only appear if you selected Time in the previous step.

mceclip13.png
11. Click Next.

12. In the Drop files to upload section, you can either click and drag the file(s) or click the Add button.

mceclip14.png

13. Browse to find the list you wish to upload. Once you select the file, the Add button changes to an Upload button. Click the Upload button to proceed.

mceclip15.png

14. In the Properties section, select a column that contains an identifier for each location. This could be a unique ID or the name of the location.

Tip: It is recommended to use an identifier column but if you do not have one, you can choose one of your coordinate columns.

mceclip0.png

15. Click Next.

16. In the Address Information section, specify the Latitude and Longitude Fields.

mceclip17.png

17. Click Finish

Depending on the size of the file, this may take some time. Once the import is complete, you will be automatically directed to the next page, where all recently imported locations will be checked off for use.

18. Once you have selected your Trade Area and Benchmark, click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step.

Note: There is a limit of 40 analysis areas per one report, so if you import a list that contains more than 40 pairs of coordinates, SPOTLIGHT will only account for the first 40 in the list.

19. Navigate to the Results page to download your report.
mceclip9.png

________________________________________________________________________________________________________________

Importing Geographic Codes to Create Areas

You can import large location files using geographic codes. Examples of geographic codes include lists of ZIP Codes that make up a trade area. 

Inputs Required:

  • A location file with geographic codes in CSV format

mceclip2.png1. From the Reporting page, select the report(s) you want to run by clicking the check mark. To select all the reports in a bundle, click the check mark next to the name of the bundle. If you would only like to select individual components of a bundle, click the check mark next to that page.

mceclip0.png

2. Once you have selected your report(s), click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step. 

mceclip6.png

3. Click Create New Areas.

mceclip6.png

4. In the Select an Area Creation Method section, click Import.

mceclip7.png

5. In the Select Type of File to Upload section, select Geography > Geocode Address.

33.GIF

6. In the Drop files to upload section, you can either click and drag a file, or click the Add button. 

mceclip14.png

7. Browse to find the list you wish to upload. Once you select the file, the Add button changes to an Upload button. Click the Upload button to proceed.

mceclip15.png

8. In the Properties section, specify whether your file has One area or More than one area

Tip: You can import a list of geographies that make up more than one area if you have a field that groups the geographies together. If you choose this option, you will be asked to specify that field.

10. In the Properties section, specify How many areas are in your file?

mceclip2.png

9. Type a name for the area that you are creating in the Area Name field. 

mceclip3.png

10. Click Next

11. In the Import Settings section, you will need to specify both the Geographic Level on which your list is based, along with the Geographic Code Field.

mceclip4.png

12. Click Next.

13. You will receive a confirmation message once you have made your selection. If the information is correct, click Finish

You will be notified when your areas have been successfully imported and you will then be automatically directed to the next screen. Your recently imported geographic areas will be selected by default, as will your benchmark.

14. Once you have selected your Trade Area and Benchmark, click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step.

15. Navigate to the Results page to download your report. 
mceclip10.png

_______________________________________________________________________________________________________________

Importing Spatial Files to Create Areas
You can import large locations using spatial files. Examples of spatial files include maps created in a spatial analysis or a Geographic Information Systems (GIS) platform. 

Inputs Required:

  • A spatial file from MapInfo, Esri or Alteryx 

mceclip3.png

Tip: Remember that for both MapInfo Tab files and Esri Shape files, all of the individual component files must be included to properly import the polygons.

Spatial file format components:

MapInfo

Esri

Alteryx

.TAB

.SHP

.YXDB

.DAT

.DBF

 

.ID

.SHX

 

.MAP

.PRJ

 

Note: Spatial files should be projected in WGS84, with SRID 4326 in order to best work with SPOTLIGHT. If you are unfamiliar with this element of your map file, we would recommend to reach out to whoever in your organization created the file(s).

1. From the Reporting page, select the report(s) you want to run by clicking the check mark. To select all the reports in a bundle, click the check mark next to the name of the bundle. If you would only like to select individual components of a bundle, click the check mark next to that page.

mceclip0.png

2. Once you have selected your report(s), click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step. 

mceclip7.png

3. Click Create New Areas.

mceclip6.png

4. In the Select an Area Creation Method section, click Import.

mceclip7.png

5. In the Select Type of File to Upload section, select Geography > Spatial (Polygon).

4.GIF

6. In the Drop files to upload section, you can either click and drag a file, or click the Add button. 

mceclip14.png

7. Browse to find the list you wish to upload. Once you select the file, the Add button changes to an Upload button. Click the Upload button to proceed.

mceclip15.png

8. In the Properties section, specify How many areas are in your file?

mceclip2.png

9. Type a name for the area that you are creating in the Area Name field. 

mceclip3.png

10. Click Next

11. You will receive a confirmation message once you have made your selection. If the information provided is correct, click Finish

You will be notified when your areas have been successfully imported and you will then be automatically directed to the next screen. Your recently imported geographic areas will be selected by default, as will your benchmark.

12. 18. Once you have selected your Trade Area and Benchmark, click the 26AC224B-A825-49B0-80E8-57835463AE84.GIF icon at the top of the page to move to the next step.

13. Navigate to the Results page to download your report. 

mceclip11.png

Powered by Zendesk