System updates
Get started
Connect data
Build reports
Data sources
Access and permissions
- Reauthentication
  - How to reauthenticate a data source connection in Google Sheets, Looker Studio, Excel, Power BI, and Supermetrics Hub
  - How to reauthenticate a data source connection in data warehouse destinations, or the Supermetrics API
- Authentication troubleshooting
Manage teams
Google Sheets
Looker Studio
Excel
Data warehouses and cloud storage
- Set up Supermetrics for data warehouses and cloud storage
- Prerequisites and configuration for data warehouse and data lake destinations
  - AlloyDB
  - Amazon S3
  - Azure SQL Database
  - Azure Storage
  - Azure Synapse
  - BigQuery
  - Google Cloud Storage
  - Redshift
  - Snowflake
  - SFTP servers
  - BigQuery (marketplace)
- Transfers
- Monitoring
  - How to monitor your data warehouse transfers on the Supermetrics Hub
  - How to monitor your BigQuery (marketplace) data transfers
- Table Manager
- Data integrations troubleshooting
  - How to refresh account list in data warehouse destinations and Query Manager (API)
  - How to fix the “Confirm logout: Cannot execute query” error
Supermetrics Storage
- Using Supermetrics Storage
Power BI
- Set up Supermetrics for Power BI
- Using Supermetrics in Power BI
  - How to add images to Power BI reports
  - How to customize data loaded to your Power BI report
- Power BI troubleshooting
The Supermetrics API and Query Manager
- Using the Supermetrics API
Collaborative work management tools
- Set up Supermetrics for monday.com
Transform data
- Data blending
- Custom fields

Bambuser connection guide

Supermetrics Support Site Team

Modified on: Thu, 20 Jun, 2024 at 8:42 AM

This guide contains all permissions and requirements for connecting your Bambuser 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

To connect Supermetrics to your Bambuser account, you need your Bambuser base URL and a copy of your API key.

Get your base URL

Log in to Bambuser, and open your dashboard.
Take a look at the URL in your address bar.
- If the URL begins with lcx.bambuser.com/, your base URL is:
  https://liveshopping-api.bambuser.com/v1.
- If the URL begins with lcx-eu.bambuser.com/, your base URL is:
  https://liveshopping-api-eu.bambuser.com/v1.

Get your API key

To get the API key, contact Bambuser support. Ask for an API key with READ_STATS and READ_SHOW scopes. Learn more in Bambuser's documentation.
Log in to Bambuser, and open your dashboard.
On the left-hand side, click Settings.
Under Settings, click Integrations.
Select API keys.
Find the API key you want to copy, and click Copy. Store this in a secure place. If you don't see an API key here, contact Bambuser support.

Connection instructions

When connecting to Bambuser, you need to provide your base URL and API key.

Select the Bambuser data source on the Supermetrics Hub or in the data destination.
Enter the base URL and API key.
Give your login a name to recognize the login later in case you have multiple logins.
If prompted, choose to make this connection shared or private.
Click Start.

See detailed instructions on how to connect to a data source from the Supermetrics Hub.

You can also connect to Bambuser 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

More resources