Upload Data

You can upload your own numeric or non-numeric data into the Geoscape ® system to visually represent it on a map and/or to perform further analysis. Data can be uploaded and mapped for any geography level for which you are currently licensed.  The Upload Data feature can be accessed from all map modules, Marketscape™ Retail Target, and MediaTargete™ as well as MDx Reports-Create Your Own Report.

Prepare Upload File

As of August 20th, 2012 GIS is using 2010 census definitions for block groups and census tracts.

Note - For accurate results the file should  not contain any duplicate geography values.

The upload file needs to have the geography defined in a manner the system will recognize.  The following identifiers for the corresponding geography are required:

Numeric data will be treated as counts, therefore the any aggregation is a simple roll up. Aggregated non-numeric data will represent the dominate item.

Upload Data

1. Click Marketscape tab.

2. On the submenu click Upload Data icon.  The File Processing Wizard displays.

3. Click Browse.  Navigate  to find your file and click Open to return back to File Processing Wizard window.

4. Click Next. After you’ve uploaded the file the File Definition screen displays showing a preview of the file.  For comma delimited files this screen allows you to define the delimiter used. For Excel files this screen allows you to select the sheet that contains the data to upload.

5. If the first row of your file contains column headings, select First Row contains Field Names check box

6. Click Next. Define Import Fields screen displays.

7. For the Geography ID Column  drop down list select the column in your file that contains the geography identifier of the data you want to upload.

8. For the Geography ID Level  drop down list specify the type of geography data you're uploading.

9. For Indicator Column drop down list select the column in your file that contains the first data value that you want to upload.

10. In the Modify Indicator Name text field enter a name by which you want to refer to this data, e.g., Total Customers.  If no value is entered the system will automatically assign the Column Heading as the name.

11. For the Data Type drop down select the corresponding type of data contained in specified column.  Available data types:

    • Count - numeric data that contains no decimals

    • Numeric - numeric data that can contain decimals

    • Text - alphanumeric data

12. For Type of Aggregation select value that correctly defines how system should aggregate values when used in Retail Target or MediaTarget™ analysis.

• Sum - values added based on household weighted proportion

• Text - during aggregation in Retail and Media Target, system will determine dominant

• Weighted Average - is an average in which each quantity to be averaged is assigned a weight

13. If type of aggregation selected is Weighted Avg then a Base Indicator value must be defined.  Click in Base Indicator field.  In the Indicator Tree popup window navigate to select the indicator that should be used as the base.  Select indicator from data tree and click Use as Base.

14. To map additional data contained in file click Upload More Indicators. Repeat steps 9 and 14 until all fields are defined.

15. Click X to eliminate any indicator definitions.

16. Click Next.

17. If there are other users in your company the Share Uploaded Data screen displays.  )Select user(s) to share your uploaded data with (this is optional)

18. Click Next.  The File Summary displays.

19. For the Project Name enter the name you want to see for this data in the system.

20. Verify mapping is correct and then click Process.