campaign
Tracks information related to marketing campaigns, including the campaign's name, target audience, start and end dates, and overall goals.
Columns
| Name | Type | References | Description |
| audience | String | The target audience for the campaign. | |
| autoname | Boolean | Indicates whether the campaign is automatically named. | |
| basecost | Decimal | The base cost associated with running the campaign. | |
| campaignid | String | The unique identifier assigned to the campaign. | |
| category | String | The category under which the campaign falls. | |
| convcostpercustomer | Decimal | The conversion cost per acquired customer. | |
| conversions | Integer | The number of successful conversions attributed to the campaign. | |
| cost | Decimal | The total cost incurred for running the campaign. | |
| costpercustomer | Decimal | The cost of acquiring a single customer through the campaign. | |
| customform | String | The custom form used for entering campaign details. | |
| enddate | Date | The date when the campaign is scheduled to end. | |
| eventnumber | String | The reference number associated with the campaign event. | |
| expectedrevenue | Decimal | The projected revenue expected from the campaign. | |
| externalid | String | A unique external identifier for referencing the campaign in external systems. | |
| family | String | The campaign family or grouping it belongs to. | |
| isinactive | Boolean | Indicates whether the campaign is currently inactive. | |
| item | String | The item associated with the campaign, such as a product or service. | |
| keyword | String | The main keyword associated with the campaign for search tracking. | |
| leadsgenerated | Integer | The total number of leads generated by the campaign. | |
| message | String | The main message or slogan used in the campaign. | |
| offer | String | The promotional offer linked to the campaign. | |
| owner | String | The individual or team responsible for managing the campaign. | |
| profit | Decimal | The total profit generated from the campaign after deducting costs. | |
| promotioncode | String | The promotion code associated with the campaign. | |
| roi | String | The return on investment (ROI) percentage for the campaign. | |
| searchengine | String | The search engine associated with the campaign, such as Google or Bing. | |
| startdate | Date | The date when the campaign officially begins. | |
| title | String | The title or name of the campaign. | |
| totalrevenue | Decimal | The total revenue generated from the campaign. | |
| uniquevisitors | Integer | The number of unique visitors who interacted with the campaign. | |
| url | String | The website or landing page URL associated with the campaign. | |
| vertical | String | The industry vertical targeted by the campaign, such as retail or healthcare. |