This article will help you learn about the fields available in the Daily Plan to Actual Marketing view, the field types, descriptions and how the fields are calculated
Key Topics
Click on the links below to take you to the section where you can learn more about this View and where it is used and how it is created
View Definition
This view is linked to the [drp.daily_plan_to_actual_marketing] table which generated as part of the Daasity transformation process and has the following fields available/visible for use.
| Field Name | Field Type | Description | Source / Calculation |
| Plan Date | Dimension Group | The plan date from the Marketing Budget Brand Supplied Data sheet | plan_date |
| Source Shop ID | Dimension | The identifier of the Order Source System | shop_id |
| Store Country | Dimension | Location Name otherwise the Store Type from the Daasity UI (eCommerce, Wholesale, Retail, Amazon, Marketplace, Manual Orders) | store_name |
| Store Integration Name | Dimension | Type selected in the Daasity UI for the Integration | store_type |
| Store Name | Dimension | Country entered in the Daasity UI for the Integration | store_country |
| Store Type | Dimension | The Name from the Location otherwise the name from the Daasity UI | store_integration_name |
| Vendor | Dimension | The Vendor from the Brand Data Marketing Plan | vendor |
| Actual First Click CPA | Measure | Total First Click Cost per Acquisition | SUM(marketing_spend) / NULLIF(SUM(first_click_new_customers),0) |
| Actual First Click Gross Sales | Measure | Total first click gross sales | SUM(first_click_gross_sales) |
| Actual First Click New Customers | Measure | Total first click new customers | SUM(first_click_new_customers) |
| Actual First Click Orders | Measure | Total first click orders | SUM(first_click_first_orders) |
| Actual First Click ROAS | Measure | Total First Click Return on Ad Spend | SUM(first_click_gross_sales) / NULLIF(SUM(marketing_spend),0) |
| Actual Last Click CPA | Measure | Total Last Click Cost per Acquisition | SUM(marketing_spend) / NULLIF(SUM(last_click_new_customers,0) |
| Actual Last Click Gross Sales | Measure | Total last click gross sales | SUM(last_click_gross_sales) |
| Actual Last Click New Customers | Measure | Total last click new customers | SUM(last_click_new_customers) |
| Actual Last Click Orders | Measure | Total last click orders | SUM(last_click_orders) |
| Actual Last Click ROAS | Measure | Total Last Click Return on Ad Spend | SUM(last_click_gross_sales) / NULLIF(SUM(marketing_spend),0) |
| Actual Vendor Reported Gross Sales | Measure | Total vendor reported gross sales | SUM(vendor_reported_gross_sales) |
| Actual Vendor Reported Orders | Measure | Total vendor reported orders | SUM(vendor_reported_orders) |
| Actual Vendor Reported ROAS | Measure | Total Vendor Reported Return on Ad Spend | SUM(vendor_reported_gross_sales) / NULLIF(SUM(marketing_spend),0) |
| Plan CPA | Measure | Planned CPA in Brand Data Marketing Plan | SUM(plan_marketing_spend * plan_cpa) / NULLIF(SUM(plan_marketing_spend),0) |
| Plan Marketing Spend | Measure | Total planned marketing spend | SUM(plan_marketing_spend) |
| Plan ROAS | Measure | Planned ROAS in Brand Data Marketing Plan | SUM(plan_marketing_spend * plan_roas) / NULLIF(SUM(plan_marketing_spend),0) |
Explores
This view is part of the following explores:
- Daily Marketing Plan to Actual Marketing Performance
Transformation Code
This view is a Daasity derived table generated by the following code:
- [4402_PFT_BAS_daily_plan_to_actual_marketing.sql]