fullmetrixDocs

Looker Studio connector

Add the Fullmetrix connector in Looker Studio with an API key, then build dashboards on your sales, orders and customers.

Looker Studio, formerly called Data Studio, is Google's free tool for building dashboards. The Fullmetrix connector brings your sales figures into it. You then build your charts by dragging fields, and the data updates on its own, with no spreadsheet in between.

The connector is free. It reads your data in read-only mode and changes nothing in Fullmetrix or in your store.

Before you start

You need three things.

  • A connected and synchronized store in Fullmetrix.
  • A Google account to use Looker Studio.
  • A Fullmetrix API key, which you create in the first step.

Connect Looker Studio to Fullmetrix

Create an API key

In Fullmetrix, open Settings, then the API Keys tab. Click Create a key, name it "Looker Studio", then click Create a key. Copy the key shown, which starts with fmx_, then click Done. The key is shown only once. The details are in Public API.

Open the connector

Open this address in your browser while signed in to your Google account.

https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzWgdMkBN7-Ufga_npbaNYY5iyGQH_F4Q1vpbnJUsrklkvQ182-AHRkxFViK8iAZB7c6w

Looker Studio opens the creation of a data source with the Fullmetrix connector. It is listed as PrestaShop by Fullmetrix, but it reads stores from every platform connected to your organization.

Authorize the connector

On first use, Looker Studio asks permission to use the connector. Click the authorize button, pick your Google account, then accept. The connector asks for two rights, connecting to an external service, here Fullmetrix, and remembering your key.

Paste the API key

Looker Studio shows a field for the key. Paste your fmx_ key and confirm. The connector checks the key with Fullmetrix. Your organization is recognized automatically from the key.

Create the data source

Click the connect button at the top right. Looker Studio shows the list of Fullmetrix fields. Then click the create report button to start a dashboard.

Available fields

FieldTypeContent
DateDimensionThe order day
StoreDimensionThe store address
CountryDimensionThe billing country, or Unknown when missing
Customer typeDimensionnew for a new customer, returning for a customer who ordered before, anonymous for an order without a usable email address
OrdersMetricThe number of orders
Items soldMetricThe number of items sold
Gross salesMetricGross sales
Net revenueMetricNet revenue, calculated as in the Revenue report
TaxesMetricTotal taxes
ShippingMetricTotal shipping fees
New customersMetricCustomers who placed their first order during the period

Figures follow your Report settings, including excluded order statuses and net sales deductions.

Ratios are calculated in Looker Studio from these fields. For average order value, create a calculated field that divides Net revenue by Orders.

Build a first dashboard

Add a date range control

The connector needs a period for each chart. Add a date range control at the top of the report, so readers pick the period themselves.

Plot revenue by day

Add a time series chart. Set Date as the dimension, then Net revenue and Orders as metrics.

Add key figure cards

Add scorecards with Net revenue, Orders and New customers. Turn on the comparison with the previous period in the scorecard options to see the trend.

Break down by country or store

Add a table with Country or Store as the dimension and Net revenue as the metric, sorted in descending order.

Check your first figures against the Fullmetrix Revenue report over the same period.

Share the dashboard

Each person who opens the report must use their own Fullmetrix API key. The connector does not share your key with readers. Someone you share the report with therefore sees the key prompt the first time they open it.

To share the report with a colleague, ask them to create their own key in Fullmetrix, or create a dedicated one and send it to them through a secure channel.

Frequently asked questions

To get other metrics or build your own integration, use the public API directly.

On this page