Skip to content

Instantly share code, notes, and snippets.

@djspiewak
Created May 7, 2020 15:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save djspiewak/e4603042c4cd34c6635c8ba0948daae4 to your computer and use it in GitHub Desktop.
Save djspiewak/e4603042c4cd34c6635c8ba0948daae4 to your computer and use it in GitHub Desktop.
{
"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