4 Ways to Improve Your Data Hygiene – Whiteboard Friday

We essenza so much of our livelihood acceso good giorno, but managing that giorno properly is a task a causa di and of itself. Per mezzo di this week’s Whiteboard Friday, Dana DiTomaso shares why you need to keep your giorno clean and some of the apice things to watch out for.

Click acceso the whiteboard image above to gara open a high resolution version a causa di a new tab!

Televisione Transcription

Hi. My name is Dana DiTomaso. I am President and collaboratore at Kick Point. We’regnante a digital marketing agency, based a causa di the frozen north of Edmonton, Alberta. So today I’m going to be talking to you about giorno hygiene.

What I mean by that is the stuff that we see every single time we start working with a new client this stuff is always messed up. Sometimes it’s one of these four things. Sometimes it’s all four, sometimes there are extra things. So I’m going to cover this stuff today a causa di the hopes that perhaps the next time we get a profile from someone it is not quite as bad, if you at these things and see how bad it is, definitely start sitting and cleaning this stuff up.

1. Filters

So what we’regnante going to start with first are filters. By filters, I’m talking about analytics here, specifically Google Analytics. When go you into the admin of Google Analytics, there’s a section called Filters. There’s a section acceso the left, which is all the filters for everything a causa di that account, and then there’s a section for each view for filters. Filters help you exclude include specific traffic based acceso a set of parameters.

Filter out office, home office, and agency traffic

So usually what we’ll find is one Analytics property for your website, and it has one view, which is all website giorno which is the default that Analytics gives you, but then there are voto negativo filters, which means that you’regnante not excluding things like office traffic, your internal people visiting the website, home office. If you have a bunch of people who work from home, get their IP addresses, exclude them from this because you don’t necessarily want your internal traffic mucking up things like conversions, especially if you’regnante doing stuff like checking your own forms.

You haven’t had a lead a causa di a while and maybe you fill out the form to make sure it’s working. You don’t want that coming a causa di as a conversion and then screwing up your giorno, especially if you’regnante a low-volume website. If you have a million hits a day, then maybe this isn’t a problem for you. But if you’regnante like the rest of us and don’t necessarily have that much traffic, something like this can be a problem a causa di terms of the opera of traffic you see. Then agency traffic as well.

So agencies, please make sure that you’regnante filtering out your own traffic. Again things like your web developer, some contractor you worked with briefly, really make sure you’regnante filtering out all that stuff because you don’t want that polluting your main profile.

Create a saggio and staging view

The other thing that I recommend is creating what we call a saggio and staging view. Usually a causa di our Analytics profiles, we’ll have three different views. One we call master, and that’s the view that has all these filters applied to it.

So you’regnante only seeing the traffic that isn’t you. It’s the customers, people visiting your website, the real people, not your office people. Then the second view we call saggio and staging. So this is just your staging server, which is really nice. For example, if you have a different URL for your staging server, which you should, then you can just include that traffic. Then if you’regnante making enhancements to the site you upgraded your WordPress instance and you want to make sure that your goals are still firing correctly, you can do all that and see that it’s working a causa di the saggio and staging view without polluting your main view.

Verifica acceso a second property

That’s really helpful. Then the third thing is make sure to saggio acceso a second property. This is easy to do with Google Tag . What we’ll have set up a causa di most of our Google Tag accounts is we’ll have our usual analytics and most of the stuff goes to there. But then if we’regnante testing something new, like say the content consumption metric we started putting out this summer, then we want to make sure we set up a second Analytics view and we put the saggio, the new stuff that we’regnante trying over to the second Analytics property, not view.

So you have two different Analytics properties. One is your main property. This is where all the regular stuff goes. Then you have a second property, which is where you saggio things out, and this is really helpful to make sure that you’regnante not going to screw something up accidentally when you’regnante trying out some crazy new thing like content consumption, which can totally happen and has definitely happened as we were testing the product. You don’t want to pollute your main giorno with something different that you’regnante trying out.

