
Closed
Posted
Paid on delivery
I need our scattered Direct-to-Consumer data pulled together into a single, reliable Google Looker Studio (Data Studio) workspace that my management team can open each morning and instantly understand how the business is performing. Scope • Combine four lenses—sales, marketing, inventory and customer behaviour—into one cohesive report. • Connect live data from Google Analytics, Meta Ads (Facebook/Instagram), Google Ads, our logistics partner’s feed, plus a manual inventory sheet (CSV/Google Sheet). If a community or partner connector is required, build or recommend it. • Design intuitive pages and filters so senior management can drill from a high-level overview into SKU, campaign or cohort detail without needing analyst support. Key views I expect – Daily, weekly and monthly sales with YoY and MoM deltas – ROAS, cost per acquisition and funnel drop-offs for each paid channel – Customer cohorts and LTV trends – Real-time inventory position with low-stock alerts matched to marketing velocity – Order-to-delivery timeline visualised from the logistics feed Deliverables 1. Fully-functional Looker Studio report with branded styling and shareable link 2. All data connectors or scheduled uploads configured and documented 3. Custom calculated fields/scripts for metrics such as blended ROAS and inventory cover days 4. One-page hand-off guide (PDF or doc) so the team can update or extend the dashboard later Acceptance The dashboard must refresh automatically on the chosen schedule, load in under 10 seconds on a standard laptop, and display correctly on desktop and tablet. Once those boxes are ticked, we’ll sign off.
Project ID: 40724078
15 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
15 freelancers are bidding on average ₹4,104 INR for this job

Hi, I can build a unified Google Looker Studio dashboard combining sales, marketing, inventory and customer data from Google Analytics, Meta Ads, Google Ads, logistics feeds and Google Sheets/CSV. I can configure the required connectors, calculated metrics such as blended ROAS and inventory cover days, management-friendly filters, SKU/campaign/cohort drill-downs, inventory alerts and order-to-delivery tracking. I’ll also optimize the report for fast loading, desktop/tablet viewing, automatic refresh, and provide documentation with a hand-off guide. I have 10+ years of experience in web and data-driven application development, including dashboard and API/data integration work. Thank you Regards, Sai
₹2,500 INR in 5 days
8.3
8.3

I have read your requirement, I can analyse data in Power BI, Google Studio & Excel Power Query data source from MS SQL Server , MySQL & ORACLE, Excel , I am specialize in database design, analysis, report generation. Please chat
₹5,000 INR in 7 days
4.2
4.2

Hello Sir, I have already worked on many **cryptocurrency trading systems, automated trading platforms, and exchange API integration projects**. I can also show you demos of my previous work. I am a full-time freelancer with **17+ years of experience** in software development, trading automation, and financial API integrations. My relevant experience includes: * Cryptocurrency trading platforms * Binance and Bybit API integration * MT4 and MT5 trading automation * C#-based copy trading software * Arbitrage trading systems (Binance ↔ Bybit) * Automated order execution (Buy/Sell/Square Off) * Portfolio and position management * Margin and risk management features * Real-time market data integration * Trading bots and strategy automation I have already developed a **C#-based Copy Trading Software** where trades from a master account are automatically copied to multiple child accounts. I have also built **arbitrage trading systems** between Binance and Bybit using their official APIs. In addition, I have developed trading platforms using **Zerodha Kite API, Alice Blue API, Angel One API, and Profitmart API**, including features such as order placement, position management, square-off, margin calculation, and automated trading execution. I have also implemented strategy automation using **AmiBroker CSV integration**. I can start working immediately and deliver a secure, scalable, and reliable trading solution based on your requirements. Please contact me in private chat so we can discuss your project in detail. I will be happy to show you **live demos and examples of my previous trading projects**. Looking forward to working with you. Thanks & Regards, Sanjay
₹1,500 INR in 5 days
3.2
3.2

You need one management dashboard that connects revenue, marketing spend, stock risk, and customer behaviour into decisions the team can make each morning. I’d use Google Looker Studio for the presentation layer, with a clean reporting model behind it rather than blending live sources repeatedly in each chart. GA4 and Google Ads can connect directly; Meta Ads and logistics data would use a vetted connector or scheduled import into Google Sheets/BigQuery depending on volume and refresh needs. That makes blended ROAS, cohort LTV, inventory-cover days, and delivery timelines consistent and keeps the report responsive. At Poundit, I worked on e-commerce systems involving payment data, customer journeys, and operational workflows. I understand the importance of reconciling revenue, ad attribution, product identifiers, and inventory before visualizing them. I’ll document source ownership, refresh schedules, metric definitions, and how to extend the report. Is your order and product data already available in a store platform or database, and what refresh frequency does the logistics feed support?
₹3,000 INR in 1 day
3.1
3.1

Hi I will build a reliable Looker Studio workspace that brings your DTC sales, marketing, inventory, and customer data into one management-ready dashboard. I understand you need live connections across GA4, Meta Ads, Google Ads, logistics, and inventory data, with fast-loading views that move from executive KPIs to SKU, campaign, and cohort detail. What you’ll get: • Cohesive dashboard with automated data refreshes and branded styling • Sales, ROAS, CPA, funnel, cohort/LTV, inventory, and delivery insights • Custom metrics including blended ROAS and inventory cover days • Documented connectors, calculated fields, and one-page handoff guide I’m an experienced freelancer and I’ve completed similar projects with 5⭐ feedback for accuracy and delivery. Timeline: 3 days Bid: 1,500 INR Please send me a message so we can get started immediately.
₹1,500 INR in 3 days
1.2
1.2

