Access the Ohio State Data Visualization Brand Guidelines. These standards work to help build an experience for all users, regardless of their visual, hearing, motor or cognitive abilities. Included in these guidelines are the Tableau Color Palette, basic charts and recommended icon and font selections.
Many of us download social data directly from the platforms and then go through a process to clean it up before we can use it. This process of manually transforming your social data exports can often be tedious and can result in user error. To streamline that process and create a level of consistency, try leveraging one of our macros.
Unfamiliar with macros? A macro is used to automate a task that you perform repeatedly or on a regular basis. It is a series of commands and actions that can be stored and run whenever you need to perform the task.
How to utilize the Excel macros
The Facebook Post Data Macro functionality will create a new tab in your workbook to combine information from three tabs in the workbook to get you the appropriate set of metrics to calculate your KPIs, diagnostics and activity metrics.
The X Activity Data Macro functionality will run a number of functions to remove erroneous rows in the dataset, reformat the time stamp as a date and clean up unnecessary columns to get you the appropriate set of metrics to calculate your KPIs, diagnostics and activity metrics.
Thanks to developers working in this open source environment, we have direct access to unsampled Google Analytics data in an R Studio environment. The Analytics team in University Marketing creates R scripts to pull and transform web data from Google Analytics for a variety of projects. Modify our pre-built scripts to quickly run your data and export as .csv files for additional analysis.
Unfamiliar with R and R scripts? An R script is a text file containing a set of commands and comments that you would enter on the command line of R. The script can be saved and used later to re-execute the saved commands. The script can also be edited so you can execute a modified version of the commands.
Expand your knowledge of R, statistics and web analytics with an assist from the website Dartistics. See what it has to offer.
Get all the information from the original developer of the Google Analytics R package - Mark Edmondson. Includes links to GitHub and API resources.
If you're using Google Marketing Cloud (e.g., Google Analytics, Google Data Studio) on a regular basis, we invite you to check out the Da Vinci Tools Chrome extension. This free Chrome extension allows you to do things such as apply heat maps to tables in Google Analytics, auto-refresh data in custom intervals in Google Data Studio and much more.