Advertising Sales Management Data Model

Advertising Sales Management uses some extensions to the Salesforce Industries Communications, Media, and Energy data model, along with some new objects which have been introduced to the existing data model.

Here's a list of key objects with selected fields that are used in Advertising Sales Management. For more information, see Object Reference for the Salesforce Platform.

Object Field Description
AdAvailabilityDimensions AdOrderItemId The advertising order item that's associated with the advertisement slot sale.
AdAvailabilityDimensions AdQuoteLineId The advertising quote line that's associated with the advertisement slot sale.
AdAvailabilityDimensions AdServer The name of the advertising server that's used to retrieve the dimension details.
AdAvailabilityDimensions AdSpaceSpecificationId The advertising space specification that's associated with the advertising slot sale.
AdAvailabilityDimensions DealType Specifies the type of deal to sell advertising slot units.
AdAvailabilityDimensions DeliveredUnits The number of slots that were delivered in a specified period.
AdAvailabilityDimensions JobId The Ad Availability Job that's associated with the dimension.
AdAvailabilityDimensions MediaChannelId The media channel that's associated with the advertising slot sale.
AdAvailabilityDimensions MediaContentTitleId The media content title that's associated with advertising slot sale.
AdAvailabilityDimensions MediaType The type of media plan that's used to run the advertisements.
AdAvailabilityDimensions Name The name of ad availability dimensions.
AdAvailabilityDimensions OwnderId The ID of the user who created the relationship record.
AdAvailabilityDimensions PricingModel Specifies the pricing model for the media plan.
AdAvailabilityDimensions ProductId The product that's associated with the advertisement sale.
AdAvailabilityJob ErrorTrace The error message indicating the reason for the failed job.
AdAvailabilityJob IsActive Indicates whether the job processed successfully (true) or not (false).
AdAvailabilityJob JobEndAt The date and time when the job started.
AdAvailabilityJob Name The name of ad availability job.
AdAvailabilityJob OwnerId The ID of the user who created the relationship record.
AdAvailabilityJob Status The status of the current job.
AdAvailabilityViewConfig ConfigurationKey The key to the configuration that's used to map the advertisement availability slot in the view.
AdAvailabilityViewConfig ConfigurationType The type of configuration that's saved for the availability view.
AdAvailabilityViewConfig ConfigurationValue The value that's used to map the advertisement availability slot in the view.
AdAvailabilityViewConfig IsActive Indicates whether the configuration is active (true) or not (false) in the availability view.
AdAvailabilityViewConfig LastReferenceDate The timestamp for when the current user last viewed a record related to this record.
AdAvailabilityViewConfig MediaType The type of media that's shown in the availability view.
AdAvailabilityViewConfig Name The name of the ad availability view configuration.
AdAvailabilityViewConfig OwnerId The ID of the user who created the relationship record.
AdAvailabilityViewConfig PivotOn The pivot for the calendar availability view.
AdBuyServerAccount AccountId ID of the Account.
AdBuyServerAccount AccountIdentifier Unique account ID in the buy side platform.
AdBuyServerAccount CurrencyIsoCode Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization.
AdBuyServerAccount Name Name of user account in the buy side platform.
AdBuyServerAccount OwnerId The ID of the user that owns this record.
AdBuyServerAccount Type The type of Account.
AdCreativeSizeType Height Captures the Height of the Creative asset.
AdCreativeSizeType MediaType Captures the type of the AdSpace SizeType.
AdCreativeSizeType Runtime Captures the Creative Run time where applicable.
AdCreativeSizeType UnitOfMeasure Represents the Unit of Measure for defining the Size of the Creative asset.
AdCreativeSizeType Width Captures the width of the Creative asset.
AdDigitalAvailability AdAvailabilityDimensionsId The Ad Availability Dimension that's associated with the digital availability.
AdDigitalAvailability AdPlacementPriorityType Specifies the type of priority assigned to a digital advertisement slot.
AdDigitalAvailability CalendarPeriodType The period that's used to filter the unit count for a selected unit type.
AdDigitalAvailability CreativeSize The creative size of the digital advertisement slot.
AdDigitalAvailability FromDate The start date of the availability of the digital advertisement slot.
AdDigitalAvailability Name The name of the ad digital availability.
AdDigitalAvailability OwnerId The ID of the user who created the relationship record.
AdDigitalAvailability ToDate The end date of the availability of the digital availability slot.
AdDigitalAvailability Units The total number of units assigned for the digital advertisement slot.
AdDigitalAvailability UnitsStatus Specifies the unit type for the digital advertisement slot.
AdLinearAvailability AdAvailabilityDimensionsId The Ad Availability Dimension that's associated with the linear availability.
AdLinearAvailability CalendarPeriodType The period that's used to filter the unit count for a selected unit type.
AdLinearAvailability FromDate The start date of the availability of the linear advertisement slot.
AdLinearAvailability Name The name of ad linear availability.
AdLinearAvailability OwnerId The ID of the user who created the relationship record.
AdLinearAvailability ProgramRunType The program during which the advertisement is scheduled to run.
AdLinearAvailability PublisherDayPart The daypart schedule to run the advertising campaign.
AdLinearAvailability SponsorshipType The sponsorship type for the linear advertisement slot.
AdLinearAvailability ToDate The end date of the availability of the linear advertisement slot.
AdLinearAvailability Units The total number of units assigned for the linear advertisement slot.
AdLinearAvailability UnitsStatus Specifies the unit type for the linear advertisement slot.
AdOpportunity BuyerId ID of the Buyer.
AdOpportunity CurrencyIsoCode Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization.
AdOpportunity DealType The campaign type to be executed in the downstream ad server.
AdOpportunity Name Name of the ad opportunity.
AdOpportunity OpportunityId ID of the Opportunity.
AdOpportunity OwnerId The ID of the user that owns this record.
AdOrderItem AdBleedAmountUom Specifies bleed height and width measurement.
AdOrderItem AdBleedAmount Captures the distance from the edge.
AdOrderItem AdCreativeSizeTypes Semicolon separated user-selected Creative SizeTypes from the possible choices presented by each Ad Space.
AdOrderItem AdCreativeUrl Specifies the URL of the Ad Creative. It may or may not be hosted by Salesforce platform.
AdOrderItem AdPlacementPriorityType Specifies the placement priority type chosen from the Ad Server's AdPriorityType record.
AdOrderItem AdRequestEndDate Captures the requested end date for the LineItem.
AdOrderItem AdRequestedStartDate Captures the requested start date for the placement.
AdOrderItem AdServerOrderIdentifier Captures the OrderId generated at the Ad Server.
AdOrderItem AdServerOrderLineIdentifier Captures the Order Line ItemId generates at the Ad Server.
AdOrderItem AdSpaceSpecificationId Lookup to the Ad Space Specification record.
AdOrderItem AdTimePerEpisode Captures the Ad Time in seconds for each episode Customer will be paying for.
AdOrderItem BonusAdTime Bonus commercial times in second provided the customer.
AdOrderItem CostPerRatingPoint Cost Per Rating Point calculated on the basis of QuoteLineItem.ImpliedRate / AdSpaceSpecification.AudienceSizeRating.
AdOrderItem CustomerDayPart Customer PrimeTime depends on the combination of genre of the show, audience interest, demographics, and so on.
AdOrderItem GrossRatingPoint Calculated on the basis of AdSpaceSpecification.AudienceSizeRating * Paid Commercial Time per 'Linear Commercial Time Slot Unit of the Org'.
AdOrderItem ImpliedRate Used by publishers to organize the revenue structure within the deal. This value is often internal to the publishers organization and not customer facing.
AdOrderItem ImpliedTotal Calculated from the ImpliedRate and is used by publishers to organize the revenue structure within the deal. The value is often internal to the publisher organization and not customer facing.
AdOrderItem IsAdBleedEnabled Indicates if the Ad extends all the way to the edge of the page on at least one side.
AdOrderItem MaximumFrequencyInterval Identifies the maximum frequency unit used for frequency capping.
AdOrderItem MaximumFrequency Identifies maximum number of times the Ad is served for frequency capping.
AdOrderItem MaximumUserFrequencyInterval Identifies the maximum user frequency interval used for frequency capping.
AdOrderItem MaximumUserFrequency Maximum number of times a unique user sees the Ad over a given time period.
AdOrderItem MediaType Captures the Media Type of the Placement record.
AdOrderItem OrderId Refers to the Order record.
AdOrderItem OrderItemId Captures the Order Product for which the extension record is to be created.
AdOrderItem PaidAdTime Indicates total commercial time slots customer are paying for in seconds.
AdOrderItem PaidOrderLineItemId Captures the prior order item in case of existing or changed order item, for new it will be blank.
AdOrderItem PriorUsedAmount This is the amount billed in prior orders in case of modified order, for new orders it will be zero.
AdOrderItem QuoteLineItemId Captures the Quote LineItem if the order is to be created for a Quote.
AdOrderItem RequestedIssues The issues selected for a placement or line item for which the selected or defined ad creatives are to be inserted.
AdOrderItem RequestedSplits The break-up of the requested units for each placement or line item, based on the selected frequency, whether daily or weekly.
AdOrderItem SponsorshipType Captures advertiser's sponsorship interested for the Ad Space Specification.
AdOrderItem TargetingParameters Ad Creative Targeting Parameters stored in JSON format.
AdOrderItem TotalAdTime Captures the Sum of Bonus and Paid Ad Time OR Ad Time Per Episode multiplied by No of Episodes on Media Content Title of Ad Space Specification.
AdOrderItem UserEngagementGoalType Specifies the user agreement goal defined in terms of clicks, impressions, and so on. This is derived from Ad Space Available GoalType.
AdOrderItem UserEngagementGoalUnit Represents the number or percentage of impressions or clicks for the Ad Creative.
AdOrderItemCreativeSizeType AdOrderItemId ID of Ad Order Item.
AdOrderItemCreativeSizeType AdSpaceCreativeSizeTypeId ID of the Ad Space Creative Size Type.
AdOrderItemCreativeSizeType CurrencyIsoCode Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization.
AdOrderItemCreativeSizeType Name Name of ad order item creative size type.
AdOrderItemCreativeSizeType Total The expected count of each of the creative sizes specified for the ad quote line item.
AdOrderLineAdTarget AdOrderItemId Foreign key to the Ad Order Item object for relating the selected values.
AdOrderLineAdTarget AdProductTargetCategoryId Foregin key to the Ad Product Target Category object for relating the selected values with the category and segments metadata.
AdOrderLineAdTarget SelectedValues Stores all the selected values for all the segments available under a particular category, in context of a specific Ad Order Line record.
AdPageLayoutType ColumnWidth Width per column of the page layout.
AdPageLayoutType Gutter Space between columns that helps separate content.
AdPageLayoutType IsActive Indicates whether the Ad Page layout is active (true) or not (false).
AdPageLayoutType MaxColValue Represents the maximum number of columns for the Ad page layout up to which the Ad creative size can be defined.
AdPageLayoutType MaxHeightValue Represents the height of the page upto which Ad creative height can be defined.
AdPageLayoutType Name Contains the label of AdPageLayout.
AdPageLayoutType UnitOfMeasure Actual unit in which the associated values are measured.
AdProductTargetCategory MediaType Represents the Media Type to which a particular Target Category is mapped.
AdProductTargetCategory ProductId Foreign key to Product record for mapping a particular category with it.
AdProductTargetCategory SegmentDetails Stores the complete metadata for an entire category and all the segments associated with it. Acts as the source of truth to represent a category across all products, media types, and so on.
AdProductTargetCategory TargetCategoryId Foreign key to Target Category record for grouping the segments under it.
AdQuote ImpliedTotalAmount Presents the sum of the Implied Total of all Media Plan Placement records.
AdQuote Quote Specified a quote, which is a record showing proposed prices for products and services.
AdQuote RequestedSplitsInterval The interval at which the requested splits for units are displayed, whether weekly or daily.
AdQuote TotalAdTime Represents the Total Ad Time for the Media Placement.
AdQuote TotalBonusAdTime Represents the Total Bonus Ad Time for the Media Placement.
AdQuote TotalCostPerRatingPoint Represents the Total Cost Per Rating Point for the Media placement.
AdQuote TotalGrossRatingPoint Represents the Total Gross Rating Point for the Media Placement.
AdQuote TotalPaidAdTime Represents the Total Paid Ad Time for the Media Placement.
AdQuoteLine AdBleedAmountUom Specifies the Ad Bleed height and width measure.
AdQuoteLine AdBleedAmount Captures the distance from the edge of the page.
AdQuoteLine AdCreativeSizeTypes Lists user selected, semicolon separated creative size types from the possible choices presented by each Ad Space.
AdQuoteLine AdCreativeUrl Specifies the URL of the Ad Creative. It may or may not be hosted by Salesforce platform.
AdQuoteLine AdPlacementPriorityType Chosen from the Ad Server's AdPriorityType record. For example: STANDARD, PRICE_PRIORITY.
AdQuoteLine AdQuoteId Captures the details of the Quote.
AdQuoteLine AdRequestedEndDate Captures the requested end date for the line item.
AdQuoteLine AdRequestedStartDate Captures the requested start date for the placement.
AdQuoteLine AdSpaceSpecificationAdServer Refers to the AdServer responsible to serve the Ad Creative.
AdQuoteLine AdSpaceSpecificationId Lookup to the Ad Space Specification record.
AdQuoteLine AdSpaceSpecificationMediaChannel Refers to the Media Channel of the Ad Space Specification record.
AdQuoteLine AdSpaceSpecificationType Refers to the Ad Space Type for the Ad Space Specification record.
AdQuoteLine AdTimePerEpisode Captures the Ad Time for each episode the customer is paying for in seconds.
AdQuoteLine BonusAdTime Bonus Ad times in seconds provided to the customer.
AdQuoteLine CostPerRatingPoint Cost Per Rating Point calculated on the basis of QuoteLineItem.Implied Rate / AdSpaceSpec.Audience Size rating.
AdQuoteLine CustomerDayPart Indicates Ad Space Specification chosen.
AdQuoteLine GrossRatingPoint Calculated on the basis of AdSpaceSpec.Audience Size Rating * Paid Commercial Time per TimeSlot.
AdQuoteLine ImpliedRate Used by publishers to organize the revenue structure within the deal. This value is often internal to the publisher organization and not customer facing.
AdQuoteLine ImpliedTotal Calculated from the ImpliedRate and is used by publishers to organize the revenue structure within the deal. This value is often internal to the publisher organization and not customer facing.
AdQuoteLine IsAdBleedEnabled Indicates if the Ad extends all the way to the edge of the page on at least one side.
AdQuoteLine MaximumFrequencyInterval Specifies the maximum frequency unit used for frequency capping.
AdQuoteLine MaximumFrequency Specifies the maximum number of times Ad is served for frequency capping.
AdQuoteLine MaximumUserFrequencyInterval Specifies maximum user frequency interval.
AdQuoteLine MaximumUserFrequency Indicates maximum number of times a unique user sees the ad over a given time.
AdQuoteLine MediaType Captures the Media Type field of the Placement record.
AdQuoteLine PaidAdTime Total Ad Time slots customer is paying for in seconds.
AdQuoteLine PercentageAdTime Captures the percentage of the Commercial time slot the placement represents in the whole deal.
AdQuoteLine QuoteLineItemId Captures the Quote LineItem for which the extension record is to be created.
AdQuoteLine QuoteLineItemProductCode Captures the Product Code of the Quote LineItem's product.
AdQuoteLine QuoteLineItemQuantity Refers to the Quantity field of the Quote LineItem record.
AdQuoteLine RequestedIssues The issues selected for a placement or line item for which the selected or defined ad creatives are to be inserted.
AdQuoteLine RequestedSplits The break-up of the requested units for each placement or line item, based on the selected frequency, whether daily or weekly.
AdQuoteLine SponsorshipType Captures advertiser's sponsorship interests for the Ad Space Specification.
AdQuoteLine TargetingParameters Stores Ad Creative targeting parameters in JSON format.
AdQuoteLine TotalAdTime Captures the sum of Bonus and Paid Ad Time OR Ad Time Per Episode multiplied by Number of episodes on Media Content Title of Ad Space Specification.
AdQuoteLine UserEngagementGoalType Specifies the user engagement goal defined in terms of clicks, impressions, and so on.
AdQuoteLine UserEngagementGoalUnitType Specifies the type of goal unit.
AdQuoteLine UserEngagementGoalUnit Represents the number or percentage of impressions or clicks that are reserved for the Ad Creative.
AdQuoteLineCreativeSizeType AdQuoteLineId ID of Ad Quote Line
AdQuoteLineCreativeSizeType AdSpaceCreativeSizeTypeId ID of the Ad Space Creative Size Type.
AdQuoteLineCreativeSizeType CurrencyIsoCode Available only for organizations with the multicurrency feature enabled. Contains the ISO code for any currency allowed by the organization.
AdQuoteLineCreativeSizeType Name Name of the ad quote line item creative size type.
AdQuoteLineCreativeSizeType Total The expected count of each of the parent creative sizes specified for the placement.
AdQuoteLineAdTarget AdProductTargetCategoryId Foreign key to the Ad Product Target Category object for relating the selected values with the category and segments metadata.
AdQuoteLineAdTarget AdQuoteLineId Foreign key to the Ad Quote Line object for relating the selected values.
AdQuoteLineAdTarget SelectedValues Stores all the selected values for all segments available under a particular category, in context of a specific Ad Quote Line record.
AdServer AdServerApplicationName Arbitrary string identifying the publisher's application.
AdServer AdServerNetworkIdentifier Identifies the associated publisher's network.
AdServer AllowedAdPriorityTypes Stores the available Ad Types for the selected Ad Server.
AdServer NamedCredentialReference Stores names of the credential references, which hold the authentication details associated with the AdServer record.
AdServerAccount AdServerAdvertiserIdentifier Captures the AdvertiserId in the Ad Server.
AdServerAccount AdServerId Specifies the AdServer ID for which the mapping is created.
AdServerAccount AdvertiserId Specifies the Advertiser account mapped to the Ad Server.
AdServerAccount Name The name of the Ad Server account.
AdServerAccount Type The account type as per the Ad server definition.
AdServerUser AdServerId Captures the Ad Server to which the User is mapped.
AdServerUser AdServerUserIdentifier Captures the publisher's Contact and User Id sent during Order Creation. This is the equivalent of TraffickerId in Google Ad Manager.
AdServerUser Type Describes the User persona as per the Ad server definition.
AdServerUser UserId Specifies the User record to which the AdServer mapping is created.
AdSpaceCreativeSizeType AdCreativeSizeTypeId Reference to the Ad Creative SizeType.
AdSpaceCreativeSizeType AdSpaceSpecificationId Reference to the AdSpace Specification record.
AdSpaceCreativeSizeType AppearanceOrder Describes the type of creative to be served by the Ad Server.
AdSpaceGroupMember AdSpaceGroupId Refers to the AdSpace Specification record of the recordType AdSpaceGroup.
AdSpaceGroupMember AdSpaceGroupMemberId Captures the AdSpace specification to be added as a Group member.
AdSpaceSpecification AdServerAdSpaceIdentifier Identifies the unique Ad Server name and Id for the Ad Space Specification.
AdSpaceSpecification AdServerId Specifies the Ad Server, which serves this Ad Space Specification.
AdSpaceSpecification AdSpaceType Indicates the AdSpace Type.
AdSpaceSpecification AudienceSizeRating Captures the Audience Size rating for the Ad Space specification.
AdSpaceSpecification EndDateTime Captures the end date and time for a scheduled program specification.
AdSpaceSpecification EndTime Captures the End Time for the Ad Space Specification.
AdSpaceSpecification EndWeekDay Captures the day of the week on which the Ad Space Specification ends.
AdSpaceSpecification IsActive Specifies whether the Ad Space Specification is active.
AdSpaceSpecification IsLiveBroadcast Indicates whether a Broadcast schedule is a Live Telecast or a Recorded Telecast.
AdSpaceSpecification MediaContentTitleId Refers to the Media Content Title record.
AdSpaceSpecification MediaChannelId Refers to the Media Channel record.
AdSpaceSpecification Product2Id Refers to the Product record associated with the Ad Space Specification. The product is added to the Placement and is used to calculate the total cost of the Placement.
AdSpaceSpecification ProgramRunType Captures the schedule type.
AdSpaceSpecification PublisherDayPart Captures the day time type for the Publisher.
AdSpaceSpecification StartDateTime Captures the start date and time for a scheduled program specification.
AdSpaceSpecification StartTime Captures the Start Time for the Ad Space specification.
AdSpaceSpecification StartWeekDay Captures the day of the week on which the Ad Space specification begins.
AdSpaceSpecification Type Represents the type for a particular Ad Space Specification.
AdSpecMediaPrintIssue AdSpaceSpecificationId Represents the ID of an Ad Space specification.
AdSpecMediaPrintIssue MediaPrintIssueId Represents the ID of an issue of the publication.
AdSpecMediaPrintIssue Name Represents the name of the issue for the publication.
AdTargetCategory Code Represents the Code on the Category record, which is mapped to the Ad Server's Code for the same record. Each Category record is represented as a separate node when the payload is sent to the Ad Server.
AdTargetCategory Description Represents the descriptions for a category record. The data for this field can be imported and mapped from the Ad Server.
AdTargetCategory DisplaySequence Indicates the sequence of multiple records configured for a particular product or media type. The sequence is determined by the number of records configured.
AdTargetCategory IsActive Indicates whether a Category record is published. If not activated, the category is not available for run-time configuration.
AdTargetCategory IsAvailableForSelfService Indicates whether a category is available in the Agent Console and the Self Service Console. By default, all categories are available in the Agent Console. If the value of this field is set to true, then the category is available in the Self Service Console.
AdTargetCategory MediaType Represents the Media Type against which a particular Target Category is mapped.
AdTargetCategory Name Represents the category name or label shown to the user.
AdTargetCategory ParentAdTargetCategoryId A self-referencing foreign key, which defines subcategories.
AdTargetCategory ProductId Foreign key to Product record for mapping a particular category with it.
AdTargetCategorySegment AvailableValues Stores all optional values for a particular targeting segment as a JSON file, based on the identifiers configured by the user.
AdTargetCategorySegment Code Represents the Code on the Category Segment record, which is mapped to the Ad Server's Segment Code for the same record. Each Segment Record is represented as a separate node when the payload is sent to the Ad Server.
AdTargetCategorySegment DataType Configures the type of data stored in the targeting segment.
AdTargetCategorySegment DependentCategorySegmentId A self-referenced foreign key to support the dependent picklist feature.
AdTargetCategorySegment Description Represents description for a particular category segment record. Data for this field can be imported and mapped from the Ad Server.
AdTargetCategorySegment DisplaySequence Indicates the sequence of the multiple records configured for a particular category. Based on the number configured here, the sequence is decided in the UI.
AdTargetCategorySegment DisplayType Used to configure how data is rendered in the UI.
AdTargetCategorySegment IsActive Indicates whether this record is a published Segment or not. If not activated, it is not available for the run-time configuration for the user.
AdTargetCategorySegment IsAvailableForSelfService Indicates whether this segment record is available only at the Agent Console or at the self care portal as well. By default, once activated, all segments are available in the Agent Console, but can be available on the Self Service Console only when this field's value is set to true. Some of the categories contain segments, which can be filled only by the Agent and they mainly contain the configurations needed by the Ad Server.
AdTargetCategorySegment MediaType Represents the Media Type against which a particular Target Category is mapped.
AdTargetCategorySegment Name Represents the category name of label shown to the user.
AdTargetCategorySegment ProductId Foreign key to Product record for mapping a particular category with it.
AdTargetCategorySegment TargetCategoryId Foreign key to Target Category record for grouping the segments under it.