- Auth
- Accounts
- First call
- Reporting
- DSP report
- Sponsored ads V3
- Sponsored ads V2
- Snapshots
- Sponsored Products
- Sponsored Display
- Sponsored Brands
- Test accounts
- Amazon Marketing Stream
- Amazon Marketing Cloud
- Administration
- Accounts
- Instances
- Create an instance
- List all instances
- List information about the requested instance
- Update instance details
- Update AWS account metadata in the requested instance
- List advertisers in instance
- Create advertiser update
- Get advertiser update
- Gets advertiser information about the requested AMC instance
- Delete AMC instance
- Reporting
- Workflows
- Schedules
- Workflow executions
- AMC Audiences
- Rule-based audiences
- Creates query based audience execution metadata information
- Get all query based audiences execution metadata.
- Get query based audience execution metadata for a given audienceExecutionId.
- Update query based audience execution metadata for a given audienceExecutionId.
- Delete query based audience execution metadata for a given audienceExecutionId.
- Lookalike audiences
- Rule-based audiences
- Sponsored Products
- Sponsored Brands
- Campaigns
- Ad groups
- Ads
- Targeting
- Recommendations
- Theme targeting
- Create keywords
- Update keyword
- Get keyword
- Delete keyword
- Create negative keywords
- Update negative keyword
- Get negative keyword
- Delete negative keyword
- Create product targets
- Update a product target
- Get product target
- Delete product target
- Create negative product target
- Update negative product target
- Get negative product target
- Delete negative product target
- Get all categories
- Get category refinements
- Ad creatives
- Get brands
- Get landing page ASINS
- Sponsored Display
- Stores
- Product metadata
- Budget rules
- Budget usage
- Creative asset library
- Locations
- Exports
- Sponsored TV
- Amazon DSP
- Partner opportunities
List all workflows in a specific instance
GET
/amc/reporting/{{instanceId}}/workflows
最后修改时间：2025-03-16 02:19:30
责任人：未设置
请求参数
Query 参数
nextToken
string
必需
limit
string
必需
Header 参数
Amazon-Advertising-API-ClientId
string
必需
示例值:
{{client_id}}
Amazon-Advertising-API-MarketplaceId
string
必需
示例值:
{{marketplace_id}}
Amazon-Advertising-API-AdvertiserId
string
必需
示例值:
{{advertiser_id}}
Authorization
string
必需
示例值:
Bearer {{access_token}}
示例代码
Shell
JavaScript
Java
Swift
Go
PHP
Python
HTTP
C
C#
Objective-C
Ruby
OCaml
Dart
R
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location -g --request GET 'https://advertising-api.amazon.com/amc/reporting/{{instanceId}}/workflows?nextToken=&limit=' \
--header 'Amazon-Advertising-API-ClientId: {{client_id}}' \
--header 'Amazon-Advertising-API-MarketplaceId: {{marketplace_id}}' \
--header 'Amazon-Advertising-API-AdvertiserId: {{advertiser_id}}' \
--header 'Authorization: Bearer {{access_token}}'返回响应
🟢200List all workflows in a specific instance
application/json
Body
workflows
array [object {5}]
必需
inputParameters
array [object {4}]
必需
sqlQuery
string
必需
workflowId
string
必需
outputColumns
array [object {3}]
必需
query
object
必需
示例
{
"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"
}
},
"secondValue": {
"type": "Column",
"column": "user_id"
}
},
"name": "CalculateFrequency",
"outputColumn": "frequency"
},
{
"type": "DropColumns",
"columns": [
"user_id",
"impressions"
],
"name": "DropIntermediateColumns"
}
]
},
"workflowId": "standard_frequency"
},
{
"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": "STRING",
"name": "frequency_buckets"
},
{
"columnType": "DIMENSION",
"dataType": "LONG",
"name": "users_in_bucket"
}
],
"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",
"name": "SumMetrics"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "LessThan",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "10"
}
},
"falseValue": {
"type": "Literal",
"columnType": "DIMENSION",
"dataType": "STRING",
"value": "frequency_10+"
},
"trueValue": {
"type": "Concatenate",
"values": [
{
"type": "Literal",
"columnType": "DIMENSION",
"dataType": "STRING",
"value": "frequency_"
},
{
"type": "Column",
"column": "impressions"
}
]
}
},
"name": "DefineFrequencyBuckets",
"outputColumn": "frequency_buckets"
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"columnAggregationTypes": {
"user_id": "COUNT_DISTINCT"
},
"name": "CountUsersInBuckets"
},
{
"type": "RenameColumns",
"inputColumns": [
"user_id"
],
"name": "Rename",
"outputColumns": [
"users_in_bucket"
]
},
{
"type": "DropColumns",
"columns": [
"impressions"
],
"name": "DropIntermediateColumns"
}
]
},
"workflowId": "standard_frequency-buckets"
},
{
"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": "STRING",
"name": "browser_family"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"browser_family",
"impressions"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
}
]
},
"workflowId": "standard_impressions-by-browser-family"
},
{
"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": "STRING",
"name": "device_type"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"device_type",
"impressions"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
}
]
},
"workflowId": "standard_impressions-by-device-type"
},
{
"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": "STRING",
"name": "dma_code"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"dma_code",
"impressions"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
}
]
},
"workflowId": "standard_impressions-by-dma"
},
{
"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": "STRING",
"name": "operating_system"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"operating_system",
"impressions"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
}
]
},
"workflowId": "standard_impressions-by-operating-system"
},
{
"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": "STRING",
"name": "site"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "supply_source"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"site",
"supply_source",
"impressions"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"name": "rename",
"outputColumns": [
"date"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
}
]
},
"workflowId": "standard_impressions-by-site-and-supply-source"
},
{
"outputColumns": [
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
},
{
"columnType": "DIMENSION",
"dataType": "INTEGER",
"name": "hour"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "entity_id"
},
{
"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": "LONG",
"name": "line_item_id"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "line_item"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "line_item_type"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "line_item_start_date"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "line_item_end_date"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "clicks"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "supply_cost"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "audience_fee"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "third_party_fees"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "platform_fee"
},
{
"columnType": "METRIC",
"dataType": "DOUBLE",
"name": "total_cost"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"impression_hour",
"entity_id",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"line_item_id",
"line_item",
"line_item_type",
"line_item_start_date",
"line_item_end_date",
"impressions",
"supply_cost",
"audience_fee",
"third_party_fees",
"platform_fee",
"total_cost",
"request_tag"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date",
"impression_hour"
],
"outputColumns": [
"date",
"hour"
]
},
{
"type": "Join",
"firstKeyColumns": [
"request_tag"
],
"joinType": "LEFT",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"optional": false,
"secondIncludedColumns": [
"clicks"
],
"secondInputData": "dsp_clicks",
"secondKeyColumns": [
"request_tag"
]
},
{
"type": "DropColumns",
"columns": [
"request_tag"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"name": "SumMetrics"
},
{
"type": "Select",
"columns": [
"date",
"hour",
"entity_id",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"line_item_id",
"line_item",
"line_item_type",
"line_item_start_date",
"line_item_end_date",
"impressions",
"clicks",
"supply_cost",
"audience_fee",
"third_party_fees",
"platform_fee",
"total_cost"
],
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S"
}
]
},
"workflowId": "standard_intraday-delivery"
},
{
"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": "LONG",
"name": "reach"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"user_id"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S",
"name": "select_impressions"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date",
"user_id"
],
"name": "Rename",
"outputColumns": [
"date",
"reach"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"columnAggregationTypes": {
"reach": "COUNT_DISTINCT"
},
"name": "SumMetrics"
}
]
},
"workflowId": "standard_reach"
},
{
"outputColumns": [
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
},
{
"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": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "LONG",
"name": "reach"
},
{
"columnType": "DIMENSION",
"dataType": "DOUBLE",
"name": "average_frequency"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_1"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_2"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_3"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_4"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_5"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_6"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_7"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_8"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_9"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_10"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_11"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_12"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_13"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_14"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_15"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_16"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_17"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_18"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_19"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_20"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_over_20"
}
],
"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"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"outputColumns": [
"date"
]
},
{
"type": "Column",
"expression": {
"type": "Column",
"column": "user_id"
},
"outputColumn": "reach"
},
{
"type": "Aggregate",
"aggregationType": "SUM"
},
{
"type": "Column",
"expression": {
"type": "Column",
"column": "impressions"
},
"outputColumn": "average_frequency"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "1"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_1"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "2"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_2"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "3"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_3"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "4"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_4"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "5"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_5"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "6"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_6"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "7"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_7"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "8"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_8"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "9"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_9"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "10"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_10"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "11"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_11"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "12"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_12"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "13"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_13"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "14"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_14"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "15"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_15"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "16"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_16"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "17"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_17"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "18"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_18"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "19"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_19"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "20"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_20"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "GreaterThan",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "20"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_over_20"
},
{
"type": "DropColumns",
"columns": [
"user_id"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"columnAggregationTypes": {
"average_frequency": "AVERAGE",
"reach": "COUNT_DISTINCT"
}
},
{
"type": "Column",
"expression": {
"type": "Classify",
"columnType": "DIMENSION",
"value": {
"type": "Column",
"column": "average_frequency"
}
}
},
{
"type": "Select",
"columns": [
"date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"impressions",
"reach",
"average_frequency",
"frequency_1",
"frequency_2",
"frequency_3",
"frequency_4",
"frequency_5",
"frequency_6",
"frequency_7",
"frequency_8",
"frequency_9",
"frequency_10",
"frequency_11",
"frequency_12",
"frequency_13",
"frequency_14",
"frequency_15",
"frequency_16",
"frequency_17",
"frequency_18",
"frequency_19",
"frequency_20",
"frequency_over_20"
],
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S"
}
]
},
"workflowId": "standard_reach-frequency"
},
{
"outputColumns": [
{
"columnType": "DIMENSION",
"dataType": "DATE",
"name": "date"
},
{
"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": "LONG",
"name": "line_item_id"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "line_item"
},
{
"columnType": "DIMENSION",
"dataType": "STRING",
"name": "line_item_type"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "line_item_start_date"
},
{
"columnType": "DIMENSION",
"dataType": "TIMESTAMP",
"name": "line_item_end_date"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "impressions"
},
{
"columnType": "DIMENSION",
"dataType": "LONG",
"name": "reach"
},
{
"columnType": "DIMENSION",
"dataType": "DOUBLE",
"name": "average_frequency"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_1"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_2"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_3"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_4"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_5"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_6"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_7"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_8"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_9"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_10"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_11"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_12"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_13"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_14"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_15"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_16"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_17"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_18"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_19"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_20"
},
{
"columnType": "METRIC",
"dataType": "LONG",
"name": "frequency_over_20"
}
],
"query": {
"operations": [
{
"type": "Select",
"columns": [
"impression_date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"line_item_id",
"line_item",
"line_item_type",
"line_item_start_date",
"line_item_end_date",
"impressions",
"user_id"
],
"inputData": "dsp_impressions",
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S"
},
{
"type": "RenameColumns",
"inputColumns": [
"impression_date"
],
"outputColumns": [
"date"
]
},
{
"type": "Column",
"expression": {
"type": "Column",
"column": "user_id"
},
"outputColumn": "reach"
},
{
"type": "Aggregate",
"aggregationType": "SUM"
},
{
"type": "Column",
"expression": {
"type": "Column",
"column": "impressions"
},
"outputColumn": "average_frequency"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "1"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_1"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "2"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_2"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "3"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_3"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "4"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_4"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "5"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_5"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "6"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_6"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "7"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_7"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "8"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_8"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "9"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_9"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "10"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_10"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "11"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_11"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "12"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_12"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "13"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_13"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "14"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_14"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "15"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_15"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "16"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_16"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "17"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_17"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "18"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_18"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "19"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_19"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "Equals",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "20"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_20"
},
{
"type": "Column",
"expression": {
"type": "IfElse",
"condition": {
"type": "GreaterThan",
"firstValue": {
"type": "Column",
"column": "impressions"
},
"secondValue": {
"type": "Literal",
"value": "20"
}
},
"falseValue": {
"type": "Literal",
"value": "0"
},
"trueValue": {
"type": "Literal",
"columnType": "METRIC",
"dataType": "LONG",
"value": "1"
}
},
"outputColumn": "frequency_over_20"
},
{
"type": "DropColumns",
"columns": [
"user_id"
]
},
{
"type": "Aggregate",
"aggregationType": "SUM",
"columnAggregationTypes": {
"average_frequency": "AVERAGE",
"reach": "COUNT_DISTINCT"
}
},
{
"type": "Column",
"expression": {
"type": "Classify",
"columnType": "DIMENSION",
"value": {
"type": "Column",
"column": "average_frequency"
}
}
},
{
"type": "Select",
"columns": [
"date",
"advertiser_id",
"advertiser",
"campaign_id",
"campaign",
"campaign_start_date",
"campaign_end_date",
"line_item_id",
"line_item",
"line_item_type",
"line_item_start_date",
"line_item_end_date",
"impressions",
"reach",
"average_frequency",
"frequency_1",
"frequency_2",
"frequency_3",
"frequency_4",
"frequency_5",
"frequency_6",
"frequency_7",
"frequency_8",
"frequency_9",
"frequency_10",
"frequency_11",
"frequency_12",
"frequency_13",
"frequency_14",
"frequency_15",
"frequency_16",
"frequency_17",
"frequency_18",
"frequency_19",
"frequency_20",
"frequency_over_20"
],
"maxTimeAfterWindow": "PT0S",
"maxTimeBeforeWindow": "PT0S"
}
]
},
"workflowId": "standard_reach-frequency-by-line-item"
}
]
}