SmartConnector™ Data Fields
When you set up or edit a SmartConnector™, you map and configure each field in your data source so that TapClicks interprets it correctly. After you upload a sample file, you select the type of data in each field from a list of field types.
Field Types
Number
- Can be used in system operations, such as sums and formulas
- Cannot be used for assigning
- Cannot be used as a date range
Decimal
- A number with two decimal places
- Can be used in system operations
- Cannot be used for assigning
- Cannot be used as a date range
Percent
- A number with a percent sign (%) and two decimal places
- Can be used in system operations
- Cannot be used for assigning
- Cannot be used as a date range
Currency
- A number used as currency
- Can be used in system operations
- Cannot be used for assigning
- Cannot be used as a date range
Text
- Stores and displays the field as a text string
- Cannot be used as a date range
Date
- Stores and displays the field as a date value
- Cannot be used for assigning
Link
- Stores clickable URLs
Thumbnail
- Cannot be used for assigning
- Cannot be used as a date range
ID
- Stores and displays the field as a text string
- Can be used as an assigning field and a unique field
- Cannot be used in system operations
- Cannot be used as a date range
Phone Number
- Stores and displays the field as a text string
- Can be used as an assigning field and a unique field
- Cannot be used in system operations
- Cannot be used as a date range
Duration
- Stores and displays the field as a time
- Cannot be used as an assigning field or a unique field
- Cannot be used in system operations
- Cannot be used as a date range
Call Recording URL
- Stores and displays the field as a playable recording
- Cannot be used as an assigning field or a unique field
Click to View URL
- Stores and displays the field as a click-to-view hyperlink
Field Settings
Is Metric?
- Select the Is Metric? check box to indicate that the field is a performance metric, such as impressions or clicks. Select this option for most fields.
- Do not select this option for values that do not change from day to day, such as a budget, an impressions target, or a campaign attribute.
Include in Charts?
- Select the Include in Charts? check box to include the metric as a row in the breakdown chart of the standard product and in the Report Generator chart.
Operation?
- From the Operation? dropdown menu, select the mathematical operation to apply to the field: Average, Average No Zeros, or Most Recent Value.
- Applies only to Number, Decimal, Percent, Currency, and Duration fields.