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
Link
-
Stores clickable URL links
Thumbnail
-
Cannot be used for assigning
-
Cannot be used as date range
ID
- Stores and displays the field as a text string
- Can be used as Assigning and Unique field
- Cannot be used as date range
- Cannot be used in system operations
Phone Number
- Stores and displays the field as a text string
- Can be used as Assigning and Unique field
- Cannot be used as date range
- Cannot be used in system operations
Duration
- Stores and displays the field as a time
- Cannot be used as Assigning or Unique field
- Cannot be used as a date range
- Cannot be used in system operations
Call Recording URL
- Stores and displays the field as a playable recording
- Cannot be used as Assigning or Unique field
Click to View URL
- Stores and displays the field as click-to-view hyperlink
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 in the breakdown chart of 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, currency, or duration field.