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

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend


More recommend