title
play

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

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


  1. title @RivalIQ @danaditomaso

  2. What is Google Data Studio? @RivalIQ @danaditomaso

  3. Google’s answer to reporting and dashboards. @RivalIQ @danaditomaso

  4. Many data source options, including Google Sheets and databases. @RivalIQ @danaditomaso

  5. If you can put it in a Google Sheet, you can visualize it in Data Studio. @RivalIQ @danaditomaso

  6. Bonus: Calculated Metrics! @RivalIQ @danaditomaso

  7. There are some limitations. @RivalIQ @danaditomaso

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

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

  10. Enter RivalIQ! https://help.rivaliq.com/using-rival-iq/google-data-studio-connector @RivalIQ @danaditomaso

  11. @RivalIQ @danaditomaso

  12. @RivalIQ @danaditomaso

  13. Summary Metrics Aggregate data, with one row of data per company. @RivalIQ @danaditomaso

  14. Daily Metrics Aggregate data, with one row of data per company per day. @RivalIQ @danaditomaso

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

  16. @RivalIQ @danaditomaso

  17. @RivalIQ @danaditomaso

  18. Add all 3 data sets to your report. @RivalIQ @danaditomaso

  19. Then you can display different data sets in the same report. @RivalIQ @danaditomaso

  20. Recreating RivalIQ in GDS @RivalIQ @danaditomaso

  21. Let’s compare Social Engagement and Social Activity. @RivalIQ @danaditomaso

  22. @RivalIQ @danaditomaso

  23. @RivalIQ @danaditomaso

  24. @RivalIQ @danaditomaso

  25. @RivalIQ @danaditomaso

  26. @RivalIQ @danaditomaso

  27. @RivalIQ @danaditomaso

  28. @RivalIQ @danaditomaso

  29. @RivalIQ @danaditomaso

  30. Let’s try a calculated field. @RivalIQ @danaditomaso

  31. Use calculated fields in any filter/chart/graph, or in another calculated field. @RivalIQ @danaditomaso

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

  33. 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 @RivalIQ @danaditomaso

  34. @RivalIQ @danaditomaso

  35. @RivalIQ @danaditomaso

  36. What is the “quality” of each social post? @RivalIQ @danaditomaso

  37. Social Quality Score (Amplification * 5) + (Conversation * 3) + (Applause) / (Presence Reach * 9) @RivalIQ @danaditomaso

  38. @RivalIQ @danaditomaso

  39. Where can you go with this? @RivalIQ @danaditomaso

  40. What are the questions that you need answered? @RivalIQ @danaditomaso

  41. Does increased social engagement result in increased sales? @RivalIQ @danaditomaso

  42. When are the best days/times to publish ads? @RivalIQ @danaditomaso

  43. What questions do your clients or bosses ask? @RivalIQ @danaditomaso

  44. Bonus Tip! @RivalIQ @danaditomaso

  45. File > Report Settings @RivalIQ @danaditomaso

  46. View the Report kickpoint.ca/rivaliq-gds/ @RivalIQ @danaditomaso

  47. @RivalIQ @danaditomaso

Recommend


More recommend