Data Management

Edit Dataset

Datasets are the backbone of any insightful dashboard; without data, there would be nothing for your dashboards to display or for you to analyze. Spotzi Targeting offers users access to diverse datasets while also giving you the option to upload personal datasets into our interface. You then have the option to make your own changes to the values within your datasets or to edit your data in bulk using SQL.

Add Rows/Columns

1. Go to MY DATA, click the OPTIONS button and select VIEW DATASET in the dropdown menu.
2. Click the bottom right corner of your newly opened dataset to add a new row or column.

Delete Rows/Columns

1. Go to MY DATA, click the OPTIONS button and select VIEW DATASET in the dropdown menu.
• Deleting a row: click the arrow button in front of your row and select DELETE THIS ROW from the dropdown menu.
• Deleting a column: Hover your mouse over the table header and click the arrow button. Select DELETE THIS ROW in the dropdown menu.
2. Confirm that you want to delete the row/column.

Edit Map Features

Spotzi’s map editing capabilities allow users to edit a map’s features directly, or to add content such as PDF URLs and images to each feature.

1. Open your map and click the point, line, or polygon you’d like to edit.
2. An infowindow will pop up; click the small data icon to edit the data attached to that feature.
3. A list of all your feature attachments will appear. You can choose to:
1. Edit data fields
2. Add extra fields

Add extra fields

Click the ADD COLUMNS button in the bottom left-hand corner of the menu to add extra fields to a map feature. You can add fields such as:

• Text fields
• Images
• Videos
• Boolean fields (true/false)
• Date/time
• Number fields
• PDFs
• Lookup fields (single/multiple)
• Time of day
• Day of the week
• Month

Change Column Types

Every column within each dataset you import is of a specific type. The column types can be found in the data view of your datasets. Each column can fall into one of these categories:

• String
• Number
• Date
• Boolean

Distinguishing between your column types is important as every type has its own SQL query. Certain column types also have their own limitations when it comes to layer styling — for example, styling your map layer using our range styling requires number columns. To change a column’s type you must do the following:

1. Click the OPTIONS button next to your dataset and select VIEW DATASET from the dropdown menu.
2. Click the arrow next to the data type. A dropdown menu will appear; select the data type you'd like to change your column to.
3. Confirm your changes.

Data management

We’ve done our best to simplify data management within our platform, so Spotzi Targeting allows users to manage all of their geomarketing datasets in one place. Our online geomarketing platform comes with the freedom to duplicate or delete your datasets, as well as to file them using our tagging system.

Duplicate datasets

1. To delete the dataset of a deleted map go to MY DATA and find your dataset. Press its OPTIONS button to ensure that it is not connected to any of your existing maps.
2. A dropdown menu will appear. Click the red DELETE DATASET button to delete your dataset.

Delete datasets in bulk

1. Go to MY DATA and select all of the datasets you want to delete.
2. A menu will appear in the upper left-hand corner. Click the red DELETE DATASETS button to delete all of your selected datasets.

Edit dataset settings

Naming and tags are essential for organization when you’re storing numerous maps and datasets in your Spotzi account. These can be changed in your settings menu.

Go to MY DATA and click the OPTIONS > SETTINGS button on the right side of your map or dataset. You can now edit the following:

• Rename: Click on the name field, edit it, and save your edits by clicking the green SAVE button.
• Description: If you want to add or edit any map/dataset descriptions simply click your description field, make your desired changes, and save your edits by clicking the green SAVE button.
• Tags: Attach keywords to your datasets or maps in order to bring these up in keyword searches. Click the tags field, enter your keywords (separated by a comma) and press enter. Save your keyword edits by clicking the green SAVE button.