Creating a Data Studio Ecommerce Dashboard Using a Template

hi thanks for joining us today this is a continuation of the first video where we looked at this e-commerce dashboard template available in data studio and assess the layout now it's time to get busy and make the changes in data studio so let's get started we'll begin from your data studio homepage and this is dailystudio.google.com so this is what the home page looks like and what we'll do is click on template gallery scroll down and click on see more that opens up a new tab and in the search bar you can just type in e-commerce and that'll bring up the e-commerce store dashboard template that uses google analytics as the data source so of course that means you need to have access to a google analytics account if you don't have one you can take a look at this video and set up a google analytics account and tracking so this is the template that we reviewed in the previous video what we'll do is click on use template and for the new data source let's pick the pick the data source that you want so here we're going to let's go ahead and create a new data source to take us through the steps so we'll click on google analytics and we'll use the demo account the universal analytics version [Music] and the master view we'll click on connect so that can bring the data source into this template and it gives us a list of all these fields if you if you just leave this alone that'll that'll just work fine and then click on copy report so once that loads we should see the data come in and fill in this template let's start with the title and obviously it says google merchandise store so we know that this dashboard will cover something about the merchandise store but what exactly is still a mystery i mean obviously we can look at the rest of the dashboard and tell what kind of information is in the dashboard but we don't want to leave the crowd guessing so since this title is actually an image let's go ahead and delete that so we can have more flexibility with the title and then let's create a background for this header so copy this gray background here this gray rectangle drag it up to the header and click on arrange order and send to the back so we can see our other other elements here and let's change the background to something similar to a google blue maybe okay that looks that was good and then click on the text icon in the menu here and create a text box where the original title used to be go over to the text properties on the right and let's try 28 pixels for the font size and select white for the color type in google merchandise store e-commerce overview [Music] since we've given this a specific title and we're only pulling from one data source we can delete that drop down this also helps to avoid any confusion with which dashboard you're looking at i mean if you have multiple eco stores on different web properties you probably have different names for those stores and so it would make sense to name your dashboards accordingly right create separate dashboards for them and name them accordingly now we'll take a look at these drop down menus and since these use the google analytics dimensions it might be good to have google analytics opened up in another tab so you can cross reference to see how many values each of these dimensions have device category will only have three values desktop mobile and tablet country that could potentially have many values especially if your company or your website has a global reach click on style and enable search box so that will allow the user to search for specific countries so the the whole dashboard will filter all the data according to that selection and then we'll select on source medium that also has a potential to have many many values for that so we'll enable search box for that and user type there's only two possible values there new and returning users so we'll leave that alone now we come to the body of the dashboard i'm actually going to delete the sessions chart because we can place that in a website performance dashboard this dashboard will focus on e-commerce performance also it's not conveyed explicitly but sessions does contribute to the e-commerce conversion rate so i'm going to get rid of sessions now we have our key performance indicators or kpis over here on the right but it would be better to place those at the top so it's the first thing that the audience reads since they are our kpis [Music] then we'll have these three charts underneath so instead of sessions we're going to turn this chart or sorry the score card into transactions so under metrics click sessions click on sessions and look for transactions scroll down and for comparison date range choose previous year and click apply you should see a percentage that compares this value to the value for the previous period and will definitely take three thousand percent growth it makes sense to compare to previous year because many companies need to take seasonality into account there are other cases where you might want to compare to the previous month as well so let's move this over to the left side of the dashboard for the second kpi we'll turn that into revenue and add a comparison to the previous year ooh almost four thousand percent in growth okay move that over and you can use the red lines to help you align each element let's turn this one into purchase conversion rate which is called e-commerce conversion rate in google analytics so choose that metric and then turn the date range or sorry the comparison date range to previous year all right do we have any bets on the increase for this one how about 3 200 all right well i was getting greedy so move that over and we'll turn the last kpi into average order value [Music] okay average order value and change the comparison date range to previous year and i'm guessing we'll have to bring this one down to earth so i'm gonna go with 20 okay not bad [Music] let's move the chart here and adjust this green background for the kpis so we'll shift the shape so that it spans across the entire pretty much the entire width to cover all the kpis okay let's edit these charts we'll keep the date dimension but change the metric to transactions and update the comparison you'll have to add a text area in order to add the title we'll call this transactions over time switch the middle chart with the revenue chart [Music] and call it revenue over time [Music] update the comparison [Music] and since we can't use currency symbols or add them to the axis labels we'll add an access title so click on style and scroll to left access left y axis click on show access title go back to the data panel and click on aut next to the revenue metric and type in revenue followed by the currency sample in parentheses and change the last chart into or average order value and add the title [Music] and then update the comparison [Music] now let's adjust the width of these charts to 400 pixels each so that it can fit in this dashboard as we do that we can see that transactions and revenue were much better than last year and average order value was not only greater but more consistent than last year now we can turn our attention to these two data tables we have product performance and then performance by traffic source since traffic source refers to acquisition and top of the funnel i'm going to put that first product performance speaks to conversions which is the end of the funnel so it makes sense to move that after the table for traffic sources for the first table i'm actually going to use the first metrics as we did for the kpis so change the first one under metrics to transactions change the second one to average order value and we'll move that to the bottom since it's the last one at the top of our dashboard let's go ahead and change [Music] the sort to revenue you can also sort by transactions to easily see which channels produce the most conversions or transactions for revenue you'll notice that the numbers vary with significant digits so click on style and scroll down to the metric section to find column two click on decimal precision and select 2 for column 3 change it from number to heat map so we can see which sources have the highest conversion rates i don't want the color too dark so the audience can still read the numbers for average order value set decimal precision to 2 and we can keep the hemat heat map format so we can see what segment of customers spend the most let's give this table a title oh how about that alliteration this could turn into a freestyle but i would listen to it and just be embarrassed okay so we'll call it performance by traffic source for the second table this metric product adds to cart shows zero because the tracking isn't set up you see the same thing in google analytics so we need to update or get rid of product ads to cart and as well as cart detail rate for the very same reason you would have to set up the tracking for those metrics if you want those metrics work with your developers to track that i'll change one of the metrics to quantity and swap the order with product revenue scroll down and sort by revenue that's interesting it looks like users don't actually review the product detail page but they just purchase these products or add them to the cart from a browsing view and i'll show you what i mean by that if we go to google merchandise store and if we look at a line of products what we'll see is if you click on a specific product you can just add that product to the cart just from browsing these products right here that's how they created the experience so you don't have to go into the product detail page in order to add the product to the cart now go to style and find the metrics section again and change the decimal point or sorry the decimal precision for revenue let's use a heat map for quantity so that's the third third metric as well as a heat map for product revenue per purchase change the decimal precision for for that metric and then we'll add a title title the table and tell timothy to talk to tom okay i'm just i'm just getting distracted we'll call it top products for this device category chart we can't add currency units so we'll just add a title and call it device or sorry performance by device category let's take a look at this revenue city chart if we click on style we see that there isn't a way to change the decimal precision for the percentages but let's try changing the dimension from city to metro and change the number of slices to 10. that works a lot better because now other is only 28.8 percent [Music] okay i'm going to make some final edits to the titles and adjust some of the spacing speaking was busy you could make this page a little bit bigger by going to the page drop down in the menu and increase the dimensions of the page if you want to give yourself more space [Music] so [Music] now we're done with editing the dashboard so let's view our finished product i just updated what was in the template but you can change the dashboard to show other charts and data tables so let me know what kind of changes you would make in the comments thanks for watching and i hope you found this helpful i'd appreciate it if you like and subscribe see you in the next video [Music]

Channel: Growth Learner

Views: 854

Rating: 5 out of 5

Keywords: Google Analytics, digital analytics, web analytics, Measure, dataviz, data visualization, dashboard, data, kpi dashboard, marketing dashboard, online marketing dashboard, digital marketing dashboard, ecommerce dashboard, performance dashboard, website dashboard, data studio dashboard, Data Studio, Google Data Studio, e-commerce dashboard

Id: NjmtosPimL0

Length: 19min 32sec (1172 seconds)

Published: Sun May 09 2021