Working in SEO leads to interesting challenges that I’m sure you’ve all faced at one point. You’re a master of flexibility and managing tedious tasks. I’ve recently found myself dealing with 100+ top-tier sites. Working with global companies, it’s quite the puzzle to: Wrangle data for 100+ sites. Keep tabs on every site’s performance. And, … Read more
Scraping data from webpages is a relatively advanced task that, until recently, required a degree of technical skill. The idea of diving into code or scripts for data extraction seemed overwhelming for many, myself included. Data scraping can power many SEO tasks, such as auditing, competitor analysis, and examining website and data structure. Google sheets … Read more
Use this formula to extract a root domain from a long URL in Google Sheets: =REGEXREPLACE(REGEXEXTRACT(B2, “https?://(.*?)/”), “^www\.”, “”) This will come in handy when you’re trying to organize a list of link prospects. Here’s the ChatGPT prompt I used: And the output: Just double-click on the cell, update the range, and hit enter to … Read more
SEO involves constantly creating and optimizing content for your website. Achieving more traffic and better organic rankings means you’ll need a content strategy. Google Sheets functions make it easy to turn your keyword research and site performance data into a list of content to be created or updated. Turn keywords into URLs with LOWER and … Read more
As the PPC landscape continues to evolve, having the ability to predict future campaign performance is invaluable. This article will cover some of my favorite PPC forecasting techniques using Google Sheets and Vertex AI that paint a clearer picture of the future and empower clients with actionable insights. While no tool or technique can provide … Read more
May 24, 2017 | Posted by Rank Ranger No one knows your data like you do. In fact, no one has access to your data the way you do. Not even Google, or Microsoft, or yes, even Rank Ranger, has access to the plethora of data you’re tracking, storing, or otherwise keeping tabs … Read more
Google announced that they added Implicit Code Execution to Bard, making Bard 30% more accurate in internal logic challenge tests. It basically made Bard better at math and data analysis. Also, Bard can export tables directly into Google Sheets. Jack Krawczyk, from the Google Bard team, wrote on Twitter, “Today we’re launching Implicit Code Execution … Read more
Google has released two updates to Google Bard, its AI chat bot. The first update is to make Bard better at mathematical tasks, coding questions and string manipulation. The second update is to allow you to export tables that Bard generated directly into Google Sheets. Improved math and data analysis. Google Bard has a new … Read more
Google Sheets is a game-changer and a well-loved program by many SEOs. Google Sheets is very similar to Microsoft Excel; only it is free to use and cloud-based. There are several Google Sheets functions every SEO should know. Google Sheets can manipulate data sets (Site Explorer export), scrap data from other websites, and create a … Read more
421
229
714
826
543