This document contains frequently asked questions that arise when working with SmartConnectors™ in TapClicks. You can quickly navigate to a particular FAQ by using the table of contents below.
General FAQs
How do I use SmartConnectors™?
How do I download an assignment file for a SmartConnector™?
Defining a SmartConnector™
Can I upload my own icon for a SmartConnector™?
What characters are accepted in service names?
Are there any best practices for my sample file?
What happens if I do not fill in the second row of the sample file?
Why is there a limit on the sample file size?
Is there a limit on query size for database delivery types?
Do you actually pull in data from the sample file?
What is a defined pick-up location?
What happens after I load my sample file?
My sample file column headers look wrong. What should I do?
What characters are accepted in column labels?
What are the available field types?
How do I use the Assignment field?
What if I have a lifetime data set?
What if I want to load data that represents an entire month (or an entire week)?
Can you explain "Include in Charts"?
What are the Operation dropdown menus?
The SmartConnector™ wants me to apply an operation to an ID field from my file. Do I have to?
I have a number field but I cannot apply an operation. What is happening?
Can you set up an FTP or SFTP for me?
What about a Google Drive, Dropbox, or Amazon S3 Bucket? Can you set up one of those for me?
What file types are supported?
Where is the Manual Upload button?
How do I delete a manually uploaded file?
What date formats are supported within the body of my data file?
I prefer not to use dashes. What are my options?
If I include a timestamp in my date format, will it be stored in the database?
What time zone do my manual files use on the dashboard?
What is margin and why would I use it?
How does "Footer rows to skip" work?
Why can I not indicate how many header rows to skip on my file?
I made a mistake in my data file. Can I fix it?
What can be changed after data starts loading?
If I change the operation type, how will that impact my data?
What if I need to change an item that cannot be modified?
When I delete all the data, will my previous data reload itself?
How do I use "Delete all data"?
What does the "Delete assignments as well" toggle do when I click "Delete all data"?
Why is the "Delete all data" option not visible?
After I define a new SmartConnector™, what is next?
What if I need to change my file delivery type after I have loaded the data?
Connecting to Data
Do I really have to assign data to clients?
Where does the list of assignments come from for a SmartConnector™?
Does TapClicks provide IP address ranges for FTP/SFTP allowlisting?
Processing Data
How far back does the SmartConnector™ pull data?
How many days of data will load each day for the SmartConnector™?
How does the SmartConnector™ process my files by date?
What happens if my file does not have a date in the name?
If I am processing data by date, does it matter where in the file name the date information appears?
Can I pull in data from multiple tabs?
Are there any restrictions on what name I give to a file?
Are there any limits on file size?
Are there any limits on how much data overall a given SmartConnector™ can process?
How does the SmartConnector™ process my data?
If I change the order of the columns in the files I upload, will my SmartConnector™ still work?
What happens if some of the columns in my file are empty?
What do I do if I do not want that 0000-00-00 value to show up on my reports?
What if I only want to add data rows to a single file? How can I get that data into the platform?
What happens if I switch from a hosted delivery type to a manual upload?
What is the best practice when changing delivery types?
Can SmartConnectors™ process a ZIP file?
Can a SmartConnector™ process an image in a CSV?
Can an email SmartConnector™ process data from a URL link in an email instead of a file attachment?
Can an email SmartConnector™ process data if there are multiple links?
Why am I getting emails about duplicate rows?
Displaying Data
Why do I not see any data in my dashboard?
My averages do not look right. What is happening?
General FAQs
What is a SmartConnector™?
A SmartConnector™ is a tool that imports data into TapClicks from a wide range of data sources and file formats. While TapClicks offers native integrations with hundreds of applications, you can create a SmartConnector™ to import data from any source and use it for reporting and analysis.
The most common use cases for SmartConnectors™ are uploading CSV files manually or retrieving data from Google Drive or Google Sheets. However, a SmartConnector™ can import data from virtually any source and can read the most commonly used file formats.
Once the SmartConnector™ is set up, it automatically retrieves new data daily.
How do I use SmartConnectors™?
See the SmartConnector™ Setup Guide.
How do I download an assignment file for a SmartConnector™?
See How to Use Manage Assignments.
Defining a SmartConnector™
Can I upload my own icon for a SmartConnector™?
No. TapClicks uses SmartConnector™ icons in many places across the platform, so icons must meet several standards to render correctly and be readable in most browsers.
What characters are accepted in service names?
The system works with any UTF-8 characters, including numbers and special characters. That includes Mandarin, Japanese, Korean, Russian, French, Spanish, and Arabic.
| Note: Right-to-left languages are supported, but might render imperfectly depending on the design of your dashboards. |
Are there any best practices for my sample file?
Yes. Your sample file should have at least two rows: one for the column headers and one with a sample of the data those columns contain.
The system uses the second row to suggest a field type for each column. For example, if it sees numerical characters, it suggests a number field. If it sees a dollar sign, it suggests currency. If it sees a date format, it suggests a date, and so on.
What happens if I do not fill in the second row of the sample file?
The file is processed normally, but the system cannot suggest field types. In this case, you need to set the field types yourself in the configuration.
Why is there a limit on the sample file size?
The sample file is only used to set up the SmartConnector™ definition. It can be as small as a file containing only the header row, or as large as 50 MB. CSV files larger than 50 MB are also supported.
Is there a limit on query size for database delivery types?
Database delivery types work best with up to 10,000,000 rows of data. If you expect your data set to exceed this limit, reach out to customercare@tapclicks.com or your Customer Success Manager to work with our Data Solutions team. They can help you understand your use case and define a scalable solution that meets your needs.
Do you actually pull in data from the sample file?
Yes, if you choose to. When defining Load Sample Data, there is an option to have the system process the sample file, as well as anything in the defined pick-up location (if one is used).
What is a defined pick-up location?
A defined pick-up location tells TapClicks exactly where to find your data. This includes FTP or SFTP servers, Dropbox, an Amazon S3 Bucket, or Google Drive.
What happens after I load my sample file?
After you load your sample file, a list appears showing every field in the file and the field type identified for each one. Field types tell the system how to handle each column in the file. You can change field types as needed.
My sample file column headers look wrong. What should I do?
If the column labels do not match what you expected, upload a sample file with valid column headers.
What characters are accepted in column labels?
The system works with any UTF-8 characters, including numbers and special characters. That includes Mandarin, Japanese, Korean, Russian, French, Spanish, and Arabic.
| Note: Right-to-left languages are supported, but might render imperfectly depending on the design of your dashboards. |
What are the available field types?
-
Number
- Used for operations in the system, like sums and formulas
- Cannot be used for assigning
- Cannot be used as a date range
-
Decimal
- Displays the field with two decimal places and can be used in system operations
- Cannot be used for assigning
- Cannot be used as a date range
-
Percent
- Displays the field with a percent sign (%) and two decimal places and can be used in system operations
- Cannot be used for assigning
- Cannot be used as a date range
-
Currency
- Works with the currency selection in the dashboard and 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
-
Duration
- Stores a time duration
-
Link
- Stores clickable URL links
-
Call Recording URL
- Stores clickable URL links
-
Thumbnail
- Stores an image
-
Phone Number
- Stores a phone number
-
Click to View URL
- Stores a link to an image
-
ID
- Stores an ID field
How do I use the Assignment field?
This is the field (see image below) you and your team use to connect data from your files to TapClicks dashboards. Fields used for assignment must be the Text type. Typically, this is an advertiser name, client name, company name, or campaign name. Think of it as the most granular item that might represent one of your customers.
If you have questions about how to approach this field, reach out to your Customer Success Manager for guidance.
How do I use the Date field?
The Date field (see image below) tells the system which field to use for the date range. This is an important field because it controls how data responds to the on-screen date range picker.
If you have questions about how to approach the Date field, reach out to your Customer Success Manager for guidance.
What if I have a lifetime data set?
In that case, we typically suggest associating your data with a date such as a campaign start date or a campaign end date. The right choice depends on how you want to report on that data.
What if I want to load data that represents an entire month (or an entire week)?
In this case, we recommend loading that data and associating it with the first or last day of the month. To load data weekly, load it on the same day of the week every week (for example, August 11, August 18, and August 25).
Can you explain "Is Metric"?
Is Metric? indicates whether the associated field is a performance metric, like impressions or clicks. The SmartConnector™ automatically selects this option for Number, Decimal, Percent, and Currency fields, but there may be cases where you do not want to classify a value as a metric. Numeric values that do not change day to day, like a budget or an impressions target, should not be marked as Is Metric?.
Can you explain "Include in Charts"?
Include in Charts? indicates whether the associated value is included in the row breakdown chart and the Report Generator chart (see image below).
What makes a field unique?
Looking at your data, what makes each row different from the row above it? Typically, this is an ID field like a Campaign ID or an Ad ID, but it could also be a keyword. Alternatively, select several fields that, when combined, always produce a different combination in each row.
If you have questions about how to approach this field, see Understanding Unique Fields or reach out to your Customer Success Manager for guidance.
What are the Operation dropdown menus?
The Operation dropdown menu defines how the system handles the fields you defined as metrics. You can either add the values of a field together or average them.
The SmartConnector™ wants me to apply an operation to an ID field from my file. Do I have to?
No. Either clear the Is Metric? checkbox or change the field type to Text.
I have a number field but I cannot apply an operation. What is happening?
Make sure the Is Metric? checkbox is selected for that field. Operations can only be applied to metrics.
What is a drilldown?
A drilldown is a link that takes you from one level in TapClicks to a lower, more granular level, so you can drill down into additional data detail. By default, these are called campaigns, but you can rename them in the SmartConnector™ definition to reflect something more pertinent to your data set.
Can you set up an FTP or SFTP for me?
Yes, for a small monthly maintenance fee. Contact your Customer Success Manager or customercare@tapclicks.com for more information.
What about a Google Drive, Dropbox, or Amazon S3 Bucket? Can you set up one of those for me?
TapClicks does not host or manage these options. However, you can connect your own hosted accounts on these systems.
I do not want to set up any of these hosting locations. Can I load data into the system as I need to?
Yes. You can load data using the manual or email delivery methods. With the manual delivery method, you load data using the Manual Upload function for the SmartConnector™. With the email delivery method, your source system emails files directly to the email address shown on your SmartConnector™.
| Note: The email address only appears when the delivery type is set to Email. |
What file types are supported?
CSV, TSV, XLSX, Google Sheets (when using Google Drive), JSON, ODS, and GZ files.
Where is the Manual Upload button?
In the left side menu, on the Data menu, click Smart Connectors to see a list of previously defined SmartConnectors™. To the far right of each one (see image below), there are two icons: one for upload and one for edit. Click the Upload (up arrow) icon and drop in the files you need (see image below). With this method, your files do not need a date format in the file name.
How do I delete a manually uploaded file?
If you uploaded an incorrect file, you can remove it by navigating to the manage manual uploads option within the SmartConnector™ options.
What date formats are supported within the body of my data file?
The system supports ISO 8601 date formats. The best practice is to use the ISO standard YYYY-MM-DD. The examples below use April 5, 2026.
| Note: Your dates are always read correctly if the month number comes before the day number or if you use text for the month. |
| Format | Example |
| YYYY-MM-DD | 2026-04-05 |
| YYYY-MM-DD HH:MM | 2026-04-05 11:30 2026-04-05 22:30 |
| YYYY-MM-DD HH:MM:SS | 2026-04-05 11:30:05 |
| YYYY-MM-DDTHH:MM:SS-HH:MM | 2026-04-05T11:30:05-00:00 |
| mm-dd-yyyy | 04-05-2026 |
| m-dd-yyyy | 4-05-2026 |
| m-d-y | 04-05-26 04-5-26 4-05-26 4-5-26 |
| m-d | 04-05 4-05 04-5 4-5 |
| d-mon-YYYY | 05-Apr-2026 5-Apr-2026 |
| d-mon | 05-Apr 5-Apr |
| mon-d-YYYY | Apr-05-2026 Apr-5-2026 |
| Month-d-YYYY | April-05-2026 April-5-2026 |
| day of week, Month d, YYYY | Sunday, April 05, 2026 Sunday, April 5, 2026 |
| abbreviated day of week, Month d, YYYY | Sun, April 05, 2026 Sun, April 5, 2026 |
| day of week, mon d, YYYY | Sunday, Apr 05, 2026 Sunday, Apr 5, 2026 |
| abbreviated day of week, mon d, YYYY | Sun, Apr 5, 2026 |
I prefer not to use dashes. What are my options?
You can use any of the following separators:
| Hyphens or dashes | - |
| Commas | , |
| Periods | . |
| Backslashes | \ |
| Forward slashes | / |
| Spaces | (space) |
| Underscores | _ |
| Pipe character | | |
I tried to use a date format like "Thur, April 9, 2026" or "Tues, Apr 07, 2026" and I got an error. What is happening?
Standard day-of-week abbreviations use three letters (for example, "Tue" and "Thu"), not four.
If I include a timestamp in my date format, will it be stored in the database?
If the field is tagged as Use for Date Range?, the system ignores the timestamp during processing. If you need the timestamp, define another field for Use for Date Range? and store the timestamp date as a text field. You can then see the full date, with the timestamp, in TapClicks.
What time zone do my manual files use on the dashboard?
The SmartConnector™ loads manual files in Coordinated Universal Time (UTC).
What is margin and why would I use it?
A margin is an additional amount or percentage above the actual spend for a given account (see image below). Use margin when you want to obscure the actual spend for a bundled product, or when you charge a service fee and want it reflected in your shared reports.
How does "Footer rows to skip" work?
This setting is for files generated by a system that adds rows at the bottom of the file, like a "total" row or information about how the report was generated. Instead of manually editing every file before loading it, you can tell the system how many rows to skip before processing.
Unlike header rows, which are handled automatically, footer rows need to be defined. For example, if your data has a "total" row at the bottom, telling the system to skip that row keeps your data from being inflated. The goal is to minimize the edits you need to make to the file.
Why can I not indicate how many header rows to skip on my file?
The system automatically skips any header rows that are fewer than three columns wide.
I made a mistake in my data file. Can I fix it?
It depends on the type of mistake and whether the data has started loading. If you have not assigned anything yet and the data has not started loading, you can modify your data. Do not make changes after the data has started loading. Changing something critical to the feed definition while it is loading, like the Unique Fields or the Date Field, increases the risk of data integrity problems. If you have any questions, reach out to your Customer Success Manager.
What can be changed after data starts loading?
The following items can be changed after the data starts loading:
- Service Name
- Service Icon
- Is Active?
- Column Label
- Operation
- Drilldown / View Name
- Delivery Type
- Data File Directory Path
- Is Metric?
The following items cannot be modified after the data starts loading:
- Sample Data Upload
- Sample File Column
- Field Type
- Assignment Field
- Date Field
- Unique Fields
- Include in Charts?
- File Name Date Format
- Footer Rows to Skip
If I change the operation type, how will that impact my data?
The next time you view your data in the dashboard, the values recalculate based on your change. This is because the view resets every time you refresh the dashboard display.
What if I need to change an item that cannot be modified?
If you need to keep the data currently in the database, define a new SmartConnector™. If you must change the Assignment Field, Date Field, or Unique Fields on the existing SmartConnector™, use Delete all data. This purges all data loaded for that SmartConnector™ to date. Once the data is purged, you can edit the SmartConnector™ fields.
When I delete all the data, will my previous data reload itself?
Yes. Delete all data clears the data and primes your assignments to reprocess the data from your files. Click Update Data to start the reload.
How do I use "Delete all data"?
1] Log in to TapClicks, and on the Data menu, click Smart Connectors.
2] In the list of SmartConnectors™, find the SmartConnector™ you want to clear.
3] On the right side of that SmartConnector™, click the Show More (three vertical dots) icon.
4] From the dropdown menu, click Delete all data (see image below).