The logistics partner's feed will decide the timeline here, more than Meta or Google Ads. If it isn't a clean CSV or API, it needs a community connector or a Sheets staging layer, and blending SKU-level data directly in Looker gets slow and fragile. I've automated ad campaigns through the Yandex Direct API, with goal tracking and lead monitoring, though Looker Studio itself is new to me. What format does the logistics feed arrive in?
₹1,500 INR in 7 days
0.3
0.3

Hi, I can complete this with high accuracy. Proven pipeline: automated extraction (pdfplumber/camelot/ccxt-style parsers) plus row-by-row validation against source and manual QA, tested on 800+ page documents. Deliverable is a clean, ready-to-use file with data preserved exactly. I can send a sample page first. Free revisions until you're satisfied. Ready to start now.
₹1,080 INR in 3 days
0.0
0.0

Hi, I’d be happy to bring your scattered DTC data into one reliable, management-friendly Looker Studio workspace. I understand the goal is not just to create charts, but to give your team a clear daily view of sales, marketing, inventory, and customer behaviour in one place. I can structure the report with an executive overview and drill-down views for SKU, campaign, channel, and customer cohorts. The dashboard can be organized around daily/weekly/monthly sales, YoY and MoM comparisons, ROAS and CPA by paid channel, funnel performance, cohort/LTV trends, inventory levels, low-stock indicators, and order-to-delivery timelines. I can also configure the required connectors or scheduled data uploads for Google Analytics, Meta Ads, Google Ads, logistics data, and your inventory sheet. For custom metrics, I can set up calculated fields such as blended ROAS and inventory cover days, with clear documentation for future maintenance. I’ll also keep the layout responsive and focused on performance, usability, and the agreed refresh requirements. Best Regards Fatima
₹600 INR in 1 day
0.0
0.0

Hi, one Looker Studio workspace where sales, ads, inventory and delivery agree on the same numbers. Blended ROAS is where these go wrong, Meta and Google count a conversion differently. How we'd build it: everything lands in BigQuery first, Google Ads and GA4 through their native transfers, Meta through a scheduled pull, inventory off the Sheet, then Looker reads one modelled table so pages load fast. Do you want cohorts by first order month? Happy to start with the sales page so you can check the numbers first. Regards, Digitalizers
₹735 INR in 7 days
0.0
0.0

Hi, I can help build a clean D2C performance dashboard that brings sales, marketing, inventory and customer metrics into one easy-to-use reporting view. My approach would be to: • Structure and clean the available source data • Connect Google Sheets/CSV and available supported data sources • Build management-level KPI views for sales, marketing, inventory and customer behaviour • Create daily, weekly and monthly performance views • Add YoY/MoM comparisons where the required historical data is available • Build calculated metrics such as ROAS, CPA and inventory cover days • Add filters for SKU, campaign and other relevant dimensions • Create clear visualizations for customer cohorts and LTV trends • Configure the dashboard for scheduled data refresh where supported by the selected connectors • Provide documentation explaining the dashboard and how the data can be updated I have experience with data analysis, Excel, SQL, Python, Power BI and Tableau, and I focus on building dashboards that are clear and useful for business decision-making. Before building the complete dashboard, I would first review the available data sources and confirm the required fields and connector availability to ensure that all requested metrics can be calculated accurately. I can start immediately and target completion within 7 days. Regards, Varikuti Pruthvinath Reddy
₹1,050 INR in 7 days
0.0
0.0

Your acceptance test is the right one, and it's the one most setups will fail. Under 10 seconds with live connectors to GA4, Meta Ads and Google Ads isn't realistic. Every chart fires its own query to every source each time the page opens, and GA4's connector hits quota limits at exactly the hour management opens it, so the morning view comes up with broken charts. The fix is to stop querying live. Ad and analytics data gets landed on a schedule, as extracts or into BigQuery, where GA4 and Google Ads both export natively, and the report reads the prepared tables. The inventory sheet stays live, since Sheets is fast, and that's what keeps the inventory view current. Second, blended ROAS. Meta, Google Ads and GA4 each count conversions on their own attribution window, so one order gets claimed two or three times. Add up what the platforms report and ROAS comes out flattering and wrong. I'd take revenue from one source of truth, your store or GA4, and divide by total spend across channels. That's the number that should match your bank. Third, standard Looker Studio only emails reports on a timer, it doesn't fire on a threshold. Low-stock alerts need a small scheduled check on the inventory sheet. Easy, just not part of the dashboard itself. Which store platform are you on, and is GA4 already exporting to BigQuery? Ronak
₹1,500 INR in 7 days
0.0
0.0

Mumbai, India
Payment method verified
Member since Jun 19, 2015
₹600-1500 INR
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹600-1500 INR
$50-250 USD
£18-36 GBP / hour
$30-250 USD
₹750-1250 INR / hour
₹12500-37500 INR
₹1500-12500 INR
$30-250 USD
₹8000-12500 INR
₹1500-12500 INR
€30-250 EUR
₹750-1250 INR / hour
₹750-1250 INR / hour
$10-30 USD
$15-25 USD / hour
₹750-1250 INR / hour
€18-36 EUR / hour
₹600-1500 INR
₹600-1500 INR
₹750-1250 INR / hour
$250-750 USD