soultree's product ad report
DESCRIPTION
Find out how SoulTree's product ads deliver. A comparison with Google Product Listing Ads vs. Facebook Multi-Product AdsTRANSCRIPT
-
SOULTREE PRODUCT AD REPORTMARCH 18TH TO JUNE 15TH(90 DAYS)
-
0.00
5,000.00
10,000.00
15,000.00
20,000.00
25,000.00
0
50000
100000
150000
200000
250000
300000
350000
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
Expe
nditu
re
Sale
s
Days
Month-on-Month Sales and Expenditure (cumulative)
First Month Second Month Third Month First month expenditure Second month expenditure Third month expenditure
Comparison of Sales and Expenditure on a month-on-month basis
The three month period shown here is indicative of the fact that the sales have risen drastically in the third month owing to an increase in the ad expenditure. Closer inspection of the data reveals that mild deviations in the expenditure is reflected in the sales figure.
The sales figure in the second period of 30 days is seen to flatten out initially but quickly gains pace towards the end when COD is introduced. The ad spend around this period is seen to rise because of the introduction of google ads.
These two new additions led to a massive growth in sales leading into the third period with sales more than twice the amount seen in the first and second periods.
COD introduced
Google ads introduced
-
0.00
5.00
10.00
15.00
20.00
25.00
0.00
200.00
400.00
600.00
800.00
1,000.00
1,200.00
1,400.00
1,600.00
Expenditure and ROI
7 per. Mov. Avg. (expenditure) 7 per. Mov. Avg. (ROI)
Comarison of ROI and Expenditure
This graph gives a very clear picture that ROI is correlated to the amount spent on ads.
A dip in ad expenditure leads to a deep fall in ROI, where as once expenditure is increased, we see ROI rise.
Ads were paused in the interval where one sees a sharp fall in expenditure leading to a sharp fall inb ROI as expected. Once the ads are resumed, the ROI shoots up again.
DIp in expenditure leads to a fall in ROI
Once Expenditure is boosted again, the ROI
increases again.
Ads paused
-
0.6
0.65
0.7
0.75
0.8
0.85
0.9
0.95
1
1.05
Sun Mon Tue Wed Thu Fri Sat
Expenditure and Sales based on day of week(Normalised graph for camparison)
Expenditure Sales Items Sold
Expenditure and sales based on day of week
We plot day wise sales and expenditure over a course of 90 days.
The graph is normalised to bring all the 3 figures on the same level and should NOT be mistaken for the actual values.
This plot shows a very strong trend wherein customers mostly buy the products towards the end of the week with maximum on saturday.
-
-200
0
200
400
600
800
1000
1200
1400
-20 0 20 40 60 80 100 120
Face
book
exp
endi
ture
Google Expenditure
Sales compared to Facebook and Google ad expenditureFacebook and Google ad expenditure compared to Sales
We plot day wise facebook and google ad expenditures and campare it to the daily sales. Bubble sizes indicate sales.
This plot shows to impact of Facebook and Google ads on the sales. The plot shows when google and facebook ad expenditures are both high, the sales are the highest. Even either one is at a low and the other is high, still, the outcome isnt that high when compared to a balanced approach to both.