Dashboards

Dashboards in Weavely offer powerful functionality by leveraging data sets already exported to BigQuery and creating custom views. These views allow you to analyze data across channels and gain deeper insights from your marketing data.

Overview of Dashboards

Dashboards allow you to create specialized views in BigQuery by combining or transforming data from various data sets. This includes:

• Cross-channel reports that bring together data from Google, Facebook, and Microsoft into a single table for consolidated reporting.

• Ngram reports for Google Ads search terms, performing an Ngram analysis to help you understand common patterns and phrases in search queries.

Setting Up a Dashboard

1. Go to the Dashboards section in Weavely.

2. Choose a dashboard to activate. Each dashboard lists:

   • Required Connections: Integrations that need to be enabled, such as Google Ads.

   • Required Tables: Data tables necessary for the dashboard to function (e.g., Google Ads search terms).

   • Dimensions and Metrics: Outputs generated by the dashboard.

3. Once activated, the dashboard will create a corresponding view in BigQuery.

Viewing and Utilizing the Dashboard in BigQuery

1. Navigate to BigQuery and locate the Weavely dashboard section.

2. You’ll see views for the enabled dashboards, such as the Ngram report.

3. You can view the schema and inspect the query powering the report to understand the data being analyzed.

Creating Reports with Looker Studio

To make reporting even easier, Weavely provides Looker Studio templates that align with the dashboard schemas:

1. Open the provided Looker Studio template for the selected dashboard (e.g., the Ngram report).

2. To use your data, make a copy of the template.

3. In your copy, select Create a new data source and connect it to BigQuery by:

   • Navigating to your BigQuery project.

   • Selecting the relevant Weavely dashboard dataset (e.g., Ngram report).

4. This will link the Looker Studio report to your data, enabling you to customize the report’s appearance, add filters, and make it your own.

With this setup, you have a ready-to-use report, complete with Weavely’s schema, and the freedom to customize it further. This makes it easy to start analyzing and visualizing your data with minimal setup.

Your dashboard in Weavely is now ready to use in Looker Studio and BigQuery, allowing you to extract powerful insights across multiple data channels.