writer

Rai Bautista

Blog POSTS
TUTORIALS
Double-clicking on the header zooms you in to that section, making it more possible for you to visually see the subdivisions in that category.

Data & Analytics

How to Make Tree Map Charts in Google Sheets
Google Sheet with the questions from a Google Form forming the top fixed row. 

Data & Analytics

How to Integrate Google Sheets with Google Forms [Step-by-Step Tutorial]
Google Sheet with FILTER function examples

Spreadsheets

Using Google Sheets FILTER Function [w/ Single & Multiple Conditions]
The options for editing the header of the email on Shopify Email.

eCommerce & Sales

How to Create an Email Marketing Campaign on Shopify Email
Google Sheets with a Pivot Table. The upper-leftmost cell of the Pivot Table highlighted.

Spreadsheets

How to Delete Pivot Tables in Google Sheets and Excel
IMPORTFEED importing the latest news headlines with their summary and timestamp.

Data & Analytics

How to Use Google Sheets IMPORT Functions [IMPORTDATA, IMPORTFEED, & More!]
The int function applied to the entire array using arrayformula. 

Spreadsheets

Guide to Using ARRAYFORMULA in Google Sheets (+ Examples!)
Shopify Store site editor, with Home page loaded. 

eCommerce & Sales

How to Edit the Home Page of your Shopify Store
The Admin API section lists all the possible data that can be accessed via the Shopify API.

eCommerce & Sales

How to Access the API Key of Your Shopify Store [in 6 easy steps]
The ranges from multiple sheets combined in the single destination Google Sheet via IMPORTRANGE. 

Spreadsheets

How to Import Multiple Sheets Using the IMPORTRANGE Function
Google Sheet with list of fruit names in Column A

Spreadsheets

How to Randomly Pick a Name from A Long List in Google Sheets
Google Sheet with sample data and VLOOKUP equations on the right

Spreadsheets

How to use VLOOKUP with Multiple Criteria in Google Sheets
Two arrays. The top array is the original one, containing an assortment of values with some cells appearing blank. The bottom array is generated by encoding an IF function to display “Really empty” when the result of ISBLANK is TRUE orDisplay “Something’s written” when the result of ISBLANK is FALSE

Spreadsheets

How to Use ISBLANK Function in Google Sheets
A table of total profit from each product from a specific week, with a row per day of the week, using pivot. The table is essentially transposed, with each item getting their own column.

Data & Analytics

How to Use the SQL Pivot Clause in Google Sheets
pop-up box for importing workbooks. Has four tabs for four options of importing the workbook: from your own Google Drive, from other users’ workbooks shared with you, from workbooks you recently opened in Google Sheets, and for uploading a spreadsheet file from your computer or smartphone, often as Excel workbook.

Spreadsheets

3 Easy Ways to Import Data from Another Workbook in Google Sheets
 A sheet containing the Pivot Table. Uses Google Sheets’ Groovy theme, using shades of red to highlight the column labels, the row labels (the individual dates from July 6 to July 13), and the Grand Total. 

Spreadsheets

How to Format Pivot Tables in Google Sheets
Google Sheets list of total profit from each product from a specific week, arranged by decreasing total profit

Data & Analytics

How to Arrange the Order of SQL Query Results in Google Sheets
Results of the query. The first column contains the specific item, the second column contains the “sum profit” per listed item. 

Data & Analytics

How to Use the 'Group by' SQL Clause in Google Sheets
Various SQL queries for aggregate values on Google Sheets

Data & Analytics

How to Use SQL Query for Aggregate Values in Google Sheets
Google Sheets spreadsheet with data and QUERY formula written in

Data & Analytics

How to Use SQL Queries to Format Google Sheets
Pivot table on top of corresponding data

Spreadsheets

How to Add Custom Formulas in a Google Sheets Pivot Table
Worksheet listing only entries for June 29. All other entries automatically hidden by the Slicer. 

Spreadsheets

How to Use Google Sheets Slicer: Filtering Data (Tutorial)
Spreadsheet containing several sheets. Names of sheets are week27, week28, and items. The displayed sheet, week27, contains the list of sales, costs, and the resulting profits.

Spreadsheets

How to Consolidate Several Sheets into a Single Pivot Table
Snippet of the output sheet. The column headers were replaced by new ones. 

Data & Analytics

How to Use SQL Labels in Google Sheets
On top, data of US states and name origins. On bottom, query result listing the states, the year their name was first attested, and language of origin of their names. All the listed states have their name first attested before 1800.

Data & Analytics

How to Select Multiple Columns through SQL Query in Google Sheets 
end of data displayed by query. There are 1267 rows loaded by the QUERY command. Selected columns loaded: date of entry, total price of order, and profit from the order. 

Data & Analytics

How to SQL Query Multiple Sheets in Google Sheets
List of states whose names originated from either Spanish language or English language: Arizona, California, Colorado, Delaware, Florida, Georgia, Maine, Maryland, Montana, Nevada, New Hampshire, New Mexico, New York, North Carolina, South Carolina, Texas, Utah, and Washington. Queried from the source worksheet.

Data & Analytics

How to Use SQL Queries to Search for Specific Words in Google Sheets
Image: U.S. states whose names did not originate from Spanish, English, nor French. The ones shown on the screen, in alphabetical order, are near the end of the list: Minnesota, Nebraska, North Dakota, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Dakota, Tennessee, Virginia, West Virginia, and Wyoming.

