1001 Freelance Projects -- Looking for Google Looker Studio Expert to Develop BI Dashboard

Latest Projects from Freelance Marketplaces

Today is: 04-Apr-2025 17:58 GMT

View this project in detail (Note: you will be redirected to external marketplace)
Project title:	Looking for Google Looker Studio Expert to Develop BI Dashboard
Posted by:	External project from PeoplePerHour
Started:	12-Feb-2025 15:17 GMT
Description:	Job Overview: I am looking for a skilled Google Looker Studio expert to create a custom Business Intelligence (BI) dashboard to track and visualize key performance indicators (KPIs) for my Online Yoga & Pilates Lesson Planner and Card Deck business. My current tracking method is an outdated Excel spreadsheet, and I want a more automated, live-data-driven solution. The BI dashboard should integrate with WordPress (WP eMember membership plugin), WooCommerce, Google Analytics, Google Search Console, and other relevant tools while providing clear insights into my business performance. I will show you the excel spreadsheet I currently use (via screenshare), so you'll need to speak English. Key Responsibilities: Develop a Google Looker Studio dashboard that connects to live data sources, eliminating manual data entry. Integrate with WordPress (WP eMember for membership data), WooCommerce (online shop data), Google Analytics, and Google Search Console. Track SaaS metrics such as: New members Cancellations Renewals Churn rate Lifetime value (LTV) per member Active members Membership growth trends Gross and net income Track website performance, including: Live blog post list with keywords used Traffic per blog post Last updated date for each post Track WooCommerce KPIs such as: Total sales Income Conversion rates Top-performing products Automate membership renewal reminders (sent 7 days before renewal date) using Google Sheets + Zapier or other automation tools. Provide a section for logging business activities (e.g., blog updates, plugin installations, marketing actions, etc.). Generate visual reports and bar charts showing the frequency of business activities. Additional KPIs & Automation Ideas: SEO Performance Tracking: Connect to Google Search Console to monitor keyword rankings and traffic sources. Content Engagement Metrics: Measure time spent on blog pages and conversion rates from blog posts. Email Marketing Integration: Track email open rates and conversion rates from email campaigns. Customer Support Metrics: Track response time and number of support requests. Automation Ideas: Auto-generate reports on key metrics weekly/monthly in Looker Studio. Send automated Slack/email notifications for significant KPI changes. Implement AI-driven recommendations for content updates based on traffic patterns. Automate data syncing from WP eMember, WooCommerce, and Google Analytics into Google Sheets for smoother Looker Studio integration. Ideal Candidate: Extensive experience using Google Looker Studio to create custom dashboards. Strong knowledge of WordPress, WooCommerce, Google Analytics, Google Search Console, and data visualization. Ability to set up API connections and automation with tools like Zapier, Google Apps Script, or Make (Integromat). Prior experience working with small businesses or SaaS-based platforms. Ability to develop cost-effective solutions that fit within a small business budget. Budget & Timeline: As a small business owner, I have a limited budget, so I am looking for an affordable solution. Open to suggestions on using other BI tools with custom integration vs. building a solution from scratch. Looking for a solution that can be delivered within 1-2 months. If you have experience creating Google Looker Studio dashboards and can help me automate and visualize my business data, please apply with examples of how you've helped similar businesses like mine.
Project ID:	3421560
Project category:
Project budget:
View this project in detail (Note: you will be redirected to external marketplace)

Project	Started
London Based Architectural Designer	04-Apr-2025 15:52 GMT
Wordpress Speed Optimisation	04-Apr-2025 15:43 GMT
Logo rendering into 3 hr video - please read nfo before applying	04-Apr-2025 15:43 GMT
AI expert to import Word content on Wordpress ACF fields	04-Apr-2025 15:02 GMT
Tabulated PDF to Word conversion and Arabic/English translation	04-Apr-2025 14:54 GMT
Full-Day Training and Build of an AI Research Agent on 8/4/25	04-Apr-2025 14:54 GMT
Social Media Awareness for New UK Edu Platform (1 week, remote)	04-Apr-2025 14:41 GMT
Bookkeeping Assistant	04-Apr-2025 14:29 GMT
Skilled Customer Service Representative	04-Apr-2025 14:28 GMT
Functional Skills E-Course Content Writer	04-Apr-2025 14:25 GMT
Create advanced AI chatbot for reporting/BI and customer help	04-Apr-2025 13:59 GMT
Design a Google doc template	04-Apr-2025 13:59 GMT
Development of Prototype for Merchant Portfolio Risk Management	04-Apr-2025 13:58 GMT
I need someone to prepare engagement letters (ICAEW)	04-Apr-2025 13:24 GMT
Improve sound recording (2mins)	04-Apr-2025 13:24 GMT

Browse All Projects

Projects by Skills ...
Projects for 'android' Projects for 'ajax' Projects for 'asp' Projects for 'aspnet' Projects for 'cms' Projects for 'cpp' Projects for 'csharp' Projects for 'css' Projects for 'delphi' Projects for 'design' Projects for 'drupal'	Projects for 'excel' Projects for 'facebook' Projects for 'flash' Projects for 'html' Projects for 'java' Projects for 'javascript' Projects for 'joomla' Projects for 'iphone' Projects for 'mysql' Projects for 'photoshop' Projects for 'php' Projects for 'python'	Projects for 'ruby' Projects for 'seo' Projects for 'sql' Projects for 'sysadm' Projects for 'translate' Projects for 'typing' Projects for 'twitter' Projects for 'vbnet' Projects for 'xml' Projects for 'wordpress' Projects for 'writing'
Read RSS feeds ... New!
RSS feed for 'android' RSS feed for 'ajax' RSS feed for 'asp' RSS feed for 'aspnet' RSS feed for 'cms' RSS feed for 'cpp' RSS feed for 'csharp' RSS feed for 'css' RSS feed for 'delphi' RSS feed for 'design' RSS feed for 'drupal'	RSS feed for 'excel' RSS feed for 'facebook' RSS feed for 'flash' RSS feed for 'html' RSS feed for 'java' RSS feed for 'javascript' RSS feed for 'joomla' RSS feed for 'iphone' RSS feed for 'mysql' RSS feed for 'photoshop' RSS feed for 'php' RSS feed for 'python'	RSS feed for 'ruby' RSS feed for 'seo' RSS feed for 'sql' RSS feed for 'sysadm' RSS feed for 'translate' RSS feed for 'typing' RSS feed for 'twitter' RSS feed for 'vbnet' RSS feed for 'xml' RSS feed for 'wordpress' RSS feed for 'writing'

New!
Проекты на русском (Projects in Russian)	Short URL: 1001fp.com	Mobile version: m.1001freelanceprojects.com