Getting Started with Event-driven Analytics feat. Hussain Mehmood Analytics is entering a new age. Pageviews are out, Events are in. So what do you need to know about this new Event-driven Analytics world? How does an Event-driven data model work? What are the best practices for creating Events? In this video, Hussain Mehmood from Marketlytics will dive deep into Event-driven Analytics
Analytics
How to Capture UTM Parameters in a Cookie and Transfer Them to a (Hidden) Form Field
UTM information is only visible on the Landing page. If you capture the information and transfer it into a cookie you can easily use it in e.g. a form. That way, when the user submits the form, you’ll be able to also know where he originally came from.
Google Tag Manager vs. the Global Site Tag (gtag.js) – Similarities and Differences
GTM and GTag are two different tracking methods of achieving the same goal. So which one should you choose? In this video we are going to show you the key differences and similarities between using Google Tag Manager vs. GTag for your tracking implementation, so you can decide which one is right for you.
Habits for data-driven marketers | Tips from Experts at Measurecamp
What is the #1 skill to build as a data-driven marketer?
We had the chance to attend Measurecamp in London, which is also known as the ‘World’s best analytics unconference”. We asked 5 experts for their opinion on what skill or habit you should build as a data-driven marketer in 2017.
Experts seen in the video:
– 00:57 Peter O’Neill (Founder of Measurecamp) https://measurecamp.org/
– 01:43 Jonathon Hibbitt (Web Analyst at Site Visibility) https://twitter.com/jonhibbitt
– 02:05 Krista Seiden (Analytics Advocate at Google) https://analytics.google.com/analytics/academy/
– 02:25 Phil Pearce (Freelance PPC/SEO/Web Analyst) https://twitter.com/philpearce
– 03:25 Simo Ahava (Senior Data Advocate at Reaktor) https://www.simoahava.com/
-04:12 Jono Alderson (Principal Consultant at Distilled) https://www.jonoalderson.com/
#DataDrivenMarketersTips
#Measurecamp
#Measure
? Helpful Links
Google Tag Manager Fundamentals:
https://analytics.google.com/analytics/academy/course/5
Google Analytics Demo Account: https://support.google.com/analytics/answer/6367342?hl=en
More Google Tag Manager Tutorials: http://bit.ly/2pucVyY
? More from Measureschool
Correct Google Analytics Setup Course: https://measureschool.com/products/google-analytics-course/
GTM Resource Guide: https://measureschool.com/guide
Free GTM Beginner course: https://measureschool.com/emailcourse
Courses: https://measureschool.com/products
How to Make Money Selling Analytics Services
You know GA, GTM and more Analytics? Turn your investment into skills profitable and start making money. How? In this video I’m going to show you 5 services you could be offering with your analytics skill set. They are..
Audits
Implementation
Analysis and Reporting
Training
Action
#MakeMoneyOnline
#AnalyticsServices
#Measure
? Learn more from Measureschool: https://measureschool.com/products
?Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
? Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
? Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
? FOLLOW US
Facebook: http://www.facebook.com/measureschool
Twitter: http://www.twitter.com/measureschool
LinkedIn: https://www.linkedin.com/company/measureschool
Now I’ve been a freelancer selling analytic services for a while. And today I want to give you my tips on what to sell and how to make money with your analytic skills. All and more come up. Hey there welcome back to another video of measureschool.com. Teaching you the data-driven way of
digital marketing. My name is Julian, and, on this channel, we do marketing
tech reviews tutorials and tips on tricks video just like this one. So, if you
haven’t yet, consider subscribing to the channel and click that down notification
icon so you will stay up to date with all that we do here on this channel. Now
today I want to talk with you about selling analytics services. I have been a
freelancer offering my services to various clients in various fields over the
last few years and have learned a lot at what you can be selling from your
skill set as a digital analyst or a digital marketer that knows a lot about
analytics. And I must say it’s a very rewarding field because there are not many
people out there specializing in this kind of digital marketing field. You can
see a lot of types of website type of data that comes across your desk and the
clients are less price sensitive I would say if you get the right client to
sell this analytics services. But what do you offer in an analytics consultation
or in an analytic service? So I want to show you here my five products that I
would sell as a digital analyst. First up audits. Now audits are really the
first thing that I do to get it feel for the client but also for the state of
the analytics implementations. And you can sell as a single product to the client as a service because the audit can bring a lot of benefit to an organization. it ensures data
quality and gives them some direction on how to improve the analytics
implementation in terms of gathering maybe more data, enhancing their existing
data quality, and obviously avoiding detrimental mistakes that they have in
their implementation. So, you start out with a thorough check of the Google Analytics or the implementation of the Google Tag Manager if your own checklist available that you go through in order to make sure that all this is set up correctly. And then you would give your client a report that outlines all the findings and the suggestions that you might have.
So, this is a product that you can sell your analytic skills on. It’s also creative because not every business is the same and you need to customize and suggest customizations to your client so there is a lot of possibility to show your client that you know all about Google Analytics but also suggest the right implementations, the right customizations to make their analytics implementation better. Building on that we have implementations. Now once you have made these suggestions, obviously the team your client could go out and implement them themselves but most of the times they want to have an expert on this case and you can up sell them to an implementation. Now implementations everything from installing button click tracking to certain goals or making sure the analytics is set up correctly. But here you would go in and change things around in their tracking setup. This has become
increasingly easier with the help of Google Tag Manager obviously because we
can do a lot of this stuff by ourselves now as visual analyst. But sometimes
you also need to be able to write a specification for a developer and help him
out to implement the right data layer for example. so, there’s a lot of
communication already going on between you and the clients but then also between
the different of departments that need that data to have the right
requirements, the right implementation, and making sure the data is correctly
in your system. Now the next point is analysis and reporting. Now a lot of
people think that we as digital analysts or digital marketers specializing in
analytics only do analysis work or reporting work but it’s just one part of the
whole analytics process. Obviously, you can log in to a Google Analytics
account and start digging through the data, but you need a lot of knowledge
about the business, about its actual functioning, and where the biggest
leverage points are. So, the inside generating machine of a digital analyst is
a big myth here. There’s a lot more to it to help the business to make
impactful changes. So, the skill of an analyst really starts with the
preparation of analysis project, what does the business actually want to
achieve with such a project, where can you find that data, is the data
qualitatively good, and can you produce the outcomes that the business would
expect. Now in most cases a lot of people think that they can just analyze a
little bit of data and then come up with a certain change on the website that will make a big impact. But it’s not always that easy because you also need to have the standing inside of the company to be able to move people forward and help them make a decision or help them change their behavior. And therefore, analysis project that lead to a certain outcome sometimes hard to accomplish within a company. so, a lot of people resort back to the reporting so building dashboards for a company which can be super helpful if the client knows what to do with that data and if he can drive the behavioral change forward in his company. Now setup of the dashboard is something we are involved with as well. But we always want to make sure that the data is relevant to the client. We can optimize that process as well but ultimately, he needs to work with that data and make changes happen in his company or in his organization. We always need to be upfront with that. We don’t want to be pushed into the direction of a data monkey who just pulls out data from Google Analytics and sends it to the client. Then the client will ask himself at some point why do I actually pay this person I could automize this whole process. So making sure you understand what you’re going into in an analysis project or a reporting project. That said I think that an analysis project in itself is most of the times not what you are doing. You would spend a package with all these three components of audit, to the implementation, and then a little bit of analysis to actually get insights to show what you can do with the data. And then help the client to take it from there to generate his own habits, his own processes to bring more insights, more change to the company with the data. Which brings me through a fourth point which is training. Now this is obviously what I do here on this channel but I also do it for clients and companies out there. Helping them to understand the data better than they have in systems to make sure that they can utilize that data and build the processes the habits to actually make a data-driven organization work. Data isn’t easy and it’s very customizable, it’s very individual to the business so investing into training is something that a company should do in the long-term. Just because outside freelancers will never have the standing in the company itself to lobby for change inside of the company with the data that I have available and the insights that I have available. So, training an in-house person long term is always an important objective to have in mind when developing people inside of the company. And therefore, training is something that’s very rewarding to me at least because the impact that you can make is long-term inside of the company. And our fifth point is obviously the action. So, all the automation that you could do or the optimizations that you could do with the data. So, I have some clients that want to set up automation with the data that they have available in their systems build new audiences for example in Facebook and generally, optimize their campaigns with their data-driven approach. Now one optimization a lot of people think about is A/B testing. Now A/B testing really encapsulate all these different components that we talked about before if you have to write an analytics implementation you can do the correct analysis the correct research to come up with a good A/B test. and then test these hypotheses, make the change on your website so you can then again start at the beginning from the defining, to measurement, to analysis and then testing as well again, so this is a full circle analytics implementation or analytics process which obviously is also a product that I could offer. But it gets really really complicated in most of the cases you would need to have a team to actually set that up correctly and make a big impact on your company. A/B testing sounds easy from the tools that we have available nowadays but to build an impactful change and an impactful optimization for a long-term is really something that should be left up to professionals and invested in the right time and the right place. Alright so there you have it. These are my five products that I would think of selling as a digital analyst if you want to turn your analytic skills into money. But I know that there are many consultants and freelancers out there that may use different techniques different services that they offer that work maybe well. I’d love for you to share them in the comments below as well. And if you haven’t yet then please consider subscribing to our channel right over there because we’re bring you new videos just like this one every week. Now my name is Julian. Till next time.
Facebook Analytics vs. Google Analytics – Which is Better?
Facebook Analytics has been introduced to give new insights on the data that is collected via the Facebook Pixel. Is it better than Google Analytics? What are the differences or similarities between the tools? Let’s find out….
Links mentioned in the video:
Facebook Analytics: https://analytics.facebook.com
Google Analytics: https://analytics.google.com
#FacebookAnalytics
#GoogleAnalytics
#FAcebookPixel
Learn more from Measureschool: https://measureschool.com/products
Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
FOLLOW US
Facebook: http://www.facebook.com/measureschool
Twitter: http://www.twitter.com/measureschool
In this video we’re gonna find out what is better Google Analytics or Facebook Analytics. All and more coming up.
Hey there welcome back to another video of measureschool.com teaching you the data driven way of digital marketing. My name is Julian and today we want to take a look at the differences between Google Analytics and Facebook Analytics.
Now this has been a really interesting question. I’ve seen this picture on Facebook, where somebody typed in Google Analytics and we see that Facebook Analytics actually puts AdWords advertising on top of the search results here. How funny is that? And they say here it says here, measure people, not cookies, Facebook Analytics, facebook.com. So, today I wanted to take the opportunity to actually look at Facebook Analytics and Google Analytics and maybe the potential on how it changes the game in terms of what analytics tools you would be using in future on your website and your app. So, lets do a little comparison of Facebook Analytics against Google Analytics.
So first up let’s talk about the history of the tools. Now Facebook Analytics is pretty new. It just came out in 2017, broadly to the public and is now available to all the advertiser of Facebook Analytics. Now this is a pretty much new tool to us and the data basis is revolutionary and different to Google Analytics. Now let’s consider the history of Google Analytics, a much older tool here. And that also plays into maybe some of the disadvantages here but also the advantages, because Google Analytics actually was different company before it was bought by Google. It was a company called Urchin. And in 2005, Google saw the potential of all these analytics tool out there and bought this tool for their own advertisers that were doing AdWords at the time. The rationale behind it was really that AdWords advertisers couldn’t measure the complete customer journey. They were only able to see how much they spent on an advertising that had made them money. But maybe not what was actually happening on the website itself. So, they thought about a solution on how they could help advertisers out to spend more money on AdWords. And that’s when they came up with the idea to buy a tool like Urchin and integrate it into Google Analytics or the suite of Google Analytics. So advertisers could actually make more money with AdWords. And they made it all free, I mean, the software, Urchin itself cost at some point 20,000 dollars per month.
Now Google Analytics premium actually cost that same amount now, but you can see that the power, the raw power of Google Analytics at that point was pretty substantial and they brought out this tool for free. So, you would be able to use it on your website. And it grew really fast because for that money, free you couldn’t get a solution out there. So a lot of website owners actually put this on their website and started tracking. Nowadays, Google Analytics is the defacto standard when it comes to web tracking because we can, first of all look at our data and compare it to other sites, so how many page use has it, how many users do you have per month, for example. But that actually comes with a clear model that Google Analytics gave us. So this model actually evolved from website tracking and it 2005 websites looked a lot different than what the web looks like today. So you would have a model that actually is centered around paid use, centered around cookies, that’s what they say in the ad and not around maybe users which Facebook is really good at.So, just remember that Google Analytics is a much older tool. Facebook is much newer. So the technology is evolved different and they come from different times of the internet history so to say. So we need to take that into account when we look at these two different tools.
Now that leads us to the next part here, which are the two tracking mechanisms. Now I already mentioned that Google Analytics is heavily relying on cookies. What does that mean? That’s the mechanism Google Analytics is built upon. So, the sessions, the page use and the users are all calculated through this cookie mechanism that is actually placed on the browser of the users to re-identify the user. Now you already can think of many different instances where this falls apart. If you, for example, come back through mobile device, you would have a different browser, a different cookie stored on your computer and you would be essentially a different user that is actually identified by Google Analytics.
Now Facebook Analytics is completely different from that, because Facebook actually knows exactly which user has been identified on there platform. So, if I click on and advertising on Facebook, it actually knows which user goes to the website. And if I click on the advertising again on my mobile device again Facebook knows exactly who I am. So, the paradigm shifts here from cookies to actually users because Facebook actually exactly knows who I am and then can track throughout my user session. So that gives them a bit more better data. So if you look into the audio demographics for example, in Facebook Analytics, you can see that there is much more data there that is interesting for us because we know that they are real user profiles that Facebook Analytics actually has in their database that they can provide us now as an advertiser or as an analytics user.
Now let’s talk about the popularity or the reach of the tools that the tools have. I think that Google Analytics is still the most widely used web tracking tool out there. There are a few competitors. I think of Yandex Metrica, which has also a very robust system behind it and give you all the data that you need. But people are just very locked-in to Google Analytics because they don’t want to change their tracking system. Maybe they don’t want to re-tag their website and it has been running for years. You know that Google Analytics is not retroactive, so you can’t be pulling in historical data into the tool. So they just keep it running, most of the website owners keep it running because they have a history of data. And if they would turn that off all that data would not exist anymore. So there’s a strong lock-in effect in terms of using Google Analytics.
Now Facebook Analytics actually has another tool that we install. Pretty much everybody, as Facebook Ads got more and more popular, you install the Facebook pixel on your website and the Facebook pixel actually provided ours with conversion tracking data. Now it’s more retargeting data and suddenly we have this whole database of Facebook Analytics available to us. So the popularity will grow as Facebook Ads grows to be the defacto one of the websites that you can buy advertising on. And Google has that obviously as well, but Facebook Analytics becomes more popular because you just have it installed already. That said, will you change over your defacto analytics tool from Google Analytics to Facebook Analytics? That’s the question. I haven’t yet seen people discuss their Facebook Analytics metrics, rather their Google Analytics metrics. So if you see somebody who is selling a website, you might as well look into their Google Analytics rather than their Facebook Analytics. It is interesting to see whether this will change over time. But for now, Google Analytics remains the dominant tool in the analytics market when it comes to website tracking.
Now let’s talk a little bit about functionality and versatility of the tools. Obviously, Google Analytics is a tool that has been developed over the years and has a lot of functionality that Facebook Analytics just doesn’t have. So if you think about the base checking, yes, you can see page use, which Facebook Analytics and Google Analytics. You can see sessions and so on. But Google Analytics has a much broader spectrum of customizations that you can make through to it. When I think about enhanced e-commerce checking, custom dimensions, user ID tracking, calculated metrics, custom metrics and so on, that’s all a very customized version of Google Analytics. And you can customize Google Analytics to the business model here. With Facebook Analytics it gives you the basics, but it doesn’t let you expand a lot of that. Now, Facebook Analytics has opened up their Facebook pixel and it has opened up over the years so you can send custom data in. But in Facebook Analytics it’s really hard to still see that data, to pull it out of the interface and actually make sense of that data. They are now doing auto tracking, so they are picking up all that meta information that you might have on the page. But they’re not really exposing that in the interface per se and giving you smart insights on that. So it’s still in the basic raw form of tracking data. I think that there will be more features introduced and maybe these features will be different from what we see in Google Analytics. But for now, Google Analytics has still many more customization features then Facebook Analytics.
So in the end, what is my conclusion? What tool is actually better? If I look at Facebook Analytics, I think that it’s really interesting that the shift really happens in the underlying tracking mechanism on how Facebook Analytics is able to track people and maybe give us more insights in terms of maybe attribution, but also demographic data and then lifetime of the user, going through the system and maybe looking at different websites. They play to their advantage a little bit of that already in there demographics data or in their funnel analysis. But it’s not too apparent yet why Facebook Analytics is the next analytics tool that we should be using. We see over the next coming months, over the next years how Facebook Analytics evolves and maybe it will become the defacto tool because it just has a better tracking basis of what we can do with our analytics data. But as you know, Google Analytics is much more than just a tool. We have so much more data available outside of Google Analytics and they are connecting so much more to it. So we have Google Tag Manager, we have Data Studio, we have Google Optimize so all these different tools really feed into the whole ecosystem that Google has built with their analytics suite. And maybe that will keep us locked-in to the analytics suite. For now, I don’t see why you shouldn’t be using two tools at the same time. It just gives you a different tracking and different database at the end. For most of my data, I actually still use Google Analytics to do quick analysis. I just know the interface better, but also I trust the data more because I know how it actually pulls in. And Facebook Analytics, it’s still a black hole. Their documentation is not yet there where you really know how to manipulate any kind of customization that you can do in the tool. And maybe they will never reveal this because right now Facebook Analytics is a tool that you add on to you advertising to get more insights from it. It’s not really something that you would use as a stand alone tool to analyze your website. But as I said, maybe I’m a very particular case.
And I’d love to hear from you if you are using Facebook Analytics over Google Analytics then please let me know in the comments below. I’d be really interesting to hear if you’re using Facebook or Google Analytics as your main tool. And if you like this video then please, give us a thumbs up and also subscribe to our channel right over there because we will bring you new videos just like this one, every week. Now my name is Julian, till next time
Data Analysis with Google Sheets – How to do it?
Spreadsheet software like Excel or Google Sheets are still a very widely used toolset for analyzing data. Sheets has some built-in Quick analysis features that can help you to get a overview on your data and very fast get to insights.
#DataAnalysis
#GoogleSheet
#measure
Links mentioned in the video:
Supermetrics: http://supermetrics.com/?aff=1014
GA Demo account: https://support.google.com/analytics/answer/6367342?hl=en
Learn more from Measureschool: https://measureschool.com/products
Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
Our tracking stack:
Google Analytics: https://analytics.google.com/analytics/web/
Google Tag Manager: https://tagmanager.google.com/
Supermetrics: http://supermetrics.com/?aff=1014
ActiveCampaign: https://www.activecampaign.com/?_r=K93ZWF56
FOLLOW US
Facebook: http://www.facebook.com/measureschool
Twitter: http://www.twitter.com/measureschool
In this first part of our data analysis with Google Sheets series, we’re going to take a look at the built in functionalities of Google Sheets to analyze data, all and more coming up.
Hey there welcome back to another video of measureschool.com, teaching you the data driven way of digital marketing. My name is Julian. And if you’re new to the channel, we do marketing tech reviews, tutorials, and the occasional live stream, all on the data driven way of digital marketing here on this channel, so if you haven’t yet, consider subscribing down below. Now today, we want to kick off our series on data analysis with Google Sheets. Now Google Sheets and Excel for that matter, are still a widely used BI tool for analysis and data analysis. As a whole, you might be able to actually analyze your data in Google Analytics, for example, on AdWords, but it gets so much more powerful once you pull it actually down. Do your own analysis and dig through the data in the raw data and most of the times with Google Sheets. So in this series, we’re gonna take a look at all these different tools that you have available in Google Sheets to slice and dice your data and get meaningful insights out of the data. And we’re gonna start out with the built in functionalities of Google Sheets, and how you can do quick analysis, get a quick overview with some data. Now we got lots to cover. So let’s dive in.
Alright, before we start in Google Sheets, we actually need to have some data available. So I’ve logged into the Google Analytics demo account that you can also get access to just check out the link in the description below. And I’m here in the conversion, ecommerce product performance report where we have some nice data in here that we want to analyze. Now, the next step would be copying this out into Google Sheets. We could do this manually, obviously, but this is quite cumbersome. So Google has an export function. Right here that we will use, just click on Export and Google Sheets here. And we can import the data right into Google Sheets. Now if you would like to optimize this whole process, I’d recommend a tool called Super metrics, which you can install as an add on to your account and can pull the data directly from the API. I’m also going to link this up in the description below. Now that we have this sheet available with all our data, let’s look at how we can analyze that data a little bit. First up, let’s clean this data a bit. So up here, this shouldn’t belong to our data set, we can simply market and press the delete button. If we wanted to put this in the first row. Because this I had a row I can actually get rid of the other rows by marking them as well. Right clicking and deleting these rows. Now we have our first row as a header row.
Now it’s also important to visually make this data a bit more appealing so we know at a quick glance What we’re looking at. So here’s our header row, let’s mark this and actually make this bold, we could also change the background color here, example to blue, change the font color, and so on. There are many different options to actually change data and make it more accessible when you look at it at a quick glance. Now, if you scroll down this data, we actually at the end here, scroll down even further, have some additional data that is pulled. This is actually the data that is available from this graph here. You won’t need this for now. So I’m just going to get rid of this. And also the last row here summarizes some eight all the data above we’ll get rid of this as well because we will do this data analysis the summation in ourselves in the sheet. So now we are left with our raw data that we want to analyze. And this is already one of the first steps that we went through. We actually cleaned our data, we made it a little bit more accessible. So we are ready to analyze a clean data set, as opposed to going back and forth between a data set that we haven’t cleaned yet and need to take care of on the fly later on. So make sure your data is in the correct format and convenient to read in order to go over to the analysis step. All right, next, let’s do a little bit of quick analysis with the built in tools that we have in Google Sheets and can utilize right away when we spot something in a data that we want to analyze. So first up, how can you sort this table now obviously, right now, it’s sorted by the product revenue, but we can sort by any kind of column, all we need to do is hover over the column that we want to sorted by click here on sort from A to Zed. So now we get the zeros most likely, up here. Now what we have just done is also sought our first header column and in order to prevent us Let’s go back, just press your Ctrl Z, we need to actually freeze this column. You can do this by simply dragging down this part of your spreadsheet down here. So now the first column is frozen. And when we scroll down, it actually stays in place. So we’ll be able to still analyze the data again, go back here and press this time on SOT Zed to a. So it will show us our highest quantities first. And we can see this product has been sold most often in terms of the quantity that was put into the basket. So again, you can get quick insights by sorting these columns or finding particular outliers. So if you go back here and say, Okay, these were never sold, but some have been put into the basket quite often, but never bought. Maybe something to look into even further. If you find anything that strikes our analysis Fancy, we can do quick analysis as well with the quick sum functions. And this is done by just simply marking the cells that you want to analyze. So for example, let’s go with the first 10 products here, and we are marking the quantity. And then down here in the right bottom corner, we can see a function that has quickly summed up all the values that we had in our range here of the cells. So our top 10 products that were sold, make up about 9000 units, as opposed to, let’s mark the whole quantity column just by clicking up here, the 17,600 products that were sold overall, so we get a quick ratio of how much the best 10 products or the most sold products are in comparison to the overall pie. In this case, it would be over a half of the product. So again, quick analysis just through the built in features here. have Google Sheets. Once we click on this box, we can actually see other data such as the average, the minimum, the maximum, the count, and the count numbers, which are actually the numbers minus the header row here in this deck. So again, without doing any kind of fancy functional analysis, we have a quick overview of our data. Now, you might also want to filter out data because we have a lot of values in here that maybe didn’t sell anything. So right here, we just want to see the products that actually sold something. How would we achieve that? Well, there is a built in button right here, which is this filter button, we can just click on it with our header row in focus. And it will summarize our data in this table and we get these little buttons here in our header row. And we can click on this and then we get down here all the values that are in here. You can also put in a Filter condition. So for example, our sell should be greater than zero. And now it should take out all the different products that didn’t sell at all. So quick way to actually filter our data, we have other mechanisms. And here, again, we have our sorting options, we have the values. So for example, if we get rid of this, go back to normal. Let’s go here to our product column and say, we only want to have products in here that actually buy the brand. Next, let’s go back. Let’s clear them all and then go to nest and select them all that are in our list. Press OK. And now, we only have our nest products here in this table and can compare that so really a quick, very quick way to use the built in functionality of this filter functions within Google Sheets. Let’s go again to select all. So we go back.
And here we are back in our products. Now the last built in feature that I want to show you is actually something new, a big push that Google is doing in all of its products, which is artificial intelligence. And this is built into the Google Sheets product here with this Explorer. So when you click on that, Google will analyze our data and give us some suggestions here of questions, we might want to ask like average of the order quantity. Let’s click on that. And that would be 1.068. And this is this column that was analyzed. So we don’t even have to fill in any kind of formula. It does it all automatically, we can see the formula so this is what we would put into this formula bar, which we’ll do in another video, but it really gives us quick analysis on the fly. If you’re interested in these questions. we scroll down we get some graphs that were analyzed like the basket to detail ratio, we get Unique purchases, how that is distributed. And we could even ask a question about our data, like how many products and it says here, how many products were sold of the maze pen count here is four. This is not quite correct. But again, the AI engine should be able at some point to pick up that we wanted to have the quantity of this product. So maybe we need to rephrase. And now we get the correct answer back. A bit counterintuitive, but again, pandas is a machine learning algorithm that will hopefully understand in the near future, all our questions that we would put into such a question and answer engine. So again, a quick way to do analysis in Google Sheets.
Alright, so there you have it. This is how you can use the built in functionalities. Google Sheets with a quick inside quick overview on your data. With the built in functionalities of sheets. We talked about sorting your data, but also filtering it. And then we looked at the functionality of explore your data within Google Sheets, and hopefully it will get a little bit better to answer all our questions on the fly. Now in our next video, we’re going to take a look at some more functionalities within Google Sheets to analyze our data. We’ll talk about functions for example. So be sure to subscribe to our channel right over there. And if the videos are already out, you can find it right there as well. And I hope to see you in the next lesson. My name is Julian. See you in the next lesson.
Import JSON-LD Meta Information from the YouTube API for embedded Videos
Having JSON-LD data about your embedded Videos on your site can help produce Rich Search Results for Videos in Google Search. Just writing this data can be tedious, so we came up with a workaround that enables us to pull the data directly from the YouTube API and transfer it into a JSON-LD object.
#JsonLD
#YouTube
#GoogleTagManager
? Links mentioned in the video:
JSON-LD for Video: https://developers.google.com/search/docs/data-types/videos
Structured Data Testing Tool: https://search.google.com/structured-data/testing-tool
Template: https://measureschool.com/youtubeschema
? Learn more from Measureschool: https://measureschool.com/products
?Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
? Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
? Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
? FOLLOW US
Facebook: http://www.facebook.com/measureschool
Twitter: http://www.twitter.com/measureschool
What Should You Be Tracking For Your Ecommerce Store?
“What data should I actually be tracking for my eCommerce store?”
This might be something you’re asking yourself as an commerce owner and with all the tracking options things can quickly get overwhelming.
Just tracking everything is not a good solution and more data doesn’t always mean more insights, so in this video we’ll show you how to figure out what kind of data you SHOULD be tracking for your eCommerce store to get the best measurement results.
#EcommerceTracking
#Measure
#Tracking
? Links mentioned in the video
Create and use UTM Tags for GA: https://www.youtube.com/watch?v=MNOsldDS_pY
What you should be tracking in GA: https://www.youtube.com/watch?v=HhNW_tOQ7F8
Google Analytics Demo Account: https://support.google.com/analytics/answer/6367342?hl=en
More Google Analytics Tutorials: http://yt.vu/p/PLgr_8Hk8l4ZHY28V3otkZFeb1KK9HTOSd
? More from Measureschool
Correct Google Analytics Setup Course: https://measureschool.com/products/google-analytics-course/
GTM Resource Guide: https://measureschool.com/guide
Free GTM Beginner course: https://measureschool.com/emailcourse
Courses: https://measureschool.com/products
?Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
? Recommended Measure Books: https://kit.com/Measureschool/recommended-measure-books
? Gear we used to produce this video: https://kit.com/Measureschool/measureschool-youtube-gear
? FOLLOW US
FACEBOOK: http://www.facebook.com/measureschool
TWITTER: http://www.twitter.com/measureschool
– So what should you be tracking for your ecommerce store? In this video I’m gonna show you what you should be setting up in your Google Analytics to track your ecommerce store correctly. All and more coming up right after this. Hi there and welcome to another video of MeasureSchool.com where we teach you the data-driven way of digital marketing. My name is Julian and on this channel we do marketing tech reviews, tutorials, and give you tips on better tracking just like this one. So if you haven’t yet consider subscribing. Now a while ago I did a video on what you should be tracking for your website and that more data doesn’t always equal more insights. So, if you have an ecommerce store, you might be asking yourself how can I apply this to my ecommerce store and build up the tracking. Now I have worked in ecommerce companies before, when I started out my digital marketing career, so I have a little bit of insights because we did a lot of things wrong and tracked a lot of data that we never used. So in this video I’m gonna give you some tips on what you should be tracking for your ecommerce store. Alright, before we get started, you need to have your Google Analytics installed and there we can start with the basic setup. Now, what is important for an ecommerce store? For an ecommerce store really it’s important to get your outcome tracked, which is the sale, this is something you want to increase, this is the number you want to increase at the end of the day. Now, gathering context about this data point, about the actual sale is very important. Google Analytics, for example, has a very nice feature which is called the ecommerce tracking, which lets you do exactly that, gather data about your sale, but also about the context of the sale, so how much was sold, what price was in there, what products were bought, shipping costs, and so on. So you have a lot of data surrounding this and can analyze it later on in your tracking correctly. So this is the most important part to install on your ecommerce store, and if your ecommerce store doesn’t have that installed get it installed right now. Now, the second part is all about getting your sources tracked, and this is about the question where did my users or the sales come from in the end. And this is all about getting your landing page URLs tagged correctly with UTM parameters. If you don’t know what they are, I have another video on that as well. But this will tell you where your users are from and give you that crucial part of you have people coming to your website and converting somehow, and where did these people come from and did they buy or didn’t they buy. So we have these two pieces that are crucial for our basic setup of Google Analytics on an ecommerce store. And really for me, this is really a lot of insight already, so if you are working on optimizing your ad spend, you can be tracking a lot through these two pieces already, and these need to be in place in order to have a base tracking that actually works for your ecommerce store. Now let’s get into the advanced section. Now, in the advanced section you would like to get more insights from your data, and probably you have a little bit of resources available to actually look at that data and also gain insights from it. What I would recommend is to gather data about the crucial touchpoints of your website. So when people come from that source that you have defined and that you can now use to actually segment your traffic, then you want to be making sure that they go through the checkout completely, or what they actually do on the category pages, how do they use the category pages, how do they use the product pages, and so on, and there’s a great feature set within the Google Analytics called Enhanced Ecommerce Tracking. Now, when you want to install this, it’s probably a little bit harder to set up. That’s why I would recommend to get proper help to install this. But the data that you will get is very beneficial to actually look at that and gain great insights about how your users are using your ecommerce website. And this is really already a little bit more sophisticated, you need to have somebody to actually look at the data and, again, gain insights from it and take action on that and optimize your website. Other than that I think that’s already a very big step up in the right direction to getting a bit more advanced in your analytics efforts on your ecommerce website. Alright, then you go into the expert level, and the expert level is all about getting more insight and more contextual data about the data points that you have already been tracking. So being able to segment your data in a more meaningful way is very important, so you need to send more dimensions and more contextual data into Google Analytics in order to be able to do that actually. What I would recommend is to set up a plan, think about which questions you really want to answer, and then send the right custom dimensions into the system. So, for example for users, is this already an existing customer? What is his lifetime value, for example? How can we be tracking that within the Google Analytics, also outside of the system, so on a more BI basis, going more into the different systems that you might have set up and your CRM system, and so on, to gain insights. Again, this is something that you would probably do once you have a person inside of the company who is already responsible for data, a BI person, or somebody who is an analyst within the company, who can actually take that data and do the hard number crunching. This is not something that you will probably do as an online marketer who just looks into how can I optimize my PPC campaign. So it needs a bit more effort to send the data in, it needs a bit more effort to get insights out, and it needs resources to maintain the data as well, and so be very intentional, again, about what you should be tracking for your ecommerce store. Alright, I hope these tips help you to get a better sense and feeling about what you should be tracking for your ecommerce store. If you have any questions about this or you have any suggestions, please leave them in the comments below. I would be really interested, if you are an ecommerce owner, what you think is the most important part of your analytics today and the data that you are gathering. And if you like this video, please give it a thumbs-up and subscribe to this channel, because we’ll bring you new videos every Wednesday. My name is Julian. Till next time!
How to Use Hotjar – A Beginners Guide
Sign up for Hotjar: https://www.hotjar.com/r/r825b
Hotjar is really an amazing tool when it comes to measuring qualitative data about the users of your website. In this video, we’ll take a closer look at Hotjar and how to use it in our advantage.
How to come up with mor A/B Tests http://conversionxl.com/how-to-come-up-with-more-winning-tests-using-data/
Hotjar UserID tracking in GA with GTM https://www.savio.no/google-analytics/hotjar-user-id-tracking-google-analytics-v2
GTM Ressource Guide: https://measureschool.com/guide
Free GTM Beginner course: https://measureschool.com/emailcourse
Courses: https://measureschool.com/products
Looking to kick-start your data journey? Hire us: https://measureschool.com/services/
FOLLOW US:
http://www.facebook.com/measureschool/
http://www.twitter.com/measureschool/
RECOMMENDED MEASURE BOOKS: https://kit.com/Measureschool/recommended-measure-books
GEAR WE USED TO PRODUCE THIS VIDEO: https://kit.com/Measureschool/measureschool-youtube-gear
– [Narrator] This week’s video, we’ll take a closer look at Hotjar, really a great tool when it comes to measuring qualitative data about the users of your website. All and more coming up right after this. Hi there and welcome to another video of measureschool.com where we teach you the data-driven way of digital marketing. My name is Julian. And on this channel, you’ll find more tutorials for the modern marketer. So if you haven’t yet, please consider subscribing. And also check out the description below because we have more links on today’s topic. Now, let’s get into today’s video. So today we’re gonna talk about Hotjar. As I say, an all-in-one solution for analytics and feedback. I would say that this tool is really a good tool for qualitative data as opposed to quantitative data that you can gather with a Google Analytics or on a Dewey Analytics. So what is the feature set of Hotjar? They give you a few different tools like heat maps, video recordings, and surveys that you can run on your website in order to get qualitative feedback and understand your users better. And all this for a pretty affordable price I would say because previously such tools would be much more expensive to install on the website. So once you sign up, you get greeted with the interface. And the first thing that you would need to do is install Hotjar on your page. Now, this is mostly done through a little bit of JavaScript that you need to install. And if you want, you can drop that into Google Tag Manager and have it installed within minutes. Once that is done, you are all ready to go. Let’s go back to the interface here. And we can see the tools that we have to our disposal. First of all, there would be heat maps where you could actually see where the people click or move or scroll on your page. This is quite interesting if you have a longer landing page and wanna see which elements were seen by the user, maybe even clicked on, although they are not clickable. This gives you really fast insight into the mind of your users, in combination with the movement of the actual mouse pointer and the scroll depth tracking. This can be super valuable if you want to know how far a user scrolled just on one specific page and want to have this nicely visualized with heap maps. So really a great tool that is built into Hotjar with just one JavaScript. Let’s go over to recordings, one of the probably most interesting features because with Hotjar, you can actually record what the user does on your webpage. And this can be super valuable once you want to understand your user a bit better. So for example here, you can play a video recording of the user entering the website or a special page, what he clicked on, what he saw. This is a mobile user and obviously our page is not that well mobile optimized. The cool thing about video recordings is that you can also play them very fast so you’ll be able to go through many different video recordings on a page-by-page basis again and you can even filter down to only see special pages and see the similarities between users going through your pages. So again, a very interesting feature when it comes to qualitative data and understanding your user better. Obviously this is a bit more resource intensive. In the free version, you only get 100 recordings which makes it worth upgrading to a bigger account if you need more recordings. I have seen conversion rate experts use these recordings to drill down on a given page and find out maybe what is wrong, how do people actually use that page and quickly go from a hypothesis or a hunch to a more concrete idea why this page is failing. So recordings are really a great way to find mistakes on your website if you already have an idea where to look for them. Next up are funnels. Now, funnels are something that I don’t use in my Hotjar installation. Why not? Because they actually, quite like Google Analytics funnels, you can only use the page URL to match up the funnel steps. They’re a bit more flexible than what Google Analytics has. But at the end, you don’t wanna be restricted to just page URLs. Then, I would rather build my own custom funnel with the help of events and the enhanced e-commerce tracking feature of Google Analytics. We did another video on that a while back. So funnels is a nice-to-have feature within Hotjar, but for me it’s mostly useless because we also have that in Google Analytics. Let’s go over to forms. Forms is really interesting because you can actually choose a form on your website and they will build a funnel for you and look at how many people actually submitted that form in the end and what the drop off rate was once the user went through and started filling out that form. So if you have a longer form on your page, this can be really interesting and give you fast insights on how to optimize your forms. Then we have a little bit of feedback mechanisms here. We have really fast polls. So what are polls? They are basically these little popups that you see on a given page. They pop up from the bottom of the page and ask you a quick question. What are you currently learning for example. Easy way to get again qualitative feedback from your users through a quick survey that you can implement easily on your website with the help of Hotjar. Again, easy to use, fast to implement, all through one tool which is Hotjar which is really, really convenient when it comes to surveying your website visitors. And the other tools here are surveys that you can run which have a certain given page or you can also recruit users to use a testing panel that you might want to run on your website. All in all, the feedback mechanisms of Hotjar are really nicely built and easy to implement once you have the JavaScript on your page. So there you have it. This is a little overview on Hotjar. In my opinion, a really great tool set for getting qualitative feedback from your website users, all easily implemented through just one JavaScript that you can drop into Google Tag Manager and start using right away. I would recommend this tool to anybody who wants to get quick results from analytics by directly getting feedback from the users itself. Now, this is obviously more useful if your user group is still smaller. So if you have a small business website or an e-commerce shop with not too many visitors, it might be well worth it to first use Hotjar and get some insights to optimize your website before you dig into the vast amounts of data that you can get through Google Analytics. So there you have it, a small overview on the Hotjar tool which is a great measurement tool for qualitative data. I usually recommend it to clients who are new to digital analytics, want to dive in, but also want to get a fast insight into the minds of their users. With Hotjar, this is possible. And it’s a great tool set to have in your tracking stack. Now, I also see a lot of conversion rate experts use this tool to find out where the highest leverage point is and where it’s actually worth running in AB testing. But that’s already it with this week’s video of measureschool.com. If you want to dive into more resources, then find the links below in the description. And while you’re down there, please hit that subscribe button to stay up to date with our newest videos which we produce every week here on this channel. And if you have any questions, you can leave them in the comments below. My name is Julian, ’til next time.