What are Smart Connector Data Fields?
When setting up or editing a Smart Connector, you will need to map and configure each field in your data source so it is interpreted correctly by TapClicks. After you upload a sample file, you will be asked to indicate what type of data is in each field. You will have a number of field types to choose from.
Field Types
Number
-
Used for operations in TapClicks like sums and formulas
-
Cannot be used for assigning
-
Cannot be used as date range
Decimal
-
A floating point number with two decimals
-
Can be used in system operations
-
Cannot be used for assigning
-
Cannot be used as date range
Percent
-
A number with a % and two decimals
-
Can be used in system operations
-
Cannot be used for assigning
-
Cannot be used as date range
Currency
-
A number used as currency
-
Can be used in system operations
-
Cannot be used for assigning
-
Cannot be used as date range
Text
-
Stores and displays the field as a text string
-
Cannot be used as date range
Date
-
Stores and displays the field as a date value
-
Cannot be used for assigning
URL
-
Stores clickable URL links
Image
-
Cannot be used for assigning
-
Cannot be used as date range
Is Metric?
- This is a field that is used to indicate if a value is a performance metric, like Impressions or clicks. Most of the time, you’ll want to select this.
- The case where you would not use this designation is for something that doesn’t change from day to day like a budget, impressions targeted value or an attribute on a campaign.
Include in Charts?
- If you check this box, the metric will be part of the row will be part of the breakdown chart in the standard product and part of the Report Generator chart.
Operation?
- The mathematical operator to apply to the field.
- Choices are 1) average, 2) average no zeros and 3) most recent value.
- Can only apply to a number, decimal, percent or currency field.