Research and Articles
Reporting &
analysis
Learn how to use your Shopify and ad-channel data to drive higher revenues.
How to correctly handle Shopify discounts for your financial reports
Oct 4, 2024
Afe Mevhare
How to automatically calculate Profit on Ad Spend (POAS) on your Shopify store
Sep 20, 2024
Afe Mevhare
How to automatically convert currencies with Google Finance for your multi-store reporting
Sep 13, 2024
Afe Mevhare
Marketing Attribution Models 101: Understanding the Impact of your Ads
Apr 5, 2024
Afe Mevhare
How to correctly attribute sales driven by Klaviyo campaigns in GA4
Mar 22, 2024
Salima Nadira
Amazon Listing Suppression: Causes, Fixes, and Prevention Strategies
Feb 16, 2024
Afe Mevhare
How to calculate product profitability to balance sell-through rates with profit margins.
Jan 26, 2024
Afe Mevhare
46 customer segments to drive profitable growth: with downloadable worksheet.
Jan 18, 2024
Saptarshi Nath
Sell-through rate: formula and improvement tactics for e-commerce brands
Jan 12, 2024
Saptarshi Nath
Are you tracking the right profit metrics for your e-commerce store?
Dec 7, 2023
Saptarshi Nath
A six-point framework for designing a product bundling strategy for your Shopify store
Nov 30, 2023
Saptarshi Nath
How to accurately track daily conversions on your Shopify store
Nov 24, 2023
Afe Mevhare
How to build segments of customers buying specific SKUs from your Shopify store?
Nov 17, 2023
Salima Nadira
The ultimate guide to reviewing your 3PL performance
Oct 26, 2023
Saptarshi Nath
How to identify the right products to cross-sell
Oct 17, 2023
Salima Nadira
Are markdowns driving more sales for your Shopify store?
Oct 5, 2023
Salima Nadira
How to identify cross-sell opportunities using your Shopify store data
Aug 22, 2023
Salima Nadira
How to create a report identifying cash on delivery payments using Google Sheets
May 5, 2023
Salima Nadira
How to set up a product sales report on Looker that updates automatically
Apr 20, 2023
Salima Nadira
How to set up ad reports on Looker that update automatically
Apr 13, 2023
Salima Nadira
How to track Shopify sales by variant
Apr 6, 2023
Salima Nadira
How to create reports in Google Looker Studio that update automatically
Mar 24, 2023
Salima Nadira
How to calculate and improve LTV for your Shopify store.
Mar 2, 2023
Saptarshi Nath
How to export Black Friday Shopify sales to Google Sheets
Oct 14, 2022
Salima Nadira
How to connect Klaviyo to Google Sheets
Sep 30, 2022
Salima Nadira
How to easily connect TikTok, Google Sheets
Sep 27, 2022
Saptarshi Nath
How to export daily Shopify sales filtered by payment method
Sep 15, 2022
Salima Nadira
How to track ecommerce conversions on your Shopify store
Aug 26, 2022
Salima Nadira
D2C Marketing KPI Report: metrics to track for your store.
Aug 19, 2022
Salima Nadira
What is Marketing Efficiency Ratio (MER) and how to make better decisions with it?
Aug 11, 2022
Saptarshi Nath
How to measure retention performance on your Shopify store through cohort analysis
Jul 29, 2022
Salima Nadira
How to track Facebook campaign performance by time of day
May 30, 2022
Georgia Bogert
Using Airboxr with Google Data Studio
May 12, 2022
Salima Nadira
How to export Shopify sales by state
Apr 28, 2022
Salima Nadira
Using RFM analysis to identify your most valuable customers
Apr 22, 2022
Saptarshi Nath
How to combine columns in Google Sheets
Mar 28, 2022
Saptarshi Nath
Convert Rows Into Columns In Google Sheets (A Step-By-Step Guide)
Mar 8, 2022
Saptarshi Nath
How to build your own Shopify sales report in Google Sheets
Feb 28, 2022
Saptarshi Nath
Building an e-commerce revenue analytics strategy
Feb 22, 2022
Saptarshi Nath
How to automatically export Shopify data to Google Sheets
Feb 10, 2022
Salima Nadira
Merging cells and data in Google Sheets
Feb 9, 2022
Sona Maharjan
A Guide to XLOOKUP in Excel
Feb 9, 2022
Sona Maharjan
Graphic design trends in data visualization for 2022
Jan 20, 2022
Salima Nadira
How to convert Excel spreadsheets to Google Sheets
Jan 5, 2022
Sean Lim
How to set up Google Sheets FILTER functions for single and multiple conditions
Dec 15, 2021
Christabel Wong
Using Google Analytics and Airboxr to track key performance metrics
Dec 5, 2021
Sean Lim
How to import multiple columns with vlookup
Dec 4, 2021
Saptarshi Nath
How to Fix Formula Parse Errors in Google Sheets
Dec 2, 2021
Sona Maharjan
How to make a Pie Chart in Google Sheets
Dec 1, 2021
Sona Maharjan
How to protect Google Sheets
Nov 28, 2021
Sona Maharjan
The Definitive Guide to Conditional Formatting on Google Sheets.
Nov 25, 2021
Saptarshi Nath
A Guide to INDEX-MATCH in Google Sheets
Sep 24, 2021
Sona Maharjan
How to combine data from Facebook Ads and Google Ads
Jul 8, 2021
Christabel Wong
Guide to Pivot Tables on Google Sheets.
Feb 2, 2021
Saptarshi Nath
How to combine data from multiple Google Sheets
Nov 20, 2020
Saptarshi Nath
How to use query + importrange to filter data on multiple criteria
Nov 4, 2020
Saptarshi Nath
Using the Query function in Google Sheets
Oct 21, 2020
Saptarshi Nath
An Exciting Upgrade for Google Sheets
Sep 7, 2020
Guest Author
This is how data analysis will change in the 2020s.
Feb 17, 2020
Saptarshi Nath
Do you need a spreadsheet or a database?
Jan 22, 2020
Saptarshi Nath
