Reduce marketing Marketing ROI cost per lead Sum (lead_cost) / costs Count (Lead_ID) MQL/SQL ratio: Count (Lead_ID) (Marketing qualified leads vs. Sales where MQL date in last month qualified leads) Divided By Count (Lead_ID) where MQL date in last month and Converted = ‘True’ Mockup - Optional Tables Which data elements will be required for achieving the above KPI’s? # Data Source Type Table Name Content Max # of Fact / Unique Rows Dimension Identifier 1 Salesforce Leads Main Lead table ~ 10M Dim 2 Google Analytics Ad performance per ~ 20M Fact date Constraints This is the place to mention any general constraints you may have on your analysis and limitation in terms of the data model (Data Security, Frequency of Use, Fiscal year etc) ... ...
Reduce marketing costs Marketing ROI cost per lead Sum (lead_cost) / Count (Lead_ID) MQL/SQL ratio: (Marketing qualified leads vs. Sales qualified leads) Count (Lead_ID) where MQL date in last month Divided By Count (Lead_ID) where MQL date in last month and Converted = ‘True’ Mockup - Optional Tables Which data elements will be required for achieving the above KPI’s? # Data Source Type Table Name Content Max # of Rows Fact / Dimension Unique Identifier 1 Salesforce Leads Main Lead table ~ 10M Dim 2 Google Analytics Ad performance per date ~ 20M Fact Constraints This is the place to mention any general constraints you may have on your analysis and limitation in terms of the data model (Data Security, Frequency of Use, Fiscal year etc) ... ...
DashboardPlanningDocument_7172016_new.docx