Bazaarvioce

Reporting:

1. Open Bazaarvoice
2. Click on the [CTA] "Workbench", which will forward you to the https://workbench-c2.bazaarvoice.com/portal/app
3. Click on the [CTA] "Dashboard", which will forward you to the https://reporting.portal.bazaarvoice.com/dashboards/index?currentDashboard=programSummaryDashboard
4. Select Attributes:
   1. Open the [Dropdown] "Date Range"
   2. Select the relevant date range
   3. Open the [Dropdown] "Product Status"
   4. Select [List-Item] "All"
   5. Open the [Dropdown] "Moderations Status"
   6. Select [List-Item] "All"
   7. Open the [Dropdown] "Display Code"
   8. Select [List-Item] "All"
   9. Open the [Dropdown] "Root Category"
   10. Select [List-Item] "All"
   11. Open the [Dropdown] "Sub Category"
   12. Select [List-Item] "All"
   13. Open the [Dropdown] "Category Path"
   14. Select [List-Item] "All"
   15. Open the [Dropdown] "Brand"
   16. Select [List-Item] "All"
   17. Open the [Dropdown] "Display Local"
   18. Select [List-Item] "de_DE"
5. Write data into the spreadsheet with the following attributes:
   1. [Attribute] "Year" in YYYY
   2. [Attribute] "Month" in MM_Mmm (exp.: 01_Jan)
   3. [Attribute] "Native Reviews"
   4. [Attribute] "Social Ads [Reviews]" you get this form the Adsmanager
6. Write data into the presentation with the following attributes:
   1. [Attribute] "Number of reviews"
   2. [Attribute] "Average rating"
   3. [Attribute] "% 4+ Star Reviews"
   4. [Bar Chart] "Ratings in %" for [Rating] "5 Star", [Rating] "4 Star",[Rating] "3 Star",[Rating] "2 Star",[Rating] "1 Star"
   5. [Column Chart] "Native Reviews" for each month of the relevant date range & the previous period
   6. [Column Chart] "Native Reviews" + "Budget" for each month of the relevant date range
7. Write summary for each chart
8. Write conclusion