Data & Analytics

How to Use SQL Query with Multiple Criteria in Google Sheets
Image: How to add the Slider widget. Click Data on the main menu and then click on the Slicer in the appearing drop-down menu.

Spreadsheets

How to Filter Charts Using the Slicer on Google Sheets
Overview page of Google Ads. Filter on top, with a box containing the values of selected metrics over a period.

Marketing

Finding Online Advertising Metrics in Google Ads (CPC, etc.)
filtered data loaded into the spreadsheet using the same ImportJSON code.

Data & Analytics

How to Filter SQL Data Before Importing into Google Sheets
sample table. Includes columns for the title of the product, the description as the “body html”, the product type, the product handle, date of launch as “published at”, and the price as “variants price”.

Data & Analytics

How to Use Basic SQL Commands + Query Another Sheet in Google Sheets
Returning customer rate graph over time on Shopify, shows a slight dip on average

Customer Success

Finding Shopify eCommerce Metrics: Repeat Customer Rate
A portion of a spreadsheet of order information. Contains the order timestamp as “Created At:, the total price, the customer name, and two columns where the timestamp was split into one column for the date of order and the time it was ordered.

Data & Analytics

How to Use SQL Queries to Search by Date on Google Sheets
Shopify Analytics Dashboard showing AOV

eCommerce & Sales

Finding eCommerce Metrics in Shopify: Average Order Value (AOV)
Online store conversion rate box in Overview dashboard on Shopify

eCommerce & Sales

Finding eCommerce Metrics in Shopify: Conversion Funnel Metrics
Google script editor. Code from bradjasper’s ImportJSON at GitHub inserted.

Data & Analytics

How to Export SQL Data to Google Sheets & Update Export
Google Sheets pivot table, with the items rearranged from biggest profit to smallest. 

Data & Analytics

How to Sort the Rows in the Pivot Table in Google Sheets
Pivot table in the new sheet. Displays the date as rows. The data cells contain the total profit for each day, as specified under the Values label of the Pivot table editor... 

Data & Analytics

How To Use Pivot Tables To Summarize Data by Time On Google Sheets
Shopify theme editor

eCommerce & Sales

How to Create Your Own Shopify Store and Customize its Theme
Mock product showing on Shopify store

eCommerce & Sales

How to Add New Products to Your Shopify Store
Overview Dashboard on Shopify under Analytics

eCommerce & Sales

Finding eCommerce Metrics in Shopify: Profit and Cost Metrics
Google Sheet entitled "How to Add/Remove Rows and Columns..." with a blank row selected and the right-click menu open

Spreadsheets

How to Add/Remove Rows and Columns in Google Sheets [2020 Tutorial]
Header: Missing column between Column A and Column C

Spreadsheets

How to Quickly Unhide Columns in Google Sheets
Header: An array of cells with Yes and No from drop-down lists

Spreadsheets

How to Add Yes/No Drop-Down Lists in Google Sheets
Annual sales data, one column per branch, with line chart

Data & Analytics

How to Create a Chart with Multiple Ranges of Data in Google Sheets
Heading photo. Name, Location, Phone Number

Spreadsheets

How to Format Phone Number Data on Google Sheets
Header image. Display checkboxes at the end of data table

Spreadsheets

How to Insert a Checkbox in Google Sheets
Miscellaneous rows of data in a Google Sheet

Spreadsheets

How to Hide and Unhide Rows in Google Sheets
A table with values, percentage column empty

Data & Analytics

Absolute Reference in Google Sheets: A Beginner's Guide
Gray bar moved to below Row 1, Row 1 now frozen on top

Spreadsheets

How to Quickly Freeze/Lock Rows in Google Sheets
Completed chart with title and labels

Data & Analytics

How to Add a Title and Label the Legends of Charts in Google Sheets
Data chart with Customer Name, Customer Creation Date, and Customer ID

eCommerce & Sales

How to Export Shopify Customer Creation Date [Step-by-Step]
Paste values only selected from Paste special option

Spreadsheets

How to Convert Formula Results into Static Values in Google Sheets
Remove duplicates option under Data highlighted

Spreadsheets

How to Remove Duplicate Entries in Google Sheets
Crude search bar inserted above the spreadsheet

Data & Analytics

How to Highlight Cells Containing Matching Search Query
Header image. The cell on another sheet selected.

Data & Analytics

How to Reference Another Sheet in the Same Workbook on Google Sheets
Built-in number formats in Google Sheets

Spreadsheets

How to Convert Numbers to Strings in Google Sheets
Simple concatenate function. Data combined without space in between

Spreadsheets

Three Ways to Merge Cells in Google Sheets
Column split to two using SPLIT() function. The original column is not replaced.

Spreadsheets

How to Split Cells in Google Sheets
Nested IF() function in Google Sheets

Data & Analytics

Simple Guide To Using The IF() Function in Google Sheets
Store with sold out products shown

eCommerce & Sales

How to Hide Out-of-Stock Products in Your Shopify Store
Import file window. Upload tab shown

Spreadsheets

How to Convert Excel Files to Google Sheets (and Vice-Versa!)
Wonder Foods collection page.

eCommerce & Sales

How to Make Collections on Shopify
Product list page. Export button highlighted

eCommerce & Sales

How to Back Up Your Shopify Store

Get early access.

We're gradually opening up early access to companies and teams who want to do more with their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.