How Our Insights Boosted Monthly Revenue by 12%
One of the most important KPI is Users.By tracking the performance of this metric, we get time-series data.
- It’s clear that there is a day-of-the-week effect. To remove this effect, use a 7-day rolling average. Then we can explicitly see the moving trend of Users.
- Anomaly Detection is a commonly used method in time-series analysis. Orange points in this plot are identified as anomaly points by using Anomaly Detection (STL + IQR methods for the situation that seasonality is not a major factor). Grey area covers 95% of all data points. Points out of this area are identified as anomalies.
- For each anomaly point, we will break Users down to several segments to figure out which specific part has caused this positive/negative change. This can help with decision making in the next step. For example in 2019-07-04, we only had 673 Users which was below the minimum. After comparing the Cost Composition Trend, we figured out that the cost/budget had a reduction in 2019-07-04, which also shows that PPC really drives the website traffic.
Geographic dataIt can also be used to identify the most profitable area of marketing.
The other and most important insight was in regards to devices and browsers.Our data visualization made it very clear that, although users browse on mobile and desktop devices (Converters: 10.7% + 85.1% = 95.8%, Non-Converters: 16.8% + 78.2% = 95%), Converters mainly use Windows desktop devices and Bing as a browser. Since the mobile usability tested positive against responsive testing, it indicates that purchases like this are searched by employees with no buying power. However, it also shows that they are the ones who make recommendations to the higher authorities in the office and they are the ones who place the order. Which aligns with our previous hypothesis. (For this pie chart, it only visualized data from 2019-01-01 to 2019-03-31) We have done further research on users’ data which added more insights to the above section and helped our client use all of this information to come up with a better strategy. Moving on to the most important dimension where all the hidden answers exist which is PPC.
PPC (Pay-per-click)For PPC insights in this case study, we have only used data from Google Adwords for the period of 2019. Here is an example of the data visualization that we have done to better understand data distribution and data points. Consistent monitoring of KPIs, experimenting with new tactics and making comparisons are key points for getting insights for PPC decision making. Cost Compositions: Clicks & CPC Daily Trend for All Campaigns’ Data
- It’s clear that there is a day-of-the-week effect on these 3 metrics: Cost, Clicks, CPC. To remove this effect, use a 7-day rolling average.
- Next, we want to figure out if there is something that might drive themoving ofClicks. For this purpose, we focus on several campaigns to get insights -going_down, going_up and flat CPC trends.
Campaign Clustering by the trend of CPCWe want to cluster campaigns by CPC trending because CPC implicitly tells the performance of PPC. Here is the Sunburst Charts for Campaigns (w/ Clicks & Cost share) clustered by CPC trends.
- Campaigns with going up trends generate 39.46% of the PPC clicks and consist 59.99% of ad cost.
- Campaigns with flat trends generate 35.52% of the PPC clicks and consist 24.6% of ad cost.
Top Clicks Campaign & Cost Composition Trends
- The following plots show the basic strategy behind how we made data-driven decisions by tracking key metrics for PPC.
- Notice: Gaps in the following plot mean the stop of this campaign.
- As you can see, after CPC gets optimized it tends to flatten. Upon increasing the budget (cost), the number of Clicks will increase and keep a stable trend. If CPC increases, we can investigate and optimize further.
- By keeping the same amount of budget and tracking CPC, we can gain insights into the performance of our ad campaign optimization. Then, we will get back to our content team to optimize quality score. That’s the reason why we want to track and optimize CPC.
Campaign Performance Metrics
Clicks & Cost: TreemapCPC and CTR In order to compare the campaign performance, we have to look at campaign groups by CPC trends.
“Smartboost team is extremely customer-oriented, always on point in terms of understanding our needs and delivering what we expected. They help us to generate comprehensive and actionable data visualization from past data, CRM, Kentico and Google Analytics.”