Visualize your Nimbata call data in Looker Studio

However, you can still build rich Looker Studio dashboards by first sending your call data to:

• Google Sheets, or
• Google Analytics 4 (GA4)

and then using those as data sources inside Looker Studio.

What you can do with Looker Studio + Nimbata

Things you can do when using Looker Studio with Nimbata data include:

• View call performance alongside web and campaign metrics (sessions, clicks, conversions).
• Build custom reports and dashboards for your team or clients.
• Analyze which sources, campaigns, and keywords drive not just more calls, but better-quality leads.
• Create a “marketing data lake” by combining call data with other sources in one place.

Available connection methods

You can connect Nimbata data to Looker Studio using one of the following methods:

1. Google Sheets > Looker Studio (Most flexible)

Nimbata can automatically push detailed call logs to a Google Sheet. That Sheet can then act as the 'repository' for Looker Studio or any other reporting platform.

2. Google Analytics 4 > Looker Studio (Best for performance dashboards)

Nimbata sends call events to GA4. You then connect your GA4 property to Looker Studio and use those events in your reports.

You can use either method or even both, depending on your reporting needs.

Method 1. Use Google Sheets as your Looker Studio data source

What the Google Sheets integration does

The Google Sheets integration lets Nimbata push your inbound call activity to a Google Sheet and keep it updated as new phone leads arrive. You can then use that spreadsheet as the source for Looker Studio dashboards.

You can, for example:

• Automatically collect and store call-tracking data in Sheets.
• Share call data with clients or teammates and allow them to add extra info in additional columns.
• Choose from many predefined properties or custom ones to include exactly the columns you need.

Set up the Google Sheets integration in Nimbata

OR follow these steps to connect Nimbata to Google Sheets:

Step 1. Go to Integrations > Google Sheets

In Nimbata, navigate to Integrations > Google Sheets and click “Sign in with Google”.

Step 2. Authorize Nimbata

Select the Google account you want to use. Google will show you the access Nimbata needs to create and edit Sheets. Click “Continue” and then “Allow” to proceed.

If the connection is successful, you will see a confirmation message.

Step 3. Select your Trigger

In the Trigger field, either:

• Use the default “After Every Call”, or
• Click the Trigger field and choose “Create Trigger” to filter which calls you send to Sheets (e.g. only calls tagged “Sales”).

Step 4. Choose the Drive folder and Sheet

Click “Select Drive Folder” and pick the folder where Nimbata should create or update your Sheet.

Then either:

• Enter a new file name (Nimbata will create it), or
• Choose an existing Sheet from the list.

You can also choose whether new rows will be added at the top or the bottom of the Sheet.

Step 5. Select the fields you want to send

From the list of available fields (caller details, source, campaign, duration, tags, etc.), select the ones you want to push to the Sheet and drag them into the order you prefer.

Step 6. Link the integration

Click “Link” to activate the connection.

• If everything is set up correctly, you’ll see a success message.
• If not, Nimbata will display an error explaining what went wrong.
• If you later want to change the list or order of fields, you should unlink the connection first, adjust the fields, and then link it again.

You can also send a test event from Nimbata to confirm that data is arriving correctly in the Sheet.

Connect your Google Sheet to Looker Studio

Once your Sheet is being populated by Nimbata:

Step 7. Add the Sheet as a data source in Looker Studio

1. Open Looker Studio and click Create > Report (or open an existing report).
2. Choose Google Sheets as your connector.
3. Select the spreadsheet and worksheet/tab that Nimbata is updating.
4. Click “Add” to create the data source, then “Add to report”.

You can now build charts and tables using fields such as:

• Call date & time
• Caller number
• Tracking number / project
• Source / medium / campaign
• Call duration
• Call tags and custom properties

Method 2. Use GA4 as your Looker Studio data source

What the GA4 integration does

The GA4 integration allows Nimbata to send events to your GA4 property every time a call is placed. This lets you see calls in Analytics alongside sessions, conversions, and other behavioral data. You can then use GA4 as a native data source in Looker Studio.

Set up the GA4 integration in Nimbata

OR follow these steps to connect Nimbata to Google Analytics 4:

Step 1. Go to Integrations > Google Analytics

In Nimbata, open Integrations > Google Analytics.

Make sure you are editing the correct project, since the integration is set up per project.

Step 2. Add your GA4 Measurement ID and API secret

In your GA4 property:

1. Go to Admin > Data collection and modification > Data Streams.
2. Open the relevant web data stream.
3. Copy your Measurement ID.
4. Under Measurement Protocol API secrets, create or locate your API secret.

Paste both values into the corresponding fields in Nimbata.

Step 3. Choose your trigger and events

Select the default trigger “After Every Call” to send all calls as events to GA4, or create a custom trigger (e.g. only answered calls from first-time callers).

Optionally, you can:

• Add additional parameters (such as start time or call tags).
• Configure multiple events (e.g. “All Calls”, “Answered Calls”, “First-time Callers”) with different triggers.

Once this is saved, Nimbata will start sending events to GA4.

Connect your GA4 property to Looker Studio

Step 4. Use GA4 as a data source in Looker Studio

1. In Looker Studio, click Create > Report.
2. Choose Google Analytics as the connector.
3. Select your GA4 property connected to Nimbata.
4. Click “Add” and then “Add to report”.

You will now see your Nimbata call events as part of the GA4 data model and can use them in any chart or table.

Which method should I choose?

Use Google Sheets > Looker Studio if you need:

• Very detailed, column-level call data.
• The ability to manually adjust or enrich data in the Sheet.
• Separate Sheets/tabs per client or project for agency reporting.

Use GA4 > Looker Studio if you want:

• Calls as part of a unified analytics view with sessions, conversions, and other events.
• Standard performance dashboards (e.g. which campaigns drive calls and online conversions together).

You can also combine both methods if your reporting needs vary by stakeholder.

And you're all set!

Updated on: 03/12/2025