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.
- An imported customer file containing geographic codes and summarized data
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.
2. Drag and drop your customer file into the upload box, or click the Add button to browse for your file.
Once a file has been placed in the box, the Add button will change to the Upload button.
3. Click the Upload button.
4. The File Preview window will display and you can adjust your file properties as required.
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.
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
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.
7. Set any field(s) for import by turning the switch ON.
8. In the drop-down list, specify the data type.
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.
10. Navigate to the Results page to access your imported customer data.
Once you have imported your data, you can utilize the following functionalities:
The diagrams below illustrate geographic hierarchies.