Importing Customer Data Summarized by Standard Geography

You can import customer data summarized or aggregated by a level of standard geography. You can also create maps and reports based on your customer data. This will work with the codes for any level of standard geography.

Inputs Required

Note: While geographic codes can represent any geographic level, the data in these files will only roll up to completely nested higher geographies. The entire geographic code must be in a single field, with leading zeros included where applicable. The codes must also be unique. If the same code exists multiple times, the data will not be aggregated automatically. 

__________________________________________________________________________________________________________________

1. In the side panel, click Import Data > Customers > Geographic Codes.

mceclip0.png

2. Drag and drop your customer file into the upload box, or click the Add mceclip1.pngbutton to browse for your file. 

mceclip2.png

Once a file has been placed in the box, the Add mceclip1.png button will change to the Upload mceclip3.png button. 

3. Click the Upload mceclip3.png button.

mceclip4.png

4. The File Preview window will display and you can adjust your file properties as required.

mceclip5.png

i. In the Dataset Name box, change the default name if required. This is the name that will appear on all dashboards an maps.

ii. In the Dataset Description box, give your file a description, where you can add any additional details to further define your customer list.

iii. In the Tags box, enter any keywords you wish. These are used for better searching. 

iv. Turn the Available in all Workspaces on or off as required.

  • ON means that this file is available in every workspaces
  • OFF means that this file is only available in the current workspace 

v. Set the Start Date and End Date as required. They act as tags referring to the vintage of your data. They can also be used to specify whether customer records become active and inactive.

vi. Click Next Step

5. Specify your Import Settings, in the following window. 

mceclip6.png

i. In the Geographic Level list, click the level of geography used to summarize your data.

ii. In the Geographic Code Field list, click the field that contains the codes. 

Canadian Workspaces                 American Workspaces
mceclip7.png    mceclip8.png

For the Record Definitions section, consider how your data is aggregated.

iii. Select the appropriate Base Variable 

iv. Choose whether you would like to use Record Count or Record Weight

  • Record Count should be used if you do not have an aggregate customer count
  • Record Weight should be used if you have an aggregated customer count

Note: If you choose Record Weight, you must also select the filed that contains the number of customers in the geography. 

6. Click Next Step

In the following window, you will choose the Additional Fields that contain the summarized data that you are importing. Things like sales, frequency, store number, tenure, or type, can be included here. Selecting the data type for these additional fields is also important.

Canadian Workspacesmceclip9.png

American Workspaces

mceclip10.png

 7. Set any field(s) for import by turning the switch ON.

8. In the drop-down list, specify the data type.

mceclip11.png

9. Click Next Step.

A message displays indicating that you are finished. You will also receive a notification when the file becomes available for use.

mceclip12.png

10. Navigate to the Results page to access your imported customer data.

Once you have imported your data, you can utilize the following functionalities:

Ranking Areas - Customer Report 
View Customers on a Map
Create a Thematic Map of Trade Areas
Distance Decays

The diagrams below illustrate geographic hierarchies. 

mceclip0.png 

mceclip1.png

Please see Canadian Geography or US Geography for more information. 

Powered by Zendesk