 Ladies and gentlemen, let's give it up for Michael Despatovic, who is going to talk a little bit about data storytelling and Google Data Studio. He comes to us with a whole bunch of interesting experience. He's the co-director of Apples and Oranges Analytics, and he also is a master's in publishing from SFU and is involved with arts and culture organizations and cooperatives. So if you really want to know about cooperatives, use your guy. And with that, let me get out of your way. Thanks, Eli. I appreciate it. Like many of you, I too am on the unceded and ancestral territories of the Skla-Holmesh and Musqueam and the Slavitooth, and I can think of a few folks from those identities and beyond who work in this space, so I'll just give them the quick shout-out. There's the First Nations Technology Council in BC. They have a great training program. I am looking forward to hiring somebody out of there in some distant future, so that might be a good place to look for future employees. And there's an agency out of Victoria called Anomaki, and I'll try to post that later in the chat. They also are, I think, completely indigenous-owned and on the Songeev's Innovation Center. So maybe those folks can help you in the future. Thanks. So I'm going to start sharing my screen here. I've planned about 30 minutes of data... If you will. And you're going to have to trust me on the format, because I'm going to jump right into the data, and then once our eyes have kind of warmed up to the screen, I'm going to backped a little bit and show you about where the data sources and stuff come from. So here we go with Data Studio Workshop. This is your view mode. DataStudio.Google.com is where you can find your Data Studio. It operates like Google Docs. Once you hit your edit button, you can basically see how everything now is its own element. So with text, that's very formatable and adjustable. With shapes, you can also do a lot there, and so on and so forth. But the number one thing to know with data is that you have to contextualize it. You have to make sure that people know where the data source is coming from and in what time period does this data become relevant in. So that's why I always leave a little date marker at the top left here, just to let everybody know what time frame are we looking at this date. So we're going to go over some of these widgets, and then you're going to see how this is going to basically kind of grow and demonstrate more and more insights. When we use data, we want to demonstrate insights, because people don't always really care about the exact number of people who come to the website or purchase something or how much time they spent. They want to know what that means. But first, we have to get the data out here. So I use a lot of scorecards, and I barely ever use gray or black or white. I like to use something orange or green or something colorful. Scorecards here basically show you one data point, one metric. Right now, for most of what you're going to see, I'm going to be pulling in Google Analytics data. But again, we'll come back to the data sources and how they plug in here. So with Google Analytics data, that shows you pretty much the basics of what's going on on your website, and that includes users. So here we have our scorecard with users, and you'll see this little percentage that's right below it that's showing you comparison data. You can see here that I've automated the default data range so that the users are particular to March, 1st to 31st. But then there's this little area here on the right side that says comparison date range, and that's where you go to basically pick, hey, do I want to compare this data to the most, to the previous period, to last year, to some custom time, all these kind of things. I imagine we're going to put a word in detail on here. So just kind of take it in while we go, and then this will be something that will just warm you up for your own practical knowledge once you jump in yourself. But to rewind, here we have our users, and here we have that they have grown 26% from the last period, which would be the previous 31 days before March. Prior to March, it's February with only 28 days, so that means it takes a little bit of January as well. So these are our scorecards, and they can show you pretty much anything you want just to kind of get across really quick. When we go down here, you can see that there are time series charts, some are hard, some are smooth. You'll see right now that every time, kind of I'm clicking these on the left side here is where all the data and that kind of stuff comes in. But then on this little tab here that says style, that affords you the option to basically change the colors, add a bunch of things, and you're going to see me play with this to basically make the insights a little bit more clear, a little bit more obvious moving forward. You'll also see at the top here that there's basically what kind of, I call them widgets, what kind of widget is this? What kind of chart is it? And if you click that, you can basically change this chart into another one with just one click. You know, not all charts translate very easily, of course, like a donut chart to a scorecard is maybe going to leave out some data, but this is just a really quick way to go through that. So here we have our scorecards. Here we have our time series charts. Here we have our bar charts. Yeah, I'm just waiting for this to kind of load. Sorry, with screenshot, things can always take a little bit longer. There we go. I'm not going to explain all the nuances of data itself. That's something that the Google Academy can help you with. If you take the Google Analytics beginner course or anything else, you'll understand a little bit about what dimensions are and what metrics are and other data courses like that. But Google Analytics has, I mean, pardon me, Google Data Studio has allowed you to see your dimensions in green, your metrics in blue. So here we're just looking at the user type. And then we're looking at the metric as the users. Here is it sorted, date, a little bit of filters and segments if I need them, and that's it. I'm going to switch to the view mode so I can show you something. All of these are interactive. So when I mouse over with my mouse, you'll see, there we go, you'll see this little point emerge in this area of the time chart. And well, you'll see this, there you go. On March 17th, it'll tell me exactly the amount of impressions that were on that time and how it's comparing itself to February 14th. So the darker color is the primary metric and the lighter color is the comparison metric. So impressions now are in this March time versus impressions prior. So you can see you can use bar charts that are stacked. So you can get to throw in a lot of data and just the exact amount of space that you could do with a simple bar chart. And then below here, we have tables with heat maps. What a heat map basically is, is just a little bit of color coding to give the bigger numbers or the bigger kind of metrics a little bit more attention. And then the smaller ones get a little bit of a lighter color. So that's what a heat map does. And you'll see those come up real soon. And then we have a table with bars. We've got a pie chart and then my favorite, the donut chart. It's got a hole in the middle. So you can throw in some extra information in that empty space. So here's your crash course on all things charts. I call them widgets, but little charts that have to do with Data Studio. We're going to move on to the next page, where we're going to basically see a little bit about how I use these charts to pull the insights out. So here we have text and then a bunch of scorecards. And you can see I've taken out the metric of the scorecard because I'm kind of telling a story here. I have two sentences and then I'm kind of filling in the blanks, kind of like, oh, jeez, now the words escape me. What's that thing where you are trying to fill in a song and then you have to put, oh, man, it's going to kill me. But by all means, here's our scorecard. In the style area, there's a little checkbox that says hide metric name. So I've gone ahead and checked off that. And now it's a little bit easier to understand your website has welcomed 4,796 users who went to your website 5,993 times. They spent about a minute 16 per trip and visited 1.84 pages per session, which is a trip to your site. So I would encourage you to use Data Studio in a way that isn't maybe super data-y. I would encourage you to mix and match your words, your text, and the Data Studio scorecards and other information. However, that's not always the best way. So I've given you some more options here. I've given you a funnel version. Here's a funnel representation of your user activity. So on one side is text. On the next side is a scorecard. These are the amount of page views that were on the website. And then here, this is actually a bullet chart that's kind of been hacked a little bit. The cool thing about Google Data Studio is that there are a lot of hacks. You can Google Data Studio tips, tricks, fun ways to visualize things. I basically followed a guide and I found basically a cool way to get this bar to turn into a funnel. As a reminder, I will be happy to share these with you so that you'll see when you input your own data, it'll all more or less automatically flow. But here we have a funnel representation of your user activity where the dark bar that's in front, that one is showing us our current data. And then the lighter bar that's kind of sneaking out in the background, that one is showing us last month's data or the last 31 days of data. And as you can see, we've had more users. Therefore, the bar has progressed a little bit. And that kind of demonstrates, oh, we have increased and there's a visual representation for that. This range limits is where you go to basically change the size of this. Don't worry about that. This is just kind of a quick way to understand your funnel. And then some of you might have your Google analytics set up with goals. So you can basically put at the bottom of your funnel a goal like 105 people click to this very important link on my website and that was a goal. When it comes to goals, you can also have conversion rates and so on and so forth. So here we have a little bit of a mini story, two sentences. Below we have a visual funnel. That's a quick way to kind of understand how to use scorecards and how to use bullet charts to relay information very quickly. I'm gonna go to the next page. Now we're getting into combo charts. You got line charts and bar charts. So I'm just gonna go into the view mode here. As you can see here, we have the line telling us how many users came to the website day after day in March. That's the red line for March and the pink or the lighter red line for February. And then in the same time, I wanna know how many page views did they see on those days? And so that's where I have these black bars and then the gray bars again from the previous 31 days. So again, not too hard. You just pick your dimension. This case, I want the date. The date runs along the bottom. Pick my metrics. I got a user, I got all my users and then all the unique page views and that's about it. Once I go into the style, you'll see that there's a lot of ways to style this data. So series number one, that's just a way of telling you, hey, what's that first metric you got? Oh yeah, it's users. Okay, I wanted this a line. If I change my mind, I wanted this a bar. This thing will just change automatically. There we go, but that doesn't look too good. So I'm gonna put it back to line. There's a bunch of options to show cumulative information points, data labels, axes, things like that. And here you have my second metric, series number two, those are the bars. Same information. So in this bar chart, I've basically shown people just day after day after day of data. But what if I'm really eager to, I don't know, demonstrate month over month growth? Well, that's where this next chart might be really useful. I've made this one cumulative. I've made this one basically start from zero, basically at the beginning of March and then day after day, the numbers accumulate and they get higher. And now I can kind of show people, look, this is how many more users we got this month and compared to last month. And this is how many page views they did compared to last month. And that is as simple as a checkbox under style that says cumulative, cumulative. Lastly, for bar charts, I just decided to throw in some of the labels here. I thought to show you what happens if you wanted to see the numbers instead of having to mouse over them. It's not foolproof. As you can see here on like March 18th, the 500 and something nine unique page views are being hidden and there's no way for me to help that. But by all means, you can also demonstrate both the visual aspect and the actual numbers themselves. All you gotta do is click show points to show the little dots and show data labels to show the numbers. So if I take the data labels off, then the information will go away. And if I don't want these points, if they're not really working for me, just take them off and there we go. But lastly, what I've done is I've put this yellow orangey benchmark bar, if you will. It's called, oh, sorry, it's called a reference line. So if I scroll down, you can put reference lines on bar charts that basically show you, you can set the value. So it's a constant value of let's say 400. Whatever that means to you, 400 users, 400 page views, whatever, put it to the right axis and then label it. So target for March was 400 users, 400 unique page views, let's just say. Here we have the line basically showing me on March 10th and March 18th and March 24th. I have hit my target, so I'm successful. You can also use this as kind of, well, more dynamic way. So if I click metric instead of constant value, then I can basically make the bar follow a metric like users and calculate it on something like an average or a median or something like that. And with that, I can write average users. And again, I can demonstrate that the average is basically just under 200 users per day. So a lot of nuance, a lot of detail in how to make your bar charts sync. Okay, lastly, in terms of all of the kind of cool things you can put, I'm gonna be showing you tables, straight up spreadsheet tables. Sometimes that's the easiest way to relay information and you don't need to over complicate things. I've added a white box on top of some of this data just to keep the anonymity of the client's data I'm using. So don't be alarmed, that's just a white box that I can delete anytime I want. But here we have the page title for the website. We have the unique page views and the page views itself. Now I've gone ahead and in the edit function, I've sorted this table by the descending value of unique page views. However, when I'm in view mode, I can change that without changing the original documents. So let's say I want to actually do ascending, then I will click basically this header for the table and it'll swap the other way. That doesn't change the original document, it just changed this one that I'm viewing. So hopefully this is the first of many signs that you'll pick up on that Data Studio is very, very, very interactive and that your job in demonstrating the data is really to create as much agency and as much play and as much fun as possible so people can actually help themselves understand the data. So here we have page title, unique page views, page views. What's really interesting about data is that you can also, like Eli was referencing earlier, filter it or change the viewpoint or try to kind of look at a small piece of it. So for those of you who know Google Analytics, you'll know that there are four channels that most people come to a website on, either organically searching through Google or Bing, directly usually typing in the website or something else, referral traffic, like from publicity or from really any other website and social media traffic. If I want, I can basically uncheck some of these, I just wanna see what organic search and referral look like and you'll see my entire data studio page share adjust to reflect just these two sources of data or you can see that the word only sometimes show up. So if I click that then it'll just basically solo click this guy and so on and so forth. And if I just wanna check them all, it'll look like that. Again, this is something you do in the view mode because you're basically trying to view and play with the data. So okay, I only wanna see the data that comes in through Google Organic, I click only and then there you go. Now I'm only seeing data that's come in through that way. So I'm just gonna let that go back. So I'm gonna jump into the edit mode to demonstrate a little bit of what's going on here. And just for those who didn't hear, I'm not keeping my own the chat box but I do intend to answer any questions that show up. I know I'm throwing a lot of information at you so I promise to come back. In the meantime, here we have our table. Let's take a quick look inside. So again, dimension here was the page title and then from the page title, I wanna know about the unique page views and the page views. As you can see, I've sorted them by unique page views descending. I can change that in the original document if you want and to understand these, these are called controls. So if you look up at kind of the top of my screen, there's a button here that says add a control. You can add a dropdown list, a fixed size list, input box, advanced filter slider, and a tick box. This is a dropdown. So it's basically showing me whatever the control field I want, which is usually a dimension. And then it'll also show me a little bit more information about which metric kind of applies to or previewing that information with. So I love using dropdowns because they just make it a little bit easier for you to kind of toggle between segments of your audience or certain understandings of things like that. But sometimes you need check boxes. So that's where this control comes in. It's a fixed size list that has countries for dimensions and page views. And again, people can check things off or click only. So let's say I only wanna look at the Canadian users coming through the sites. And so now this will get all changed to only show me the Canadian users. However, out of all these options, I actually like this one the most. This is an advanced filter. It allows you to kind of run basically kind of regex style queries just to kind of understand a little bit more. So let's say I'm looking for a very specific page title. I'm looking for something that is in volume 93. I type it in, I hit enter. I know there's no button. That's not my doing, I promise, but I hit enter. And now this will all adjust to show me just the pages that have to do with volume 93. And also only those in Canada. Let me see, you can compound your kind of restrictions here. So okay, now I've put all the countries in and now the information gets a little bit bigger to show me volume three. So if I delete this and hit enter again, it'll all go back. Another failsafe is just to simply hit the refresh button and it'll all reset back to normal. So this page shows you drop down controls. Here's your title, sorry for me, here's your table. Here's your advanced filter. And then here's your fixed size list. Okay, let's put it all together. So I've been showing you, go ahead. I've got a question coming in, Michael. Is this an okay time? Yes, yes, please. So Carolyn, I've just given you mic power as if you want to come on mic and ask. Otherwise you can ask for you. Oh goodness, hello. I didn't expect to have to talk. So this looks really, really great. But my question was we are taking like data and analyzing data from like analytics from Google ads. We're looking at social insights. And then we also get like lead data from our CRM. So are you able to pull? Like do you need like an API or something to pull it into data studio or for something like that where you're pulling from multiple sources, do you have to look at a like a Power BI style product? And I'm saying that because that's the only one that I've heard of before, there may be something else that's better or easier to use. Yeah, great question. I can answer that. And then that'll actually lead me perfectly into how the data sources work with data studio. So data studio is definitely really good at showing you kind of siloed data like just your Google analytics and then just your Twitter and things like that. However, in a couple of minutes I will be showing you how to blend data sources. So how to take the advertising spend from one channel like Google ads and then blend it with the advertising spend on Facebook for instance. So you can blend the sources together but to truly answer your question, well, how do I get the data sources in here? That's where you can see that these buttons get really relevant. So we've already talked about adding a chart. We've talked about adding control. Now you just got to add data. This same button for add data shows up in resource where you get to manage added data sources and you'll see some more information that we might get to today. So when you manage added data sources, these are some of the data sources I have. So I'm gonna click add a data source and then here we have two options. You can either connect to something external or after you connect to it you can basically make it kind of like permanently available in your data studio. And so that's where I have a bunch of my clients here with their data, but to start off you need to connect to something. So it'll show you first the Google connectors which are Google analytics, Google ads, Google sheets. However, you can see that there's a file upload option. So if you have like a CSV file, you can upload that. If you have some of the more, yeah, like complicated database stuff like BigQuery or this you can do that my SQL search console. And so after you get through the Google stuff that's when you see the 384 partner connections that can connect you to the sources that you want. So I don't think I heard you mention a specific one but you can always search for it in the search bar or you can scroll for it or you can Google to see if there's a partner connector. Naturally, when it comes to partner connectors the vast majority of them do come with some sort of payment some sort of fee, some sort of license that you have to purchase in order to use that. And I'm a fan of using Supermetrics. I use one of the more expensive licenses for Supermetrics so that I can pull in information from all of these marketing channels. But again, if you have something that's a little bit more custom, it is possible. It is, you do need someone to help you out. Otherwise, the rest of these are basically APIs. They are just branded APIs. That's all they are. Thanks so much. I didn't realize that Data Studio could do that. That's really helpful to know. Thank you. Yeah, you're welcome. And the fun thing about Data Studio is that whatever I say today you're probably gonna get even better results next week and the week after. Data Studio is growing at a crazy rate. Like there are new features almost every week and new partner connections and so on and so forth. So. Well, thank you Carolyn because this let me then basically explain to you how, yeah, if you wanted to click Google Analytics to get your Google Analytics in here you would go into your, you would authorize it. I'm already authorized and you would pick whichever account you want and whichever property you want and then whichever view and you would just hit add. So fortunately, all the Google connect other quite well. And then the partner ones, you kind of as a small learning curve depending on who you go with which is why I've gone with Supermetrics because the learning curve is the same for each and every single one of these kind of plugins. Good. So we've talked about basically the visualization points all these charts. We've talked about the way to control them and let people kind of go in and out and how to add that data in there. The one thing I haven't covered is like why does this look like an eight and a half by 11 piece of paper? Because I decided it should look like that. So if you look under theme and layout which just kind of shows up whenever you're not clicking anything special you can go to layout and you'll see that there's an option here to basically make your canvas whatever you want. I know a lot of people who basically do this instead of Google Slides because of course you can pull data in you can put images in it's basically like just make it I don't know 900 by 600 and then you kind of looks like a Google Slide deck. I've gone for letters because of course people understand kind of eight and a half by 11 paper but you'll see me also kind of adjust that in the future. Also when you're right clicking kind of an empty space you can see information about the report settings. So you can make your entire report have one single data source and then it's really easy for this connector to know which sorry this widget this table to know where which data source to pull from. You can put a date range dimension on it you can put some other stuff you can even actually add Google Analytics here if you want to know if other people are looking at it. And then what I like to do is I make things really easy on my clients I basically say hey this page is just Google Analytics and so when I click current page settings I put in the data source for Google Analytics and then I make sure that the default data range is whatever is in the corner that's it. So I wanna show you what happens when we put this all together and by all together I mean nobody wants to see six bar charts in a row six donut charts in a row that's a little bit it's a little bit of a visual overload. So I mix things up. So here's my story, right? Your website has gone or this many users went to your website this many times. Here's my bar chart, here's my line charts lot of information there with that information. So this a little more presentable you know getting people that you know whatever you want you can also not use a lot of this part of the bullet points for what I mentioned today like accessibility, trying to get people who don't really have training or kind of understand data, you know immediately understand I did a data report once for youth like for 12 to 18 year olds for a nonprofit and this was kind of just what I did I color coded everything. So here we had the gray text and then here this kind of naturally shows up blue stuff and then here's the green text that applies to the green so you don't need to be an amazing designer you can just color code things you can just kind of feel like very straightforward in terms of what's going on and that can be enough like you don't have to go too hard and you know there's no limit to how many pages you can use how many charts you can use so go wild. I'm gonna jump back here. I also like to sometimes make pages about even well sorry let me back up. When we are using our data controls that can be really great to let the person see what's going on but sometimes you can also make that work in the back end so to speak in the current page here I have put in filters and the filter is basically only show me data related to the book reviews and so I know this based on the URL structure I know that when it says domain.com slash book reviews slash how to kill a mockingbird then anything that has the book reviews in the URL I only want that information in here maybe that'll like if your website has well if the word blog is in the URL or something like that and so filters are really easy to make you just basically have to understand a little bit of conditions like include or exclude your dimension or dimension and then starts with whatever the URL is or I can put contains or something like that. Hey Michael actually I've got a question right about filters here coming in from Jay. Jay are you able to come on Mike? If not I can read it out. So Jay's question is when pulling in Google Analytics data are we able to put a filter on for an entire dashboard? That is to say like you don't want to like filter in just one of the bar charts but actually like everything on the page. Yeah perfect so this is how you do it on the page you just put in the filter here and if you wanted it for the entire report then under the report settings you would also be able to put filters there. Well once I put in the data oh okay there's the filter so I can add a filter there if I want. Cool that's great thank you I'm gonna have another question coming in from Christina Wong who could also go on Mike if so curious wants to do if you want to do so. Go for it you had some questions about templates I believe. Yeah I'm just wondering if well you already mentioned earlier that you're gonna share the link to examples that you're doing awesome but I'm kind of curious this is I feel like it's really new I guess or maybe I'm just been MIA but I've looked into like no code low code stuff and this feels so like similar to this kind of like things I'm just curious like what are some common like favorite uses that you have with Data Studio because I feel like it's very approachable and user friendly so thanks. Yeah no great question. Yeah Data Studio I haven't even shown you stuff related to like building a map like you can build a map and have you know geographical information on the map things like that so there's a lot of I'm just taking you to datastudio.com right now to show you how there's a bunch of templates in here and how in template gallery there's even more and if you click see more it keeps going and just like everything Google there is like a community visualization so you can download other people's templates for free I'm assuming they posted it up on the template I've never had to go in that far but this is great if you want just your YouTube or just your merchandise tour or whatever and there's more in here so you can see already that some people are visualizing data related to like location and things like that but I thought I would do kind of a fun example with you so this is a good time for me to swap to this I've made here the smallest Google Data Studio file ever it's literally where's my layout here it is 300 by 200 pixels wide it contains one scorecard I've pretended that the data here is talking about current donors and there being 959,514 let's say it's pulling that from some database of yours or some CRM or whatever and then I went ahead and I basically made this pretend save the hamsters campaign because the hamsters are endangered where the hamsters need your help and as you can see, you need to donate to help save the hamsters and we need about 10,000 donors right now we only have 9,514 but this is a Data Studio report that got pulled in here with a simple embed so I'm just gonna let it load up so you can kind of see that it's not part of the landing page it's just part of this embedded code okay, it's not really coming fast enough here but when I go to, where is it here? right here under share, you had embed report there you go, embed the code put all that code somewhere and then I was using unbounce and I basically pasted the code if you use anything else that lets you just paste some random code now I've taken this tiny 300 by 300 300 by 200 iframe and put it in right here so there's a way for you to be kind of data transparent with what's going on and help people understand, you know how close you are to a goal or what's going on that's a really creative and fun use of this but yeah, most people just use it for audits dashboards and reports, boring stuff Shall I continue? Thank you, you got it well it's good because I'm able to fold in some of the stuff I wanna get in so I can still finish up in about five minutes and leave even more time here some of you know with Google Analytics you can use goals and so this is something to let you kind of show like goals, like the link they clicked to how do they do the thing all this kind of stuff and you may be asking yourself you know, that's an interesting name for a dimension and a metric well that's because Google Data Studio allows you to rename any data metric or dimension you want without like repercussion so when I click into this you can see that here is the green for the dimension and that when I mouse over the kind of left side there's this little pencil when I click it it tells me that the source field is from Google Analytics an event field and I've renamed it link they clicked on to do the thing same thing with metric, right so these are actually total events that happened in Google Analytics and I've renamed it does the thing so let me just add one more here come on of course I have to, okay oh now I've gone into territory okay, page views, come on let's just do revenue so I'll pull in the revenue here actually I don't think this data source has any revenue but that's okay this is about to update with all of the information about the revenue and then when I hit the edit button I basically get to rename it whatever I want so it can be like this is how much money we collected in March or whatever you want the metric to say this is really helpful when it comes to like Google Analytics has this term sessions which is a trip to the website instead of saying sessions you can just rename it trip to the website okay, I'm gonna proceed with the last couple of bits here this information you can also pull in stuff from your audience so here we got our donut charts heat maps, we're all kind of familiar with that I've got some of this here so I'm gonna keep going good, here's information from Facebook it's a Facebook page this is coming in through my super metrics license so here we have information about the followers and the new likes and things like that we have information about every single post that was made and a link to the post and the post description and if you mouse over it you can see the actual thing will show up in case you need to truncate things and more information there you can see I put a little disclaimer sometimes it's really important to pick the month and so forth this last page has a little bit about Twitter I was basically demonstrating how each time this organization tweeted they got a little bit more impressions and more engagements and this is kind of accumulating I'm trying to show them the effort of their work and how important it is to keep tweeting every day as opposed to whenever they feel like it you'll also see I sometimes make scorecards gray and that's because once in a while the data points will not be dynamic they will not be information that you can control with time or something like that sometimes the metrics will just have to be right now whatever today right now's data is I can't look in the past know historical data and so I tell people hey when the scorecards are gray it's always going to show you today's data so there are a few limitations but not from Data Studio it's coming from the actual API itself lastly I'm going to really jam this in here the you're allowed to use Data Studio to blend data so as you can see here I have Facebook add amount spend Pinterest add amount spend and then I've blended it I've put those two numbers together you may be asking yourself how did he do that so under resource manage blended data this is going to this is going to look a little intimidating but I promise you there's not much here there's basically two data sources and I've picked them I've picked the Facebook ads one and the Facebook sorry five cycle pin ads and what I've done is I've put a bunch of metrics from the Facebook one and I've put a bunch of metrics from the pin one and now they both show up in the same data source once I've done that I'm sorry this does get a little bit advanced but once I've done that I change the scorecard to be the data source specific to my ads that are combined and then I make a custom field so let me get out of here when you choose your metrics there's always this button at the bottom that says create a field when you click it it basically takes you to something that looks like this and I said ad spend combined and then what I've done is I've just basically done what you do in Excel right when you make a expression come together amount spend Facebook plus amount spend Pinterest the sum of that the currency is Canadian hit apply and next thing you know I have a metric that is technically two metrics added together I could have also done some and then the brackets but either or works here so that's a really cool way to basically blend your data bring things together and then like be able to demonstrate to people well instead of just calculating this in your head I can do it for you make it really easy to understand exactly how much data was spent since I'm running out of time I just wanted to know that there's a bunch of stuff that you can do here you can do MailChimp data about emails opens clicks orders you can do Clavio data you can do ads data at my agency we kind of do all this work so that's why we end up reporting about it we do ads we do email we do social so here's the nice way to understand ads where you have kind of impressions clicks ads to cart total orders and then even some more information here so you can understand which of your ads are doing the most for you without having to go into business manager which can be a little intimidating so lots to do I've shown you all of my reports and all my demo stuff so I'm gonna leave it here and start going towards questions awesome thank you so much there's so much here and as a reminder because things moved quickly we'll have the video available afterwards so you can always like pause, slow down say like where did he go next so you can sort of follow things through but I've actually got a question here coming in from one of our members who is just finding sort of the initial landing on the site a little bit confusing and I'm wondering if you were able to just like slowly walk through that initial building out so you know which is Lori's saying is I find the data available field super confusing to just to set up and understand it and you know it's just kind of stuck at page one so if you could just like walk through like what are we looking at here what's happening as I drag this through like what are you actually what are you working in manipulating yeah, yeah so I'm also gonna defer a little bit of that experience to how Data Studio allows you to do this thing oh no where'd it go I guess I already used it there is a template I can share it with you once I locate it but basically and just to be clear it's the filters on the right column that seems to be the sticking point okay well anyway oh there's a total report it's right in front of me so this the total report is really good I would encourage everyone to click here first and let Google kind of walk you through what's going on so this is my answer to that question but once we get into the data and you hit the edit button basically yes it is very intimidating let's say I click on the scorecard to see that this kind of mini screen has given me so many options along the right side again the green being dimensions the blue being metric dimensions is kind of like well actually this doesn't apply to Twitter for some reason but so whatever I like from here like if I like the how many replies I want how many retuts I want I can either grab it and drag it and replace it and then if there's a room below like with a table or something then you drag it a little bit below and now you can see this has changed from retweets to replies but then also don't forget here the data source is our default data source which is set in the report settings the report settings being when I right click some blank space and I hit report settings and I say okay well the report setting well actually technically this one is from current page settings and the current page settings involve the data here so resource manage add a data sources add a data source go through those steps use these buttons here like add a chart maybe a scorecard and then that scorecard will default to something and it's up to you to edit it and format it I do a lot of copying and pasting so that I don't have to format each thing I'll just click this and I'll right click it and I'll copy it and then or I can use my keyboard come on there you go paste it and then swap out the metric make sure the data source is good the date range is good Butterbeam Butterboom hopefully cool yes you're dragging basically from those green available fields and you drag that over the sort of the blue metric area and then basically it swaps out depending on what you're looking at or in other kinds of charts it would have like multiple data fields there yeah yeah there's even more ways to do it so you can just actually click the blue button and then you can base or the blue metric or blue or green dimension and you can search for it or start typing it in so I've just clicked this and now it's giving me a bunch of things but I know I'm looking for tweets and then it'll show me tweets fabulous that's really helpful thanks for sort of walking us through just like that initial like how does the UI set up but I think yeah I think what I'm hearing is just get clicking into one of the examples and see what happens that's right cool well thank you so much we're wrapping up here but before people go I just want to like you know one thank you so much Michael for sharing your expertise on this and as I said we'll share that video out but the other thing is I would love to basically yeah do a quick promo because this is not the only event we're doing there is there's more goodness coming so let me just dive right in there and say we're busy so we're going to be gathering again in a month's time to talk about the future of fundraising events and our friends at Trellis have actually done a survey of Canadian nonprofits to talk a little bit about the current status of events as we come through this COVID period around their fundraising work and they're going to share the best practices and the results of that surveys with us in June as we start thinking about like oh what what could my fundraising events look like as we come into the fall then maybe we'll take the summer off maybe someone will come to me with a good event idea but otherwise no for sure that we'll be back in September where we're going to actually go into some of this Google analytics analytics goals that Michael was talking about so the event will be the 25% of Google analytics that you actually need to know about there's a lot in there maybe it's not all that stuff you need to like worry about all the time so we'll focus in on just the hot 25% that event will be on September 14th and again if you go to events.techsoup.org you can register for all those events now and get them into your calendar and otherwise thank you so much everyone for showing up it was a delight to get to connect with you and I hope to one day have in person events with many of you again at a minimum we'll do that in 2021 we're going to see how the fall plays out but otherwise thank you all and have a really lovely day