Upload Geography

You can upload your own geography layer into the Geoscape ® system , i.e., zones, such as Census Regions, self-defined sales territories, marketing regions, etc., and both visualize them on maps and aggregate data to them for display and reporting.

Regions can be defined based on any geography level for which you are currently licensed.  The Upload Geography 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:

The  file needs to contain the following:

1. Geography Identifier - This the geography by which your regions will be defined, such as the two letter state code, or ZIP Codes, or County FIPS as explained in table above.
2. Region ID - This column that identifies how to group together your geographies which together  create regions. This value may be numeric or text.
3. Region Name - Label for Region IDs. (optional)
• Example

  

Upload Data

1. Click Marketscape tab.

2. On the submenu click Upload Data icon and select Upload Geography  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 select the type of geography data you're uploading.

9. For Region ID Column drop down list select the column in your file that contains the region IDs that unite your geographies.

10. For Region Name Column drop down list select the column in your file that contains the value you would want to see in reports and as labels.

11. Click Next.

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

13. Click Next.  The File Summary displays.

14. For the Project Name enter the name you want to see for this custom geography in the system.

15. Verify mapping is correct and then click Process.