Olesia Stetsiuk posted on July 21st, 2016
In the last blogs, we mostly focused on few universal aspects of business reporting. We discussed data visualisation and storytelling impact on perception and effectiveness of business reports. This time, in order to reach more concrete insights, we will concentrate more on marketing analytics.
We all want techniques and tools we are using in marketing analytics to provide actionable insights. Such available tools as web pivot tables, charts, dashboards etc can benefit business a lot when accurately used. Among commonly used techniques, there are prediction models, decision-making tools, and, apparently, metrics as one of the most valuable instruments. Metrics are business-oriented key performance indicators (KPI), which enable us to monitor business and to evaluate an effect of actions such as a correlation between marketing spending and results.
Just to name a few:
– Evolution of the consumer-marketer relationship.
– Massive and often unstructured marketing and sales data.
– Search-engine algorithms are frequently changing.
– Smartphone adoption will be increasing constantly.
These are only a few challenges marketers are facing. Not to mention working in the situation of reduced resources and high level of global competition. Besides, it seems like one difficulty is eternal. Can you guess which one? It is calculating ROI of marketing activities. There is a famous saying attributed to John Wanamaker illustrating how tough it is to qualify the effect of advertising: “Half the money I spend on advertising is wasted; the trouble is I don’t know which half”. Comparing to the times of Mr Wanamaker situation in latter days is even worse due to the variety of channels, diversity of customer segments, availability of new tools and technologies. And at the same time, current CEOs can not afford such axioms anymore. Actually, executives demand not only descriptive analysis to see the effectiveness of marketing activities post factum but also predictive analytics to make better decisions on allocation of limited resources. To be competitive business needs both diagnostic and predictive information.
Thus, important metrics give CEOs the information they need to pinpoint a real-time state the company. Online pivot tables and dashboards can accumulate KPI and other relevant metrics on a single display for more profound investigation. In widely used Analysis Services, a KPI is a collection of computations, which are linked to a measure group of a cube. And for example, Flexmonster Pivot Table Component can automatically recognize and display all KPIs if OLAP cube includes this information. Main definitions of standard KPI terms in Analysis Services such as Goal, Value, Status, Trend that can be easily shown by our Component.
Such challenges as understanding customer need across several segments, targeting information for the global audience, getting a handle on channels, and complications with data must not prevent any marketer from focusing on revenue impact from marketing. Therefore, getting used to different analytical tools and techniques should become an area for everyday development.