Adding Calculated Fields in a Blended Connector - Understanding Their Behavior

This guide will help you understand how to add and configure calculated fields to enhance your data analysis capabilities.

The Calculated Fields feature in Dataslayer's Blended Connectors is a powerful tool that allows you to create custom metrics and dimensions using existing data.

Accessing the Calculated Fields Pop-Up

To access this functionality, click the Calculated Fields button in the Blended Connectors interface. This action opens a pop-up window where you can define new calculated fields or edit existing ones.

Adding a Calculated Field

Click the + Add Calculated Field button located on the left side of the pop-up. This action creates a new calculated field entry.
In the Name field, enter a descriptive name for your calculated field. This name will help you identify the field in your analyses.
Choose the type of calculated field you are creating from the Type dropdown menu. The available types include "Metric" and "Dimension".
In the Formula field, input the formula for your calculated field. You can use existing metrics and dimensions from your data sources, as well as standard mathematical functions and operators.
For example, to sum the costs from Google Ads and Facebook Ads, you could use the formula:

Cost (Google Ads) + Total Cost (Facebook)

Meanwhile you are entering your formula, a green check mark will indicate that the formula is valid. If there is an error in the formula, a red cross mark will appear, prompting you to correct the formula.

You can find a comprehensive list of all the formulas supported by calculated fields, along with their descriptions, by following this link!

After writing and validating your formula, click the Confirm Changes button to save the calculated field. This action will add a new field to your blended connector, making it available for use in your queries.

Bear in mind that the metrics and dimensions available in the calculated fields will be limited to those previously selected in the Blended Connector tables - not all the ones available from the connector itself.

If you need a formula that we don't currently have, please contact us via live chat or e-mail. We will evaluate its complexity to determine if it can be added.

Understanding the Behavior of Calculated Fields

Calculated fields in Dataslayer Blended Connectors allow for dynamic and flexible data manipulation. Here are a few key behaviors to understand:

Dynamic Updates: Calculated fields are dynamically updated based on the data from the connected sources. Any changes in the underlying data will be reflected in the calculated fields.
Data Integrity: The integrity of the data is maintained through validation checks on the formulas. This ensures that only correct and meaningful calculations are added to your dataset.
Versatility: You can create a wide range of calculated fields, from simple sums and averages to more complex calculations involving multiple parameters and functions. This versatility enables more insightful and comprehensive data analysis.
Real-Time Calculation: Calculated fields are computed in real-time, providing up-to-date metrics and dimensions that reflect the current state of your data sources.

By effectively using calculated fields in the Blended Connectors, you can enhance your data analysis, uncover deeper insights, and make more informed decisions based on a customized view of your data.

As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!