We Built a Tool to Find Baller Meetup Sponsorship Opps

meetup tool

Reading Time: 3 minutes

Share This

There’s tons of value in Meetup.com groups. If you’ve never taken part, they’re organized get-togethers that can resemble little mini-conferences, meet & greets, networking events, game nights, and basically any idea that can bring together a group of like-minded people. That’s right – a bunch of people, united by a common interest in something, all under one roof and talking about that something.

If your business IS that something, you can do wonders for your website, brand, community and personal stock.

Participating in Meetup groups, from a business perspective, is fun and easy. It’s also really impactful if you pick a growing group and make yourself a big part of it. Whether it’s by presenting, sponsoring, offering deals, and getting links back, you’re bound to win when you’re bound with a winner group.

How can we find a baller growing Meetup group?

make-copy-tool
Wanna use the free tool we built? Just make a copy!

A strong, growing group with an engaged base and great, frequent events is where we’re going to get the best bang for our efforts. How can we find such groups, without digging through pages manually? What we decided to do was build a tool that scrapes Meetup data into a Google sheet, analyzes, and shows trends and stats. Check it out here, and read below for the logic and how to use this thing.

Membership numbers are nice, but attendance growth is key.

We definitely want to find a strong, growing Meetup group to focus our attention on. I’ve seen plenty of groups with impressive numbers, but a steady decline in attendance when we take a look. Check it out:

Technical.ly Philly not only has great membership numbers, but attendance is clearly growing strong over the past two years.
Philadelphia Happy Hour has a high number of members, super-frequent meetups, but a somewhat declining attendance.
Philadelphia Happy Hour has a high number of members, super-frequent meetups, but a somewhat declining attendance.
This Philly singles group, by contrast, has thousands of members - but no one seems to be going to the events!
This Philly singles group, by contrast, has thousands of members – but no one seems to be going to the events.

 

What else can the tool do?

We wanted to take a look at even deeper info on who’s going to the group. We added the ability to quickly see the newest members, in the Meetup Detailed Stats tab. This also pulls the user’s bio and website if found.

Another thing we want to look at is member bios. Meetup bios are unique for each group the member is in, so better bios means more engaged users. Right in the main tab, we’ve listed all members that we’ve found who have bios under the graph.

Check this out – tons of members with tons of bios!

Whoops – I haven’t updated my Technical.ly profile in a few years!

 

 

 

How does this tool work?

We built this thing in a Google Sheets doc, and it’s completely free and open-source. In fact, we do 100% of the scraping and crawling using nothing but standard formulas! The main one is ImportXML – it’s basically magic, so go learn more about it.

The main formulas that pull data are:

[toggle title=”Get the past Meetup events” bgcolor=”” textcolor=”” bordercolor=”” opacity=””]This code gets the <li> tags from the past events page and lists ’em all out!

=query(IMPORTXML('Meetup Detailed Stats'!$D$2&"events/past/","//li"),"SELECT Col1,Col2,Col4 WHERE Col4!=''[/toggle]

[toggle title=”Get Meetup group overall stats” bgcolor=”” textcolor=”” bordercolor=”” opacity=””]This pulls out the main stats for the group.

=query(importxml('Meetup Detailed Stats'!$D$2 &"events/past/","//ul[@class='dividedList small']/li/a"),"SELECT Col1,Col2 WHERE Col1 !='Our calendar'")[/toggle]

[toggle title=”Get individual group member details” bgcolor=”” textcolor=”” bordercolor=”” opacity=””]Grabs member details and bios. Totally not creepy!

=iferror(importxml('Meetup Detailed Stats'!$D$2 &"members/","//div[contains(@id,'memberInfo')]"))[/toggle]

 

Conclusion

Sponsor Meetup groups. Go out and speak. Network, make friends and get results. A link from a strong, growing Meetup group can work wonders. Just remember – even though we’re scraping and analyzing, don’t think for a minute about spamming groups.

You’re building a brand in front of real people, and they can smell BS a mile away. Finding the ideal Meetup group is a great step in the right direction – now you’ve got to become a real part of the community!

 

 

 

Share This
Sean Malseed

Sean Malseed

Director of Technology

Sean is a developer, technical SEO, and entrepreneur with over 10 years of industry experience. Prior to Greenlane, he founded CircleRank, a successful technical SEO agency in Philadelphia. He has spoken at major digital marketing conferences around the world, including PubCon, SMX, SES/ClickZ, and OMCap. He also co-organizes Philly’s monthly digital marketing event, SEO Grail.

Follow Me on Twitter

Leave a Reply

Your email address will not be published. Required fields are marked *

More Related Articles

keyword tool
Content Strategy Digital Marketing SEO

What Is The Best Google Suggest Keyword Tool

A rose by any other name may smell just as sweet, but good luck trying to find good results for “thorny red flower” on the first page of the SERPs! Until Google gets even better with their relationship-mapping (thanks Hummingbird, you're a great start!), long-tail optimization will be a huge …
Continue Reading
Digital Marketing SEO

What Google’s Featured Snippet Deduplication Means for Your Site

On January 22, 2020, Google announced via Twitter that featured snippets will now be counted as one of the main organic search results, meaning that the same URL can no longer hold both the featured snippet and another organic listing…
Continue Reading

Digital Marketing PPC SEO

Google’s Current Desktop Design

Update as of January 24, 2020: After Google received negative feedback about favicons in organic search results, they have rolled back the favicon portion of this update. The other changes including updates to the Ad symbol and breadcrumb placement remain…
Continue Reading