![]() ![]() Each item you choose will display as a column in the data preview table. ![]() Tip: Columns represent the fields that are available for the data view you selected above. Under Columns, select the checkboxes beside the columns you want to include in your data feed.Applying filters here, at the query (source) level, rather than later at the query results level can improve efficiency and simplify data handling. Tip: APIs for some services include "StartDate" and "EndDate" as optional data view filters. Under Data view filters, add required filters (if needed) and optional filters (if desired).In the Choose data for your data feed page, under Data view, click the drop-down and choose the subset of data you want to query.You can apply filters to the data view and to columns in the left sidebar and in the data preview. This reduces the size of the query, improving performance and ensuring you only get the data you actually need. Tip: Use filtering to pinpoint the data you want to retrieve and include in your data feed. You’ll then choose from those columns to specify what data to include in your data feed. ![]() Using the data view you select, we’ll run a query to get a list of available columns (fields) from within the data view. Later, when you create custom metrics, you’ll choose which pieces of data from the data feed you want to display for each metric. In the query builder, you tell us what data you want to retrieve for your data feed. Choosing the data you want to retrieve in the query builder You're connected! Next step – choose the data you want to retrieve using the query builder. You can either select an alternate, existing account or click “Add new account”. If you want to connect to a different account, you can do so there by clicking the account connection at the top of the data preview window (see below). If you’ve connected to Airtable before, we assume you want to use the same account and take you directly to the next step - Choosing the data you want to retrieve in the query builder.Under Choose account settings, select the desired Airtable base from the drop-down list.Next, to further define the data you're looking for, under Select account settings, click Add account settings.Click Grant access to allow Klipfolio PowerMetrics to securely access your Airtable data.We recommend you select the "All current and future bases" option, as, if you add a specific base and want to add another one later, you'll need to update your account connection (token) to be able to select it as an option in PowerMetrics. Click +Add a base and either select All current and future bases in all current and future workspaces or a specific base.Enter your Airtable login credentials and click Sign in.If this is your first time connecting to Airtable:.On the Where is your data? page, select Airtable.In the left navigation sidebar, click the + button beside Data Feeds.To connect PowerMetrics to your Airtable data: If that happens to you, go here for help. If you have trouble accessing an existing connection, your OAuth token may have expired. You can use the same account connection every time you connect to Airtable. Go here for more information on managing your account connections. You can rename connections from your list of connections (accessed by clicking the in the left navigation sidebar and selecting Connections) or within the application as you create metrics. By default, your connection name looks like this: yourname. We are serious about protecting your data privacy. The first time you connect your Airtable data to PowerMetrics, you'll be prompted to enter your Airtable login credentials and give permission to allow access to the data within your Airtable account. The first step in creating an Airtable data feed is to connect PowerMetrics to your data. Refine the data in the data feed editor (optional).Ĭonnecting PowerMetrics to your Airtable data.Choose the data you want to retrieve in the query builder.Connect PowerMetrics to your Airtable data.Next steps - Creating Airtable custom metrics.When you're finished adding Airtable data feeds, you'll use them to power your custom metrics. Ready to get the most from your Airtable database-spreadsheet data? Get started by setting up a connection between PowerMetrics and your Airtable data and adding one (or more) data feeds. If you see Data Feeds in the left navigation sidebar, you’ll learn how to connect to your data and create data feeds in this article. We’re gradually releasing this new feature to our customers. Our recent redesign simplifies the data transfer experience by combining raw and modelled data sources into a single object - data feeds. ![]()
0 Comments
Leave a Reply. |