Connecting Impact Radius data in Clarisights
Overview
Impact requires a report to be set up in DataLab and then sent to a third party like Clarisights via SFTP. The steps below highlight what needs to be done on Impact versus what needs to be done in Clarisights.
This integration allows you to automatically import your Impact affiliate marketing data into Clarisights for unified reporting and analysis.
Step 1: Get SFTP Credentials from Your CSM
Before you can schedule reports from Impact, you need to obtain SFTP connection details from Clarisights.
Action Required:
- Reach out to your Customer Success Manager (CSM), or
- Send an email to support@clarisights.com
Request: SFTP directory and connection details for your Impact integration with Clarisights
Your CSM will provide you with a one-time-link containing:
- Server URL
- Directory path
- Port number
- Username
- Password
Please keep these credentials secure as you will need them in Step 2.
Step 2: Create the Report on Impact
2.1 Access Impact DataLab
Login to Impact and navigate to DataLab.
2.2 Create a Data Table
Create a new data table with the following dimensions and metrics and select a date range (ideally the entire a few days longer than your maximum corrections window):
Required Dimensions:
- Date
- Country/Region
- Partner
- Partner ID
- Ad Name
- Ad ID
- Ad Type
- Ad Campaign Name
- Operating System
- Product Category
- Event Type
- Event Type Category
- Event Type Id
Required Metrics:
- Clicks
- Action Cost
- Other Cost
- Total Cost
- All Revenue
- Actions
Note: While you can add other metrics and dimensions to the report, do keep in mind that certain dimensions in Impact (eg: Partner Group) can "inflate" the metric values. The above list is validated by the Clarisights team.
2.3 Schedule the Report
Configure the report schedule with the following settings:
Frequency: Daily (at preferred time)
Format: CSV without metadata
Delivery Method: Partner FTP
Connection Details: Use the SFTP credentials provided by your Clarisights CSM
- Server URL
- Directory
- Port
- Username
- Password
Step 3: Clarisights Configuration
Once your report is scheduled in Impact, your CSM will configure the integration on the Clarisights side to continuously import your Impact data.
No action is required from you - your CSM will configure the platform for ingestion from Impact.
Step 4: Backfill Historical Data (Optional)
If you need to import historical data from before the integration was set up:
1. Run a manual export for the same Impact DataLab with the desired date range
2. It will deliver the report via the same SFTP connection
3. Inform your CSM that a backfill report has been sent
Your CSM will process the historical data and ensure it's properly imported into Clarisights.
Summary
Your Responsibilities:
1. Obtain SFTP credentials from Clarisights
2. Create and schedule the daily report in Impact DataLab
3. (Optional) Run backfill reports if historical data is needed
Clarisights CSM Responsibilities:
1. Provide SFTP connection details
2. Configure data mappings in Clarisights
3. Process backfill data if required
We hope this article was helpful for you. If you face any issues or questions please reach out to the Clarisights team on support@clarisights.com and we'll help you out!