Jason Frasca |||

Building Long IF Statements in Google Sheets

Been working on a large Keyword Research project in an arena I’m largely unfamiliar. This has led to casting a wide net to find the relevant keywords.

As such I’ve collected more keywords than normal. Identifying the signal amidst the noise is a challenge.

Through seed keywords and competitor analysis, I curated a set of 51,538 keywords to analyze.

This is before including the relevant competitor’s sites this has all led me to.

I narrowed these down to 3,422.

Now, of these 3,422 only a small portion are highly relevant based on relevance, intent, and Cost Per Click value (CPCv).

Leveraging the strength of Google Sheets formulas makes all of this palatable.

VLOOKUP is Not Always the Answer

I was struggling with my VLOOKUP tables. It was not dynamic enough.

What I discovered was the IF Formula. Based on a series of IF, IF ELSE statements.

My IF Statement was growing outside of my comfort zone so I recruited the help of AbleBits IF Formula Builder.

I’ve used AbleBits add-ons before but was never compelled to purchase - till now… signing up for a lifetime subscription.

Research Complete

Research is complete. I understand the landscape, opportunities, and gaps that intersect with our strengths.

IF statements!

Up next Thoughts: Super Wildcard Weekend 2021 I have a friend in Austria who loves the NFL - so I wrote this up for him. Figured I’d post it. Game of the weekend: Bucs v. Washington. Was the Keyword Research to Determine Supply and Demand An Overview of a recent SEO keyword research project I completed: Did a quick keyword research review and this is a penetrable market. There is no
Latest posts Keyword Research to Determine Supply and Demand Building Long IF Statements in Google Sheets Thoughts: Super Wildcard Weekend 2021 Website Images: The Hidden Sunk Cost Fall 2020 Semester Recap - No Code ROT13 to Obfuscate for Better Search Results 2020 MIX Lab - A Year in Review Differences in SEO Tool Evaluations Improvements to the 3D Printing Lab’s Network Trust At A Glance - TAAG Selective Web Scraping Drafts Action Posts to Blot Write Once Use Twice Research Ways To Present My Newsletter Podcast Editing Migraine Journal in Airtable Pandemic Network Effect Helping Local Business During the Pandemic Getting the Copyright Right Juxtaposed Setting Up The Day With Intention How I Measure Sprint Progress What Will The Kids Do This Summer? Power of the Daily Standup Which Conferencing Tool Records Audio? Wordpress vs Ghost vs Squarespace vs Blot via Dropbox Back of the Napkin Sketch




© 2020 Jason M. Frasca