If you don’t have the time to start from scratch and create your own customized Looker Studio report, this template from Data Bloo makes it easy to see where you stand in one dashboard.
It is a good Looker Studio use case concept that you can apply in your dashboards, and has some interesting KPIs as well.
With this template you can, among other things, analyze the performance of your keywords, view your page rankings on Google and monitor the current status of your Search Console KPIs with one click.
These templates are great for getting started, or for creating reports in a hurry. All you need to do is select the template that you want to use and then customize it to match your needs. It’s really that simple.
This dashboard provides a detailed, in-depth look at how users are engaging and interacting with your ECommerce store. This was the most complete example of an ECommerce management dashboard that we could find.
This Multi-Channel template can become your main marketing dashboard. Users will have a holistic view of their performance across various channels to make informed decisions and optimize their digital marketing strategies for maximum impact.
The template includes pre-built visualizations that allow you to easily monitor and analyze your search traffic, identify opportunities for improvement, and track the impact of your SEO efforts over time.
Want a year-on-year overview of SEO metrics by keyword analysis by brand vs. generic and page rankings? Get all that and an organic overview with this template.
Measuring the competition is one of the most critical reporting components of a PPC template. Databloo’s report offers insightful information about your competitors and you can easily find a summary of other brands that bid on the exact keywords.
Here’s the beautiful template by Data Bloo for your SEO needs. You can use it immediately simply by plugging in your data source.
Data Bloo provides a wide array of Looker Studio templates tailored for various industries and data visualization needs. I have to admit, their templates are visually appealing. Another plus, they are easy to customize, helping you convey complex data insights clearly and effectively.
The dashboard makes use of little touches that help bring it to life, like the color scheme and the images. It’s everything a Looker Studio dashboard should be – intuitive, creative, and most of all, helpful.
Data Bloo is both a pioneer and a leader in the Looker Studio templates niche. It perfectly combines data-driven insights with an attractive design that customers like.
Ensure you have the following ready:
On the “Connect WooCommerce Store” screen (as shown in your image):
https://yourstore.com)💡 How to generate your API credentials:
- Log in to your WooCommerce admin panel
- Navigate to WooCommerce → Settings → Advanced → REST API
- Click Add Key
- Give it a name, set Permissions to Read, and click Generate API Key
- Copy the Consumer Key and Consumer Secret
Click Connect Store to complete the connection.
Once connected, your Looker Studio dashboard will include metrics such as:
To manage multiple stores or refresh keys:
Your dashboard will now reflect the new configuration.
| Issue | Solution |
|---|---|
| Connection failed | Ensure the store URL is correct (HTTPS recommended) and that API keys are valid with “Read” access |
| No data in dashboard | Confirm that the store has recent orders/products and the API is enabled |
| OAuth window didn’t appear | Disable pop-up blockers and clear cookies. Ensure one Google session is active |
| Bad Request (400) | Make sure the same Google account is used across Data Bloo and Looker Studio |
| Multiple stores | Add each store separately using unique API keys; use filters in Looker Studio to separate or combine reports |
Total sales, Net sales, Gross Sales, Orders
Billing Email, Number of Customers, High and Low Spenders
Value, AOV, Items Sold
Shipping, Taxes, Refunds, Discounts
| WooCommerce Fields | Dimension / Metric | Field Type | Description |
|---|---|---|---|
| Avg. Order Value | Metric | Currency | The average monetary value of each order. |
| Avg. Orders Per Customer | Metric | Number | The average number of orders placed per customer. |
| Billing City | Dimension | Text | The city listed in the order’s billing address. |
| Billing Company | Dimension | Text | The company name listed in the order’s billing address. |
| Billing Country | Dimension | Country | The country listed in the order’s billing address. |
| Billing Email | Dimension | Text | The billing email address of the customer. |
| Billing Post Code | Dimension | Text | The postal code listed in the order’s billing address. |
| Billing State | Dimension | Text | The state or region listed in the order’s billing address. |
| Cart Tax | Metric | Currency | The amount of tax charged on the items in the shopping cart. |
| Coupon Code | Dimension | Text | The code used by the customer to apply a discount to the order. |
| Created Via | Dimension | Text | Specifies the method where the order originated, such as ‘checkout’ or ‘admin’. |
| Currency | Dimension | Text | Indicates the currency used for transactions. |
| Customer ID | Dimension | Text | A unique identifier WooCommerce assigns to each customer. |
| Customers | Metric | Number | The total number of unique customers. |
| Date Completed | Dimension | Date Hour Minute | The date and time when an order’s status changes to ‘Completed’. |
| Date Created | Dimension | Date Hour Minute | The date and time when an order was created. |
| Date Modified | Dimension | Date Hour Minute | The date and time when an order was last modified. |
| Date Paid | Dimension | Date Hour Minute | The date and time when an order’s status changes to ‘Paid’. |
| Discount Tax | Metric | Currency | The tax amount applied to any discounts given on an order. |
| Discount Total | Metric | Currency | The total amount of discounts applied to an order. |
| Gross Sales | Metric | Currency | Gross sales, calculated by adding order discounts and refunds to net sales. |
| Net Sales | Metric | Currency | Net sales, calculated by subtracting an order’s tax and shipping costs from the total sales. |
| Order ID | Dimension | Text | The unique identifier assigned by WooCommerce for an order. |
| Order Status | Dimension | Text | The current status of an order (e.g., pending, processing, completed, cancelled, refunded). |
| Order Number | Dimension | Text | The sequential number assigned to an order for identification and tracking. |
| Orders | Metric | Number | The total number of orders. |
| Payment Method | Dimension | Text | The method of payment used to complete an order (e.g., Credit Card, PayPal). |
| Product Name | Dimension | Text | The name of the product sold. |
| Quantity | Metric | Number | The total number of items sold. |
| Shipping City | Dimension | Text | The city listed in the order’s shipping address. |
| Shipping Company | Dimension | Text | The company name listed in the order’s shipping address, if applicable. |
| Shipping Country | Dimension | Country | The country listed in the order’s shipping address. |
| Shipping Post Code | Dimension | Text | The postal code listed in the order’s shipping address. |
| Shipping State | Dimension | Text | The state or region listed in the order’s shipping address. |
| Shipping Tax | Metric | Currency | The tax amount collected specifically for shipping on an order. |
| Shipping Total | Metric | Currency | The total cost charged for shipping. |
| Total Sales | Metric | Currency | The total amount of an order, including products, taxes, and shipping fees. |
| Total Tax | Metric | Currency | The total amount of tax applied to an order. |
| Total Refunds | Metric | Currency | The total amount of refunds. |
