title @RivalIQ @danaditomaso What is Google Data Studio? @RivalIQ - - PowerPoint PPT Presentation

▶
title
SMART_READER_LITE
LIVE PREVIEW

title @RivalIQ @danaditomaso What is Google Data Studio? @RivalIQ - - PowerPoint PPT Presentation

Mar 25, 2024 306 likes •790 views

title @RivalIQ @danaditomaso What is Google Data Studio? @RivalIQ @danaditomaso Googles answer to reporting and dashboards. @RivalIQ @danaditomaso Many data source options, including Google Sheets and databases. @RivalIQ @danaditomaso

slide-1
SLIDE 1

@RivalIQ @danaditomaso

title

slide-2
SLIDE 2

@RivalIQ @danaditomaso

What is Google Data Studio?

slide-3
SLIDE 3

@RivalIQ @danaditomaso

Google’s answer to reporting and dashboards.

slide-4
SLIDE 4

@RivalIQ @danaditomaso

Many data source

  • ptions, including

Google Sheets and databases.

slide-5
SLIDE 5

@RivalIQ @danaditomaso

If you can put it in a Google Sheet, you can visualize it in Data Studio.

slide-6
SLIDE 6

@RivalIQ @danaditomaso

Bonus: Calculated Metrics!

slide-7
SLIDE 7

@RivalIQ @danaditomaso

There are some limitations.

slide-8
SLIDE 8

@RivalIQ @danaditomaso

You can’t compare two data sources in the same chart. (Unless it’s already combined in a Google Sheet.)

slide-9
SLIDE 9

@RivalIQ @danaditomaso

There aren’t a lot of non-Google data sources for GDS (yet).

slide-10
SLIDE 10

@RivalIQ @danaditomaso

Enter RivalIQ!

https://help.rivaliq.com/using-rival-iq/google-data-studio-connector

slide-11
SLIDE 11

@RivalIQ @danaditomaso

slide-12
SLIDE 12

@RivalIQ @danaditomaso

slide-13
SLIDE 13

@RivalIQ @danaditomaso

Summary Metrics Aggregate data, with one row

  • f data per company.
slide-14
SLIDE 14

@RivalIQ @danaditomaso

Daily Metrics Aggregate data, with one row

  • f data per company per day.
slide-15
SLIDE 15

@RivalIQ @danaditomaso

Social Posts Post-level data, including engagement metrics, message, and metadata. One row per post.

slide-16
SLIDE 16

@RivalIQ @danaditomaso

slide-17
SLIDE 17

@RivalIQ @danaditomaso

slide-18
SLIDE 18

@RivalIQ @danaditomaso

Add all 3 data sets to your report.

slide-19
SLIDE 19

@RivalIQ @danaditomaso

Then you can display different data sets in the same report.

slide-20
SLIDE 20

@RivalIQ @danaditomaso

Recreating RivalIQ in GDS

slide-21
SLIDE 21

@RivalIQ @danaditomaso

Let’s compare Social Engagement and Social Activity.

slide-22
SLIDE 22

@RivalIQ @danaditomaso

slide-23
SLIDE 23

@RivalIQ @danaditomaso

slide-24
SLIDE 24

@RivalIQ @danaditomaso

slide-25
SLIDE 25

@RivalIQ @danaditomaso

slide-26
SLIDE 26

@RivalIQ @danaditomaso

slide-27
SLIDE 27

@RivalIQ @danaditomaso

slide-28
SLIDE 28

@RivalIQ @danaditomaso

slide-29
SLIDE 29

@RivalIQ @danaditomaso

slide-30
SLIDE 30

@RivalIQ @danaditomaso

Let’s try a calculated field.

slide-31
SLIDE 31

@RivalIQ @danaditomaso

Use calculated fields in any filter/chart/graph,

  • r in another calculated field.
slide-32
SLIDE 32

@RivalIQ @danaditomaso

Use basic math, or functions — sum(), avg(), min(), max(), regexp_match(), date_diff() ...

slide-33
SLIDE 33

@RivalIQ @danaditomaso

CASE WHEN REGEXP_MATCH(Company Name, "New England Patriots|Buffalo Bills|Miami Dolphins|New York Jets") THEN "AFC East" WHEN REGEXP_MATCH(Company Name, "Pittsburgh Steelers|Baltimore Ravens|Cincinnati Bengals|Cleveland Browns") THEN "AFC North" WHEN REGEXP_MATCH(Company Name, "Jacksonville Jaguars|Tennessee Titans|Indianapolis Colts|Houston Texans") THEN "AFC South" WHEN REGEXP_MATCH(Company Name, "Kansas City Chiefs|St Louis Chargers|Oakland Raiders|Denver Broncos") THEN "AFC West" ELSE "NFC" END

slide-34
SLIDE 34

@RivalIQ @danaditomaso

slide-35
SLIDE 35

@RivalIQ @danaditomaso

slide-36
SLIDE 36

@RivalIQ @danaditomaso

What is the “quality” of each social post?

slide-37
SLIDE 37

@RivalIQ @danaditomaso

Social Quality Score

(Amplification * 5) + (Conversation * 3) + (Applause) / (Presence Reach * 9)

slide-38
SLIDE 38

@RivalIQ @danaditomaso

slide-39
SLIDE 39

@RivalIQ @danaditomaso

Where can you go with this?

slide-40
SLIDE 40

@RivalIQ @danaditomaso

What are the questions that you need answered?

slide-41
SLIDE 41

@RivalIQ @danaditomaso

Does increased social engagement result in increased sales?

slide-42
SLIDE 42

@RivalIQ @danaditomaso

When are the best days/times to publish ads?

slide-43
SLIDE 43

@RivalIQ @danaditomaso

What questions do your clients or bosses ask?

slide-44
SLIDE 44

@RivalIQ @danaditomaso

Bonus Tip!

slide-45
SLIDE 45

@RivalIQ @danaditomaso

File > Report Settings

slide-46
SLIDE 46

@RivalIQ @danaditomaso

View the Report kickpoint.ca/rivaliq-gds/

slide-47
SLIDE 47

@RivalIQ @danaditomaso