Create a Branded Lead Magnet from Qualitative Data
In this video, learn how to enhance a Google Sheet lead magnet created from qualitative data by adding branding elements, analyzing call-to-action lengths, and improving usability for sharing. Discover tips on making your sheets more appealing and functional.
We found another Google Sheet in the wild. So Josh Nussbaum, who I have met and is a wonderful open source developer, he's The maintainer of Svelte Stripe. He also tweets about Svelte and open, open source software. He has created a qualitative not quantitative, but qualitative data set of H1 subheads and call to actions from many websites. And when I saw this, I was like, it's one, a Google sheet, and two, it's free, but three, it's missing a lot of cool stuff that I think we can add to it.
I'll also put a link down there for you to see that. But yeah, go grab this sheet if you want to see what he's done, and maybe I will give him what we do here, and so hi Josh, and we'll then hopefully we'll see it in action if we do see it eventually, but I want to make this sheet better. Here is the sheet itself. Let's take a file, make a copy and. Close the first one and what we're gonna do here is first off. I want to make this as joshy as possible We're gonna get into a little bit of analysis . I want to do some analysis of the h1 sub heads primary called actions We want to find like the most common ones how long they are how many characters they are all that kind of stuff We'll do a bit of that.
add a row under the frozen one. Why is that? It's because normally if you look at sort of freebies in Sheets, they will add above the freeze line this big banner and they'll say, Hey, I'm Josh and here's my podiaceae, here you can buy stuff from me.
Actually get color from image . I'll just google that it's always gonna be like in the first one We're just gonna upload the image and get the colors.
And actually, we're going to use template , actually I'm not going to use copy for this one, I'm going to use template preview for this one.
we have to actually allow access , so we allow access in there. There's Josh. Hi.
Like we want the sheets that we make to be so useful that they, people want to share them. So don't think about like, there is protections you can do.
if you're a programmer and you're trying to sell to other programmers, add in here, yes, in Apps Script , a note .
But what the cool thing here is, is that it's gonna just be blank instead of a, an actual number zero, which is important.
like, does it include the word free? Does it include get started? We could do deeper analysis if we take our time to sort of add more context to each one of these.
So even if there's one or zero, it'll have one. So what we need to do is if find, we're going to search for a period. Text to search for is going to be the subhead.
more like two periods in their subhead, or sorry, H1 or subhead. We added this copy sheet link, we made it sort of nice, we added an about page, we added this