| campaign_no |
varchar(100)
|
utf8mb3_general_ci
|
|
|
| campaignname |
varchar(255)
|
utf8mb3_general_ci
|
|
|
| campaigntype |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| campaignstatus |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| expectedrevenue |
decimal(25,8)
|
|
|
|
| budgetcost |
decimal(25,8)
|
|
|
|
| actualcost |
decimal(25,8)
|
|
|
|
| expectedresponse |
varchar(200)
|
utf8mb3_general_ci
|
|
|
| numsent |
decimal(11,0)
|
|
|
|
| product_id |
int
|
|
|
|
| sponsor |
varchar(255)
|
utf8mb3_general_ci
|
|
|
| targetaudience |
varchar(255)
|
utf8mb3_general_ci
|
|
|
| targetsize |
int
|
|
|
|
| expectedresponsecount |
int
|
|
|
|
| expectedsalescount |
int
|
|
|
|
| expectedroi |
decimal(25,8)
|
|
|
|
| actualresponsecount |
int
|
|
|
|
| actualsalescount |
int
|
|
|
|
| actualroi |
decimal(25,8)
|
|
|
|
| campaignid |
int
|
|
|
Browse foreign values
|
| closingdate |
date
|
|
|
|
| tags |
varchar(1)
|
utf8mb3_general_ci
|
|
|