Metadata attributes

Campaign Code

CORE,RETAIL

X

dbo.CAMPAIGN

(Required) Campaign Code

N

String

100

CampaignCode

Campaign Name

CORE,RETAIL

X

dbo.CAMPAIGN

Campaign Name

N

String

500

CampaignName

Campaign Desc

CORE,RETAIL

X

dbo.CAMPAIGN

Campaign Description

N

String

1000

CampaignDesc

Campaign Start Date

CORE,RETAIL

X

dbo.CAMPAIGN

Campaign End Date

CORE,RETAIL

X

dbo.CAMPAIGN

Promo Code

RETAIL

PROMOTION TABLE

Promo Code

N

String

100

PromoCode

Promo Name

RETAIL

PROMOTION TABLE

Promo Name

N

String

500

PromoName

Promo Start Date

RETAIL

PROMOTION TABLE

Promo Start Date

N

DateTime

PromoStartDate

Promo End Date

RETAIL

PROMOTION TABLE

Promo End Date

N

DateTime

PromoEndDate

Offer Code 1

RETAIL

X

dbo.OFFER

Offer Code 1

N

String

100

OfferCode1

Offer Value 1

RETAIL

X

dbo.OFFER

Offer Value 1

N

String

500

OfferValue1

Offer Type 1

RETAIL

X

dbo.OFFER

Offer Type 1

N

String

500

OfferType1

Offer Code 2

RETAIL

X

dbo.OFFER

Offer Code 2

N

String

100

OfferCode2

Offer Value 2

RETAIL

X

dbo.OFFER

Offer Value 2

N

String

500

OfferValue2

Offer Type 2

RETAIL

X

dbo.OFFER

Offer Type 2

N

String

500

OfferType2

Offer Code 3

RETAIL

X

dbo.OFFER

Offer Code 3

N

String

100

OfferCode3

Offer Value 3

RETAIL

X

dbo.OFFER

Offer Value 3

N

String

500

OfferValue3

Offer Type 3

RETAIL

X

dbo.OFFER

Offer Type 3

N

String

500

OfferType3

Coupon Group Name 1

RETAIL

COUPON TABLE

Coupon Group Name 1

N

String

100

CouponGroupName1

Coupon Type 1

RETAIL

COUPON TABLE

Coupon Type 1

N

String

15

CouponType1

Coupon Group Name 2

RETAIL

COUPON TABLE

Coupon Group Name 2

N

String

100

CouponGroupName2

Coupon Type 2

RETAIL

COUPON TABLE

Coupon Type 2

N

String

15

CouponType2

Coupon Group Name 3

RETAIL

COUPON TABLE

Coupon Group Name 3

N

String

100

CouponGroupName3

Coupon Type 3

RETAIL

COUPON TABLE

Coupon Type 3

N

String

15

CouponType3

Drop Date

CORE,RETAIL

X

dbo.CAMPAIGN_EVENT

Drop Date

Field name: drop_date

N

DateTime

DropDate

Is Control

CORE,RETAIL

X

dbo.CAMPAIGN_EVENT

Is Control

Field name: control_group_ind

Y

String

1

IsControl

UTM Source

CORE,RETAIL

CELL

UTM Source

N

String

1000

UTM Content

CORE,RETAIL

CELL

UTM Content

N

String

1000

UTM Medium

CORE,RETAIL

CELL

UTM Medium

N

String

1000

UTM Campaign

CORE,RETAIL

CELL

UTM Campaign

N

String

1000

UTM Term

CORE,RETAIL

CELL

UTM Term

N

String

1000

Subject Line

CORE,RETAIL

Subject Line

N

String

100

Pre Header

CORE,RETAIL

Pre Header

N

String

100

Message Intent

CORE,RETAIL

Message Intent

Y

String

100