Looker Studio from scratch using Datanable

Datanable lets you create Looker Studio dashboards from templates with just one click and no setup required. Unlike other solutions that can be time-consuming and frustrating, Datanable provides a simple, seamless experience for instant, tailored data visualizations.

However, if you wish to create a Looker Studio dashboard from scratch, please refer to the following documentation.

Prerequisites

Prerequisites:

1. You must have at least one active connection with an "OK" status.
2. You must have performed a Google Data Share to ensure your data is shared with your Google account and available in Looker Studio.

1. Create a new Report

Go to Looker Studio and either create a new report or open an existing one.

2. Connect to BigQuery

1. Click the "Add Data" button in the menu bar.
2. Click on BigQuery.
3. Navigate to "My Projects" and locate datanable-cloud. (If you don't see datanable-cloud and you've just completed a Google Data Share, immediate access to the data may not be available. It can take up to 15 minutes for Google to grant access to the shared data.)
4. Select the source you wish to use, such as meta_ads__{your_organization_id}.
5. Select a specific table, for example, meta_ads__ad_daily, to access your daily ad insights.
6. Click "Add" to integrate the data.

Repeat this process to add all the tables you wish to include.

3. Calculated fields

You will potentially need to add calculated fields for dynamic metrics such as CPM or CTR.

1. On the right side, click on "Data". A "Data" menu will appear with all the tables you have connected.
2. Click on the BigQuery logo next to the table you wish to edit.
3. Once the new menu opens, click on "Add a field", then select "Add calculated field".
4. You can then create a calculated field. For example the CPM for Meta Ads, using the formula: (sum(spend) / sum(impressions)) * 1000

4. Create dashboards

Final step: Enjoy creating lightning-fast dashboards!