Bakz T. Future | How To Find Niche Audience/Customer Segments Using Free Reddit Data @bakztfuture | Uploaded September 2019 | Updated October 2024, 3 hours ago.
Niche Community and Product Use Case Identification Using Competitive Backlink Analysis on Reddit Dataset

Finding a potential niche and product use case for a new product or startup idea can be difficult. It's hard to brainstorm audience segments outside of your own interests, demographics, and life experience.

In today's video, you'll learn a new method which uses competitive backlink analysis to identify potential niche audience segments and product use cases. You'll learn how the method works, take a look at real data and examples for large companies like Slack, and learn about its overall research implications.

Required Materials:
- Google Cloud BigQuery
- Reddit dataset hosted on Google Cloud
- Google Cloud BigTable

Resources:
link to SQL Code:
pastebin.com/giTLZpTz

Slack, original data/Big Query results (Reddit posts): docs.google.com/spreadsheets/d/1i60bw80qyArR5o7MiRj4pkeXDDJa1dffNkUMTJK47B8/edit?usp=sharing

Slack, original data/Big Query results (Reddit comments): docs.google.com/spreadsheets/d/1AglhIIRXLCZ8ol1VDP8j6-YSMnvv37-BZcd1ZWn3_pc/edit#gid=70544113

Slack, combined data:
docs.google.com/spreadsheets/d/1J9T2ciXutsbmZ3Akp2SxkBRFa2pxOiDH-2NWkEakhcE/edit?usp=sharing

—
► Remember to Like, Comment, and Subscribe!
—
Connect with me:
Twitter - twitter.com/bakztfuture
Instagram - instagram.com/bakztfuture
Github - github.com/bakztfuture

Feel free to send me an email or just say hello:
bakztfuture@gmail.com