5] Follow the prompts to delete your SmartConnector™ data.
| Note: You have the option to drop your assignments as well. If you only want to delete the data, you do not need to drop the assignments. If you do drop the assignments, you need to reassign all your data to a TapClicks client before you can use that data in visualizations. |
What does the "Delete assignments as well" toggle do when I click "Delete all data"?
The dialog gives you the option to purge the assignments (see image below). If you are not changing the field you assign by, you do not need to drop the assignments. Keeping them preserves the assignment work you have already done.
If you do change the field you assign by, remove the previous assignments. For example, if you were assigning by advertiser but need to assign by campaign, keeping the old advertiser-level connections does not help, because the SmartConnector™ now assigns by campaign.
Why is the "Delete all data" option not visible?
If you have already deleted all data for a SmartConnector™, or if no data has been loaded for it, this option does not appear because there is nothing in the database to delete.
After I define a new SmartConnector™, what is next?
After you define a new SmartConnector™, complete the following checkpoints to visualize your data:
- Assign your data: You can do this in bulk using the Manage Assignments feature.
- Create calculations: Calculations ensure data integrity with your new SmartConnector™ data. Define underlying formulas so that when you change the aggregation and date ranges on your dashboards, the metric recalculates on the fly.
- Create widgets: Since this is a new data source, you need to configure new widgets on your dashboards.
- Create channels: Similar to widgets, new channels may need to be defined based on how you report this data to your advertisers.
- Define margin & markup rules: To apply margin or markup to cost data brought in through a SmartConnector™, use the Margin Rules area.
What if I need to change my file delivery type after I have loaded the data?
You can do this, but when you change the underlying data source, make sure the same data is available in the new source. For example, if you move from an Amazon S3 bucket to an FTP location, make sure the underlying data is available in the new location.
If you need help with this change, reach out to your Customer Success Manager or customercare@tapclicks.com.
Connecting to Data
What are assignments?
Assigning is the process of connecting data from a source to a client in TapClicks. In Manage Data Sources, when you click a data source icon, the list of available options that appears are assignments. Each assignment connects to a TapClicks client record.
Do I really have to assign data to clients?
Yes. However, if all the data from your SmartConnector™ is going to be assigned to a single client, a toggle in the SmartConnector™ creation process helps with this (see image below). When you turn on Assign this SC to a single client, you are taken to the Manage Data Sources screen after you finish configuring your SmartConnector™. There, select the client to assign all the data to. All existing and future data is then processed and associated with that TapClicks client record.
I want to assign as many clients to my SmartConnector™ data as I can at once to save time. Can I do that?
Yes, use the Manage Assignments feature. You can download your assignments, configure them in CSV format, upload the file back to TapClicks, and review the results. If there were any issues with the upload, the resulting CSV file lists the problems assignment by assignment. Once complete, click Update Data.
To get to this feature, in the left side menu, on the Data menu, click Data Sources, and then click Manage Assignments (see image below).
Where does the list of assignments come from for a SmartConnector™?
The list is generated from one of the following:
- All the files in your hosting location
- The dedicated file for assigning (if you use this feature)
- The dedicated query you defined for assigning (if you use this feature and a database delivery type)
For Snowflake SmartConnectors™, what is the transport mechanism between Snowflake and TapClicks for uploading a CSV file?
TapClicks uses the Snowflake PDO driver to connect securely to Snowflake through a certificate, and TLSv1.2 for any internal communication within our network. To learn more about the Snowflake PDO driver, contact Snowflake directly.
Does TapClicks provide IP address ranges for FTP/SFTP allowlisting?
TapClicks does not provide IP address ranges for SmartConnector™ FTP/SFTP delivery types. IP address ranges are generally provided only for database delivery types, and when available, they appear directly on the SmartConnector™ setup screen.
The TapClicks application does not connect from a fixed set of IP addresses, so IP address allowlisting is not recommended. Instead, use strong password authentication on your FTP/SFTP endpoint.
If your FTP provider requires IP allowlisting and cannot accommodate other security methods, use a different delivery method.
Processing Data
How far back does the SmartConnector™ pull data?
When you connect a data source to TapClicks, the system automatically updates data from that source so your reporting and insights stay up to date. This process of collecting data from the source is called data loading.
There are two types of data loads:
- Initial data load: Triggered when you connect your assignments to a data source for the first time, and the system fetches historical data
- Periodic load: Daily data collection performed by TapClicks
The amount of historical data requested for a given data load is known as the lookback period. Each data source and data load type has a different lookback period. It is defined by the respective application based on several factors, including what is available from the data source and how long those data loads take. TapClicks stores this data, so you can see a history of all data pulled for a given source for connected data sets.
Information about data loading times is shown on the Connection Status page, found in the Administration section of the left side menu. If the lookback period balloon is empty for a given service, reach out to your Customer Success Manager for more information.
When you assign a new client in an existing SmartConnector™, the system looks at the last six months of data for any rows relevant to that client. If no matching rows exist in the older files, no historical data loads.
How many days of data will load each day for the SmartConnector™?
It depends. When a fetch starts (either the regular daily fetch or when you click Update Data) and there are no new assignments for the SmartConnector™ in Manage Data Sources, the system pulls data from files within approximately the last three days. You can configure the number of days in your SmartConnector™ (see image below).
If you add a new assignment to a TapClicks client in Manage Data Sources, the system refreshes all the data for assignments from files with a name-date format within the last six months. This applies to both previously assigned and newly assigned items.
If you unassign something, its data is no longer picked up in subsequent fetches. However, any data loaded to date stays in the database.
How does the SmartConnector™ process my files by date?
If every file in the hosting location (like Google Drive, Dropbox, FTP, or SFTP) has a date in the file name, you can configure the SmartConnector™ to process data by that date. The format is typically YYYY-MM-DD, but you can configure it in the SmartConnector™ (see images below).
What happens if my file does not have a date in the name?
If your files do not have a date in the name, you can have the SmartConnector™ process data by Last Modified Date (see image below).
If I am processing data by date, does it matter where in the file name the date information appears?
No. The system reads the file name from left to right, so the first string that matches the configured date format is used as the date for processing.
Can I pull in data from multiple tabs?
Yes, but if your tabs have different column headers, create a separate SmartConnector™ or child Data View for each tab's data. For example, in the image below, a Google Sheet has multiple tabs, and you can select one tab or all tabs. You can also select tabs based on a specific naming pattern.
Are there any restrictions on what name I give to a file?
No. The system only looks at the date format in the file name, and if you load based on Last Modified Date, even that is not required. You can name your files however you like.
Are there any limits on file size?
The sample file has a size limit, but that is the only firm limit TapClicks imposes.
XLSX files over 75,000 rows become difficult to process, so it is best to convert them to CSV.
If your files are over 500 MB, let us know so we can review your feed and make sure it is working as expected.
With large files, the assignment list takes longer to load in Manage Data Sources, and data fetches may take longer to complete. If you have any questions, reach out to your Customer Success Manager or customercare@tapclicks.com.
Are there any limits on how much data overall a given SmartConnector™ can process?
As a best practice, a SmartConnector™ processes approximately 100,000 rows of data per day and approximately 10,000,000 rows of data overall for most delivery types.
If you expect your data set to exceed these limits, reach out to customercare@tapclicks.com or your Customer Success Manager to work with our Data Solutions team. They can help you understand your use case and define a scalable solution that meets your needs.
How does the SmartConnector™ process my data?
The system reads the column headers in your files. If you change a column header in new files, that data is not picked up and the fetch may return errors. This is why column headers cannot be modified in the SmartConnector™ interface.
If I change the order of the columns in the files I upload, will my SmartConnector™ still work?
Yes.
What happens if some of the columns in my file are empty?
As long as the column is not used for assignments, uniqueness, or the date range, blank columns are stored as blank fields in the database.
I have a "Campaign End Date" that is not used as my "Date" field and it was blank in my file, but I see a 0000-00-00 value on screen. What happened?
Dates are handled in a special way in TapClicks. If a date value is empty during processing, the system fills in a default value of 0000-00-00.
What do I do if I do not want that 0000-00-00 value to show up on my reports?
Change the column type to Text. The value is then stored as a text string and appears empty when the field is blank in the source file.
What happens if I have a lot of different files with different column headers that I need to send into the SmartConnector™?
There are several ways to handle this. One of the simplest is to create a separate folder in your hosting location for each group of files that share the same column headers. For example, if you want one SmartConnector™ for campaign data and another for keyword data, create a separate folder for each. This keeps the files organized for processing and makes troubleshooting easier.
What if I only want to add data rows to a single file? How can I get that data into the platform?
Use a SmartConnector™ configured to process data based on Last Modified Date. The file is then processed automatically whenever it is updated. Keep the old rows in the file, because if you need to assign new data in the future, the system needs to pick up the older rows as well.
If you use a Google Sheet and add new rows to the bottom of the document, those rows are processed. Over time, however, the Google Sheet may become too large to open in your web browser. In this case, we recommend a more traditional SmartConnector™ setup.
If you have questions about your specific use case, reach out to your Customer Success Manager or customercare@tapclicks.com.
What if I have a lot of files that all have the same column headers, for the same day, but tied to different campaigns or advertisers?
This is most common when a vendor only allows you to pull data for a single advertiser or campaign at a time. There are a few ways to handle it:
- If all your files include a field that represents the advertiser or campaign, load all the files to the same directory and use the Assignment field to route data to the appropriate TapClicks clients.
- If nothing in the file body represents the advertiser, create one SmartConnector™ per TapClicks client and assign each SmartConnector™ to a single client. As new files are processed, the data is automatically associated with the correct client.
- If your file names contain a unique value that represents your advertiser, our Customer Solutions team can review how best to automate your use case.
To get in touch, reach out to your Customer Success Manager or customercare@tapclicks.com.
What happens if I switch from a hosted delivery type to a manual upload?
Your assignments are not affected.
What is the best practice when changing delivery types?
1] Back up your assignments using Manage Assignments for the SmartConnector™.
2] Delete all data for the SmartConnector™.
3] Edit the configuration as needed.
4] Save the SmartConnector™.
5] In Manage Data Sources, review your assignments. Use the backup from step 1 as a reference if needed. You only need to reconnect assignments if you dropped them in step 2 or changed your Assignment field.
Why are my SmartConnector™ date fields not treated as dates, except for the Use for Date Range field?
A SmartConnector™ has only one defined date field: the field marked Use for Date Range?. Other fields set to the Date type in the SmartConnector™ definition are stored as text in the database.
Can SmartConnectors™ process a ZIP file?
Yes. Use the email delivery method to send a ZIP file attachment containing one supported file.
Can a SmartConnector™ process an image in a CSV?
A SmartConnector™ does not display images copied into cells, but there are two other options. You can include a link to an image using the Click to View URL field type, which renders the image, or you can use the Thumbnail field type.
Can an email SmartConnector™ process data from a URL link in an email instead of a file attachment?
Yes.
Can an email SmartConnector™ process data if there are multiple links?
Yes.
Why am I getting emails about duplicate rows?
When a data file contains duplicate rows, TapClicks sends an email notification. The data still loads and is processed for the SmartConnector™, but removing redundant rows keeps your data clean.
Displaying Data
Why do I not see any data in my dashboard?
Make sure you clicked Update Data. If you have not, click it to prompt the system to fetch your data.
| Note: The fetch can take time depending on how much data you are processing. |
My averages do not look right. What is happening?
This is likely because of how the system treats averages. They are strict averages, meaning any 0 values are included, which can lower your average.
If the value is calculated from base values in your file, we strongly suggest creating a calculation to handle it for data accuracy.
Example:
Average Conversion Rate: Average of the Conversion Rate fields = (3.18 + 3.88 + 3.63) / 3 = 3.56%
Actual Total Conversion Rate: (Total Conversions / Total Impressions) = (43 + 27 + 35) / (1352 + 696 + 965) = 3.48%