Table: dim_promo_code

Type: Dimension Columns: 10

Description

Information about registration fee promo discount codes. The data grain is promo codes at the business level.

Columns

Column Name Type Description
promo_code_id string

Unique identifier for the promo_code

promo_code_name string

User friendly name for the promo_code (currently the same as promo_code)

promo_code string

The code users input to get the registration fee discount

promo_code_type string

Indicates whether the promo code's value is a flat rate (e.g., a dollar amount) or a percentage off; enumerated: 'Flat' or 'Percentage'

promo_code_value double

The value of the promo code discount which is either in dollars or percent corresponding to promo_code_type

promo_code_start_at timestamp[ns]

The start date time for which the promo code is valid

promo_code_end_at timestamp[ns]

The end date time for which the promo code is valid

business_id string

Unique identifier for the business

data_current_as_of_utc timestamp[ns] No description provided.
source_type string No description provided.