sample script: eyeota-incremental
- 16 Minutes to read
- Print
- DarkLight
- PDF
sample script: eyeota-incremental
- 16 Minutes to read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
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?