> For the complete documentation index, see [llms.txt](https://docs.roivenue.com/roivenue-resources/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.roivenue.com/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/heureka/heureka-supported-columns.md).

# Heureka - Supported Columns

Every column the Heureka connector can download.

These are the columns available to a Heureka connector. The recommended template uses a small subset, listed on the [Heureka](/roivenue-resources/roivenue-training/roivenue-app/data/connectors-overview/list-of-connectors/heureka.md) page. The rest can be added to a connector through the Advanced Editor, which stops that connector receiving template updates.

## Dimensions

| Column               | Type     |
| -------------------- | -------- |
| `date`               | DateTime |
| `product_card_id`    | String   |
| `on_bidded_position` | Boolean  |
| `satellite_name`     | String   |
| `click_source`       | String   |
| `shop_item.id`       | String   |
| `shop_item.name`     | String   |
| `portal_category.id` | Int      |

## Metrics

| Column                         | Type    |
| ------------------------------ | ------- |
| `visits.total`                 | Int     |
| `visits.bidded`                | Int     |
| `visits.not_bidded`            | Int     |
| `visits.free`                  | Int     |
| `costs_with_vat.total`         | Decimal |
| `costs_with_vat.bidded`        | Decimal |
| `costs_with_vat.not_bidded`    | Decimal |
| `costs_without_vat.total`      | Decimal |
| `costs_without_vat.bidded`     | Decimal |
| `costs_without_vat.not_bidded` | Decimal |
| `orders.total`                 | Int     |
| `orders.bidded`                | Int     |
| `orders.not_bidded`            | Int     |
| `orders.free`                  | Int     |
| `revenue.total`                | Decimal |
| `revenue.bidded`               | Decimal |
| `revenue.not_bidded`           | Decimal |
| `revenue.free`                 | Decimal |

Visits, orders and revenue each arrive as a total plus a breakdown. `bidded` covers activity from bidded positions, the ones you pay for, `not_bidded` covers positions you did not bid on, and `free` covers activity Heureka did not charge for. Costs come in both VAT variants, and the default template uses the one without VAT.

## Category columns

| Column              | Type   |
| ------------------- | ------ |
| `CATEGORY_NAME`     | String |
| `CATEGORY_FULLNAME` | String |

These two are switched off unless a category country is set on the connector's source parameters, which has to be done in the Advanced Editor. Until then they do not exist on the connector at all rather than arriving empty.