DIY SEO: How To Check On-Page Ranking Factors Using Google Docs My kids and I really enjoy watching the MAKE Magazine video podcasts together. It’s one of those rare and happy things that a ten-year-old girl, an eight-year-old boy, and an adult can watch together and find interesting. Inspired by these podcasts, I thought it would be a good idea to create a do-it-yourself SEO project. So today, we’ll make a Google Spreadsheet that checks a web page for various on-page factors that can affect SEO. Getting Started What you need: A Google Account for logging into Google SpreadsheetsA URL that you want to check. In this article, I’ll be checking Once you are signed in to Google Spreadsheets, you will be able to make your own copy to work with by opening the spreadsheet and selecting File -> Make A Copy… If you would rather start with a blank spreadsheet and fill it in as you go through this article, select File -> New -> Spreadsheet. How It Works A good resource for Xpath queries can be found here. Testing The Basics Extra Credit
Google Sheets IF function – usage and formula examples The IF function in Google Sheets is one of the easiest functions to learn, and while this holds true, it is also a very helpful one. In this tutorial, we will take a closer look at how Google Spreadsheet IF function works and what advantages we can get from using it. What is IF function in Google Sheets? Whenever we use IF function, we create a decision tree in which certain action follows under one condition, and if that condition is not met - another action follows. For this purpose, the condition of the function must be in a format of the alternative question with only two possible answers: "yes" and "no". This is how a decision tree may look like: So, IF function allows us to ask a question and indicate two alternative actions depending on the received answer. IF function syntax in Google Sheets The syntax for the IF function and its arguments are as follows: =IF(logical_expression, value_if_true, value_if_false) Let's explore the arguments of our IF function in more detail. Note.
Custom Functions in Google Sheets | Apps Script | Google Developers Google Sheets offers hundreds of built-in functions like AVERAGE, SUM, and VLOOKUP. When these aren’t enough for your needs, you can use Google Apps Script to write custom functions — say, to convert meters to miles or fetch live content from the Internet — then use them in Google Sheets just like a built-in function. Getting started Custom functions are created using standard JavaScript. Here's a simple custom function, named DOUBLE, which multiplies an input value by 2: function DOUBLE(input) { return input * 2;} If you don't know how to write JavaScript and don't have time to learn, check the add-on store to see whether someone else has already built the custom function you need. Creating a custom function To write a custom function: Create or open a spreadsheet in Google Sheets.Select the menu item Tools > Script editor. Getting a custom function from the add-on store The add-on store offers several custom functions as add-ons for Google Sheets. Using a custom function Naming Arguments
Spreadsheets - Google Apps Script Google Apps Script lets you do new and cool things with Google Sheets. You can use Apps Script to add custom menus, dialogs, and sidebars to Google Sheets. It also lets you write custom functions for Sheets, as well as integrate Sheets with other Google services like Calendar, Drive, and Gmail. Most scripts designed for Google Sheets manipulate arrays to interact with the cells, rows, and columns in a spreadsheet. If you're not familiar with arrays in JavaScript, Codecademy offers a great training module for arrays. (Note that this course wasn't developed by and isn't associated with Google.) For a quick introduction to using Apps Script with Google Sheets, see the 5-minute quickstart guide for Macros, Menus, and Custom Functions. Get started Apps Script includes special APIs to let you programmatically create, read, and edit Google Sheets. The Spreadsheet service treats Google Sheets as a grid, operating with two-dimensional arrays. Reading data View logs Writing data Formatting Charts Macros
How to Indent Text in Google Sheets (Easy Step-by-Step Guide) Skip to content Home » How to Indent Text in Google Sheets (Easy Step-by-Step Guide) How to Indent Text in Google Sheets (Easy Step-by-Step Guide) Sumit Watch Video – How to Indent Text in Google Sheets In case you prefer reading over watching a video, below is a complete written tutorial on adding indentation in Google Sheets. While Google Sheets has so many amazing features, there are some basic ones that lack. And one such feature is the ability to indent cell content in Google Sheets. There are, however, some workarounds that you can use. In this tutorial, I will show you two simple ways you can use to indent text in Google Sheets. Table of Contents Indent Text by Using Custom Number Formatting Custom Number formatting in Google Sheets determines how we see the text or a value in a cell. Remember the number formatting only changes the format of the text/value in the cell, and not the value itself. While mostly this is used for formatting numbers, we can also give it some custom format.
googleapis | Dart Package Auto-generated Dart libraries for accessing Google APIs. First, obtain OAuth 2.0 access credentials. This can be done using the googleapis_auth package. Your application can access APIs on behalf of a user or using a service account. After obtaining credentials, an API from the googleapis package can be accessed with an authenticated HTTP client. The following command line application lists files in Google Drive by using a service account. Create a pubspec.yaml file with the googleapis_auth and googleapis dependencies. ...dependencies: googleapis: any googleapis_auth: any Create a service account in the Google Cloud Console and save the credential information. Then create a Dart application to list files in a spececific project. The following is a list of APIs that are currently available inside this package. Views Abusive Experience Report data, and gets a list of sites that have a significant number of abusive experiences. Official API documentation:
Using Google Docs To Generate Hot Content Strategies [Tool] - SEOgadgetSEOgadget > Skip the chit chat, give me that tool now! It has been a little while now since my last blog post, but hopefully the wait has been worth it! I’m very excited to be writing this post and to be sharing this tool with you. Research for new content strategies takes time Every day in our industry we face the challenge of developing new strategies for attracting traffic to a website and staying ahead of the competition, whether this is through on or off site engagement. As marketers it’s our job to overcome these challenges to ultimately build ROI. But before you can jump to a strategy you need to do the research: What type of content is (and has been) working well – is it contextually relevant? – In a nut shell, what is hot right now? Our research doesn’t end there, once you have the above data you should be checking out similar topics too. Check out our content generation tool For the purposes of this blog post here is a top level view of the on & off site strategy process: Content aggregators
importrange - How can I get Google Sheets to auto-update a reference to another sheet? 5 clever Gmail tricks to minimize regret, frustration and spam Most people treat Gmail like a reliable old clunker that needs little if any regular maintenance. But what if you could tweak a few settings to supercharge your Gmail experience and turn your daily driver into the roadster of your dreams? In the early days of email, users were limited to four basic gears: Check Mail, Compose, Save as Draft and Send. All that changed with the advent of browser-based webmail. By harnessing the power of Google software and services, Gmail packs some incredibly dynamic customization options just under the hood. If you've been using Gmail like it's still the 1990s, it's time to step into our time machine and learn how to hot-rod your Gmail with these five tips and tricks. Now playing: Watch this: Tips and tricks for using Gmail 30 seconds to regret: How to unsend Gmail messages Nearly everyone has caught a typo after hitting Send. First, click the gear icon in the upper right-hand corner and navigate to Settings > General. Unlimited aliases, sort of 1. 2. 3. 4.
An SEO's Guide to RegEx RegEx is not necessarily as complicated as it first seems. What looks like an assorted mess of random characters can be over facing, but in reality it only takes a little reading to be able to use some basic Regular Expressions in your day to day work. For example, you could be using the filter box at the bottom of your Google Analytics keyword report to find keywords containing your brand, such as Distilled. If you want to include both capitalised and non-capitalised versions, you could use the Regular Expression [Dd]istilled. Pretty simple, right? Hang on though… some of you might be asking, what the hell is RegEx? So in the example of the keyword report above, your Regular Expression is applied to each keyword and if it matches it’s included in the report. RegEx has many uses aside from Google Analytics too such as form validation or URL rewrite rules. Characters & Metacharacters I mentioned that Regular Expressions are made up of characters and metacharacters. Dot . Backslash \ Phew!