searchCampaign
Contains information on search campaigns used in marketing and lead generation.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | The internal system ID used to uniquely identify the search campaign record. | |
| audience | String | The targeted audience segment for the search campaign, such as a customer group or demographic profile. | |
| basecost | Decimal | The foundational cost of running the search campaign before additional variables are applied. | |
| campaignid | String | The unique identifier of the search campaign used for internal tracking or integration purposes. | |
| category | String | The category or classification assigned to the campaign, used to organize and report on campaign types. | |
| convcostpercustomer | Decimal | The cost per customer who made a purchase as a result of the campaign. | |
| conversions | Integer | The number of customers who made a purchase due to the campaign. | |
| cost | Decimal | The total cost incurred for executing the campaign, including all related expenses. | |
| costpercustomer | Decimal | The cost associated with acquiring each new lead or potential customer through the campaign. | |
| enddate | Date | The date when the campaign officially ends or stops generating results. | |
| expectedrevenue | Decimal | The projected income or revenue anticipated from running the campaign. | |
| externalid | String | An optional external reference ID used for integration or reporting outside of NetSuite. | |
| family | String | The campaign family, used to group campaigns under a shared initiative or strategic goal. | |
| isdefaultleadsource | Boolean | If the value is 'true', this campaign is designated as the default lead source for incoming leads. | |
| isinactive | Boolean | If the value is 'true', the campaign is inactive and not currently in use. | |
| issalescampaign | Boolean | If the value is 'true', the campaign is focused specifically on sales rather than general brand awareness. | |
| item | String | The product or service item associated with the campaign, used for attribution and performance tracking. | |
| keyword | String | The search engine keyword or phrase targeted by this campaign for visibility or advertisement placement. | |
| leadsgenerated | Integer | The number of potential customers acquired through the campaign. | |
| message | String | A description of the campaign message or creative content used in search ads or listings. | |
| offer | String | The promotional offer tied to the campaign, such as a discount, limited-time deal, or bundle. | |
| owner | String | The campaign manager responsible for planning and overseeing campaign execution and results. | |
| ownerrole | String | The NetSuite role assigned to the campaign manager, which can determine permissions and visibility. | |
| profit | Decimal | The net profit generated by the campaign after subtracting total costs from revenue. | |
| promotioncode | String | The specific promotion or discount code linked to the campaign. | |
| roi | Double | The return on investment (ROI) of the campaign, calculated as (Profit ÷ Cost) × 100. | |
| searchengine | String | The search engine used for running the campaign, such as Google, Bing, or Yahoo. | |
| startdate | Date | The date when the campaign began generating traffic or customer activity. | |
| title | String | The internal name or title of the campaign used for tracking and reporting. | |
| totalrevenue | Decimal | The total revenue earned directly from the campaign. | |
| uniquevisitors | Integer | The number of individual visitors who interacted with the campaign content. |