Insights

LTV Calculation & Dashboard - choosing the right LTV calculation is hugely important for your business - we walk you through the options and what we chose. Through this 10 part series, we'll walk through all the steps you need to automate data, store it in a database, decide on what LTV makes sense, calculate LTV, and build some dashboard visuals so you can be data-driven in your analysis to increase it! Full length walkthrough: https://youtu.be/jb92BIttiig More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

LTV Calculation & Dashboard - we show you how to automate data from BigQuery into Looker Studio. Through this 10 part series, we'll walk through all the steps you need to automate data, store it in a database, decide on what LTV makes sense, calculate LTV, and build some dashboard visuals so you can be data-driven in your analysis to increase it! Full length walkthrough: https://youtu.be/jb92BIttiig More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

LTV Calculation - we dive into the Shopify table Order Line Items automation and data so you can build a Looker Studio dashboard. Through this 10 part series, we'll walk through all the steps you need to automate data, store it in a database, decide on what LTV makes sense, calculate LTV, and build some dashboard visuals so you can be data-driven in your analysis to increase it! Full length walkthrough: https://youtu.be/jb92BIttiig More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

LTV Calculation - we'll walk you through the options to get the RIGHT Shopify data automated into BigQuery so you can build a Looker Studio dashboard. Through this 10 part series, we'll walk through all the steps you need to automate data, store it in a database, decide on what LTV makes sense, calculate LTV, and build some dashboard visuals so you can be data-driven in your analysis to increase it! Full length walkthrough: https://youtu.be/jb92BIttiig More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

LTV Calculation - understanding how to get all the Shopify data you need into a Looker Studio dashboard! Through this 10 part series, we'll walk through all the steps you need to automate data, store it in a database, decide on what LTV makes sense, calculate LTV, and build some dashboard visuals so you can be data-driven in your analysis to increase it! Full length walkthrough: https://youtu.be/jb92BIttiig More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

LTV calculation from your Shopify data - see the Looker Studio dashboard full walkthrough with steps for 1) automating data, 2) deciding on the right LTV calculation for you, and 3) building visuals in Looker Studio. More on us at Pineapple here: https://www.pineapplecf.com/featured Ecommerce dashboards: https://www.pineapplecf.com/ecommerce-dashboards Fractional Analyst services: https://www.pineapplecf.com/fractional-analyst Data automation affiliate links: Coupler: https://www.coupler.io/?ref=nge0mtv Make.com: https://www.make.com/en/register?pc=pineapplejack Datadoo: email jack@pineapplecf.com for an email intro

See how Gemini can explain queries in BigQuery! It's pretty straightforward! Get Google Workspace through our affiliate link for 10% off! https://workspace.google.com/pricing?utm_source=sign-up&utm_medium=affiliatereferral&utm_campaign=apps-referral-program&uj=ref.promo~save10&uj=ref.referrer~PVN6IKL More on us at Pineapple: https://www.pineapplecf.com/featured

Our Fractional Analyst service pricing overview. It breaks down into three transparent parts, 1) an initial diagnostic, 2) ongoing Analytics Retainer, and 3) Impact Commission where we only win if you win. Our goal is completely aligned incentives! More info on our Fractional Analyst offering: https://www.pineapplecf.com/fractional-analyst