Configure Spot Calendar for Linear Media Planning

Configure the spot calendar by updating the Ad Availability View Configuration object. This configuration defines the layout and behavior of the spot calendar.

Available in: Lightning Experience

Available in: Enterprise, Performance, and Unlimited editions with Media Cloud- Advanced

Create the configuration record for the spot calendar with these details:

Setting	Value
Name	Spot Calendar Grid Configuration
Configuration Type	Screen
Configuration Key	spot-calendar-grid-template
Is Active	true

Configure the grid columns for the spot calendar as shown in this sample snippet for Local TV and Radio:

{
  "gridColumns": {
    "Local TV": [
      {
        "label": "Product",
        "fieldDeveloperName": "QuoteLineItem.Product2.Name",
        "fieldDeveloperType": "String",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "Station",
        "fieldDeveloperName": "AdSpaceSpecificationMediaChannel",
        "fieldDeveloperType": "Text",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "DayPart",
        "fieldDeveloperName": "CustomerDayPart",
        "fieldDeveloperType": "Picklist",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "Spots",
        "fieldDeveloperName": "TotAdQuotLineUnitSpltQty",
        "fieldDeveloperType": "Double",
        "gridColumnType": "Double",
        "pinned": "left",
        "isVisible": true
      },
      {
        "insertSpotCalendar": true,
        "editable": true
      },
      {
        "label": "Total",
        "fieldDeveloperName": "TotAdQuotLineUnitSpltPrc",
        "fieldDeveloperType": "Currency",
        "gridColumnType": "String",
        "pinned": "right",
        "isVisible": true
      }
    ],
    "Radio": [
      {
        "label": "Product",
        "fieldDeveloperName": "QuoteLineItem.Product2.Name",
        "fieldDeveloperType": "String",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "Station",
        "fieldDeveloperName": "AdSpaceSpecificationMediaChannel",
        "fieldDeveloperType": "Text",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "DayPart",
        "fieldDeveloperName": "CustomerDayPart",
        "fieldDeveloperType": "Picklist",
        "gridColumnType": "String",
        "pinned": "left",
        "isVisible": true
      },
      {
        "label": "Spots",
        "fieldDeveloperName": "TotAdQuotLineUnitSpltQty",
        "fieldDeveloperType": "Double",
        "gridColumnType": "Double",
        "pinned": "left",
        "isVisible": true
      },
      {
        "insertSpotCalendar": true,
        "editable": true
      },
      {
        "label": "Total",
        "fieldDeveloperName": "TotAdQuotLineUnitSpltPrc",
        "fieldDeveloperType": "Currency",
        "gridColumnType": "String",
        "pinned": "right",
        "isVisible": true
      }
    ]
  }
}