I’ve had a few SEO consulting projects lately that have given me a chance to work with a lot more keywords than anybody should be working within a spreadsheet. When I come across these types of projects, I use the same workflow: bring all the data into a database and run the analyses in SQL. …
SEO Analytics in SQL for Beginners: A step-by-step tutorial Read More »
This is a quick post to provide context for the SEO A/B test-curious people out there. I was prompted by a thread in Measure Slack and figured long-form would make more sense. I didn’t want to make this another hideously long SEO-ified post but rather get to the point quickly. Here’s the post and then …
Read This Before You Run Your First SEO A/B Test Read More »
As a digital marketer, I use SQL every single day. And looking back on my career so far, it would be fair (though a bit reductive) to say that I could define my career by two distinct periods: before I learned SQL and after I learned SQL. The two periods are distinct for three main …
Getting Started with SQL for Marketing (with Facebook Ads Example) Read More »
Pssst… have you heard about Google Search Console’s BigQuery integration?? The thing I enjoy most about SEO is thinking at scale. Working at Postmates was fun because sometimes it’s more appropriate to size opportunities on a logarithmic scale than a linear one. But there is a challenge that comes along with that: opportunities scale logarithmically, …
SEO with the Google Search Console API and Python Read More »
This post demonstrates several ways to add click-to-call and click-to-chat Skype button functionality into your website. Beyond just being a modern way to use a web browser, it enables a modern approach to interacting with leads and customers. There is good reason to do this. Let me tell you why… A New Definition of “Social” Brands The …
Add a Website Skype Button to Talk With Leads and Customers Read More »
If you can remember your elementary school English lessons, you might recall learning how to format postal addresses so you could send a letter or navigate yourself to a particular destination. Today, most of us navigate to Web addresses far more often than street addresses and yet we no sense about how web addresses work, what …
Web Addresses Explained: What Every Human Should Know About URLs Read More »
This is part one of four in the $10k Technical Skills for Digital Marketing series. You’ve gone a long way, Keep it up! Getting Started and the Learning Mindset Being a technical marketer is as much about using technologies as it is about learning and adapting to new ones. The learning mindset may not get its …
Top 3 Resources to Learn Digital Marketing Technical Skills | $10k Tech Skills 4/4 Read More »
This is part 3 of 4 of the $10k Technical Skills for Digital Marketing. You could be so much faster! Right now, you are using your browser to view HTML pages. You go to a page, get some information and move on. Imagine how much more information you could gather if you could tell your browser to look at …
Learn the Power of API’s for Digital Marketing | $10k Tech Skills 3/4 Read More »
This is part t in the $10k Technical Skills for Digital Marketing Series. Part one introduced the importance of learning client-side technologies and offers a plan to learn Javascript, HTML and CSS for digital marketing. This post broadens the picture by introducing server-side programming and databases, which together compose web applications. Understanding how web applications work …
Learn Programming and Databases for Digital Marketing | $10k Tech Skills 2/4 Read More »
This is part one of four in the $10k Technical Skills for Digital Marketing series. Being able to code JavaScript, HTML and CSS are the technical skills that enable you to design the presentation and experience of your marketing messaging. JavaScript will also take you much further. These skills will really increase your market value …
Learn JavaScript, HTML and CSS for Digital Marketing | $10k Tech Skills 1/4 Read More »
