Macro
This data type supports all kinds of macroeconomic data like unemployment rate, consumer confidence, consumer price index, interest rates, and currency exchange.
Macroeconomic indicators often affect your business. This can be as
simple as the fact that the unemployment rate might make people more or less
willing to invest in a new car.
The Macro Data file should contain the following column headers:
- Country (string): A three-letter country code as specified in the ISO 3166 standard, indicating the country where the indicator were collected.
- Region (string): The region within the country where the indicators were collected. The format for the region may vary depending on the specific region being represented, but it should adhere to the ISO 3166 standard.
- Grouping (string): An optional field for grouping the indicator data based on additional criteria, such as product categories or sales territories.
- Date (date): The date when the indicators were collected, in the format of YYYY-MM-DD (ISO 8601).
- Indicator (string): The name of the macroeconomic indicator being reported (e.g. “Unemployment Rate”, “Consumer Confidence Index”, “Interest Rate”).
- Value (float): The value of the macroeconomic indicator being reported at the given date and for the given region and country.
The data can be uploaded in both wide and long format, depending on your needs.
Long format:
| Country | Region | Grouping | Date | Indicator | Value |
|---|---|---|---|---|---|
| SWE | all | all | 2018-01-07 | Unemployment | 0.2123493 |
| SWE | all | all | 2018-01-07 | Happiness | 0.8387580 |
| SWE | all | all | 2018-01-07 | CCI | 108.1410075 |
| SWE | all | all | 2018-01-14 | Unemployment | 0.2136844 |
| SWE | all | all | 2018-01-14 | Happiness | 0.8374786 |
| SWE | all | all | 2018-01-14 | CCI | 105.3537534 |
| Wide format: |
| Country | SWE | SWE | SWE |
|---|---|---|---|
| Region | all | all | all |
| Indicator | Unemployment | Happiness | CCI |
| Grouping | all | all | all |
| 2018-01-08 | 0.2123492784 | 0.8387580455 | 108.1410075 |
| 2018-01-15 | 0.2136843525 | 0.8374786345 | 105.3537534 |
| 2018-01-22 | 0.2128232805 | 0.8154242335 | 107.6426854 |
| 2018-01-29 | 0.2059345445 | 0.8425253371 | 106.477429 |
| 2018-02-05 | 0.2029192976 | 0.8324368096 | 101.2852837 |
| 2018-02-12 | 0.2041849944 | 0.8752431161 | 109.793951 |