About
This data range report provides details of the collected UTM click collected within your account, and the weighted revenue from the resulting sales.
Learn about UTM here: https://en.wikipedia.org/wiki/UTM_parameters
Report Details
Optional Scheduling Report settings (Click the ‘Schedule Report’ for scheduling options.)
This report has two configurable options:
Date Range
Schedule Report
Report Worksheet and Column Descriptions
The report s composed of 4 worksheets:
source_campaign_and_term
source_and_campaign
source
per order
Source_campaign_and_term Columns
Column | Description |
---|---|
order_id | |
total_clicks | |
total | |
creation_dts | |
utm_source1 | |
utm_campaign1 | |
utm_term1 | |
ts1 | |
click_weight1 | |
click_revenue1 | |
utm_source2 | |
utm_campaign2 | |
utm_term2 | |
ts2 | |
click_weight2 | |
click_revenue2 | |
utm_source3 | |
utm_campaign3 | |
utm_term3 | |
ts3 | |
click_weight3 | |
click_revenue3 | |
utm_source4 | |
utm_campaign4 | |
utm_term4 | |
ts4 | |
click_weight4 | |
click_revenue4 | |
utm_source5 | |
utm_campaign5 | |
utm_term5 | |
ts5 | |
click_weight5 | |
click_revenue5 |
Source_and_campaign columns
Column | Description |
---|---|
utm_source | |
utm_campaign | |
weighted_revenue | |
total_click_count | |
conversion_click_count | |
middle_of_funnel_click_count | |
top_of_funnel_click_count |
Source worksheet columns
Column | Description |
---|---|
utm_source | |
weighted_revenue | |
total_click_count | |
conversion_click_count | |
middle_of_funnel_click_count | |
top_of_funnel_click_count |
Per order worksheet columns
Column | Description |
---|---|
order_id | |
total_clicks | |
total | |
creation_dts | |
utm_source1 | |
utm_campaign1 | |
utm_term1 | |
ts1 | |
click_weight1 | |
click_revenue1 | |
utm_source2 | |
utm_campaign2 | |
utm_term2 | |
ts2 | |
click_weight2 | |
click_revenue2 | |
utm_source3 | |
utm_campaign3 | |
utm_term3 | |
ts3 | |
click_weight3 | |
click_revenue3 | |
utm_source4 | |
utm_campaign4 | |
utm_term4 | |
ts4 | |
click_weight4 | |
click_revenue4 | |
utm_source5 | |
utm_campaign5 | |
utm_term5 | |
ts5 | |
click_weight5 | |
click_revenue5 |