Schema: Data Warehouse - Conversions

Order

Name

Description

Type

1

type

The report type (e.g., platform_data)

Note: this static column is only visible in Snowflake integrations

str

2

report

The name of the report

Note: this static column is only visible in Snowflake integrations

str

3

advertiser

Rockerbox Account ID

Note: this static column is only visible in Snowflake integrations

str

4

identifier

conversion segment id

Note: this static column is only visible in Snowflake integrations

int

5

action

Name of the conversion event

str

6

conversion_hash_id

Identifier per unique conversion (this is a hash of the conversion_key value)

str

7

date

Date when the action occurred

date

8

timestamp_conv

Timestamp of when the conversion occurred (ISO 8601 format in UTC)

timestamp

9

hash_ip_conv

The IP address (SHA256 hashed) of the users device when they converted

str

10

conversion_key

An identifier used to denote a unique conversion event (this is typically your provided Order ID)

str

11

order_id

str

12

revenue

The revenue associated with conversion (e.g. order value)

float

13

new_to_file

At the time of conversion, if Rockerbox has seen that user make a Purchase before, then new_to_file = 0. Otherwise, they are considered a new customer and new_to_file = 1.

int

14

base_id

Primary User ID

str

15

uid

Rockerbox User ID cookie

str

16

external_id

The user ID sent to Rockerbox from a third party (e.g. Shopify Customer ID)

str

17

email

The email address associated with the user

str

18

phone_number

The phone number associated with the user

str

19

user_agent_conv

User agent string associated with the user

str

20

additional_attributes

Custom conversion parameters

dict

21

rb_sync_id

Identifier used by Rockerbox to sync dataset to your warehouse

int

22

updated_at

Time the cache record was updated most recently

timestamp


How did we do?