Why Every Startup Marketer Needs to Learn SQL

Thumbnail

  About 4 weeks back I learned SQL and it’s been one of the greatest skills I could have ever acquired as a marketing / business guy at a startup. Since learning SQL, our marketing team has: Determined the interests which are most highly correlated with our user base –> allowing us to create super high-value target groups for our Facebook ads. Determined the courses which are most highly correlated with those target groups (so that we know which courses to advertise). Compiled a set of rockstar vanity metrics that showcase the size and awesomeness of Udemy –> Did you know that students have enrolled in more than 143,907 courses on Udemy? Determined the demographic differences between our Facebook & Adwords ad signups (to better explain why our Facebook ad signups have an LTV that’s 4-5x those of our Adwords signups). Analyzed the future enrollment rates of our users based on which course they enrolled in first –> confirming our hypothesis that users who enrolled in a crappy 1st course were far less likely (about 70% less) to go on to enroll in another course on Udemy (ever!). This drove us to create much stronger quality controls on Udemy.

How to Track Sales for your PPC Campaigns

Thumbnail

Before you start spending money on PPC campaigns, you should have specific goals in mind for what you want your marketing to accomplish. If you do not have a goal set for your marketing efforts, then you can never tell if you will be successful or not. What is a Good Goal? A goal should be specific and measureable. The most common goals are: To make more money To sell more stuff Unfortunately, these goals are not specific enough. Do you want to make $1 more each month, or $10,000 more? Your goals should really be: Increase total revenue $1,000 each month for 12 months Get 100 new email subscribers per month at a cost of $5 per subscription Attain a $15 CPA for new leads with a minimum of 50 leads per month Many companies will set multiple goals.

Introducing SocialBro as a Chrome App

Thumbnail

We are thrilled to announce today SocialBro as a Chrome app, which will greatly improve the tool’s performance and flexibility. Many of you have asked us for a faster version of our app, so we’ve developed this version with all the features of the current desktop client. However, it is more stable and efficient, especially for the huge Twitter communities.Users of Google’s Chrome web browser can now visit the Google Web Store and download a Chrome-specific SocialBro app (see below “Getting started with SocialBro for Chrome”). Like the Adobe Air version, currently the Chrome app is also totally free.We’d like to emphasize that SocialBro as a Chrome app is not a replacement for our existing desktop version. We have many people, companies and brands using the desktop version, who trust us, and we are naturally continuing support and development of that platform, just as we have done till now.Today, we’re also launching a user guide about SocialBro to help you to find out all the features of our app.Export and import the history for users of the Adobe Air versionSocialBro allows you to have in your Chrome app your entire history from the Adobe Air version (see below “How to export and import your history”).

When is the best time to tweet?

Thumbnail

People want to know when is the best time to tweet, when their followers are online, to interact with them in a better way. That’s why we created the tool “Best time to tweet”! On the SocialBro dashboard you will find the tool icon. “Best time to tweet” has many charts: when your followers are online, when you get more retweets or replies etc., generated by analyzing your top 100 followers, in this current free version. The first thing to do is to request the report by clicking the tool icon. The report takes about two hours to be generated.

Web Analytics and Your Website – What You Need to Know

When it comes to the web, information is king. Indeed, the web itself is information, a massive collection of articles, videos, blogs, news stories and photographs trying to convey a message to various audiences scattered around the world. The big sensation over the last year has been Twitter, a system built around condensing information to [...]