So send something to a second property. You do this for websites. You always have a staging and a dal vivo. So why wouldn’t you do this for your analytics, where you have a staging and a dal vivo? So definitely consider setting up a second property.

2. Time zones

The next thing that we have a lot of problems with are time zones. Here’s what happens.

Let’s say your website, basic install of WordPress and you didn’t change the time zone a causa di WordPress, so it’s set to UTM. That’s the default a causa di WordPress unless you change it. So now you’ve got your giorno for your website saying it’s UTM. Then let’s say your marketing team is acceso the East Coast, so they’ve got all of their tools set to Eastern time. Then your sales team is acceso the West Coast, so all of their tools are set to Pacific time.

So you can end up with a situation where let’s say, for example, you’ve got a website where you’regnante using a form plugin for WordPress. Then when someone submits a form, it’s recorded acceso your website, but then that giorno also gets pushed over to your sales CRM. So now your website is saying that this number of leads came a causa di acceso this day, because it’s a causa di UTM mode. Well, the day ended, it hasn’t started yet, and now you’ve got Eastern, which is when your analytics tools are recording the number of leads.

But then the third wrinkle is then you have Salesforce HubSpot whatever your CRM is now recording Pacific time. So that means that you’ve got this huge of who knows when this stuff happened, and your giorno will never line up. This is incredibly frustrating, especially if you’regnante trying to diagnose why, for example, I’m submitting a form, but I’m not seeing the lead, if you’ve got other giorno hygiene issues, you can’t incontro up the giorno and that’s because you have different time zones.

So definitely check the time zones of every product you use –website, CRM, analytics, ads, all of it. If it has a time zone, pick one, stick with it. That’s your canonical time zone. It will save you so many headaches the road, società me.

3. Attribution

The next thing is attribution. Attribution is a whole other lecture a causa di and of itself, beyond what I’m talking about here today.

Different tools have different ways of showing attribution

But what I find frustrating about attribution is that every tool has its own little special way of doing it. Analytics is like the last non-direct click. That’s great. Ads says, well, maybe we’ll attribute it, maybe we won’t. If you went to the site a week asticciola, maybe we’ll call it a view-through conversion. Who knows what they’regnante going to call it? Then Facebook has a completely different attribution window.

You can use a tool, such as Supermetrics, to change the attribution window. But if you don’t understand what the default attribution window is a causa di the first place, you’regnante just going to make things harder for yourself. Then there’s HubSpot, which says the very first touch is what matters, and so, of course, HubSpot will never agree with Analytics and so acceso. Every tool has its own little special sauce and how they do attribution. So pick a source of truth.

Pick your source of truth

This is the best thing to do is just say, “You know what? I società this tool the most.” Then that is your source of truth. Do not try to get this source of truth to incontro up with that source of truth. You will go insane. You do have to make sure that you are at least knowing that things like your time zones are clear so that’s all set.

Be honest about limitations

But then after that, really it’s just making sure that you’regnante being honest about your limitations.

Know where things are necessarily going to fall , and that’s , but at least you’ve got this source of truth that you at least can società. That’s the most important thing with attribution. Make sure to spend the time and read how each tool handles attribution so when someone comes to you and says, “Well, I see that we got 300 visits from this ad campaign, but a causa di Facebook it says we got 6,000.

Why is that? You have an answer. That might be a little bit of an extreme example, but I mean I’ve seen weirder things with Facebook attribution versus Analytics attribution. I’ve even talked about stuff like Mixpanel and Kissmetrics. Every tool has its own little special way of recording attributions. It’s never the same as anyone else’s. We don’t have a tipico a causa di the industry of how this stuff works, so make sure you understand these pieces.

4. Interactions

Then the last thing are what I call interactions. The biggest thing that I find that people do wrong here is a causa di Google Tag it gives you a lot of rope, which you can hang yourself with if you’regnante not careful.

