This guide contains all permissions and requirements for connecting your Piano Analytics (AT Internet) 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 Piano Analytics (AT Internet) connector, you must get your site ID as well as an access key and secret key.
- Log in to Piano Analytics (AT Internet).
- Open the Data Query feature.
- Select the “Site ID” as the row and “Visits” as the column.
- Click the arrow on the right side to launch the query.
- Your site ID should now be visible in the table. Copy and save this number.
- If you have multiple sites that you want to report for, copy and save each one.
- In "Piano Analytics (AT Internet)", go to your profile page.
- Select the API Keys tab.
- Select Create a new API Key.
- Give any name for this key, for example, “Supermetrics”.
- Click Create a new API Key.
- Copy the access key and secret key to a safe place.
- Click OK.
Query types
If prompted, you need to select a query type to pull data.
- Performance report: Analytics data for your website, including metrics for acquisition and on-site behavior.
Connection instructions
When connecting to Piano Analytics (AT Internet), you need to provide the site ID, access key, and secret key.
- Select the Piano Analytics (AT Internet) data source on the Supermetrics Hub or in the data destination.
- Enter the site ID that you want to report for. You can enter one site as “12345”, or multiple sites separated by commas: “12345,56342,23444”.
- Enter your access key and secret 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 Piano Analytics (AT Internet) 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