With PowerMetrics, you can connect to the data that matters most to you, whether it be on premise or in the cloud. From web services to files stored on your computer, servers, or in your data warehouse, we help you get the data you need to understand your business and help it grow. You can see a full list of the data sources Klipfolio PowerMetrics connects to on our Integrations page.
This article includes:
- What data services can I connect to?
- How do I connect to my data?
- Connecting to your data and adding instant metrics
- Connecting to your data and creating custom metrics
What data services can I connect to?
With PowerMetrics, you can connect to your data from many sources:
- Cloud applications:
Get data from all your essential cloud services. See a list of data services you can connect to using Klipfolio.
- Uploaded local files:
Connect to data in your local files. We support the following file types: XML, Excel, CSV, and JSON.
- Cloud file sharing services:
You can bring data into PowerMetrics from several cloud file sharing services, for example, Google Drive, Google BigQuery, Dropbox, Box, Microsoft OneDrive, and Microsoft SharePoint.
- Semantic layers and metric stores: Retrieve metrics directly from a semantic layer to instantly create a catalog of trusted, synchronized metrics. Learn how to import metrics from your dbt™ Semantic Layer project(s).
- REST/URL - Open Web Service Connections:
Our Data Services page lists services for which we have dedicated, built-in connectors, however, we’ve verified connections to over 400 services. If you can’t find the pre-built connector you’re looking for, you can still connect to services using our REST/URL connector. It connects to most APIs that use the REST protocol and one of these authentication methods (if authentication is required): Basic HTTP authentication, 2-Step authentication, API Key authentication, and OAuth authentication.
If you want to learn more, take a look at the video and articles below:
Video introduction to APIs
Guide to REST API data sources and data feeds
About JSON and XML data sources
- SQL databases:
Structured Query Language (SQL) is used to manipulate and extract information from an SQL database. PowerMetrics enables you to connect to an SQL database and execute an SQL query to retrieve information to create a data feed. Learn more.
Access data on your servers to build a data feed using our FTP/SFTP connector. Learn more.
How do I connect to my data?
This article includes general information on how to connect to your data. There are too many connection options to describe each of them in detail here. For example, you might want to connect to a service, like Facebook or Google Analytics, or to a database, or to a local file. For detailed information on how to connect to all kinds of data, refer to this section of our Knowledge Base
Connecting to your data and adding instant metrics
Connecting to your data with instant metrics is fast! All you need to do is select a service, sign into your account, and choose the instant metrics you’re interested in. You can add instant metrics for many popular services. Go here for more detailed information on connecting to your data for instant metrics.
Connecting to your data and creating custom metrics
When you connect to your data for custom metrics, you create data feeds. Data feeds connect the source data from your files, databases, applications, and services to your custom metrics. Learn more about data feeds.
The method for connecting to your data and creating data feeds for custom metrics depends on the data service you choose.
Some data services, for example, Google Analytics and HubSpot, support both instant and custom metrics. For those data services, you'll connect to your data by signing into your service account, choosing the data you want to retrieve (in the query builder), and modifying the data (if needed) in the data feed editor. Once the data feed has been created, you can use it to build custom metrics.
For services that don’t include instant metrics (only custom metrics), for example, file upload and REST/URL, the method used to connect to your data and create data feeds is slightly different (and varies according to the service).