Before you begin: This user guide details the steps for setting up a Smart Connector using the manual upload delivery type, which is a type of basic connection.
Data Source and View Settings
1] On the left side menu click Data.
2] Click Smart Connectors. You're taken to the Smart Connectors list.
3] In the upper right, click the "+" to add a Smart Connector.
4] On the New Smart Connector page, enter a name for your Smart Connector in the Name textbox. This is effectively the name of the data source, so make it memorable and relevant to the data you are adding.
5] Enter a drilldown name for the Smart Connector in the Drilldown / view name textbox.
NOTE: The drilldown / view name will be the name of the data view you are creating. A data view is the same thing as a table in a database. You can read more about data views here: What is a Data View? |
6] Slide the Is active? control to the right to ensure the Smart Connector is turned on after you save it. You can change this later if needed.
Manage Connection
7] From the Delivery type dropdown menu, choose Manual Upload.
Additional Features
8] Choose the following optional features by sliding the control to the right.
- Map this SC to a single client?
- Use Geo Data? (By request only and may not be available for all accounts.)
- Use pre-process function?
- Use Email Service?
- Data does not contain Dates?
- Use JSON Parsing Settings?
- Use Tab Parsing?
NOTE: If you are uploading a JSON file, the system will automatically recognize the format, regardless of what delivery type you use. However, if you want to only pull a subset of a JSON file, you should slide the Use JSON File Config? slider to the on position. This will enable you to specify one or more arrays, subarrays, or objects from a JSON file to pull into TapClicks while ignoring the rest. Learn more about the Use JSON File Config settings in this article. |
Data Fields
9] To provide sample data to TapClicks, click the Select Sample File button on the far right.
NOTE: The following file formats are allowed:
|
10] Navigate to the file on your local machine and click Open.
11] Click Upload.
12] The parsed data appears in the Data Fields section.
13] TapClicks does its best to guess the field type for each field. In the event that it's wrong, you can change the field type using the Field type dropdown menu.
14] Check the Is metric? checkbox when that field that should be used as a performance metric.
15] Check the Include in charts? checkbox if the performance metric specified above is to be used in the row breakdown chart and part of the Report Generator chart.
16] For fields that have field type = number, you will be given a choice of which operation to apply to the numbers in that field. Choose the applicable operation from the Operation? dropdown menu. The operation must be set for all metric-based field types (i.e., number, decimal, percent, currency).
17] To remove an unwanted field, click the trash can icon on the far right.
18] Choose which field to use as the date from the Date field dropdown menu.
19] Choose which field to use for client assignment from the Assignment dropdown menu. Typically this is the Campaign name or Client name.
20] Choose one or more unique fields from the Unique Fields dropdown menu. If you're not sure how to choose unique fields, see this article here.
21] You can remove a unique field by clicking the "x" in the upper right corner.
22] If you have a currency field and would like to use it for a margin rule, select it from the Use for margin dropdown menu.
23] From the Load sample data? dropdown menu, choose Yes. This is recommended if you’d like to use your sample file in your reporting.
24] If your data has footer rows you want TapClicks to ignore, enter the number of footer rows to skip in the # Footer rows to skip textbox.
25] At the bottom of the page, click the Save Changes button.
Smart Connector Sublevels
You may have the option to set up sublevels in your Smart Connector. To learn more about sublevels, see this article here.
Managing and Deleting Files
1] Click the three-dot icon located on the far right of the Smart Connector you want to manage or delete files for.
2] From the dropdown menu, select Manage uploaded files.
3] The Manage Files page appears. Here, you can:
- View all files imported into TapClicks using this Smart Connector.
- Download files to review their data.
- Delete files as needed.
4] Use the search box or scroll to locate the desired file.
5] To download a file, click the Download icon located to the right of the desired file.
6] To delete a file, click the Trash can icon located on the far right of the desired file.