A dashboard needs to be created in Looker Studio.

Databases & SQL — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Create a dashboard for monitoring and analyzing the performance of the company's location network (branches) in Google Business Profile (GBP) through the official Google Business Profile API.

Process via a script based on Google Apps Script (link to Google Sheets).

Record data in Google Sheets (which serves as a database for Looker Studio).

Update: Daily (with an indication of the last update date). Create a Google Cloud service account.

The script runs once a day (trigger at 03:00 AM) and sends a request to the GBP API.

It retrieves metrics for the previous day for each location (locationId).

Records data in a flat format (row = unique combination of Date + Branch ID + Metrics).

Key Performance Indicator Cards

Card Name	GBP Metric	Dynamic Format
Profile Views	Impressions (Search + Maps)	Percentage %, Sparkline (blue)
Calls	Local Services Phone Calls	Percentage %, Sparkline (green)
Website Clicks	Website Clicks	Percentage %, Sparkline (purple)
Direction Requests	Direction Requests	Percentage %, Sparkline (orange)
Average Rating	Average Review Rating	Absolute change (e.g., +0.1), Sparkline (yellow)
New Reviews	New Reviews Count	Percentage %, Sparkline (turquoise)

Proposals 11 Discussions

Serhii Valko

30 0

Budget: 5000 UAH Deadline: 5 days

The task is to automatically collect metrics from Google Business Profile for each branch, compile them into Google Sheets, and build a live dashboard in Looker Studio.

Here’s how I will do it: a Google Cloud service account with OAuth2 connects to the GBP API (mybusiness/v4 or Business Profile Performance API), an Apps Script trigger at 03:00 daily pulls metrics for yesterday for each locationId and writes rows in Sheets in the format Date + LocationId + all 6 metrics. Looker Studio connects to this table as a data source, where for each card I create a Scorecard comparing to the previous period and a Sparkline through Time Series with color coding according to the specifications. The date of the last update is displayed as a separate field with MAX(Date).

How many locations are in the network, and is there already a Google Cloud service account, or are we starting from scratch?

Andriy Koval

0 0

Projects -
Rating -
Rating 282

Budget: 8500 UAH Deadline: 6 days

1. Set up Google Cloud and Service Account to work with the Google Business Profile API.

2. Implement a Google Apps Script that will automatically retrieve statistics for all locations daily and record them in Google Sheets.

3. Build a Looker Studio dashboard with KPI cards, sparklines, date and location filters, and an indication of the last update.

I noticed that the most important point is to correctly configure access to the Google Business Profile API and the structure of the table to avoid issues with automatic updates and scaling in the future.

I already have examples of dashboards in my profile, so I understand well how to build user-friendly analytics and organize data for Looker Studio.

If the Google Business Profile is already set up and there is access to the account, we can discuss the details and immediately move on to implementation.

Oleg N.

53 0

Budget: 3000 UAH Deadline: 3 days

Hello! I am ready to complete your task, I have experience working on similar projects.

Demyan N.

11 0

Budget: 3500 UAH Deadline: 3 days

Good day. I have reviewed the specifications. This is quite close to the tasks I have recently completed. I have worked with Looker Studio, Google Analytics, Google Ads, and dashboards with KPIs, so I understand how to properly organize data and create convenient visualizations. I will be able to implement all necessary metric cards, dynamics, and reporting. If needed, I can also suggest a few improvements for usability. I am ready to discuss the details.

Roman S.

2 0

Projects -
Rating -
Rating 472

Budget: 8000 UAH Deadline: 5 days

Hello! I have experience working with Google Apps Script and API integration, including the Google Business Profile API. I am ready to implement automated data collection for you: I will set up a service account, write a script for daily metric exports to Google Sheets, and connect it to Looker Studio for visualization. I have experience with flat data structures for accurate representation of dynamics and sparklines. I am ready to discuss the details, feel free to write.