SQL Skills for Product Managers 💿
Data to product managers is like ammunition to an assassin; nothing gives us more pleasure than gently annihilating a loud, forceful stakeholder with an incisive bullet of data which obliterates their stance in a few seconds.
In larger corporates, there are entire teams set up specifically to deal with and manage your data. If you want a bit of data, you need to make a formal request and you might get it a few days later. In smaller companies, it’s usually the engineering team’s responsibility to retrieve the data – or the business analysts if you have them.
But what if you didn’t need to rely on other people? It’s an extremely useful skill to be able to interact directly with a database yourself and retrieve the data you need, whenever you want to.
One of the most popular languages used for creating, retrieving, updating and deleting data from a database is SQL.
With even a little bit of SQL knowledge you’ll be able to write queries, generate reports and completely bypass your data teams in some instances.
So you want to know more about SQL? OK, great.
Time To Read: 15 Minutes
Published: May 2020
Link: SQL Skills for Product Managers 💿
TikTok is working on several new features to boost usage and expand its older audiences in the US, according to a new report by The Information.
Among the features in the works is a paywall, allowing creators to set a price on their content. Viewers would pay $1 — or some other fee chosen by the creator — to watch videos, according to the report. Exclusive content only for paying fans is a tactic other companies like Instagram have tried in an effort to entice creators to use the platform. On Instagram, for example, creators can share subscriber-only posts, Reels, stories, and other content not available to other followers.
TikTok is also testing a revamped creator fund that’s already underway in France and Brazil and could begin to roll out in the US next month, according to The Information. Launched in 2020, the original fund is a three-year, $1 billion pool of money that pays creators for popular videos. But some have criticized the fund model broadly, saying it limits how much content creators can earn. Some TikTokers say they earn a few dollars for videos viewed millions of times and just pennies a day when their content isn’t going viral.
Read More: TikTok is reportedly working on paywalled videos and a revamped creator fund 🤳🏻
Loving Rabbit Hole🐰? Share it with your friend
Product: Popsync
What It Does: Popsync helps search multiple photo and image libraries at the same time, including Getty Images, Google Images, Unsplash, and more. Instantly find that perfect image, create mood boards, and share your discoveries with others.
I Interviewed ChatGPT for a PM role, and it almost got the job 🤖
What is the hook model? How to build habit-forming products🪝
We work with sponsors to keep this newsletter free & running 😇
Interested in sponsoring one of the issues? Let us know!