MARK3085 Digital Marketing & Web Analytics
Assessment 1 Instructions
Lecturer: Lidy Romijnders
Online Dashboard
• Assignment Instructions
• Demo
• Tips
• Data Visualisation Tips
• Inspirational Dashboard examples
Online Dashboard Instructions
• Company: Beachvolleyball.com.au
• Task: create an Online Dashboard using Google’s LookerStudio to visualise
and comment on the findings related to the 10 assignment questions
• Steps:
• Login to Google Looker Studio
• Create a new blank report
• Connect Excel Data source (all sheets) with Looker Studio. Assign correct field value
types to each Dimension and Metric. > see instruction video on Moodle
• Use tables, charts, scorecards, and text blocks to create report. Consider which chart
type would visualise the data best.
• Edit the report style to suit the business and create a visually appealing dashboard.
Online Dashboard - Demo
LookerStudio Dashboard Tips
Increase page size:
➢ Go to ‘Page’ in top menu
➢ Current Page settings
➢ Click on ‘Style’ in right hand menu
➢ Adjust Height
LookerStudio Dashboard Tips
• Update the number of bars in
your chart
➢Some bar types only show 10 bars,
by default.
➢Change the number of bars in the
‘Style’ section > Adjust ‘Pubs, Bars’
LookerStudio Dashboard Tips
• Create a calculated field
➢Sometimes data is more accurately
calculated and visualised by using
manually calculated fields instead of
using pre-calculated averages or
percentages from the data set
➢For example: Sessions / Users
➢ Instructions:
➢ In your chart ‘set-up’ section, click on
‘metric’ field
➢ Click on ‘Add Field’
➢ Include required details and formula
Additional Insights and Tips
• No information about Beachvolleyball.com.au organisation is
required to complete the report.
• Use common sense or commonly known information to make
predictions on the rationale behind some results. E.g.
seasonality. Indicate clearly that you are making an
assumption.
> Ask questions in the Assessment Forum on Moodle
Data Visualisation Tips
• Who’s seeing the data?Consider the context
• What data are you visualising?Use the right chart
• What are you trying to show?Understand the purpose
• What is the priority?Consider layout and hierarchy
• Descending? Alphabetical?Use the right ordering
• Are you adding context?Include comparisons
• Are you only including what’s needed?Keep it simple
10
Data Visualisation Tips
• Are colours consistent? Do they aid analysis?Consider colour
• Are you using the right metrics and dimensions?Use the right data
• What’s included? What’s excluded?Explain the data
• How will you visualise the data?Choose the right tool
• Are you engaging your audience?Tell a story
• Have you tried different visualisations?Experiment
• Are your dashboards and reports evolving?Be dynamic
11
Use the Right Chart
• Bar charts are perfect for comparisons.
Like comparing the amount of traffic
coming from your top marketing channels.
• Line charts are ideal for showing
changes. If you want to show the
seasonal trend for a metric like users,
revenue or conversions, then a line chart
is a great option.
12
Use the Right Chart
• Pie charts are suited to showing
proportions. For example, if you
wanted to show the percentage of
people converting on mobile devices
compared to tablets and computers.
• Bubble charts can be used to show
relationships. Like showing the traffic to
product pages along with their total
product revenue.
13
Using the Right Order
• It can be easier to identify and interpret differences in a chart by using appropriate
ordering. For example, ordering this bar chart by value makes it easy to see the most
important content on the website.
14
Include Comparisons
• To show seasonal trends it can be helpful to include date range comparisons. For
example, if you have a seasonal campaign every year, then including a year on year
comparison makes it easy to compare performance.
• Try to keep lines to a minimum when using line charts. One or two lines are ideal, but
don’t include more than four as they will become difficult to interpret.
15
Consider Colour
• If you have multiple graphs that present the same data, like a social dashboard that
includes two bar charts, then make sure the colour for each social network is consistent.
For example, make sure the data for Twitter is always presented in blue (and not blue in
one graph and orange in another).
16
LookerStudio Gallery
https://lookerstudio.google.com/gallery