{
"workflows": [
{
"inputParameters": [
{
"dataType": {
"type": "ARRAY",
"elementDataType": "STRING",
"elementNullable": false
},
"defaultValue": [
"ALL"
],
"description": "Enter description for parameter",
"name": "sa_campaigns"
}
],
"sqlQuery": "SELECT campaign, SUM(IMPRESSIONS) AS Impressions FROM sponsored_ads_traffic WHERE ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), 'ALL') OR ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), campaign) GROUP BY 1",
"workflowId": "my-first-workflow-with-custom-parameters"
},
{
"inputParameters": [
{
"dataType": {
"type": "ARRAY",
"elementDataType": "STRING",
"elementNullable": false
},
"defaultValue": [
"ALL"
],
"description": "Enter description for parameter",
"name": "sa_campaigns"
}
],
"sqlQuery": "SELECT campaign, SUM(IMPRESSIONS) AS Impressions FROM sponsored_ads_traffic WHERE ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), 'ALL') OR ARRAY_CONTAINS(CUSTOM_PARAMETER('sa_campaigns'), campaign) GROUP BY 1",
"workflowId": "AAAAA"
},
{
"outputColumns": [
{
"columnType": "DIMENSION",
"dataType": "LONG",
"name": "advertiser_id"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "advertiser"
},
{
"columnType": "DIMENSION",
"dataType": "LONG",
"name": "campaign_id"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "campaign"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "campaign_start_date"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "campaign_end_date"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
},
{
"columnType": "DIMENSION",
"dataType": "DOUBLE",
"name": "frequency"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"impressions",
"user_id"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "Rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"columnAggregationTypes": {
"user_id": "COUNT_DISTINCT"
},
"name": "SumMetrics"
},
{
"type": "Column",
"expression": {
"type": "Divide",
"firstValue": {
"type": "Cast",
"dataType": "DOUBLE",
"value": {
"type": "Column",
"column": "impressions"