objid | campaign | objid | Campaign internal record number | 3 (UNIQUE) |
owner_objid | user | objid | User internal record number | |
price_objid | price_prog | objid | Price_prog internal record number | |
currency_objid | currency | objid | Currency internal record number | |
name | campaign | name | Name of the campaign | |
cam_type | campaign | cam_type | Type of the campaign | |
status | campaign | status | Status of the campaign | |
start_date | campaign | start_date | Starting date of the campaign | |
end_date | campaign | end_date | Ending date of the campaign | |
audience | campaign | audience | Target audience of the campaign | |
description | campaign | description | description of the campaign | |
products | campaign | products | Product families addressed by the campaign | |
objective | campaign | objective | What the campaign is intended to achieve | |
cost | campaign | cost | Amount spent on campaign | |
revenue_goal | campaign | revenue_goal | Goal in currency of revenue generated from the campaign | |
budget_amt | campaign | budget_amt | Goal in currency for the cost of the campaign | |
opps_goal | campaign | opps_goal | Goal in number of opportunities generated from the campaign | |
won_goal | campaign | won_goal | Goal in number of deals won from the campaign | |
currency_name | currency | name | Currency in which campaign is denominated | |
owner_name | user | login_name | Login name of the owner of the campaign | |
price_name | price_prog | name | Price program used for the campaign | |
sub_scale | currency | sub_scale | Gives the decimal scale of the sub unit in which the currency will be calculated: e.g., US dollar has a sub unit (cent) whose scale=2; Italian lira has no sub unit, its sub unit scale=0 | |