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 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.