Google Sheets CLTV and Pivot Tables

₹600-1500 INR

Closed

Posted 7 days ago

₹600-1500 INR

Paid on delivery

I need assistance with creating pivot tables and calculating customer lifetime value (CLTV) in Google Sheets. I will provide the necessary data sources. Requirements: - Proficiency in Google Sheets - Experience with creating pivot tables - Familiarity with CLTV calculations - Attention to detail and accuracy

Project ID: 40511628

About the project

8 proposals

Remote project

Active 5 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

8 freelancers are bidding on average ₹1,269 INR for this job

@Sahyadri96

@SahyadriTech #SahyadriTech Completed Projects: 1. Hotel Booking Management & Tracking System (Excel + VBA Script) 2. Appsheet: ERP system for textile business 3. MNGL Gas Incident Tracker & Dashboard (Google Sheets + Google Data Studio) 4. Daily Expenses Tracker (Google Sheets) 5. Option Scalping Strategy Automation (Excel VBA) 6. Nifty50 Live Option Chain Dashboard (Google Sheets) 7. Binary Trading Sheet (Google Sheets) 8. Customer Data Cleaning & Sorting Tool (Excel VBA & Python) 9. Historical Stock Closing Price Analysis for 2,600 Stocks (Excel & Python) 10. Power Bi dashboard for F1 Car racing insights 11. GOLD Loan tracking in Google sheet and Google Data studio 12. Local Taxi Tracking System (Google Sheets + Google Data Studio) 13. Appsheet Milk Drivers wages and attendance system (Appsheet + Google sheet ) Key Highlights: 1. Pay only if satisfied with the work 2. Expert in Power BI, Excel, VBA Macros, Google Sheets, Google Apps Script, and Python 3. Experience in 3 American MNCs 4. Skilled in Data Analytics, Automation, and Visualization 5. Proficient in Statistical Analysis 6. Offer Long-Term Support for all projects 7. Quick Delivery with multiple revisions I can deliver any project related to Data Analytics, Automation, and Reporting with precision and reliability.

₹1,500 INR in 7 days

5.0

(7 reviews)

3.1

@Huzaifa366

Hello, I would be happy to assist with creating Pivot Tables and calculating Customer Lifetime Value (CLTV) in Google Sheets. I have experience working with spreadsheets, data analysis, reporting, and business metrics. I can help organize your data, build clear Pivot Tables for analysis, and create accurate CLTV calculations while explaining the logic behind the formulas if needed. I can assist with: • Creating and optimizing Pivot Tables • Data cleaning and preparation • Customer segmentation and analysis • CLTV calculations and formulas • Google Sheets functions and reporting • Dashboard-style summaries and visualizations My focus is on accuracy, clear documentation, and making sure the final sheet is easy for you to understand and maintain. Please share the data sources and your preferred CLTV methodology (historical or predictive), and I can get started right away. Looking forward to working with you. Best Regards, Muhammad Huzaifa

₹1,500 INR in 27 days

0.0

(0 reviews)

0.0

@edhernandezworks

I can build this as a clean Google Sheets workbook: source-data tabs, PivotTables, a simple CLTV calculation tab, and a short notes tab explaining the formulas so you can update it later. For this budget I would keep the scope tight: one data source set, CLTV logic, pivots, and a clean handoff. If the data has messy columns, duplicates, or missing values, I’ll flag those clearly instead of hiding them. I’ve done similar data cleanup / reporting proof work with messy CSV and reconciliation outputs. I can turn this around in 1 day once the source data is shared. One quick question: do you already have the CLTV formula you want used, or should I use a simple revenue / customer count style calculation based on the fields available?

₹1,500 INR in 1 day