In this tutorial, you will learn how to set up a data export. Each export si defined in the export object.
...
| Name | Title | Data type |
|---|---|---|
customer_id | Customer ID | integer |
neighborhood_code | Neighborhood code | string |
city | Customer's city | string |
address | Customer's address | string |
sex | Customer's sex | string |
age_group | Customer's age group | string |
lat | Address latitude | latitude |
lng | Address longitude | longitude |
...
| Code Block | ||
|---|---|---|
| ||
... "mapOptions": { "center": { "lat": 49.203, "lng": 16.606 }, "zoom": 12, "tileLayer": "mapbox" }, "exports": [ { "export": "/rest/projects/$projectId/md/exports?name=customers_export" } ] }, "accessInfo": { ... |
Before we perform the export, we have to apply the required filter first.
Applied histogram filter on the transaction_size property
Also, don't forget to that the map window should contain all available areas.
The export is available after clicking the Menu button in the top left corner (
), and selecting Export.
Select Transactions export and hit Export.
The selected columns, as well as metric results will be present in the transactions_export.csv file. You can see that the metric results do not hold much informational value, because the metrics are not computable for each transaction (e.g. turnover value of one transaction equals to the transaction_value property).
Stores export
This is the stores dataset we've added in the previous tutorial.
| Identifier | Title | Data type |
|---|---|---|
| Store ID | integer |
address | Store address | string |
store_type | Store type | string |
| Opening hours | string |
monthly_rent | Monthly rent | integer |
contact | Contact email | string |
link | Store web link | string |
parking | Designated parking lot | string |
employees | Number of employees | integer |
lat | Store's latitude | latitude |
lng | Store's longitude | longitude |
...
| Code Block | ||
|---|---|---|
| ||
... "mapOptions": { "center": { "lat": 49.203, "lng": 16.606 }, "zoom": 12, "tileLayer": "mapbox" }, "exports": [ { "export": "/rest/projects/$projectId/md/exports?name=customers_export" }, { "export": "/rest/projects/$projectId/md/exports?name=stores_export" } ] }, "accessInfo": { ... |
Push the object using pushProject. Then repeat the export process, but select Stores export and hit Export.
...