Campaigns
The information on email marketing campaigns created in Oracle B2C Service Outreach Cloud Service.
Table-Specific Information
SELECT
The 本製品 will use the Oracle Service Cloud API to process WHERE clause conditions built with =,!=,<,>,<=,>=,IN,NOT_IN,IS,IS_NOT,LIKE operators. The rest of the filters are executed client side within the 本製品.
SELECT * FROM Campaigns WHERE id = 12 SELECT * FROM Campaigns WHERE id > 15 SELECT * FROM Campaigns WHERE lookUpName LIKE '%test' SELECT * FROM Campaigns WHERE id IN (12, 23, 123) SELECT * FROM Campaigns WHERE lookUpName IS NOT NULL
Columns
| Name | Type | Description |
| ActualLeads | Int | The number of actual leads generated from the campaign. |
| ActualOpportunities | Int | The number of actual opportunities generated from the campaign. |
| AssignedToAccountId | Long | Id of assignedToAccount. The staff member assigned to the campaign. |
| AssignedToAccountlookUpName | String | LookUpName of assignedToAccount. The staff member assigned to the campaign. |
| CampaignEndTime | Datetime | The date and time when the campaign ends. |
| CampaignStartTime | Datetime | The date and time when the campaign begins. |
| CreatedByAccountId | Long | Id of createdByAccount. The ID number of the staff member who created the campaign. |
| CreatedByAccountlookUpName | String | LookUpName of createdByAccount. The ID number of the staff member who created the campaign. |
| CreatedTime | Datetime | The date and time when the campaign was created. This attribute is read-only. |
| ExpectedLeads | Int | The number of expected leads generated from the campaign. |
| ExpectedOpportunities | Int | The number of expected opportunities generated from the campaign. |
| FlowId | Long | Id of flow. The ID of the flow that the campaign is associated with. |
| FlowlookUpName | String | LookUpName of flow. The ID of the flow that the campaign is associated with. |
| Id [KEY] | Long | The unique identifier of the campaign. |
| InterfaceId | Long | Id of interface. The ID of the interface that the campaign is associated with. |
| InterfacelookUpName | String | LookUpName of interface. The ID of the interface that the campaign is associated with. |
| IsSingleExecute | Bool | Indicates whether the contacts are allowed to flow through the recurring campaign only one time. This attribute does not have a default value. |
| LookupName | String | The name used to look up the campaign. |
| Name | String | The name of the campaign. |
| ObjectivesSummary | String | The summary of the objectives specified for the campaign. |
| UpdatedByAccountId | Long | Id of updatedByAccount. The ID of the staff member who last updated the campaign. |
| UpdatedByAccountlookUpName | String | LookUpName of updatedByAccount. The ID of the staff member who last updated the campaign. |
| UpdatedTime | Datetime | The date and time when the campaign was last updated. This attribute is read-only. |
| ActualCostcurrencyId | Long | Id of currency. The ID of the currency. |
| ActualCostcurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| ActualCostexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ActualCostexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ActualCostvalue | String | The value of the currency. |
| ActualSalescurrencyId | Long | Id of currency. The ID of the currency. |
| ActualSalescurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| ActualSalesexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ActualSalesexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ActualSalesvalue | String | The value of the currency. |
| BudgetcurrencyId | Long | Id of currency. The ID of the currency. |
| BudgetcurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| BudgetexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| BudgetexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| Budgetvalue | String | The value of the currency. |
| ExpectedCostcurrencyId | Long | Id of currency. The ID of the currency. |
| ExpectedCostcurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| ExpectedCostexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ExpectedCostexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ExpectedCostvalue | String | The value of the currency. |
| ExpectedSalescurrencyId | Long | Id of currency. The ID of the currency. |
| ExpectedSalescurrencylookUpName | String | LookUpName of currency. The ID of the currency. |
| ExpectedSalesexchangeRateId | Long | Id of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ExpectedSalesexchangeRatelookUpName | String | LookUpName of exchangeRate. The exchange rate in effect when the value was set. This is used to convert the value to other currencies. |
| ExpectedSalesvalue | String | The value of the currency. |
| Folderid | Long | ID value |
| FolderlookupName | String | Name used to lookup this object |