 We're going to go ahead and get started. Can everybody in the room hear me in the back? No, not too much. I'll move this up a little higher. All right, how about now? All right, I'll speak loud. All right, in this talk, we're going to be talking about Google Data Studio. Before we dive in, I want to find out, kind of, pull the room. Who here has heard of Google Data Studio? OK, just a couple. How about Google Analytics? Awesome, everybody's pretty much heard of that. How many of you are already using Google Analytics on your site? All right, about the same amount. So first, just to introduce myself, my name is Chris Edwards. I'm from Orlando, Florida. I've been a website developer for, wow, 19 years, starting to feel old doing this. Started back in high school. Got my first professional gig when I was in 9th grade. Granted, I wasn't charging enough. I think I built the website for somebody for, like, $300, which probably today I would have charged $3,000 or more for that same site that I built then. But that's when I got my start. And then just been really playing around with it my whole life. I've been using WordPress for about seven years now. Moved over a transition to it just because of it being a great CMS to use and so forth. Now, I've been using Google Analytics. How many of you know, interesting fact, Google Analytics was actually Urchin Analytics originally? All right, we've got a few here who know that. Google bought Urchin Analytics out about, I think, 12 years ago or so. So I've been using it since it was Urchin Analytics. And it's really been a great, it's always been one of the greatest platforms for tracking page view-based analytics on your website. I've been a digital marketer for a very long time as well, doing SEO, PPC, those types of things. And I've been a complete data nerd pretty much my entire life. I like to track everything and make graphs out of everything down to mileage of my car, down to just anything I can find I can attach numbers to. I like to analyze it and create data for it. You can follow me on Twitter at ChrisEdwardsCE. I do post a lot of stuff about analytics, marketing, and so forth on the Twitter account. So you can follow me on there if you want to get different information, different articles we write, and so forth. Oh, the other thing is I also have a agency out of Orlando called Data Driven Labs. We do analytics, SEO, WordPress development, mostly digital marketing type of things. So that's kind of what I do. Now let's jump into why you all came here. So a lot of you, or almost all of you, use Google Analytics or at least know what Google Analytics is. So what is Google Data Studio? Basically, Google Data Studio allows any of you to create amazing dashboards to analyze your different analytics. So I was just speaking to somebody out in the halls earlier who uses Google Analytics. And they were telling me that they love looking at all their data, but it's all over the place. And one of the things that you'll notice with Google Analytics is you have all this data and very valuable data in many different places inside of analytics. But sometimes you want to just be able to find that data and look at it right away. You want to be able to analyze certain key aspects all from one page without have to click around. Your clients may want to see only certain things. And just going through and trying to find all that is very hard. So what many people have done is they've gone out, created spreadsheets, created different things, and pooled different data manually into all of these different places to send to their clients or send to their key stakeholders in their company to show the performance of their site. Data Studio basically allows it so that anyone can create dashboards and pool this information automatically. And you can make really nice looking ones. This is an example. I'm actually going to give you the template to this at the end of somewhere in this talk so that you can actually download this template. It actually has five different pages, and I'll show it off to you guys. So you can actually take this. I have e-commerce one and just a regular website one. So if you have e-commerce platform, you can use the one template. If you don't, you can just use the regular one. But it's going to allow you to use this for your site. You can actually make a copy and then change it how you like, change colors, and all that. We're going to talk about how to do all that in this talk. Data Studio is all drag and drop. So you're going to see it's really easy to create. If you all can use Google Word, I know this is in the developer room, but this is really basic. You don't have to know any code to do this. If you can drag and drop inside of Microsoft Word or Google Docs, it's pretty much the same thing. So what Google Data Studio does is allows you to collect or connect to a whole bunch of different data sources. So a lot of these data sources are things like Google Analytics, Google AdWords, Google Sheets, you can connect it to Google Search Console, YouTube, pretty much any of the Google products. And you also can connect to CSV. So I do want to point out Google Sheets and CSV basically makes this a dashboarding system that you can use for any data you want. If you want to track the mileage of your car, you can put that into a Google Sheet and then create a dashboard based off of that information. And I say that because we're going to talk about all the community connectors as well, but if your community connector is not already out there, all you have to do is export it to CSV or into Google Sheets and you can build stuff with Google Data Studio as well. Other ones, there's community connectors, a lot of them are paid. You can connect other sources, Facebook, ads, Harvest, Stripe, LinkedIn ads, all these different types of systems out there. You can connect in and pull their data in and create dashboards off of this. Now the interesting thing that we're gonna talk about here, you can use multiple data sources inside of one dashboard. So what that means is we can have displayed over here on the one side of the site. We might be able to show off, say, Google Analytics so we can show how many page views there were, but over here we can show how our ad words are performing. And then down below we can actually create something that shows how our Facebook ads are performing. So there's a lot of really cool stuff you can do. Google just launched, so it's not gonna be in this talk about a week or about a week and a half ago. They just launched the ability to actually combine and calculate those together, which is more advanced, but you're able to actually take Google Analytics and say Google AdWords and take perimeters from both of those and combine them into one table, which is really cool. But we're not gonna get into that because that's a little more advanced. We're gonna kind of keep it on the basic level to teach you how to use Google Data Studio today. So there's a lot of different type of dashboards you can create. Just showing off here, you see there's a Google My Business one up there in the left-hand side, all the way over to the right, Google AdSense, and then you'll see there's a bunch of other ones in here as well. And you'll see how all these look different. You have the ability with Google Data Studio to really dive in there, customize everything, and make it look how you want. This is really great for your clients. You can create branding for either your company to provide dashboards to them, or you can actually make a dashboard to match their company. We do actually find sometimes clients want to put up a TV in their marketing offices. They may have a large TV or a large display that they wanna have the dashboard displayed on. So you can actually brand it to fit their needs if you want to. Some other examples, this is a YouTube report. The one on the other right, I believe is an analytics report. But again, you can see how you have a lot of customization really to make different colors and pull different data in. Here's Google AdWords, Google Search Console. So this is really just showing you all the different things you can really build with these dashboards. So it's not gonna be just your analytics dashboard. You can pull in all kinds of different data from all different data sources and really create a very unique look for your company. You can also, these are pulling from Google Sheets right here. So this is what we were talking about before. This is just random data about world population and TV ad performance. These are actually pulling from Google Sheets as their data source. And you can see how they were able to create really cool graphs just by putting their Google Sheets data in there. So if you just have a whole bunch of data from something else, you can pull that data in and create a really cool dashboard to help display that. It's really great if you're trying to take a bunch of data and you're gonna be doing a presentation to board members, you can go and pull all that data in and show off just the items and a nice visual look instead of showing them a huge spreadsheet. So I wanna show a quick example of what the dashboards look like because there's some really cool things that can't show you with screenshots. So we're gonna dive in real quick. We actually have decent Wi-Fi here so I can do the live demo. Sometimes I have to skip this portion because it breaks, but we can do it here today. So this is the template I'm actually going to give you guys at the end of this talk so you can use this. This is an e-commerce template and you'll see we have all that information we just saw but the cool thing is as you hover over these, you have different information that pops up. So we can hover over here, see organic search, others, and you can see it's actually interactive. We can see the percentages here come down. You can see all the tables, these tables actually can scroll. So let's look at here age groups. You can scroll through this data. Here we can scroll down and we can actually go to multiple pages. So there's a lot of really cool things that you can do. It makes it an interactive dashboard, not just a flat dashboard. The other thing you can do, this is what's really cool. You can actually change and affect the date ranges. You can put date range control filters in here. And so we can actually say that we wanna do it. We can pick our time here. We have preset, so if we wanna do last 28 days. And we can reset the data to be shown from the last 28 days. So this is really great. What we do, I do this a lot with our PPC clients. I don't, you have clients that when you're running certain campaigns that are gonna be calling you on a weekly basis, hey, I'm about to run into a meeting. I need to show what our performance was from this date to this date. And you're going, oh, okay, let me try and get that together for you real quick and I'll send that over to you. And it can be really exhausting and also take a lot of your time. By creating this, we create these for our PPC clients through a Google AdWords one. We give them this dashboard and they're able to go in and create their own date ranges and then they can actually show and their meeting they're running into. They can pull that data themselves. Instead of us obviously having to try to build them something custom every single time they're going to a meeting. So it's a great way to help your clients see their data or help you see your data on your own website very easily. The other thing you can do is create pages. So you'll see we're on the overview page. I have acquisition channels. And on this one we added a different thing. We added a filter for changing the channels. So you see we have all these different channels. If we want to see just how organic search did, I can select organic search. And now all this data is just organic search based. You can create these different filters for anything that's in here. We can say we want to see just organic search and direct traffic. So we can select those two. And then there we go. This is showing just those two channels inside of here. So you can really build out and put these filters. These filters could be anything. You can make this filter based off demographic. Male, female. You can make this based off of obviously here we did channel base. You can really pick different things you want to build the filters for. And you can stack filters. I don't have an example of a stack filtered one but you could have multiple filters where we say we want to see by channel and then we want to see by source and filter by source as well. So there's a lot of really cool stuff you can do with those pieces. Again, we have the date range control filter over here. As it stands right now, they have not made it where if I select information inside here and it carries over to the other pages, everything's page specific. So we'd have to reset our date range here. I'm hoping that's something they do fix in a while that this header could be overall for all pages but at this time they currently don't. Google Data Studio is technically still in beta so they are adding features left and right and they're really working on this product a lot. Another idea is to track your e-commerce. So this is the e-commerce page that we have set up here and we can actually see this is the Google Store, this isn't my revenue. I wish it was my revenue over the last 28 days but it's not. This is, you can see we're able to build, I built over here returning visitor versus new visitor. And so that we can see average order value in transactions. Again, we're gonna give you this dashboard and this presentation so you can use this as a template to start but we show top products, traffic and revenue trends. All this information is already inside of Google Analytics. All we're doing is pulling it into a more logical way for it to be displayed and make it nice and visual so that you can find the information you want. I'm sure you all have gone into Analytics and tried to dive in and you'll know that all this stuff you would have went to about four or five different pages in Analytics to pull each one of these different pieces and it would have been really difficult to find that information. Technology, this is another fun one I like to use. I like to give to all my clients. It actually helps more with the development team to understand how many people are using mobile, how many people are using desktop, helps you with design decisions and understanding what you're working with and so forth and on this one we actually pulled the revenue conversion rates for all of those different devices so you can see that mobile has a horrible conversion rate compared, mobile and tablet, have a horrible conversion rate compared to desktop. If this was a client of mine, hey, if Google wants to become a client of mine I am open to bring that business in but my advice to them would be let's focus on our mobile version because that conversion rate is really low and that could be because the mobile experience and the purchasing experience on a mobile device is not very friendly and that could be why the conversion rate's low. So this is a great tool. You can really get a lot of insight from these different dashboards and so forth. So this dashboard, I will give you a link to get this dashboard when you actually open it. You'll have a button up here because it's mine, I don't have it. They'll say make a copy or a copy. You'll click copy. Actually right there, there it is. You'll copy this report so you'll hit this button and you'll be able to copy this into your data studio account which we're gonna walk through how to create one of those just a second and then you'll select your new data source so it'll come over here with a blank and you'll select your data source. We're gonna talk about how to connect data source as well but you'll be able to put in your own data source and be able to use these different analytics for your site. All right, so let's jump back over to the presentation. All right. So let's go ahead and dive in and let's talk about creating a report. First thing you're gonna do is you're gonna log in and create a blank report. The way it works is if you have, it's going to use your analytics account that's attached to your Google account when you're using data studios. So if your analytics are all in account B, you need to sign in and create a data studio account with account B. So you're gonna sign in, this is your Google account. If you are using analytics, you already have a Google account, just use that account to log in. And once you log in, it's gonna pop up and it's gonna ask you to create your first dashboard. There are a couple of example dashboards you can pull in and take a look at too if you wanna kinda play around in there. I'd always like to start with creating a new one. You can do also, we just talked about making a copy of that, once you create that account, you can make a copy of the dashboards that I'll give you guys a link to. And once you make that copy, you can just use those and manipulate those for your first dashboard and then worry about creating your new one down the road. So I'm sorry. You're gonna click on the blank template and then the first thing you wanna do, and I point this out, even though it seems like this would be a basic step, you wanna name your report. And the reason I say name your report, it names it as Untitled Report and it doesn't prompt you and it's actually a little bit hidden because it doesn't have, it doesn't pop up and ask you to edit it. It just dives you right in to start creating your report and I often forget to do this step. And so my account, if you go into my account, I have about 30 Untitled Reports and I have no idea what they go to and there's no little preview screen next to them. So I have to open each and every one of them to see what they are. Now you can rename them later so it's not like it's gonna stay that way but it is a little annoying when you log in and see all those. So make sure you do name them. Unfortunately, there's not a folder system right now inside of Google Data Studio. Again, one of those things that we're hoping that they change down the road, right now they just are all just listed. So what I like to tell you to do is come up the naming convention. What I usually do is I do client name dash and then what kind of report it is and that allows me to go in and search because it's really, it's based off of last time viewed on the inside the report screen. And so what happens is you see all the previous ones viewed so if you haven't looked at the report in two months you can be buried and hard to find. So I always do it by client name so I can search easily and find that client's dashboard if I need to. And then once you're in there the first thing that's gonna have to pop up is a little button down there that says create a new data source. So what we're gonna do is we're gonna click on that button to create ourselves a new data source. We're gonna go to Google, for this one we're gonna select Google Analytics. You're gonna see a whole bunch of other data sources you can add. These are the default data sources that are built into Google Analytics. You can add any of those if you want for this dashboard that we're gonna be building here. We're gonna talk about using Google Analytics just for the ease of it. And I will actually give you guys an article. We did create an article that's a step by steps like 5,000 words and tons of pictures. It's more detailed than this of how to do this. So I'll provide that to you guys as well at the end of the slides here and you can follow that article if you get lost in this process here. Once you do it you're gonna need to authorize the account. This is basically just saying you're allowing Google Data Studio to access the data inside of Google Analytics. Any of the connectors you use you're always gonna have to authorize your account to it. So once you do that pop up and come up to allow access. And then you're going to add your first data source. So the first thing we're gonna do, again, name the data source. It'll put a default name in there. What'll happen is it puts Google Analytics as the name. What happens down the road is as you create more reports all those data sources are saved inside of Google Data Studio. If you don't rename that you're gonna have seven of them to just say Google Analytics. And you're gonna have to go back like we talked again. You have to go through, you have to select each one of those and actually connect it to try to figure out what Google Analytics account is actually attached to. And that's just no fun. So what we're gonna wanna do is name this one. I'm naming this one demo, Google Analytics because it's gonna be our demo account. And then number two, this is where you select. So you select which Analytics account you want. It'll have all of yours listed. I have a lot of them, but I'll pick the demo account and you'll see that there. Once you select the demo account it'll allow you to select which property. As you know in Google Analytics you can have 50 properties under each account. So if you have multiple properties under account pick the property you're building this database or this dashboard for. And then you go in and select the view. So master view is the one we selected on this because we wanna pull the test view. Now if you wanna pull the test view for a maybe development dashboard you can do that as well. And then you're gonna hit add to report. You're gonna get this screen here that allows you to do some edits and stuff. Ignore that, that's more advanced stuff. Everything's in there that you need. It's about 500 and no, 447. No, it's like 500. I forget with this one. There's a lot of tables in there. So if you wanna scroll through and see all the metrics it has the ability of pooling you can but there's a lot of stuff in there. I would just hit add to report and move on. And then you get to where you now get to build your dashboard. So we've connected our data source which was our first thing we needed to do. So now the data source is connected. This is really the best part about it. This is where you get to get creative. You can add graphs, charts, other elements. You'll see them all across the top. You can hover over each one of them. When you go to place them it'll automatically pool what it thinks it's gonna be the best information to pool. So you can actually, if you wanna see what each one of these will look like just drag and drop each one onto the screen and see what it looks like. And then you can manipulate the data which we'll talk about in just a second. These are different types of charts. So you got a time series chart which is a line chart, bar chart, combo chart, pie chart. You can create a table, create a geo map. You can create scorecards. By the way those are my favorite scorecards just because they have the ability of comparing to previous data and it just, I think they look really cool. Scatter chart, bullet chart, area chart, pivot table. Yes, you can do pivot tables inside of Data Studio as well. So you can pull a lot of different information in which is really, really cool to build out your different pieces of your dashboard. So in this case, we're gonna do the time series, right? We take it, you literally drag a box about the size you want it to be. You can adjust the size down the road. So just drag out one that's about big enough for what you think it's gonna be down the road when you're cleaning everything up. You're gonna resize everything anyways. So go ahead and just drag and drop it in there. And like I said, it automatically in this one, picked out a time dimension of date, excuse my mouth showing up, yeah. Picked out time dimension of date and then the metric is sessions. So it automatically looked at it and said, most people who create these time series wanna put sessions in here. So we're gonna go ahead and use sessions as the default. But we do have that ability to change that and I'll show you here in just a second right here. So that little side piece that brought in allows us to pick what we want. So in this case, we wanna go ahead and make sure that we do have the correct data source in there, which is the demo analytics one because we named it so we could tell. The time dimension that we're gonna do this based off of date. And then we have our metric. So we had sessions already in there, which this particular graph I wanted to have sessions, so that works, we'll leave that one on there. But then we hit add metric and we added page views so that we can actually see both of those on there, see sessions and page views. We left everything else the same, but there are other elements you have the ability to mess with to really kind of make your graph what you want it to be. So once we add those in, you'll see over here, it's kind of hidden, but we have those two lines inside there showing those two different metrics. So we have everything we need. And what I wanna show you is we actually kind of advanced ahead on the slides just because of time, but the article I'll give you guys, I actually walk you through adding every single one of those elements so you can see how to add pie charts, but they all work very much the same. You drag and drop them on there and then you select your data source, your dimensions, your metrics and add those in. And then there's some options to turn on and off for each one. So adding date range filters. Date range filters are along the top as well. That was that thing that we talked about in the beginning where you saw me changing the date. By default, you can set your report to be only for a certain amount of time or a certain date. What we wanna do for this is we wanna give people the ability to change the time and date that's in that report. So you can go up here, select date range filter and you just drag and drop it on there like any of the other graphs, bar charts, any of those others, just drag and drop it onto the page and there it is. When you add that in, that gives you this ability to have this item pop up that you saw me show off just a little bit ago. It allows you to select the date range. You can actually set as the default settings in there what you want the default date range to be. I often set it to be past 30 days because that's what most clients want. We do have some clients who say I wanna see the past week, past seven days. Whatever they want is their default. You can set the default over in that side bar. You can set that default in there. It'll default to that date range and then they can still change the date range if they want. If you are doing comparison elements which we talked about that little percentage change that was on the bottom of the scorecards or any other ones that you're doing comparison metrics on, what you can do with those, those will always compare to the previous period. So if you select 45 days inside of here, if you do compare to previous period, you can compare to the previous year if you want. So it'll compare the same dates from the previous year or you can compare to the previous 45 days. If you select 31 days then it'll compare to the previous 31 days. So basically that's how the compare feature works. I like to bring that up because some people do ask questions about what's actually compared to. In addition to the graphs and charts and everything, you have the ability of adding in things like text images. So this is where you can go in, add your own headers because not all of these will be labeled the way you want them to be. So you can go in, you can add your own text headers, add your own images and put them into the report. You can even add shapes. That's how I get those nice little lines you see in there and you can add colors and so forth. So styling, this is where you get to get creative. The dashboards, when you're done with them, they're gonna look really plain, boring, and you really wanna kinda spice it up to make it look really nice. Especially if you're giving these to clients and so forth. You're gonna wanna make it look really nice to the clients. It gives you a more professional look. It pushes your brand, helps you with your branding as well. So go in there, you'll see on every single one of them you have layout, or I'm sorry, on the main global styles, you have layout and you have theme. So your layout is going to affect the actual layout of the dashboard itself. Inside of there, you can actually select what size your dashboard is. So if you wanna make it for a TV screen, you can do a 16 by nine. If you wanna make it more of a paper, you can make it a portrait size. You can really kind of affect whatever you wanna make it, whatever size you wanna make it. You can embed these onto other websites in an iFrame as well. So you can make it a certain size so it can be embedded on your website or maybe if you create a plugin, you can actually maybe put this inside of someone's WordPress dashboard if you want, through a plugin. There's a lot of different things you can do on that side with embedding these reports. So you can affect the size that's down here in Canvas size. Under layout and theme, you can actually pick the default. So when you're dropping those graphs on there, they're gonna by default pull from the theme and then you can individually set the colors for those as well. But they'll first pull from the theme with nothing set. So this is where you can set your default colors, default fonts, all that, so that you can kind of change everything pretty quick. Then on each element, you're able to style each element. And so what we did is we talked about all those different elements that you can bring on there. Each of those elements have sidebars. It has a theme option. You can go in and you can, or I'm sorry, style option. You can go in and style each one of those. Change the colors. You can make those work the way you want them to. So what does that do? When I created that one dashboard, when I was done just dropping everything on there and I didn't do any styling, it looked like this, which still looks kind of all right, but you see everything is kind of all over the place. Colors don't really pop out. Can't really tell. Just by doing a little bit of styling, I didn't change any of the elements or anything like that. We created that, which in my opinion looks a lot better. It brings over to branding of my company, which was what I was trying for on this one, and really just changes the look and makes it obviously a lot more professional. Doesn't look like you just threw something together. Everything's lined up perfectly. Just looks really nice. It's appealing for others. So you can really have a lot of fun with the styling. It makes your data pop out a lot more as well, even with just adding the little dots on there and made it a little easier for people to go, oh, I could hover over each of those pieces. So you create this dashboard, which looks great, but it's inside your Google account. So you have the ability now to share these reports with others. This works. Who here has used Google Docs? Okay, so if you use Google Docs, Google Sheets, or any of those items, and you've ever shared this with people, you have ways to share them when you go up to the sharing area. This works the exact same thing. It actually runs off of Google Docs' sharing platform, I guess you would say. But you have the ability to limit who can see this. You can either do it by where you invite certain people and they have to be logged into a Google account. So we do this, we actually work with a large hospital network. Obviously, their analytics doesn't have to be HIPAA compliant, but obviously because they're a for-profit hospital network, they don't want their competition seeing all their data, how much they're spending on ads or any of those dashboards. So we actually have it where we shared with Google accounts, they have to log in so that there's no way to get to it. But you can also make these available publicly or you can make them available where if anyone who has the link can view the dashboard. You also have the ability of making it where they can edit it. If they have a Google account, you can actually add other people to be able to edit the reports. I do suggest you don't give edit capabilities if you're the one building a dashboard because people can get around there and start playing around and you've seen what happens when you let clients start playing around with stuff. You get something that looks nothing and then they want you, they hire you and say, hey, can you fix this? I don't know what happened. And you're going, I know it happened. This, it'll save you a lot of headaches if you just share with just the view permissions. What makes this great is you can give clients access to Google Analytics, you can try and give access to Google AdWords, give people the ability to see all this data, but what happens is there's so much stuff in there. They start playing around and then they start spending a lot of time asking you questions. I had a lot of questions when I would just give people access to Google Analytics. They'd log in. Even though in analytics, you have the ability of creating Google Analytics dashboards, what I found is a lot of people would log into those and they'd come back and they'd be like, so I was in there and then I got lost to start playing with this. Can you tell me what this, this and this means? And I'm like, it doesn't really mean anything for you. That's, you're getting too deep. That's beyond what you really should be diving into, but then they wanna know everything and now you have an hour long phone call that you're spending with a client and depending on how your retainers are set up, that's money that's lost because after you tell them, they go, oh yeah, I don't need that. Well, that's why I didn't tell you to look at that in the beginning. So with dashboards, you can really show them what you want them to see. Not saying to be unethical here or anything like that and just saying you can make it, you know your client, you know what data, what I usually do with my clients is I show them one of my example dashboards and then I tell them, are there other metrics that you wanna see? And I get them to tell me what they're looking for, what their marketing department wants, what every other person wants. And then what we do is we go in and we build out that dashboard to fit their team's preferences of what they want. And if they want something different, we have them contact us and we add that piece in there. But that way they're not sitting here trying to dig through there and try to find all this data and you're not having to give them a bunch of access to all these other tools to see all this. You can literally, so I mean, you're talking certain clients, if I'm running Facebook ads, LinkedIn ads, if I'm running as well as Google ad words, which is now Google ads, by the way, they just changed your name last week. And the whole interface, everything, it was a mess. They changed it in the middle of me working on something that was time-sensitive, it was really frustrating. And it was like I got it in the halfway point of launch so like half the stuff would tell me to go through this way, which didn't exist anymore and yet it was fun. I don't know why they don't make them like midnight. They decided to make them in the middle of the business day. But you may have all these different sources. You don't wanna try and get them set up to log in for each one of those and then them getting lost in each one. Then you have to do a training session on those. Just give them the dashboard and it pulls all that data in so they can see everything in just one spot. I do a quick training with all my clients on here's how to use Google dashboards, here's how to change the stuff, takes about 15 minutes to show it to them and then I put all their data in there and they don't have to teach them how to use Facebook Insights, which then if you all have done Facebook ads, their reporting sucks. It's horrible and I can't even, it takes forever for me to find the data I need. So if I create this dashboard, it makes it really easy because I can pull that data and just put it right there. I don't have to teach them how to dig deep inside there and find that. Half time they're looking at someone else's account anyways because Facebook's system's bad. Anyways, you have options with the sharing. You can share with anybody inside your organization. You can share with it to be public on the web. If you're embedding it on your site, you would obviously want it to be public on the web so people can see it. A lot of different options you do with the sharing. All right, this is where I give you links. So I'm gonna leave this slide up there so you can find it. Everybody gets a dashboard that came here today and you can share it with anyone else if you want. Go in, if you go to these, these are short URLs because the actual URL is just a bunch of letters and numbers. If you go to ce2.io, ga-ecom, that's gonna be the one that's tailored for e-commerce. If you go to the other one is ga-only. If you don't have Google Analytics e-commerce tracking because you're not an e-commerce site or you're not using e-commerce and if you're not using e-commerce, you need to. Also set up advanced e-commerce but I'll talk about that tomorrow in my Google Analytics talk that's at the end of the day. If you all want to stay, I would love it. Come on out and I'll show you how that works. But you can pull down both of these. I take down both links because you never know when you're gonna end up adding e-commerce or get a client with e-commerce. And then just, like I said, go up and make a copy of it, connect it to your data source and then you're up and moving. It's just got default colors on it so just change the colors, change up the logo to be whatever you want. And you can actually use this for your own. It's that template that had those five, four, five different pages on there. The Google dash, Google dash only one. Instead of using revenue based for everything, we use goals. So if you have goals set up, it'll pull all your goals in on that one page. It was technically e-commerce in the other one. It's gonna be, everything's gonna be goals based so it'll show your goals, conversion values and such. So feel free to grab those. Did everybody get time to copy those down? Awesome, if not, grab a picture real quick. The slides will be available later anyways. I wanna talk about community connectors. So we talked about all the Google connectors. Google makes this really easy to connect to their products. Google did something amazing, which was really nice because everybody loved this and everyone was like, this is awesome but we use more than just your products. Facebook ads is a key. So they opened it up so that you can actually create because the way people were doing it was they saw that everybody was creating connectors to bring everything over into Google Sheets and then they were taking Google Sheets data and using it and so Google saw this opportunity to build this out and make it a little bit easier for that. So they created these things called community connectors. This allows you developers to create these connectors to connect other people's APIs straight into Google Data Studio so the data can be pulled in and you can actually view all of the data inside of there. It works great for pulling all the information in. It's super easy for you guys to use. It is a pain in the butt if you're developing connectors, which I'll talk about in a second. I pull a lot of hair out, that's why I'm losing hair probably, trying to build connectors with it because things will work and then they stop working for a day and you're trying to figure out what you broke in your code when you haven't committed any new code and then a day later everything's working again. So gotta love Google. Inter-documentation's not the best on the developer side. But these are developed by third parties. Most of them are paid so you have to pay for a subscription to access these. Some of the biggest third-party connectors out there, you have Supermetrics, they have like about 30 something connectors. They have like Facebook ads, LinkedIn ads, bunch of marketing ad platforms that you're able to pull in. You have Funnel, they boast over 360 connectors. They're a little more expensive and they have basically all kinds of Mar-Tech products out there to connect to. And then you have, we are actually working right now on launching one. It's in private beta right now. Like I said, we're still working out some of the kinks. But we have it launching and one of the things that we're doing with ours is we're focusing more on the WordPress side because I know this is a big hole in that area to connect to WooCommerce, things like that. Build like dashboards based off of those type of items. So we're working on building those. We're gonna be launching soon. So if you want to go to that page and sign up for early access, I think there's like a coupon code that we have on the page that will give you like discounts on a free year or something. But anyways, our goal is to focus on WordPress-based products as well as some of the ad platforms. Funnel has a lot of just everything out there and Supermetrics has mostly the ad platforms. Go take a look and see what connectors they all have and see what works best for you. And that's the biggest thing because you may find one has all the connectors you need and the other doesn't. So double check those. We're working on a connector for Twilio. I think Funnel might also have a connector for Twilio. I don't think Supermetrics, Supermetrics I think has it in their pipeline. They haven't launched yet, yes sir? Funnel.io. Funnel.io, yes. And Supermetrics is I think Supermetrics.com. You can Google it and you'll find it. The first thing that pops up. I have all my slides available at that link. And then as I said, this whole entire talk is based off of an article I wrote on our website that goes literally step by step through every single creation of every single one of those graphs. It's a very long article but very detailed. You can follow it straight through. We're actually gonna be launching a YouTube video showing the actual creation of this as well, hopefully here soon as well. And it'll be posted on that page when it's out there. This article actually, funny enough, was picked up by Google and Analytics tweeted it out out of nowhere, which was really cool. My site stayed up. Got a lot of traffic really fast. And then, funny enough, my host is Flywheel. So we stayed up and running. And then, about a month later after that, they put it in their main newsletter. So if you're actually signed up for Google Data Studio, it was listed in their main newsletter, which was really cool. I had no idea. All of a sudden out of nowhere, I look at my site and my site was just, I had a bunch of alerts hit my phone. My site was blowing up. I had 5,000 people on my site at once just looking. I'm like, I said, it came from an email. So I looked at UTM and it came from an email. I'm like, I don't send out emails. So who sent out an email? And I was like, had to be a big listen. Sure enough, I was able to track it back and see what it was put in their newsletter, which was kind of cool. So, check out that article. It does go step-by-step, so you should be able to go follow through it. I know this talk was kind of abbreviated because we have a short amount of time. It takes probably about an hour and a half to really go through full step-by-step how to do it. So, I'm going to open the floor to questions. Yes. Yes, sir. I'm sorry, the names. Yes, yes, you can change your names at any point in time. You can, as we talked about, you can drop text in there and talk, you can drop images in there. So yes, you could drop images in there to go with it. I have one that I did drop icons in, but you have to drop each one in. You can't associate and say, whenever this item pops up, put this icon in front of it. Yes, sir. Ah, the fun question. No, not right this second. You can't send it as an email. You can set, like, we actually, for ours, we actually have an automatic email template set up in our email program that sends them the same link every month because for some reason they, every month they seem to forget and they don't know how to search your email. You know, you all get it. So we send it and also reminds them to go take a look. So you can do that. The other thing you can do, you cannot at this time, stupidest thing ever, it's like one of the most highly requested features. You can't export it as a PDF right now, which, yeah, it's really frustrating because that's like everyone, that's like the most basic functionality. You can't, you can do a print, you can print the screen and then print the PDF but it's still, it tries to print everything else around it because everything else, it's frustrating. It is on, people have been requesting it and like I said, they're really working hard to, this is one of the few products that Google actually seems to be paying attention to the community for and not just building whatever they want. But people have been asking for the PDF functionality for a year now and they haven't built that. So I don't 100% know why that's not there but hopefully that gets added soon. There is, I did read that Google says they're working on some kind of email reporting feature. So hopefully that comes out really soon. I believe they're supposed to be something coming out, I think it's in beta right now. So there's something supposed to be coming out real soon for that. But none of us really know what it looks like. So hopefully that maybe brings the PDF functionality or something. Yes, yes, you have to go through one of the connector services and unfortunately the Facebook ad side, Supermetrics has a free version but it only pulls the last 14 days under the free version and you can't pull beyond that. So you do have to pay for them. So you'll have to look at the different connectors that are out there. Some range from, if you want just a single connector from $7 a month to, I think Supermetrics is $29 a month for a single. So you just gotta look at the different ones. There's like six different ones who have a Facebook ads one. So just look and see which one fits your price range and stuff, but unfortunately yes, the Facebook ad ones have to be purchased. Any other questions in the back? So on the ones that are embedded, the data refreshes, don't quote me on this, every 30 minutes it was loaded. So if you put it on a high traffic site, obviously it's not gonna refresh every second you get a page load because it would overload Google servers. I think it's every 30 minutes. On any of the other dashboards that are not embedded that are in there, you have a little refresh button that you can hit refresh if the data is old and force refresh it. Just on the embeds, you can't force refresh but it refreshes, I think it's like 30 minutes is the timeframe there. So it's not like it'll show four day old data. And that's obviously done just to keep their servers from overloading on a busy site. Google Analytics has gotten better at that. They're about it one to two hours I've noticed on goals normally. On a new account, it's still like about 24 hours but after your account's been established, it's been doing about one to two hours lately as my, but yes, it pulls the data from Google Analytics. So if Google Analytics hasn't shown the data, it won't pull down into the report. Any other questions? All right, I'll be over in the happiness bar sometime, I believe it's lunch now. So I'll be in the happiness bar after lunch. So if you have any other questions, come by. If you need to know more about analytics, I have a talk tomorrow, last talk of the day. I don't know what room it's in. Look at the schedule and come by and we'll talk more about analytics. Thank you for coming.