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. |
