Marketing Campaign

The medium to convey a marketing message to the targeted audience with the goal of retaining existing customers or generating new selling opportunities.

QName: {http://xmlns.oracle.com/apps/marketing/coreMarketing/campaigns/campaignService/}Campaign

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Marketing Campaign Lead Distribution Partner

Contains

Marketing Source Code

Contains

Marketing Campaign Resource

Handled by

Marketing Campaign Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

ActiveFlag

boolean

Indicates the activity status of the marketing campaign as Active or Inactive.

ApproverId

long

The identifier of the approver for this campaign.

ApproverNote

string

A note provided by the approver of this campaign.

AttachmentEntityName

string

The name of the attachment associated with this campaign.

BUId

long

The identifier of the business unit associated with this record.

CalculationSubCost

decimal

The calculated sub cost.

CampaignCode

string

The code associated with this campaign.

CampaignEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The end date of the campaign.

CampaignId

long

The unique identifier for the campaign.
  • Primary Key

CampaignName

string

The name of the campaign.

CampaignNumber

string

The number associated with this campaign. This attribute acts as a public surrogate key.

CampaignPartners

Marketing Campaign Lead Distribution Partner

Reference to marketing campaign partners.

CampaignResources

Marketing Campaign Resource

Reference to marketing campaign resources.

CampaignStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The start date associated with this campaign.

CampaignTypeCode

string

The type of campaign.

CampaignUsage

string

The usage of this campaign.

ClassificationCode

string

The organization's classification code.

CreatedBy

string

The user who created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

Description

string

The free text description of the record.

DesignStatusCode

string

The status of the campaign design for this campaign.

DialogStatusMeaning

string

The meaning associated with the campaign design status for this campaign.

EffectiveEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the end of the date range within which the row is effective.

EffectiveStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the beginning of the date range within which the row is effective.

EnforceApprovalFlag

boolean

Indicates whether approval is enforced for this campaign.

ExecutionStatusCode

string

The status of the campaign execution.

LanguageCode

string

The language associated with this campaign.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdatedBy

string

The user who last updated the record.

LaunchFinishDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The end date of the campaign launch window.

LaunchStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The start date of the campaign launch window.

LeadDistributionMode

string

Indicates whether lead assignment is done based on sales territories or rules, or both.

MktgTmplId

long

Identifier of the campaign template used to created this campaign.

Name

string

The name of the organization.

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

ObjectVersionNumber1

int

The attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was last queried.

Objective

string

The objective of this campaign.

Organization

string

The name of the organization.

OrganizationId

long

The organization Id of the campaign.

Owner

string

The owner associated with the treatment.

OwnerId

decimal

The resource identifier associated with the campaign coordinator.

OwnerResourceOrgId

long

The resource organization identifier associated with the campaign coordinator.

OwnerTreeCode

string

The resource organization hierarchy code associated with the resource organization associated with the campaign coordinator.

OwnerTreeStructureCode

string

The resource organization hierarchy structure code associated with the resource organization associated with the campaign coordinator.

OwnerTreeVersionId

string

The resource organization hierarchy version associated with the resource organization associated with the campaign coordinator.

PartnerProgramId

long

The identifier of the partner program for which this campaign is created to generate demand.

PartnerProgramName

string

The name of the partner program for which this campaign is created to generate demand.

PartnerType

string

The partner type recorded on the campaign. This campaign is created to generate demand for this type of partners.

PartyId

long

The unique identifier of the contact party.

PartyName

string

The name of the party.

PeriodId

long

The fiscal calendar period associated with this campaign.

PlannedCampaignEndDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The end date of the campaign.

PlannedCampaignStartDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The start date of the campaign.

PlannedLaunchFinishDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The end date of the campaign launch.

PlannedLaunchStartDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The start date of the campaign launch.

PrimaryPartnerId

decimal

The identifier of the partner sponsoring this campaign. All leads generated from this campaign are typically routed to this partner.

PriorityCode

string

The priority code associated with the campaign.

PublicSiteURL

string

The public site URL to track the publicly accessible site for collecting responses for the Fusion social campaign.

PurposeCode

string

The purpose of the campaign.

RegionCode

string

The region associated with this campaign.

RegionId

decimal

The identifier of the region associated with this campaign.

SalesChannelType

string

The sales channel recorded on the campaign. This campaign is created to generate demand for this specific sales channel.

SourceCodes

Marketing Source Code

The reference to the marketing campaign source codes.

StatusCode

string

The pre-defined code used to indicate the status.

TaskTemplateId

long

The identifier of the task template used to create tasks for this campaign.

TemplateFlag

boolean

Indicates whether this record is a campaign template.