1 of 27

Bonami & Google Data Studio

Campaign evaluation and reporting in our company

2 of 27

  • Ecommerce: furniture, interior design
  • Since 2013
  • Eshop & inspiration
  • 9 countries
  • More than 50 000 products
  • Online & stores

3 of 27

4 of 27

Company level

5 of 27

Team level

6 of 27

Actual month situation overview

  • Setting up clear expectations for the team
  • Easy check up of the current situation

7 of 27

Google sheet connection

Data blending

8 of 27

*tip

=((DAY(TODAY()))-1)

=(today/number of days in month)*100

=DAY(EOMONTH(TODAY();0))

9 of 27

Teams cooperation

10 of 27

Product problem solving

  • Long lasting problems which needs action from another team

​

  • Explains and shows the problems to someone who does not understand how it affects performance

​

  • Always on

11 of 27

12 of 27

13 of 27

Specialist level

14 of 27

Basic overview for last day

  • Everyday morning routine

​

  • Getting used to what is “normal” in the accounts

15 of 27

Month expectations

16 of 27

*tip

=LOOKUP(MONTH(A2),Sheet1!$A$2:$B$13,Sheet1!$B$2:$B$13)/day(EOMONTH(A2,0))

=LOOKUP(MONTH(A2),Sheet1!$A$2:$C$13,Sheet1!$C$2:$C$13)/day(EOMONTH(A2,0))

17 of 27

Graphs

18 of 27

All campaigns overview

19 of 27

Shopping

& feed

  • General overview of the feed quality
  • Pointing out weak categories for further changes

20 of 27

To share

21 of 27

22 of 27

23 of 27

24 of 27

25 of 27

26 of 27

27 of 27

https://datastudio.google.com/reporting/43a1ac49-d2b7-4ced-b978-431a8096841f