………………………………………………………………………………………….

MULTIPLE REGRESSION MODEL FOR DETERMINING BEST ONLINE MKT MIX

A Multiple regression model for determining best online marketing mix. How to determine feasible zones (where sales are more likely to be generated) and forecast sales using an optimization model.

 ………………………………………………………………………………………….

 DATA INTEGRATION

A Brief Introduction on how to integrate online and offline stats ensuring data and trend consistency

 ………………………………………………………………………………………….

TREND ANALYSIS

Few samples of interesting data manipulation and forecasting methodologies for:

• Forecasting techniques: >Trend analysis and Gut Method
• Benchmarking: > client vs. competitors activity and >  analytics vs. ad impressions

 ………………………………………………………………………………………….

DASHBOARD CREATION IN EXCEL

How to become more efficient: collect all your data in a Masterplan document and use Excel Macros to extract daily, weekly, vs. Budget insights stylishly presented on easy to update excel sheets.
Fantastic solution for combining all your data in one dashboard regardless the source!