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
04.10.2024
Afe Mevhare
How to automatically calculate Profit on Ad Spend (POAS) on your Shopify store
20.09.2024
Afe Mevhare
How to automatically convert currencies with Google Finance for your multi-store reporting
13.09.2024
Afe Mevhare
Marketing Attribution Models 101: Understanding the Impact of your Ads
05.04.2024
Afe Mevhare
How to correctly attribute sales driven by Klaviyo campaigns in GA4
22.03.2024
Salima Nadira
Amazon Listing Suppression: Causes, Fixes, and Prevention Strategies
16.02.2024
Afe Mevhare
How to calculate product profitability to balance sell-through rates with profit margins.
26.01.2024
Afe Mevhare
46 customer segments to drive profitable growth: with downloadable worksheet.
18.01.2024
Saptarshi Nath
Sell-through rate: formula and improvement tactics for e-commerce brands
12.01.2024
Saptarshi Nath
Are you tracking the right profit metrics for your e-commerce store?
07.12.2023
Saptarshi Nath
A six-point framework for designing a product bundling strategy for your Shopify store
30.11.2023
Saptarshi Nath
How to accurately track daily conversions on your Shopify store
24.11.2023
Afe Mevhare
How to build segments of customers buying specific SKUs from your Shopify store?
17.11.2023
Salima Nadira
The ultimate guide to reviewing your 3PL performance
26.10.2023
Saptarshi Nath
How to identify the right products to cross-sell
17.10.2023
Salima Nadira
Are markdowns driving more sales for your Shopify store?
05.10.2023
Salima Nadira
How to identify cross-sell opportunities using your Shopify store data
22.08.2023
Salima Nadira
How to create a report identifying cash on delivery payments using Google Sheets
05.05.2023
Salima Nadira
How to set up a product sales report on Looker that updates automatically
20.04.2023
Salima Nadira
How to set up ad reports on Looker that update automatically
13.04.2023
Salima Nadira
How to track Shopify sales by variant
06.04.2023
Salima Nadira
How to create reports in Google Looker Studio that update automatically
24.03.2023
Salima Nadira
How to calculate and improve LTV for your Shopify store.
02.03.2023
Saptarshi Nath
How to export Black Friday Shopify sales to Google Sheets
14.10.2022
Salima Nadira
How to connect Klaviyo to Google Sheets
30.09.2022
Salima Nadira
How to easily connect TikTok, Google Sheets
27.09.2022
Saptarshi Nath
How to export daily Shopify sales filtered by payment method
15.09.2022
Salima Nadira
How to track ecommerce conversions on your Shopify store
26.08.2022
Salima Nadira
D2C Marketing KPI Report: metrics to track for your store.
19.08.2022
Salima Nadira
What is Marketing Efficiency Ratio (MER) and how to make better decisions with it?
11.08.2022
Saptarshi Nath
How to measure retention performance on your Shopify store through cohort analysis
29.07.2022
Salima Nadira
How to track Facebook campaign performance by time of day
30.05.2022
Georgia Bogert
Using Airboxr with Google Data Studio
12.05.2022
Salima Nadira
How to export Shopify sales by state
28.04.2022
Salima Nadira
Using RFM analysis to identify your most valuable customers
22.04.2022
Saptarshi Nath
How to combine columns in Google Sheets
28.03.2022
Saptarshi Nath
Convert Rows Into Columns In Google Sheets (A Step-By-Step Guide)
08.03.2022
Saptarshi Nath
How to build your own Shopify sales report in Google Sheets
28.02.2022
Saptarshi Nath
Building an e-commerce revenue analytics strategy
22.02.2022
Saptarshi Nath
How to automatically export Shopify data to Google Sheets
10.02.2022
Salima Nadira
Merging cells and data in Google Sheets
09.02.2022
Sona Maharjan
A Guide to XLOOKUP in Excel
09.02.2022
Sona Maharjan
Graphic design trends in data visualization for 2022
20.01.2022
Salima Nadira
How to convert Excel spreadsheets to Google Sheets
05.01.2022
Sean Lim
How to set up Google Sheets FILTER functions for single and multiple conditions
15.12.2021
Christabel Wong
Using Google Analytics and Airboxr to track key performance metrics
05.12.2021
Sean Lim
How to import multiple columns with vlookup
04.12.2021
Saptarshi Nath
How to Fix Formula Parse Errors in Google Sheets
02.12.2021
Sona Maharjan
How to make a Pie Chart in Google Sheets
01.12.2021
Sona Maharjan
How to protect Google Sheets
28.11.2021
Sona Maharjan
The Definitive Guide to Conditional Formatting on Google Sheets.
25.11.2021
Saptarshi Nath
A Guide to INDEX-MATCH in Google Sheets
24.09.2021
Sona Maharjan
How to combine data from Facebook Ads and Google Ads
08.07.2021
Christabel Wong
Guide to Pivot Tables on Google Sheets.
02.02.2021
Saptarshi Nath
How to combine data from multiple Google Sheets
20.11.2020
Saptarshi Nath
How to use query + importrange to filter data on multiple criteria
04.11.2020
Saptarshi Nath
Using the Query function in Google Sheets
21.10.2020
Saptarshi Nath
An Exciting Upgrade for Google Sheets
07.09.2020
Guest Author
This is how data analysis will change in the 2020s.
17.02.2020
Saptarshi Nath
Do you need a spreadsheet or a database?
22.01.2020
Saptarshi Nath
