Are you over 18 and want to see adult content?
More Annotations
![A complete backup of xboxalliance.com](https://www.archivebay.com/archive2/58b7dc1a-4c7e-4e2f-bdd0-0be9623694f2.png)
A complete backup of xboxalliance.com
Are you over 18 and want to see adult content?
![A complete backup of changeresearch.com](https://www.archivebay.com/archive2/a84fb353-fda7-421a-a2e3-a34202e3f7ac.png)
A complete backup of changeresearch.com
Are you over 18 and want to see adult content?
![A complete backup of jonathanrosenbaum.net](https://www.archivebay.com/archive2/69517dbf-ec1e-45b1-9dfa-1c26c69b6ca0.png)
A complete backup of jonathanrosenbaum.net
Are you over 18 and want to see adult content?
![A complete backup of friendsofblackwater.org](https://www.archivebay.com/archive2/b9df3dad-d5bc-4d3d-88b7-2c763ad0fb2d.png)
A complete backup of friendsofblackwater.org
Are you over 18 and want to see adult content?
![A complete backup of britain-magazine.com](https://www.archivebay.com/archive2/f615d476-e931-4590-aa12-fbe56b3febdb.png)
A complete backup of britain-magazine.com
Are you over 18 and want to see adult content?
![A complete backup of planificarenunta.ro](https://www.archivebay.com/archive2/853f9ddf-3cbf-4511-b747-34952f10bc27.png)
A complete backup of planificarenunta.ro
Are you over 18 and want to see adult content?
![A complete backup of hauser-kaibling.at](https://www.archivebay.com/archive2/d19926a0-a9e2-41ad-b598-540b2bbcbb49.png)
A complete backup of hauser-kaibling.at
Are you over 18 and want to see adult content?
![A complete backup of redevolution.com](https://www.archivebay.com/archive2/688580d5-46f7-4fa3-82a5-800fe99aa776.png)
A complete backup of redevolution.com
Are you over 18 and want to see adult content?
Favourite Annotations
![A complete backup of https://vitality.ink](https://www.archivebay.com/archive6/images/05d6254c-7bf0-44f3-b073-9fd3f87007fd.png)
A complete backup of https://vitality.ink
Are you over 18 and want to see adult content?
![A complete backup of https://serviatiende.com](https://www.archivebay.com/archive6/images/ab890160-832b-47d1-bfbc-acd696bf07b2.png)
A complete backup of https://serviatiende.com
Are you over 18 and want to see adult content?
![A complete backup of https://acics.org](https://www.archivebay.com/archive6/images/0cf76ab9-c591-4b12-81b8-6b79e33158a0.png)
A complete backup of https://acics.org
Are you over 18 and want to see adult content?
![A complete backup of https://woshu-moshu.com](https://www.archivebay.com/archive6/images/df94ee6d-4110-4e63-a6c7-3463eab44ad3.png)
A complete backup of https://woshu-moshu.com
Are you over 18 and want to see adult content?
![A complete backup of https://cask-marque.co.uk](https://www.archivebay.com/archive6/images/666eb1f0-13be-4cc5-aaac-46f7eec2810b.png)
A complete backup of https://cask-marque.co.uk
Are you over 18 and want to see adult content?
![A complete backup of https://nashik.gov.in](https://www.archivebay.com/archive6/images/1a85311c-fb30-4639-9c1e-259f2719b3a0.png)
A complete backup of https://nashik.gov.in
Are you over 18 and want to see adult content?
![A complete backup of https://ablic.com](https://www.archivebay.com/archive6/images/f1537c30-4e55-4d58-a69d-52c028293426.png)
A complete backup of https://ablic.com
Are you over 18 and want to see adult content?
![A complete backup of https://sensuapp.org](https://www.archivebay.com/archive6/images/96d518b9-07e4-4734-8e46-59b486da568a.png)
A complete backup of https://sensuapp.org
Are you over 18 and want to see adult content?
![A complete backup of https://rimini.com](https://www.archivebay.com/archive6/images/f6ccc6dc-3543-4e2b-8cef-42f18e3f56a8.png)
A complete backup of https://rimini.com
Are you over 18 and want to see adult content?
![A complete backup of https://fhmzbih.gov.ba](https://www.archivebay.com/archive6/images/81ab7caa-3a24-4b19-97ac-db6053b8e702.png)
A complete backup of https://fhmzbih.gov.ba
Are you over 18 and want to see adult content?
![A complete backup of https://bfmufa.ru](https://www.archivebay.com/archive6/images/a9788199-776c-4632-af79-4979c51cafd3.png)
A complete backup of https://bfmufa.ru
Are you over 18 and want to see adult content?
![A complete backup of https://pomeroy.com](https://www.archivebay.com/archive6/images/aabebf66-86cf-4e5b-8590-ba52d0ae227e.png)
A complete backup of https://pomeroy.com
Are you over 18 and want to see adult content?
Text
reporting
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery, or elsewhere): A pipeline outputs visualization-ready data, which can VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. HOW TO FIND YOUR BEST MARKETING CHANNEL · CODING IS FOR LOSERS 1. Get raw data flowing. There are two types of data required in this (or any) data pipeline: The raw data itself, from Google Analytics. Some administrative mapping data, for example to specify how each Google Analytics source / medium translates into a ‘Channel’. I recommend using Stitch for pushing the first type of raw data toBigQuery
WTF IS DBT? · CODING IS FOR LOSERS dbt (aka data build tool) is an open-source framework for running, testing and documenting SQL queries, that allows you to bring a software-engineering-style discipline to your data analysis work. It is the ultimate tool in our lazy toolbox – it allows you to neverrepeat
GETTING STARTED WITH GOOGLE DATA STUDIO · CODING IS FOR LOSERS The first step to building any dashboard is wrangling your data – connecting the sources you’ll use to make charts. Google Data Studio allows you to connect any number of data sources: Adwords, BigQuery or MySQL databases, Google Analytics, Youtube and Google Sheets. I usually dump data from many different sources into a Google Sheet,then
PROJECT MANAGEMENT IN GOOGLE SHEETS A FREE project management system built into Google Sheets. Get instant access to our templates + training system. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
HOW TO FIND YOUR BEST MARKETING CHANNEL · CODING IS FOR LOSERS 1. Get raw data flowing. There are two types of data required in this (or any) data pipeline: The raw data itself, from Google Analytics. Some administrative mapping data, for example to specify how each Google Analytics source / medium translates into a ‘Channel’. I recommend using Stitch for pushing the first type of raw data toBigQuery
WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery, or elsewhere): A pipeline outputs visualization-ready data, which can QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. FIND QUICK WIN KEYWORDS FOR SEO GROWTH If you’re lazy efficient, APIs are designed for you.. Add in a spreadsheet and you’ll get a lot more done. Like, a lot more. In this article I’ll be walking through how I use APIs + spreadsheet to find quick win keywords to go after for as part of an SEO campaign. WTF IS DBT? · CODING IS FOR LOSERS dbt (aka data build tool) is an open-source framework for running, testing and documenting SQL queries, that allows you to bring a software-engineering-style discipline to your data analysis work. It is the ultimate tool in our lazy toolbox – it allows you to neverrepeat
HOW TO USE GOOGLE SHEETS FOR PROJECT MANAGEMENT The list goes on. If setup properly, Google Sheets can perfectly match this fluidity, and be the project management tool. Let’s walk through how we built a custom Sheets project management system to manage a 7 figure digital agency. This short video walks you HOW TO BLEND DATA IN GOOGLE DATA STUDIO · CODING IS FOR LOSERS Step 1: create new blended data. At this point, you’ve already started a new report in the Data Studio with your first dataset. In your Google Data Studio report, click on Resources in the top menu and select “manage blended data.”. Now, click on “add a dataview.”.
5 ADVANCED SHOPIFY REPORTS IN BIGQUERY · CODING IS FOR LOSERS Using BigQuery for Shopify analysis. We’ve helped our ecommerce clients setup dozens of custom reports in BigQuery, this post will detail the 5 of the most powerful Ecommerce analyses out there: Cohort analysis. Buyer segmentation (aka RFM analysis) Sales + Margin Forecasting. Basket analysis. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. GET STARTED · CODING IS FOR LOSERS Data pipelines run $6,250 per 3-week sprint, in which we'll build one of your unique analysis workflows (a website audit or ad funnel analysis, for example). CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
RECIPES · CODING IS FOR LOSERS Quickly understand which pages are surging and falling in traffic and impressions. The most powerful, flexible SEO audit in the market - powered by BigQuery. Pulls organic traffic + competitor KW data to project traffic from an SEO campaign. Find your Shopify store's best customers + marketing channels. Improve the performance of yourwebsite's
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance HOW TO FIND YOUR BEST MARKETING CHANNEL · CODING IS FOR LOSERS 1. Get raw data flowing. There are two types of data required in this (or any) data pipeline: The raw data itself, from Google Analytics. Some administrative mapping data, for example to specify how each Google Analytics source / medium translates into a ‘Channel’. I recommend using Stitch for pushing the first type of raw data toBigQuery
WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery, or elsewhere): A pipeline outputs visualization-ready data, which can WTF IS DBT? · CODING IS FOR LOSERS dbt (aka data build tool) is an open-source framework for running, testing and documenting SQL queries, that allows you to bring a software-engineering-style discipline to your data analysis work. It is the ultimate tool in our lazy toolbox – it allows you to neverrepeat
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. HOW TO USE GOOGLE SHEETS FOR PROJECT MANAGEMENT The list goes on. If setup properly, Google Sheets can perfectly match this fluidity, and be the project management tool. Let’s walk through how we built a custom Sheets project management system to manage a 7 figure digital agency. This short video walks you CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. TUTORIALS · CODING IS FOR LOSERS LAZINESS IS A VIRTUE. We help marketers automate their day-to-day data analysis work, by unleashing the power of Google Sheets, Data Studioand BigQuery.
ABOUT | CODING IS FOR LOSERS We don’t think coders are losers.. We’ve just found that writing *new* code should be a last resort. We believe laziness is a virtue.. As a marketer, you have a million things to get done everyday. CODING IS FOR LOSERS The Query function is the shortcut to mastering Google Sheets. Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query. MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS Top-down vs bottom-up forecasting. Let’s first define what we mean by these two. Top-down forecasts take some broad macro trend, like top-line revenue growth, and forecast forward based on that trend.All of the subcomponents of revenue (COGS, gross profit, THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS Let’s break down a basic SELECT query, pulling visits, transactions and revenue by channel from our Google Analytics dataset: SELECT date, channelGrouping as channel, totals.visits, totals.transactions, totals.transactionRevenue FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801`LIMIT
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS Contents hide What Is A Database? What is SQL And Why You Should Care What SEOs Can Do With a Bit of SQL Specific Examples of SQL For Automation & Analysis Dumbing Down The Basics of SQL How To Learn SQL Learning Resources Final Thoughts If you’re an SEO, you’re probably running a ton of QUERY FUNCTION IN GOOGLE SHEETS There comes a time in every life, where you want to combine two data ranges within a Google Sheets query. Let’s talk about how to combine data ranges from within the same spreadsheet (or from two different sheets), to run one query – working through examples using sampleTwitter data.
CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. TUTORIALS · CODING IS FOR LOSERS LAZINESS IS A VIRTUE. We help marketers automate their day-to-day data analysis work, by unleashing the power of Google Sheets, Data Studioand BigQuery.
ABOUT | CODING IS FOR LOSERS We don’t think coders are losers.. We’ve just found that writing *new* code should be a last resort. We believe laziness is a virtue.. As a marketer, you have a million things to get done everyday. CODING IS FOR LOSERS The Query function is the shortcut to mastering Google Sheets. Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query. MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS Top-down vs bottom-up forecasting. Let’s first define what we mean by these two. Top-down forecasts take some broad macro trend, like top-line revenue growth, and forecast forward based on that trend.All of the subcomponents of revenue (COGS, gross profit, THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS Let’s break down a basic SELECT query, pulling visits, transactions and revenue by channel from our Google Analytics dataset: SELECT date, channelGrouping as channel, totals.visits, totals.transactions, totals.transactionRevenue FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801`LIMIT
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS Contents hide What Is A Database? What is SQL And Why You Should Care What SEOs Can Do With a Bit of SQL Specific Examples of SQL For Automation & Analysis Dumbing Down The Basics of SQL How To Learn SQL Learning Resources Final Thoughts If you’re an SEO, you’re probably running a ton of QUERY FUNCTION IN GOOGLE SHEETS There comes a time in every life, where you want to combine two data ranges within a Google Sheets query. Let’s talk about how to combine data ranges from within the same spreadsheet (or from two different sheets), to run one query – working through examples using sampleTwitter data.
GET STARTED · CODING IS FOR LOSERS Data pipelines run $6,250 per 3-week sprint, in which we'll build one of your unique analysis workflows (a website audit or ad funnel analysis, for example). CODING IS FOR LOSERS The Query function is the shortcut to mastering Google Sheets. Instead of mixing up a bunch of spreadsheet formulas to get something done, you can get away with writing one Query. HOW TO FIND YOUR BEST MARKETING CHANNEL · CODING IS FOR LOSERS Contents hide The Google Analytics Conversion Index (GACI) Applying the GACI to our website Diving deeper How the pipeline’s built Firing up your own conversion index analysis When it comes to our marketing, I’m lazy. I don’t like digging through a dozen reports to see what’s working. So, I built a powerful dashboard that answers WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery,or elsewhere):
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) 3. VLOOKUP from another Sheet. One of my favorite things about Google Sheets, is that you can easily pass data across different sheets. For example, if you have a sheet that collects form responses, you probably don’t want to be mucking it up with some analysis. QUERY FUNCTION IN GOOGLE SHEETS There comes a time in every life, where you want to combine two data ranges within a Google Sheets query. Let’s talk about how to combine data ranges from within the same spreadsheet (or from two different sheets), to run one query – working through examples using sampleTwitter data.
FIND QUICK WIN KEYWORDS FOR SEO GROWTH If you’re lazy efficient, APIs are designed for you.. Add in a spreadsheet and you’ll get a lot more done. Like, a lot more. In this article I’ll be walking through how I use APIs + spreadsheet to find quick win keywords to go after for as part of an SEO campaign. HOW TO USE GOOGLE SHEETS FOR PROJECT MANAGEMENT Project management for a digital agency is easily 100x more challenging than for a single business.. For a single business, standalone project management tools like Trello or Asana make a ton of sense. You can build boards for each team or function, and use themfor years.
WTF IS A "RECIPE"? · CODING IS FOR LOSERS David Krevitt. Lover of laziness, connoisseur of lean-back capitalism. Potentially the #1 user of Google Sheets in the world.THE TEMPLATE VAULT
Access all free templates produced by CIFL. Enrolling in this course grants you one invitation to our master Trello board, where we store templates related to marketing automation + reporting. It also allows you to contribute to building new templates with us, or suggest a newtemplate idea.
CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW WE AUTOMATED OUR SOCIAL MEDIA ANALYSIS · CODING IS FOR Contents hide What’s in the social media dashboard? Picking your metrics Setting your goals and baseline Catching the outliers Single-sheet social channel comparison Setup your own social media dashboard Bask in the Glory of Your Cross-Channel Social Media Audit Template and Data Your life as a social media marketer relies on striking the perfect balance. HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS Let’s break down a basic SELECT query, pulling visits, transactions and revenue by channel from our Google Analytics dataset: SELECT date, channelGrouping as channel, totals.visits, totals.transactions, totals.transactionRevenue FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801`LIMIT
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
9 GOOGLE SHEETS FORMULAS + CHEAT SHEET 9, to be exact. I’m going to walk you through each of the 9 key Google Sheets formulas that you need to become a master. I put together a Google Sheets formulas cheatsheet that you can use to follow along with this post. Grab the workbook through the link below. MAKE A COPY OF THE WORKBOOK. I’m not asking for your email address(I know that
HOW WE AUTOMATED OUR SOCIAL MEDIA ANALYSIS · CODING IS FOR Contents hide What’s in the social media dashboard? Picking your metrics Setting your goals and baseline Catching the outliers Single-sheet social channel comparison Setup your own social media dashboard Bask in the Glory of Your Cross-Channel Social Media Audit Template and Data Your life as a social media marketer relies on striking the perfect balance. HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS Let’s break down a basic SELECT query, pulling visits, transactions and revenue by channel from our Google Analytics dataset: SELECT date, channelGrouping as channel, totals.visits, totals.transactions, totals.transactionRevenue FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801`LIMIT
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. GET STARTED · CODING IS FOR LOSERS Data pipelines run $6,250 per 3-week sprint, in which we'll build one of your unique analysis workflows (a website audit or ad funnel analysis, for example). CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
RECIPES · CODING IS FOR LOSERS Quickly understand which pages are surging and falling in traffic and impressions. The most powerful, flexible SEO audit in the market - powered by BigQuery. Pulls organic traffic + competitor KW data to project traffic from an SEO campaign. Find your Shopify store's best customers + marketing channels. Improve the performance of yourwebsite's
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery, or elsewhere): A pipeline outputs visualization-ready data, which can VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. HOW TO BLEND DATA IN GOOGLE DATA STUDIO · CODING IS FOR LOSERS Step 1: create new blended data. At this point, you’ve already started a new report in the Data Studio with your first dataset. In your Google Data Studio report, click on Resources in the top menu and select “manage blended data.”. Now, click on “add a dataview.”.
PROJECT MANAGEMENT IN GOOGLE SHEETS A FREE project management system built into Google Sheets. Get instant access to our templates + training system. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. CODING IS FOR LOSERS · AUTOMATE YOUR MARKETING DATAABOUTSERVICESCASE STUDIESRECIPESTUTORIALSGET STARTED We build custom pipeline "Recipes" in 3-week development sprints. Each sprint costs $6,250. Most clients will build approximately 4-5 recipes as part of a pipeline, for a total development cost of ~$25,000. After development is complete, CIFL can maintain your pipeline + offer analysis advisory for $3k per month, depending on needs. ABOUT | CODING IS FOR LOSERS That’s where CIFL comes in . We help marketers reclaim lost time through automated data pipelines. A data pipeline aggregates all your marketing data in one place: a Google BigQuery warehouse. This allows you to report on it when needed – without having to wrangle data from dozens of platforms. The era of manually pulling data forreporting
CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
MODELING CUSTOMER RETENTION IN BIGQUERY SQL · CODING IS Step 0: Generate a Date Range. To fill in the gaps in each customer’s history, first we need a time series to work from. In BigQuery, we use the GENERATE_DATE_ARRAY function – this statement will generate a series of dates from 1/1/2020 until the current date.. GENERATE_DATE_ARRAY(DATE('2020-01-01'), CURRENT_DATE(), INTERVAL 1DAY)
HOW TO FORECAST YOUR SITE'S ORGANIC TRAFFIC · CODING IS We ended up with 3 forecast scenarios: Business as Usual. As discussed, a top-down forecast using total organic traffic from GA. Improve Existing Keywords. A bottom-up forecast using your site’s existing keyword rankings from SEMrush, with the traffic boost coming from a 50% assumed ranking improvement over the next year. New KeywordGrowth.
HOW TO LEVERAGE SQL FOR SEO AUTOMATION · CODING IS FOR LOSERS 1. Automate Category Tagging. As part of the website quality audit, you have to manually tag pages by page category. For example, is the URL a blog post, landing page, blog category, etc. You can easily automate much of this process using simple IF THEN login. In THE LAZY GUIDE TO LEARNING BIGQUERY SQL · CODING IS FOR LOSERS In BigQuery SQL (and most other forms of SQL), the only key difference is that you reference a table (with a FROM parameter), instead of a spreadsheet range: SELECT * FROM table WHERE x = y. Other than that, you’ll find the logic ( AND / OR ) and math syntax to be verysimilar.
SEO CONTENT AUDIT TEMPLATE Content marketing strategy. We've helped 1,000+ websites grow from free Google traffic. That knowledge is wrapped up in this template along with detailed guidance QUERY FUNCTION IN GOOGLE SHEETS 1. The basics of Google Sheets Queries. QUERY combines all of the capabilities of arithmetic functions (SUM, COUNT, AVERAGE) with the filtering abilities of a function like FILTER. In this example, we’ll walk through a few QUERY examples, to analyze a sampling of Twitter data. The basic structure of a VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. TUTORIALS · CODING IS FOR LOSERS data-viz. 11 Best Data Visualization Tools All of the best tools for data visualization, ranked and reviewed based on our experience. sheets. Google Sheets Automation Tools. A faster, cheaper alternative to building clunky automation software. bigquery. GET STARTED · CODING IS FOR LOSERS Data pipelines run $6,250 per 3-week sprint, in which we'll build one of your unique analysis workflows (a website audit or ad funnel analysis, for example). CODING IS FOR LOSERS Google Sheets has become a weapon of mass laziness - when combined with tools like Blockspring and Zapier, it allows you to drastically cut your time spent wrangling and analyzing data. In this course, you’ll learn the three-part process we use at Coding is for Losers to analyze data: Pulling data into Sheets using apps like Blockspringor
WTF IS A DATA PIPELINE? · CODING IS FOR LOSERS A Data Pipeline unifies your team’s data in one place. It is not a specific piece of technology. It is a way of liberation. A pipeline combines into a single database (whether that’s in Sheets, BigQuery, or elsewhere): A pipeline outputs visualization-ready data, which can HOW TO FIND YOUR BEST MARKETING CHANNEL · CODING IS FOR LOSERS 1. Get raw data flowing. There are two types of data required in this (or any) data pipeline: The raw data itself, from Google Analytics. Some administrative mapping data, for example to specify how each Google Analytics source / medium translates into a ‘Channel’. I recommend using Stitch for pushing the first type of raw data toBigQuery
VLOOKUP IN GOOGLE SHEETS (CHEAT SHEET) VLOOKUP is the gateway drug of Google Sheets formulas. A little taste of it and I was hooked – it’s a small, simple formula that will save you hours in data entry. This post will help teach you how to write a number of VLOOKUP formulas using a cheat sheet I put together for you. Grab the VLOOKUP workbook through the link below. 5 ADVANCED SHOPIFY REPORTS IN BIGQUERY · CODING IS FOR LOSERS Using BigQuery for Shopify analysis. We’ve helped our ecommerce clients setup dozens of custom reports in BigQuery, this post will detail the 5 of the most powerful Ecommerce analyses out there: Cohort analysis. Buyer segmentation (aka RFM analysis) Sales + Margin Forecasting. Basket analysis. FIND QUICK WIN KEYWORDS FOR SEO GROWTH If you’re lazy efficient, APIs are designed for you.. Add in a spreadsheet and you’ll get a lot more done. Like, a lot more. In this article I’ll be walking through how I use APIs + spreadsheet to find quick win keywords to go after for as part of an SEO campaign. WTF IS A "RECIPE"? · CODING IS FOR LOSERS For each site that you set up for a Recipe, you pay a flat fee per month of $25. For Recipes that include access to paid APIs (like Deepcrawl or SEMrush), we’ll even cover your API costs for you, so you don’t have to purchase your own API key: Deepcrawl site crawl (includes Majestic backlinks data): $20 HOW TO USE GOOGLE SHEETS FOR PROJECT MANAGEMENT The list goes on. If setup properly, Google Sheets can perfectly match this fluidity, and be the project management tool. Let’s walk through how we built a custom Sheets project management system to manage a 7 figure digital agency. This short video walks you CIFL Laziness is a Virtue MenuSERENITY NOW!
Automate your data pipeline in Google Sheets, BigQuery and DataStudio.
* Start Here
GOOGLE SHEETS TUTORIALS Master the Foundation of any Lazy Analyst's Stack. DATA ANALYSIS RECIPES Repeatable data analysis templates built in Google Sheets or BigQuery. ANALYTICS TOOL REVIEWS + TUTORIALS Get up and running with BigQuery, DBT, Google Data Studio, Supermetrics and more. CASE STUDIES IN LAZINESS Stories of organizations deploying the Lazy Way to great effect. DATA ANALYSIS COURSES Get your doctorate in the Lazy Way.VIDEO TUTORIALS
Browse our semi-deep library on YouTube.WTF IS CIFL?
Coding is for Losers is an elite group of analysts, executives, marketers and nonprofiteers advancing the idea that working with data need not be a drag. We collaborate via a public Trello board, which houses all CIFL analysis templates, tutorials and the invite link to our super-secret Slack channel.* Join us on Trello
* GitHub
* YouTube
* © Coding is for Losers * Read our Privacy Policy * BigQuery Connector Privacy Policy* Analysis Recipes
* Analytics Tools
* Case Studies
* CIFL Courses
* Google Sheets Tutorials * Letters from Commish* WTF is CIFL?
Close
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0