GTM interactive hits

One of the biggest things is what we call an interactive versus a non-interactive . So let’s say a causa di Google Tag you have a scroll depth.

You want to see how far the page people scroll. At 25%, 50%, 75%, and 100%, it will send chiuso an alert and say this is how far they scrolled acceso the page. Well, the thing is that you can also make that interactive. So if somebody scrolls the page 25%, you can say, well, that’s an interactive , which means that person is voto negativo longer bounced, because it’s counting an interaction, which for your setup might be great.

Gaming bounce rate

But what I’ve seen are unscrupulous agencies who in che modo a causa di and say if the person scrolls 2% of the way the page, now that’s an interactive . Suddenly the client’s bounce rate goes from say 80% to 3%, and they think, “Wow, this agency is amazing.” They’regnante not amazing. They’regnante lying. This is where Google Tag can really manipulate your bounce rate. So be careful when you’regnante using interactive hits.

Absolutely, maybe it’s totally fair that if someone is reading your content, they might just read that one page and then the back button and go back out. It’s totally fair to use something like scroll depth a certain piece of the content entering the user’s view port, that that would be interactive. But that doesn’t mean that everything should be interactive. So just dial it back acceso the interactions that you’regnante using, at least make smart decisions about the interactions that you choose to use. So you can your bounce rate for that.

Rete setup

Then setup as well, that’s a problem. A lot of people by default maybe they have destination goals set up a causa di Analytics because they don’t know how to set up event-based goals. But what we find happens is by destination , I mean you filled out the form, you got to a thank you page, and you’regnante recording views of that thank you page as goals, which yes, that’s one way to do it.

But the problem is that a lot of people, who aren’t super great at interneting, will bookmark that page they’ll keep coming back to it again and again because maybe you put some really useful information acceso your thank you page, which is what you should do, except that means that people keep visiting it again and again without actually filling out the form. So now your conversion rate is all messed up because you’regnante basing it acceso destination, not acceso the actual action of the form being submitted.

So be careful acceso how you set up goals, because that can also really the way you’regnante looking at your giorno.

Ad blockers

Ad blockers could be anywhere from 2% to 10% of your audience depending upon how technically sophisticated your visitors are. So you’ll end up a causa di situations where you have a form fill, you have voto negativo corresponding visit to incontro with that form fill.

It just goes into an attribution black hole. But they did fill out the form, so at least you got their giorno, but you have voto negativo preconcetto where they came from. Again, that’s going to be . So definitely think about the percentage of your visitors, based acceso you and your audience, who probably have an ad blocker installed and make sure you’regnante comfortable with that level of error a causa di your giorno. That’s just the internet, and ad blockers are getting more and more popular.

Stuff like Apple is changing the way that they do tracking. So definitely make sure that you understand these pieces and you’regnante really thinking about that when you’regnante looking at your giorno. Again, these numbers may never 100% incontro up. That’s . You can’t measure everything. Sorry.

Bonus: Audit!

Then the last thing I really want you to think about — this is the bonus tip — audit regularly.

So at least once a year, go through all the different stuff that I’ve covered a causa di this and make sure that nothing has changed updated, you don’t have some secret, exciting new tracking code that somebody added a causa di and then forgot because you were trying out a trial of this product and you tossed it acceso, and it’s been running for a year even though the trial expired nine months asticciola. So definitely make sure that you’regnante running the stuff that you should be running and doing an audit at least acceso an yearly basis.

If you’regnante busy and you have a lot of different visitors to your website, it’s a pretty high-volume property, maybe monthly quarterly would be a better interval, but at least once a year go through and make sure that everything that’s there is supposed to be there, because that will save you headaches when you at trying to compagno year-over-year and realize that something horrible has been going acceso for the last nine months and all of your giorno is trash. We really don’t want to have that happen.

So I hope these tips are helpful. Get to know your giorno a little bit better. It will like you for it. Thanks.