Campaign

searchcampaign

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Audience audience select Yes Yes Yes
Campaign Manager owner select Yes Yes Yes
Category category select Yes Yes Yes
Cost basecost currency Yes Yes Yes
Cost Per Lead costpercustomer currency Yes Yes Yes
Cost per Purchaser convcostpercustomer currency Yes Yes Yes
Default defaultevent sublist Yes Yes Yes
Default Lead Source isdefaultleadsource checkbox Yes Yes Yes
Description message textarea Yes Yes Yes
Direct Mail campaigndirectmail sublist Yes Yes Yes
Email campaignemail sublist Yes Yes Yes
End Date enddate date Yes Yes Yes
External ID externalid text Yes Yes Yes
Family family select Yes Yes Yes
ID campaignid identifieranycase Yes Yes Yes
Inactive isinactive checkbox Yes Yes Yes
Internal ID id integer Yes Yes Yes
Item item multiselect Yes Yes Yes
Keyword keyword text Yes Yes Yes
Lead Nurturing campaigndrip sublist Yes Yes Yes
Leads Generated leadsgenerated integer Yes Yes Yes
Manager Role ownerrole select Yes Yes Yes
Number of Purchasers conversions integer Yes Yes Yes
Offer offer select Yes Yes Yes
Print/Other campaignevent sublist Yes Yes Yes
Profit profit currency Yes Yes Yes
Projected Income expectedrevenue currency Yes Yes Yes
Promotion promotioncode select Yes Yes Yes
Return on Investment roi percent Yes Yes Yes
Revenue totalrevenue currency Yes Yes Yes
Sales Campaign issalescampaign checkbox Yes Yes Yes
Start Date startdate date Yes Yes Yes
Title title text Yes Yes Yes
Total Cost cost currency Yes Yes Yes
Unique Visitors uniquevisitors integer Yes Yes Yes
URL url url Yes Yes Yes
Vertical vertical select Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Campaign to Campaign Offer (campaignOffer.id) campaign (searchcampaign, searchcampaign.offer) No Yes Yes
Campaign to Entity (entity.id) campaign (searchcampaign, searchcampaign.owner) No Yes Yes
Campaign to Campaign Vertical (campaignVertical.id) campaign (searchcampaign, searchcampaign.vertical) No Yes Yes