This guide contains all permissions and requirements for connecting your Adobe Commerce (Magento 2) data to Supermetrics.
You can connect to data sources from the Data sources page on the Supermetrics Hub. On the Hub, you can also share an authentication link to connect to a data source you don't have direct access to.
After you connect to the data source on the Hub, you can use the data source connection in all available destinations.
Required permissions
Before using the Adobe Commerce (Magento 2) connector, you need to generate API credentials in your store admin page.
To get your API credentials:
- In the Magento admin panel, go to System → Integrations and select Add new integration.
- Enter a name for the integration, for example, "Supermetrics", and enter your password. You can ignore the other fields.
- Under Basic Settings on the left-hand side, select API and give the integration access to the following resources:
- Sales > Operations > Orders > Actions > View
- Customers > All Customers
- Stores > Settings > All Stores
- Click Save.
- In the list of integrations, click Activate for the new integration and click Allow.
- Copy the generated credentials (consumer key, consumer secret, access token, access token secret).
Query types
Query types define what sort of metrics and dimensions are available. You need to select one of the following query types when pulling data:
- Orders: Fetch order-level data and metrics from your store.
- Order items: Fetch item-level data and metrics from orders in your store.
- Customers: Fetch details of all customers registered in your store.
Connection instructions
When connecting to Adobe Commerce (Magento 2), you need to provide your API credentials.
- Select the Adobe Commerce (Magento 2) data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Enter a name for your account to identify the login later in case you have multiple accounts.
- Enter the API credentials.
- Click Start.
- In your data destination, select the stores to include in your query and a query type to use.
See detailed instructions on how to connect to a data source from the Supermetrics Hub.
You can also connect to Adobe Commerce (Magento 2) from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer