Opportunity Campaigns

The opportunity campaign view object contains information about opportunity such as opportunity, revenue percentage, campaign and so on.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.MktBiccExtractAM.OpportunityCampaignExtractPVO

Primary Keys : OptyCampaignId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CampaignId	The unique identifier of the campaign in the Opportunity Campaign. This is a foreign key of the campaigns view object.
CreatedBy	The user who created the opportunity campaign record.
CreationDate	The date and time when the opportunity campaign record was created.
LastUpdateDate	The date and time when the opportunity campaign record was last updated.
LastUpdateLogin	The session login associated to the user who last updated the opportunity campaign record.
LastUpdatedBy	The user who last updated the opportunity campaign record.
OptyCampaignId	The unique identifier of the opportunity campaign . This is a primary key of the Opportunity Campaign view object.
OptyId	The unique identifier of the opportunity in the Opportunity Campaign. This is a foreign key of the opportunity view object.
RevenuePercentage	The percentage value of the opportunity's revenue shared by one or more campaigns.
UserLastUpdateDate	The date and time of user last update date of opportunity campaign record. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database such as a different mobile database or the server.