sample script: eyeota-incremental
  • 16 Minutes to read
  • Dark
    Light
  • PDF

sample script: eyeota-incremental

  • Dark
    Light
  • PDF

Article summary

sample load and process script for eyeota-incremental project


(Note: paths have been removed from this sample script)

[
  {
    "method": "DropProject",
    "deleteFiles": true,
    "project": "eyeota-incremental",
    "name": "eyeota-incremental"
  },
  {
    "method": "CreateProject",
    "description": "",
    "project": "eyeota-incremental",
    "name": "eyeota-incremental"
  },
  {
    "method": "OpenProject",
    "project": "eyeota-incremental",
    "name": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Process raw data files into segment data files",
    "project": "eyeota-incremental"
  },
  {
    "method": "ProcessSegments",
    "sourcepath": ".../",
    "targetpath": ".../",
    "segspath": ".../",
    "childfolder": "HEMSHA2",
    "reportFile": "%OUTPUT%SegmentProcessReport.json",
    "latestFolders": 1,
    "-note": "latestFolders 1 just loads most recent daily source folder",
    "numericFoldersOnly": true,
    "ignoreCompressedFolders": true,
    "finalConvert": true,
    "cleanOnStart": true,
    "sample": false,
    "writekeys": true,
    "description": "Process Eyeota Segments",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Export Audience Summary Data to File",
    "project": "eyeota-incremental"
  },
  {
    "method": ";GetCampaignHistory",
    "filename": "AudienceReport.xlsx",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Export Audience Summary data to Temp Audience History Table",
    "description": "",
    "project": "eyeota-incremental"
  },
  {
    "method": "GetCampaignHistory",
    "targetTable": "DailyLoad",
    "description": "Daily Load Statistics table",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Load Hash-Key file into Primary Contact Table",
    "project": "eyeota-incremental"
  },
  {
    "method": "CreateTableFromFile",
    "action": "LOAD",
    "table": "DATA_EYE_DAILY",
    "filename": "...",
    "definition": [
      "SHA256|CONTINUOUS|STRING|68",
      "key|CONTINUOUS|INTEGER|"
    ],
    "loading": [
      "SHA256",
      "key"
    ],
    "sample": false,
    "preHeaderSkip": 0,
    "dateFormat": "YYYY-MM-DD",
    "fileFormat": "ASCII8",
    "skipFirstLine": false,
    "delimiter": "TAB",
    "stripCharacter": "",
    "dateTimeFormat": "YYYY-MM-DD HH:MM:SS",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Import Audience Definitions from saved file",
    "project": "eyeota-incremental"
  },
  {
    "method": "ImportAudienceDefinitions",
    "filename": "myaudiences.json",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Generate Daily Audience Extract Files",
    "project": "eyeota-incremental"
  },
  {
    "method": "BulkExportAudiences",
    "status": "*",
    "fileStub": "testexport",
    "prefix": "US\t",
    "suffix": "\t%AUDIENCEID%",
    "recordsPerFile": 50000,
    "description": "Export all audiences of all status",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Add Date Data to Temp Audience History table",
    "description": "",
    "project": "eyeota-incremental"
  },
  {
    "method": "BuildBakedField",
    "name": "date",
    "targetTable": "DailyLoad",
    "overwrite": true,
    "dataType": "default",
    "function": "dmath",
    "p1": "expression",
    "p2": "today()",
    "nullIsZero": false,
    "NOORD": false,
    "project": "eyeota-incremental"
  },
  {
    "method": "BuildBakedField",
    "name": "datetime",
    "targetTable": "DailyLoad",
    "overwrite": true,
    "dataType": "default",
    "function": "dmath",
    "p1": "expression",
    "p2": "now()",
    "nullIsZero": false,
    "NOORD": false,
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Extract the audience history data to file",
    "project": "eyeota-incremental"
  },
  {
    "method": "Export",
    "exportHeaders": true,
    "urns": false,
    "quotedStringHeaders": false,
    "overwrite": true,
    "delimiter": "Tab",
    "createImportScript": false,
    "-note": "sending the metadata somewhere else, do as not disrupt the * load",
    "infoPath": "%DATAPATH%eyeotadailymetainfo",
    "exportAlternateFields": false,
    "fields": [
      "DailyLoad.Id",
      "DailyLoad.name",
      "DailyLoad.type",
      "DailyLoad.description",
      "DailyLoad.records",
      "DailyLoad.date",
      "DailyLoad.datetime"
    ],
    "dataSet": {
      "logic": "or",
      "name": "SubSet",
      "strict": true,
      "set": [
        {
          "logic": "or",
          "stype": "TABLE",
          "entity": "DailyLoad"
        }
      ]
    },
    "exportFilename": "%DATAPATH%campaignExports/EyeotaDaily/dailyload_%DSTAMP%.dat",
    "project": "eyeota-incremental"
  },
  {
    "method": "remark",
    "text": "Load All History Data Files into reporting table",
    "description": "",
    "project": "eyeota-incremental"
  },
  {
    "method": "CreateTableFromFile",
    "action": "LOAD",
    "table": "LoadHistory",
    "filename": "%DATAPATH%campaignExports/EyeotaDaily/*",
    "definition": [
      "Id|DISCRETE|INTEGER|BYTE",
      "name|DISCRETE|STRING|BYTE",
      "type|DISCRETE|STRING|BYTE",
      "description|DISCRETE|STRING|BYTE",
      "records|DISCRETE|INTEGER|BYTE",
      "date|DISCRETE|DATE|SHORT",
      "datetime|CONTINUOUS|DATETIME|"
    ],
    "loading": [
      "Id",
      "name",
      "type",
      "description",
      "records",
      "date",
      "datetime"
    ],
    "sample": false,
    "preHeaderSkip": 0,
    "dateFormat": "YYYY-MM-DD",
    "fileFormat": "ASCII8",
    "skipFirstLine": true,
    "delimiter": "TAB",
    "stripCharacter": "",
    "dateTimeFormat": "YYYY-MM-DD HH:MM:SS",
    "project": "eyeota-incremental"
  },
  {
    "method": "AddToCollection",
    "project": "eyeota-incremental",
    "overwrite": true,
    "name": "Segment Dashboard2",
    "description": "",
    "type": "DJExplorer.DashBoardExControl",
    "tags": [
      ""
    ],
    "users": [],
    "groups": [],
    "collection": "REPORTS",
    "definition": {
      "version": 2,
      "entries": [
        {
          "row": 0,
          "rowSpan": 1,
          "column": 0,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Historic Segment Type",
            "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
            "user": "smccarth",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "LoadHistory.type",
                  "table": "LoadHistory",
                  "valueFilter": []
                }
              ],
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "LoadHistory.records",
              "sortMode": 1,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 1,
                "relativeWidth": 1,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart",
                "rotation": 1,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": true,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 1,
                  "sortColumn": -1,
                  "percentType": 0,
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "LoadHistory.records",
                        "table": "LoadHistory",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "LoadHistory.type",
                      "table": "LoadHistory",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Historic Segment Type",
          "state": {
            "relativeHeight": 1,
            "relativeWidth": 1,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart",
            "rotation": 1,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": true,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        },
        {
          "row": 0,
          "rowSpan": 1,
          "column": 1,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Segment Type - Today",
            "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
            "user": "smccarth",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "DailyLoad.type",
                  "table": "DailyLoad",
                  "valueFilter": []
                }
              ],
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "DailyLoad.records",
              "sortMode": 1,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 1,
                "relativeWidth": 1,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart",
                "rotation": 0,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": true,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 1,
                  "sortColumn": -1,
                  "percentType": 0,
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "DailyLoad.records",
                        "table": "DailyLoad",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "DailyLoad.type",
                      "table": "DailyLoad",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Segment Type - Today",
          "state": {
            "relativeHeight": 1,
            "relativeWidth": 1,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart",
            "rotation": 0,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": true,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        },
        {
          "row": 1,
          "rowSpan": 1,
          "column": 0,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Records by Date",
            "description": "",
            "user": "smccarth",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "LoadHistory.date",
                  "table": "LoadHistory",
                  "valueFilter": []
                }
              ],
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "LoadHistory.records",
              "sortMode": 0,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 0,
                "relativeWidth": 0,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart2",
                "rotation": 0,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": false,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 0,
                  "sortColumn": -1,
                  "percentType": 0,
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "LoadHistory.records",
                        "table": "LoadHistory",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "LoadHistory.date",
                      "table": "LoadHistory",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Records by Date",
          "state": {
            "relativeHeight": 0,
            "relativeWidth": 0,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart2",
            "rotation": 0,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": false,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        },
        {
          "row": 1,
          "rowSpan": 1,
          "column": 1,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Records by Segment Type",
            "description": "",
            "user": "smccarth",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "LoadHistory.type",
                  "table": "LoadHistory",
                  "valueFilter": []
                },
                {
                  "type": "field",
                  "name": "LoadHistory.date",
                  "table": "LoadHistory",
                  "valueFilter": []
                }
              ],
              "pivot": "LoadHistory.date",
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "LoadHistory.records",
              "sortMode": 0,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 0,
                "relativeWidth": 0,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart",
                "rotation": 0,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": true,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 0,
                  "sortColumn": -1,
                  "percentType": 0,
                  "pivot": {
                    "type": "field",
                    "name": "LoadHistory.date",
                    "table": "LoadHistory",
                    "valueFilter": []
                  },
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "LoadHistory.records",
                        "table": "LoadHistory",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "LoadHistory.type",
                      "table": "LoadHistory",
                      "valueFilter": []
                    },
                    {
                      "type": "field",
                      "name": "LoadHistory.date",
                      "table": "LoadHistory",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Records by Segment Type",
          "state": {
            "relativeHeight": 0,
            "relativeWidth": 0,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart",
            "rotation": 0,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": true,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        }
      ],
      "xlTemplate": "",
      "xlSheet": "Sheet1",
      "xlLocalTemplateFile": "",
      "xlOffset": 0
    },
    "isTemp": false
  },
  {
    "method": "remark",
    "text": "Create simple reporting",
    "project": "eyeota-incremental"
  },
  {
    "method": "AddToCollection",
    "overwrite": true,
    "name": "Segment Type",
    "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
    "type": "DJExplorer.FProfileControl",
    "tags": [
      ""
    ],
    "users": [],
    "groups": [],
    "collection": "REPORTS",
    "definition": {
      "version": 2,
      "fields": [
        {
          "type": "field",
          "name": "DailyLoad.type",
          "table": "DailyLoad",
          "valueFilter": []
        }
      ],
      "dataSet": {
        "logic": "or",
        "name": "SubSet",
        "strict": true,
        "set": []
      },
      "function": 1,
      "postFunction": "",
      "measure": "DailyLoad.records",
      "sortMode": 1,
      "sortColumn": -1,
      "sortOn": 0,
      "zscore": false,
      "percentType": 0,
      "limitRows": 0,
      "limitColumns": 0,
      "rowLimitMode": 0,
      "columnLimitMode": 0,
      "showEmptyOrNullRows": false,
      "hideTotals": false,
      "hideNullCategory": false,
      "showNullAsZero": false,
      "favorInteger": false,
      "extendedTotals": false,
      "showEmptyOrNullColumns": false,
      "alwaysShowNull": false,
      "displayPrecision": 2,
      "distinct": "",
      "controlState": {
        "relativeHeight": 0,
        "relativeWidth": 0,
        "displayMode": 2,
        "plotOption": 0,
        "preferredChart": "BarChart",
        "rotation": 0,
        "gridFlip": false,
        "chartFlip": false,
        "plotNull": false,
        "legendLeft": false,
        "heatMapState": 0,
        "useLegend": true,
        "trendColumn": -1,
        "trendColumnName": "",
        "showHeatchartLabels": true,
        "rotateCategoricalLabels": true,
        "axisOnTicks": false,
        "highTickCount": false,
        "pieLabelOnly": false,
        "pieLabelPercent": false,
        "datapointPalette": false,
        "stepLines": false,
        "multiLineAxis": false,
        "horizontalLegend": false,
        "reverseCategoricalAxis": false,
        "radarAreaChart": false,
        "forcedPercentageHeatmap": false,
        "plotRegression": false
      },
      "zoomState": false,
      "xlTemplate": "",
      "xlSheet": "Sheet1",
      "xlOffset": 0,
      "displayControl": "DataGridGraphControl",
      "serializedAPI": {
        "apiCall": {
          "method": "GenProfile",
          "project": "eyeota-incremental",
          "name": "profile",
          "showEmptyOrNullRows": false,
          "hideTotals": false,
          "hideNullCategory": false,
          "showNullAsZero": false,
          "favorInteger": false,
          "showEmptyOrNullColumns": false,
          "alwaysShowNull": false,
          "extendedTotals": false,
          "displayPrecision": 2,
          "profilePercentColumn": false,
          "distinct": "",
          "zscore": false,
          "limitRows": 0,
          "processOrder": 0,
          "modelTimeout": 180000,
          "limitColumns": 0,
          "rowLimitMode": 0,
          "columnLimitMode": 0,
          "sortOn": 0,
          "sortMode": 1,
          "sortColumn": -1,
          "percentType": 0,
          "measures": [
            {
              "name": "sum records",
              "field": {
                "type": "field",
                "name": "DailyLoad.records",
                "table": "DailyLoad",
                "valueFilter": []
              },
              "function": "sum",
              "postFunction": "",
              "countAtTable": "",
              "distinct": "",
              "axis": 0,
              "plot": true,
              "seriesType": "Default",
              "calloutMode": "Default",
              "prefix": ""
            }
          ],
          "fields": [
            {
              "type": "field",
              "name": "DailyLoad.type",
              "table": "DailyLoad",
              "valueFilter": []
            }
          ]
        },
        "apiType": "AGenProfile"
      }
    },
    "isTemp": false,
    "project": "eyeota-incremental"
  },
  {
    "method": "AddToCollection",
    "overwrite": true,
    "name": "Segment Dashboard",
    "description": "",
    "type": "DJExplorer.DashBoardExControl",
    "tags": [
      ""
    ],
    "users": [],
    "groups": [],
    "collection": "REPORTS",
    "definition": {
      "version": 2,
      "entries": [
        {
          "row": 0,
          "rowSpan": 2,
          "column": 0,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Historic Segment Type",
            "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
            "user": "tmccarthy@datajetsoftware.com",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "LoadHistory.type",
                  "table": "LoadHistory",
                  "valueFilter": []
                }
              ],
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "LoadHistory.records",
              "sortMode": 1,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 1,
                "relativeWidth": 1,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart",
                "rotation": 1,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": true,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 1,
                  "sortColumn": -1,
                  "percentType": 0,
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "LoadHistory.records",
                        "table": "LoadHistory",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "LoadHistory.type",
                      "table": "LoadHistory",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Historic Segment Type",
          "state": {
            "relativeHeight": 1,
            "relativeWidth": 1,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart",
            "rotation": 1,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": true,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        },
        {
          "row": 0,
          "rowSpan": 2,
          "column": 1,
          "columnSpan": 1,
          "isStatic": false,
          "report": {
            "name": "Segment Type",
            "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
            "user": "tmccarthy@datajetsoftware.com",
            "type": "DJExplorer.FProfileControl",
            "def": {
              "version": 2,
              "fields": [
                {
                  "type": "field",
                  "name": "DailyLoad.type",
                  "table": "DailyLoad",
                  "valueFilter": []
                }
              ],
              "dataSet": {
                "logic": "or",
                "name": "SubSet",
                "strict": true,
                "set": []
              },
              "function": 1,
              "postFunction": "",
              "measure": "DailyLoad.records",
              "sortMode": 1,
              "sortColumn": -1,
              "sortOn": 0,
              "zscore": false,
              "percentType": 0,
              "limitRows": 0,
              "limitColumns": 0,
              "rowLimitMode": 0,
              "columnLimitMode": 0,
              "showEmptyOrNullRows": false,
              "hideTotals": false,
              "hideNullCategory": false,
              "showNullAsZero": false,
              "favorInteger": false,
              "extendedTotals": false,
              "showEmptyOrNullColumns": false,
              "alwaysShowNull": false,
              "displayPrecision": 2,
              "distinct": "",
              "controlState": {
                "relativeHeight": 1,
                "relativeWidth": 1,
                "displayMode": 1,
                "plotOption": 0,
                "preferredChart": "BarChart",
                "rotation": 0,
                "gridFlip": false,
                "chartFlip": false,
                "plotNull": false,
                "legendLeft": false,
                "heatMapState": 0,
                "useLegend": true,
                "trendColumn": -1,
                "trendColumnName": "",
                "showHeatchartLabels": true,
                "rotateCategoricalLabels": true,
                "axisOnTicks": false,
                "highTickCount": false,
                "pieLabelOnly": false,
                "pieLabelPercent": false,
                "datapointPalette": false,
                "stepLines": false,
                "multiLineAxis": false,
                "horizontalLegend": false,
                "reverseCategoricalAxis": false,
                "radarAreaChart": false,
                "forcedPercentageHeatmap": false,
                "plotRegression": false
              },
              "zoomState": false,
              "xlTemplate": "",
              "xlSheet": "Sheet1",
              "xlOffset": 0,
              "displayControl": "DataGridGraphControl",
              "serializedAPI": {
                "apiCall": {
                  "method": "GenProfile",
                  "project": "eyeota-incremental",
                  "name": "profile",
                  "showEmptyOrNullRows": false,
                  "hideTotals": false,
                  "hideNullCategory": false,
                  "showNullAsZero": false,
                  "favorInteger": false,
                  "showEmptyOrNullColumns": false,
                  "alwaysShowNull": false,
                  "extendedTotals": false,
                  "displayPrecision": 2,
                  "profilePercentColumn": false,
                  "distinct": "",
                  "zscore": false,
                  "limitRows": 0,
                  "processOrder": 0,
                  "modelTimeout": 180000,
                  "limitColumns": 0,
                  "rowLimitMode": 0,
                  "columnLimitMode": 0,
                  "sortOn": 0,
                  "sortMode": 1,
                  "sortColumn": -1,
                  "percentType": 0,
                  "measures": [
                    {
                      "name": "sum records",
                      "field": {
                        "type": "field",
                        "name": "DailyLoad.records",
                        "table": "DailyLoad",
                        "valueFilter": []
                      },
                      "function": "sum",
                      "postFunction": "",
                      "countAtTable": "",
                      "distinct": "",
                      "axis": 0,
                      "plot": true,
                      "seriesType": "Default",
                      "calloutMode": "Default",
                      "prefix": ""
                    }
                  ],
                  "fields": [
                    {
                      "type": "field",
                      "name": "DailyLoad.type",
                      "table": "DailyLoad",
                      "valueFilter": []
                    }
                  ]
                },
                "apiType": "AGenProfile"
              }
            },
            "tags": [],
            "users": [],
            "groups": []
          },
          "title": "Segment Type",
          "state": {
            "relativeHeight": 1,
            "relativeWidth": 1,
            "displayMode": 1,
            "plotOption": 0,
            "preferredChart": "BarChart",
            "rotation": 0,
            "gridFlip": false,
            "chartFlip": false,
            "plotNull": false,
            "legendLeft": false,
            "heatMapState": 0,
            "useLegend": true,
            "trendColumn": -1,
            "trendColumnName": "",
            "showHeatchartLabels": true,
            "rotateCategoricalLabels": true,
            "axisOnTicks": false,
            "highTickCount": false,
            "pieLabelOnly": false,
            "pieLabelPercent": false,
            "datapointPalette": false,
            "stepLines": false,
            "multiLineAxis": false,
            "horizontalLegend": false,
            "reverseCategoricalAxis": false,
            "radarAreaChart": false,
            "forcedPercentageHeatmap": false,
            "plotRegression": false
          }
        }
      ],
      "xlTemplate": "",
      "xlSheet": "Sheet1",
      "xlLocalTemplateFile": "",
      "xlOffset": 0
    },
    "isTemp": false,
    "project": "eyeota-incremental"
  },
  {
    "method": "AddToCollection",
    "overwrite": true,
    "name": "Historic Segment Type",
    "description": "Profile AudienceReport.type\r\nShowing sum of AudienceReport.records\r\nSorting by Descending Value for Row and Column on Column 0",
    "type": "DJExplorer.FProfileControl",
    "tags": [
      ""
    ],
    "users": [],
    "groups": [],
    "collection": "REPORTS",
    "definition": {
      "version": 2,
      "fields": [
        {
          "type": "field",
          "name": "LoadHistory.type",
          "table": "LoadHistory",
          "valueFilter": []
        }
      ],
      "dataSet": {
        "logic": "or",
        "name": "SubSet",
        "strict": true,
        "set": []
      },
      "function": 1,
      "postFunction": "",
      "measure": "LoadHistory.records",
      "sortMode": 1,
      "sortColumn": -1,
      "sortOn": 0,
      "zscore": false,
      "percentType": 0,
      "limitRows": 0,
      "limitColumns": 0,
      "rowLimitMode": 0,
      "columnLimitMode": 0,
      "showEmptyOrNullRows": false,
      "hideTotals": false,
      "hideNullCategory": false,
      "showNullAsZero": false,
      "favorInteger": false,
      "extendedTotals": false,
      "showEmptyOrNullColumns": false,
      "alwaysShowNull": false,
      "displayPrecision": 2,
      "distinct": "",
      "controlState": {
        "relativeHeight": 0,
        "relativeWidth": 0,
        "displayMode": 2,
        "plotOption": 0,
        "preferredChart": "BarChart",
        "rotation": 0,
        "gridFlip": false,
        "chartFlip": false,
        "plotNull": false,
        "legendLeft": false,
        "heatMapState": 0,
        "useLegend": true,
        "trendColumn": -1,
        "trendColumnName": "",
        "showHeatchartLabels": true,
        "rotateCategoricalLabels": true,
        "axisOnTicks": false,
        "highTickCount": false,
        "pieLabelOnly": false,
        "pieLabelPercent": false,
        "datapointPalette": false,
        "stepLines": false,
        "multiLineAxis": false,
        "horizontalLegend": false,
        "reverseCategoricalAxis": false,
        "radarAreaChart": false,
        "forcedPercentageHeatmap": false,
        "plotRegression": false
      },
      "zoomState": false,
      "xlTemplate": "",
      "xlSheet": "Sheet1",
      "xlOffset": 0,
      "displayControl": "DataGridGraphControl",
      "serializedAPI": {
        "apiCall": {
          "method": "GenProfile",
          "project": "eyeota-incremental",
          "name": "profile",
          "showEmptyOrNullRows": false,
          "hideTotals": false,
          "hideNullCategory": false,
          "showNullAsZero": false,
          "favorInteger": false,
          "showEmptyOrNullColumns": false,
          "alwaysShowNull": false,
          "extendedTotals": false,
          "displayPrecision": 2,
          "profilePercentColumn": false,
          "distinct": "",
          "zscore": false,
          "limitRows": 0,
          "processOrder": 0,
          "modelTimeout": 180000,
          "limitColumns": 0,
          "rowLimitMode": 0,
          "columnLimitMode": 0,
          "sortOn": 0,
          "sortMode": 1,
          "sortColumn": -1,
          "percentType": 0,
          "measures": [
            {
              "name": "sum records",
              "field": {
                "type": "field",
                "name": "LoadHistory.records",
                "table": "LoadHistory",
                "valueFilter": []
              },
              "function": "sum",
              "postFunction": "",
              "countAtTable": "",
              "distinct": "",
              "axis": 0,
              "plot": true,
              "seriesType": "Default",
              "calloutMode": "Default",
              "prefix": ""
            }
          ],
          "fields": [
            {
              "type": "field",
              "name": "LoadHistory.type",
              "table": "LoadHistory",
              "valueFilter": []
            }
          ]
        },
        "apiType": "AGenProfile"
      }
    },
    "isTemp": false,
    "project": "eyeota-incremental"
  }
]



Was this article helpful?