From the course: Marketing Tips
SQL for marketers
- [Brett] Hey, and welcome to another episode of Marketing Tips. I'm Brett Batesole and this week, I want to encourage you to consider learning SQL as a new skill. SQL stands for Structured Query Language. Simply put, it's a basic programming language that's used to retrieve data from databases. Now as marketers, we're curious. It's part of our responsibility to ask lots of questions. And most of these questions require data to answer, and that data tends to be locked away into a database. The faster you can get to that data, the faster you can adjust your marketing objectives. And this data-driven marketing mindset delivers far better results. And not only that, but data analysis skills are incredibly in demand, more and more job requirements for marketers, are starting to list SQL. So, to retrieve data out of a database, you'll typically use what's known as an SQL query. And this lets you outline what information you want and from where. Let's say we have these questions. We want to know what percentage of our users logged in last week. Or how many users visited once, but have not returned. Or even, who your top ten active users are. This data is likely not in Google Analytics, but instead in your database. So you'll want to create a query that asks the database for that answer. And here's an example of a basic query. You're essentially going to say "I want to get this piece of data "from this table, where the data matches these criteria." Now it's actually not incredibly difficult to learn the basics of how to get that data. And even if you're going to be using an existing reporting interface, such as Tableau or Cluvio, knowing how it works under the hood can greatly improve your expertise or even your ability to expand that data further. Now, even though I'm fairly proficient at SQL, I'm not going to pretend that I'm ready to teach it. I've still got plenty of learning to do myself. So I want to point you towards the course SQL for Data Reporting and Analysis. This course is a great place to learn how to get the information you need, without having to go too deep on everything there is to know about SQL. You can also check out the LinkedIn topic page for SQL, at linkedin.com/topic/sql. Here you can engage with others who have this skill, or identify learning paths and posts related to this topic. I highly recommend that you take some time to explore SQL. Maybe schedule time to sit down with the developer on your team, who can secure you read-only access to your database and then get you set up with a client, that'll allow you to start playing around with your own SQL queries. Thanks for checking in this week. As always, I'd love to hear from you. So connect with me on LinkedIn or follow me on Twitter via @bradbatesole. And let me know if you're thinking about learning SQL. I'll see ya next week.
Contents
-
-
-
Best practices for organizing UTM tags for campaigns5m 26s
-
How to conduct A/B testing with Google Optimize4m 47s
-
Calculate and forecast growth rate using Excel4m 6s
-
Project management tips for agile marketing using Trello3m 42s
-
Data analysis with Google Data Studio3m 52s
-
SQL for marketers3m 6s
-
Why you need to bid on your brand keywords with Google Ads3m 1s
-
How to work with a new sales team3m 5s
-
How to calculate what to bid and spend on ads4m 24s
-
Build a lean canvas with RealtimeBoard5m 1s
-
How to increase email open rates by improving timing4m 14s
-
Searching competitor sites for hidden gems and content2m 51s
-
Use SEO research to generate ideas for your blog content2m 15s
-
Shortcut to quickly generate new Google Docs, Sheets, and Slides1m 17s
-
Advertise in Gmail with Google Ads4m 18s
-
Launch a legally compliant sweepstakes6m 17s
-
Check URL redirects after a site relaunch3m 14s
-
Landing page inspiration with Land-book1m 37s
-
Use Hunter.io to find email addresses2m 14s
-
How to set up Google Alerts2m 53s
-
Growth hacking content using Twitter custom Audiences3m 28s
-
Use Google Shopping Insights for market research3m 47s
-
What is creativity and how do you come up with new ideas?4m 49s
-
Source testimonials from your customers4m 30s
-
Prioritze objectives with the ICE model5m 8s
-
Introduce high-tempo testing in your workflow3m 10s
-
Evaluate your Net Promoter Score (NPS)4m 2s
-
Building better landing pages1m 46s
-
How to improve your local SEO2m 33s
-
Quicky add subtitles to any video with Kapwing3m 20s
-
How to prequalify traffic when running PPC ads2m 56s
-
Identify conversion problems with Google Analytics4m 41s
-
Use HARO to make connections with journalists2m 18s
-
Conduct SEO research by running PPC ads3m 8s
-
Monitor your competitors' websites for changes1m 50s
-
Matchbooks are good marketing3m 43s
-
What is your unfair advantage?3m 56s
-
Sensory marketing: Mental stimulation in display ads3m 26s
-
Geotarget single buildings in Facebook ads2m 53s
-
Automate your LinkedIn networking3m 52s
-
Google image search tips for market research2m 56s
-
Creating animated images with Crello1m 46s
-
Optimizing your LinkedIn profile3m 22s
-
Listing your service or delivery business on Google1m 32s
-
Using Google Trends for market research3m 39s
-