Campaign dimension table
bi_dimcampaign
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | Flag that indicates whether the applied campaign is active. - True: Active campaign. - False: Inactive campaign. - Null: No campaign is applied. | boolean | |
allowgiftcertificates | boolean | ||
allowothers | boolean | ||
alwayson | boolean | ||
appliesto | integer | ||
autoapply | Flag that indicates whether the campaign has to be auto-applied to the customer. - True: Auto-applied. - False: Not to be auto-applied. | boolean | |
bookingenddate | timestamp without time zone | ||
bookingstartdate | timestamp without time zone | ||
campaigncode | Unique code of the campaign applied on the corresponding invoice item. Note: If there are multiple campaigns applied on the invoice item, only one campaign code is populated here. | varchar ( 4096 ) | |
campaigndesc | Description of the campaign. You can leave this field blank. | varchar ( 4096 ) | |
campaignfilepath | varchar ( 512 ) | ||
campaignid | Flag that indicates whether the corresponding invoice item contains ONLY a manual discount. - True: Discount applied is ONLY a manual discount. | varchar ( 36 ) | |
campaignmessage | varchar ( 16000 ) | ||
campaignname | If applicable, this is the campaign name corresponding to the discount. | varchar ( 512 ) | |
campaignopportunitytype | varchar ( 1024 ) | ||
campaigntype | This flag indicates the type of the campaign. - 1: Email/SMS/Push Notification - 3: Opportunity - 5: Notes campaign | integer | |
campaignwid | unique identifier for the row | bigint | |
cashback | varchar ( 32 ) | ||
cashbackredeemedbyall | boolean | ||
combineoffers | Flag that indicates whether the corresponding campaign can be combined with other offers. - True: Can be combined. - False: Cannot be combined. | boolean | |
discountid | varchar ( 36 ) | ||
enddate | End date that corresponds to the 'Offer is valid for x days' configuration while creating a campaign. | timestamp without time zone | |
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
expirydate | Applicable only for cashback campaigns. This field stores the date for the 'Cashback is valid until' configuration while creating a campaign. | timestamp without time zone | |
expirydays | integer | ||
freeservicecommissioneligible | Flag that indicates whether the discount applied through the corresponding campaign is eligible for free service revenue and commission for employees. | boolean | |
isbroadcast | boolean | ||
launchdate | DO NOT USE - THIS FIELD IS BEING DEPRECATED. | timestamp without time zone | |
maximumamount | numeric | ||
maxredemptiontimesperguest | integer | ||
metadescription | varchar ( 1024 ) | ||
metakeywords | varchar ( 1024 ) | ||
minimumamount | numeric | ||
needotpauthorization | boolean | ||
opportunityowner | varchar ( 36 ) | ||
organizationid | Unique identifier for the organization | varchar ( 36 ) | |
podname | varchar ( 20 ) | ||
programid | varchar ( 36 ) | ||
ruleid | varchar ( 36 ) | ||
scheduledatetime | timestamp without time zone | ||
sendonlyonce | boolean | ||
sendruleid | varchar ( 36 ) | ||
showincatalog | integer | ||
smscampaign | integer | ||
startdate | Start date that corresponds to the 'Offer is valid for x days' configuration while creating a campaign. | timestamp without time zone | |
validitydays | Applicable only for cashback campaigns. This field stores the number of days for the 'Cashback is valid for x days' configuration while creating a campaign. | integer | |
void | boolean | ||
webstorepagetitle | varchar ( 1024 ) | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |