# Campaign: Campaigns - Name: `Campaign` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Campaigns ## Table Columns The columns of the table `Campaign` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ActualCost` | `decimal` | Actual Cost | ☐ | | | `AmountAllOpportunities` | `decimal` | Amount All Opportunities | ☐ | | | `AmountWonOpportunities` | `decimal` | Amount Won Opportunities | ☐ | | | `BudgetedCost` | `decimal` | Budgeted Cost | ☐ | | | `CampaignMemberRecordTypeId` | `string` | Campaign Member Record Type ID | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `Description` | `string` | Description | ☐ | | | `EndDate` | `datetime` | End Date | ☐ | | | `ExpectedResponse` | `string` | Expected Response | ☐ | | | `ExpectedRevenue` | `decimal` | Expected Revenue | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsActive` | `boolean` | Is Active | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastActivityDate` | `datetime` | Date Last Activity | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `NumberOfContacts` | `int32` | Number of Contacts | ☐ | | | `NumberOfConvertedLeads` | `int32` | Number of Converted Leads | ☐ | | | `NumberOfLeads` | `int32` | Number of Leads | ☐ | | | `NumberOfOpportunities` | `int32` | Number of Opportunities | ☐ | | | `NumberOfResponses` | `int32` | Number of Responses | ☐ | | | `NumberOfWonOpportunities` | `int32` | Number of Won Opportunities | ☐ | | | `NumberSent` | `double` | Number Sent | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `ParentId` | `string` | Parent ID | ☐ | | | `StartDate` | `datetime` | Start Date | ☐ | | | `Status` | `string` | Status | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Type` | `string` | Type | ☐ | |