From the course: Marketing Tips
Data analysis with Google Data Studio
- [Instructor] Hey, and thanks for joining me for another episode of Weekly Marketing Tips. I'm Brad Batesole and this week we're looking at Google Data Studio. Data Studio allows you to create beautiful reports from multiple data sources. You can connect your marketing data, say from Analytics and AdWords, and turn that into reports that are fully customizable, update dynamically, and could be shared with others. Now, I'm here at datastudio.google.com. You'll simply log in with your Google account and you'll arrive at a dashboard similar to this. Let's jump into this sample report labeled Acme Marketing. So, right away you can see this is an excellent method to create beautiful reports that could be shared with your clients, your team, or even the rest of your company. And they're interactive. In this case, I can select in the upper right hand corner and choose a date range and choose Apply, and the data will change to accommodate the date range that I've selected. I'm gonna go back to the dashboard by selecting the back arrow in the upper left hand corner. Now, you'll notice that along the left hand side, you have two options. Reports, which are the visualizations that you're going to create, and then Data Sources, which is where that information is going to come from. In the bottom right hand corner, you'll see the plus symbol. And this is how we'll go about building a report and adding a data source. Here on the right hand side after I choose the plus icon, we have to select our data source. To add your own data source, you'll select Create New Data Source at the bottom, but Google has already provided us with some sample data sources that we can use. I'll select the Google Analytics data source and choose to add to the report. And here we move into our report editor. So, this grid is completely blank, but we're going to have the ability to edit it by interacting with the navigation here at the top of the screen. Let's start by adding a time series chart. I'll select the option from the top bar, and then we click and drag to indicate where we want this module to be placed. On the right hand side, we'll verify the data source. And from here we need to modify the dimensions and the metrics. It defaults to date over sessions. If I select into the sessions metric, we can choose from the list what we'd like to pick as our metric. Perhaps I'll select Organic Searches. You'll notice that the graph will update in real time. You can adjust this by clicking and dragging, scaling, or even by selecting the style panel to adjust colors, line weight, and so on. If you'd like, you can add text simply by choosing the text option, and then typing as you would in any visual editor. Once you're done, you can choose View in the upper right hand corner, and you'll see how it looks to an end user. Now, it's evident that there is so much that you can do with this tool, and it's way too much to cover in one tip. But I recommend that you sign up, add in your data sources, and then start playing around and building your own reports. It's a fairly intuitive tool, and I think after a little bit of time of clicking through and adjusting the data, you'll be ready to build beautiful reports that you can then share with others on your team or your company. Thanks for checking in this week. As always, I'd love to hear from you. So, connect with me on LinkedIn or follow me on Twitter via @BradBatesole and let me know what you thought about this week's episode. I'll see you next week.
Contents
-
-
-
Best practices for organizing UTM tags for campaigns5m 26s
-
How to conduct A/B testing with Google Optimize4m 47s
-
Calculate and forecast growth rate using Excel4m 6s
-
Project management tips for agile marketing using Trello3m 42s
-
Data analysis with Google Data Studio3m 52s
-
SQL for marketers3m 6s
-
Why you need to bid on your brand keywords with Google Ads3m 1s
-
How to work with a new sales team3m 5s
-
How to calculate what to bid and spend on ads4m 24s
-
Build a lean canvas with RealtimeBoard5m 1s
-
How to increase email open rates by improving timing4m 14s
-
Searching competitor sites for hidden gems and content2m 51s
-
Use SEO research to generate ideas for your blog content2m 15s
-
Shortcut to quickly generate new Google Docs, Sheets, and Slides1m 17s
-
Advertise in Gmail with Google Ads4m 18s
-
Launch a legally compliant sweepstakes6m 17s
-
Check URL redirects after a site relaunch3m 14s
-
Landing page inspiration with Land-book1m 37s
-
Use Hunter.io to find email addresses2m 14s
-
How to set up Google Alerts2m 53s
-
Growth hacking content using Twitter custom Audiences3m 28s
-
Use Google Shopping Insights for market research3m 47s
-
What is creativity and how do you come up with new ideas?4m 49s
-
Source testimonials from your customers4m 30s
-
Prioritze objectives with the ICE model5m 8s
-
Introduce high-tempo testing in your workflow3m 10s
-
Evaluate your Net Promoter Score (NPS)4m 2s
-
Building better landing pages1m 46s
-
How to improve your local SEO2m 33s
-
Quicky add subtitles to any video with Kapwing3m 20s
-
How to prequalify traffic when running PPC ads2m 56s
-
Identify conversion problems with Google Analytics4m 41s
-
Use HARO to make connections with journalists2m 18s
-
Conduct SEO research by running PPC ads3m 8s
-
Monitor your competitors' websites for changes1m 50s
-
Matchbooks are good marketing3m 43s
-
What is your unfair advantage?3m 56s
-
Sensory marketing: Mental stimulation in display ads3m 26s
-
Geotarget single buildings in Facebook ads2m 53s
-
Automate your LinkedIn networking3m 52s
-
Google image search tips for market research2m 56s
-
Creating animated images with Crello1m 46s
-
Optimizing your LinkedIn profile3m 22s
-
Listing your service or delivery business on Google1m 32s
-
Using Google Trends for market research3m 39s
-