Created
May 7, 2020 15:05
-
-
Save djspiewak/e4603042c4cd34c6635c8ba0948daae4 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"62aece90-ed59-4066-a038-3314cac47126": { | |
"name": "Campaigns Daily Stats", | |
"description": { | |
"table": { | |
"steps": [ | |
{ | |
"act": { | |
"tag": "attachAll", | |
"value": { | |
"tag": "source", | |
"value": "8c46f820-ff6e-4dee-b775-b7dac002372f" | |
} | |
}, | |
"sxv": "v31.2.2" | |
}, | |
{ | |
"act": { | |
"tag": "freeze" | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_web_push_sent" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "web_push_sent" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "00da7188-6532-4fe6-9e54-f0da77c10f58" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_web_push_errored" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "web_push_errored" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "ffcf88bf-aaca-4eaa-8045-48381b7c5b4c" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_sms_sent" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "sms_sent" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "c64a8f8b-eaa7-4ed7-8320-611465d9b607" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_sms_errored" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "sms_errored" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "4c8669a2-2360-4d1a-9142-628112504fb1" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_ios_push_sent" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "ios_push_sent" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "79a0b26a-a4d1-411d-9889-4ccdb47781b7" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_ios_push_errored" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "ios_push_errored" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "a96bba38-3421-4f1b-a325-8f526ded8412" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_email_sent" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "email_sent" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "21abd901-1644-4ae6-ba3c-2254f9cea819" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_email_errored" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "email_errored" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "f8f069c6-81fb-435f-86f6-eb9d575506a1" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_android_push_sent" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "android_push_sent" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "b2b9daba-5b0b-42df-bd5d-f15a7af3ee09" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_android_push_errored" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
} | |
}, | |
"key": "android_push_errored" | |
} | |
} | |
}, | |
"scalar": "Number" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "19626a7c-2f23-4a49-ae71-4de48086b75d" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_keys_1" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "shiftKeys", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "shiftMap", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
} | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "f3c076f7-b0d7-4b55-95fc-5ae2e9363211" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "stats_keys" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [], | |
"proj": { | |
"tag": "shiftKeys", | |
"value": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "stats" | |
} | |
} | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "0b7d4161-3a35-49c2-b4cd-19af65ce6d1b" | |
} | |
}, | |
"sxv": "v30.0.9" | |
}, | |
{ | |
"act": { | |
"tag": "addColumn", | |
"value": { | |
"alias": { | |
"dynamic": "date" | |
}, | |
"content": { | |
"tag": "pick", | |
"value": { | |
"tag": "extract", | |
"value": { | |
"interp": [ | |
{ | |
"tag": "stringToISODatetime" | |
} | |
], | |
"proj": { | |
"tag": "atType", | |
"value": { | |
"cursor": { | |
"tag": "Just", | |
"value": { | |
"tag": "atKey", | |
"value": { | |
"cursor": { | |
"tag": "Nothing" | |
}, | |
"key": "date" | |
} | |
} | |
}, | |
"scalar": "String" | |
} | |
}, | |
"resource": { | |
"dataSource": "60f0659a-1d04-4abc-8326-c4e5224c058c", | |
"path": "/**", | |
"resourceType": "aggregate" | |
} | |
} | |
} | |
}, | |
"id": "c70b41a9-695b-4e88-8839-c55b88c51329" | |
} | |
}, | |
"sxv": "v30.0.9" | |
} | |
] | |
} | |
} | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment