It's time to tag team and by tag team, I mean, if you don't know how to use Google tag manager, you need to tag someone, find someone who does to work for your business or to help you as a marketer and for the most complex and important questions within your business. My name is Ryan with elevated conversions. And today I'm going to show you how a one way to use Google tag manager actually for car dealerships and how you can use it to not pay an expensive, [00:00:30] you know, third-party marketing company to tell you how many cars, uh, what traffic sources sold, how many cars. Uh, there's plenty of companies that will charge you a nominal like for that, it's obviously a very important question. Um, I don't, I've worked with, uh, multiple different third-party companies out there that you're going to help you find that answer.
So they'd tell you and you know, a lot of them do a pretty good job, but as uh, a technical, uh, measurement marketer, uh, if you know how to use Google tag manager and Google [00:01:00] analytics and you're a creative problem solver, you don't need their fancy attribution models, which I was never fully convinced on those having used those, talked with their teams at length. Um, and so I'm going to show you, um, how you can do it yourself. Um, if you're a car dealer and I'm the only investment is your time, um, or higher and someone like me to do it for you if you don't want to try and figure this out, but it's not that complicated. And Google tag manager, uh, I'm going to go into more of [00:01:30] after you set it up in Google tag manager, how you see it in Google analytics and you just push that to a simple Google sheet and then just do a v lookup.
Which is seen right here. My computer's loading a bit. I think I have a few times open. All right, so I'm going to just [00:04:00] close that as once again. And then what I did is I used a secondary dimension and I just typed in vehicle vin is that's the custom dimension. Um, and that's coming in, uh, as a custom dimension. As a, uh, a page view, uh, hits a level custom dimension. I'm not going to go into what that means, but it means that the hit can change from page to page and obviously each page has its own bin numbers. So we want to import the custom dimension as they hit level dimension. [00:04:30] So we have all the sources, we have the vehicle vin numbers. And what we simply did is just an export this into a Google sheet, uh, which was pretty easy to just a built in. You can export, um, right up here and just as Google sheets. So we did that and why copied all the source mediums and all of the bins and I put it in a different spreadsheet, just kind of wanted to use a different spreadsheet. And so let's take this filter off. So what we're looking [00:05:00] at is all of the vins in Google analytics. S
This is Google analytics. Let's color these two orange like Google analytics and this will color light bread has, that's probably the CRM. This dealer is using. This is just dummy sold vin numbers. I just chose a few from here so we would see which ones are or will be able to surface which ones are assault. Um, I just put some random prices and dates as well too. This is all dummy [00:05:30] data minus the GA is actually the real day. There should be just saw, um, this is all dummy data, but the point is if you have this data you'll be able to figure it out, which is the important part. And so I organized this, uh, how I wanted to, with knowing how we look at v lookups work. And so what we're doing is simply just looking in column a so it tells you what you're looking for or searching for.
Uh, this vin number in column a through the entirety of columns B [00:06:00] through C. I wanted to see because that's what I want to return a within the range of a v lookup. Um, but, uh, we're really just looking in column B for that vehicle Vin number. And this is text. So it's obviously not going to find this vin number in column C and we're returning the second column, which is the index is what um, returns. So if it's an a, that means that where there weren't any website traffic sources in Google analytics attributable for that, [00:06:30] uh, that, that vin number. And if the returns a traffic source, that means it was sold and that's the source that's responsible for. And uh, so what we can do is we can filter then we don't want to see the Nas. We want to see everything that was actually sold and we can simply see the most profitable sources, um, that were actually sold.
So that's super simple way of being able to tangibly, um, see [00:07:00] which sources are actually driving car leads, which is a much more valuable metric. Then, you know, bounce rates or sort of any sort of page engagement metrics. Dealers want to know if cars were sold or not. And this is a way where with some technical knowledge, I think Google tag manager is probably the hardest part. Uh, integrating that with Google analytics. Um, but v look up in a, in a Google sheet is, you know, a pretty simple function. You just have to know how that works. And I love keeping [00:07:30] things in the cloud, in Google sheets as opposed to excel. Excel is very unneeded nowadays. I feel like in so many areas and this is definitely one of those. So, um, hope that helps you. If you're a dealer, feel free to shoot elevator conversions, a message.
Uh, we've been in the industry for about four years. Uh, we've been out of the industry for a half of a year. Um, just kind of had a, a change with an existing client we were working with. And um, we, we know our value and we want to be able to be [00:08:00] more consultants in this industry and guide dealers along a data driven business and data informed business-driven decisions, which is really, really powerful. That, and we specialize in building dashboards for dealers, bringing in all the data so that you can see your business health and make decisions based off of your dashboard.