Clickwise

Clickwise is a digital marketing analytics platform that provides comprehensive click tracking and reporting capabilities, enabling businesses to monitor campaign performance, analyze user behavior, and optimize digital marketing strategies through detailed click analytics.

Power end-to-end data operations for your Clickwise API with Nexla. Our bi-directional Clickwise connector is purpose-built for Clickwise, making it simple to ingest data, sync it across systems, and deliver it anywhere — all with no coding required. Nexla turns API-sourced data into ready-to-use, reusable data products and makes it easy to send data to Clickwise or any other destination. With comprehensive monitoring, lineage tracking, and access controls, Nexla keeps your Clickwise workflows fast, secure, and fully governed.

Features

Type: API

SourceDestination

• Seamless API Integration: Connect to any endpoint as source or destination without coding, with automatic data product creation
• Visual Composition & Chaining: Build complex integrations using visual templates, chain API calls, and compose workflows with data validation and filtering
• API Proxy: Expose curated slices of your data securely with a secure and customizable API proxy that validates and transforms data on the fly
• Request optimization with intelligent batching, retry, and caching to minimize API calls and costs

Prerequisites

Before creating a Clickwise credential, you need to obtain an API key and base URL from your Clickwise account. The API key is required to authenticate with the Clickwise API, and the base URL specifies your Clickwise API account endpoint.

To obtain your API credentials, you need to have a Clickwise account with API access enabled. Once you have access to your account, you can generate an API key from your account settings. The API key is sent in the X-ApiKey header to authenticate all API requests to the Clickwise API. The base URL is specific to your Clickwise API account and should be provided by your Clickwise account administrator or found in your account settings. For detailed information about API key setup and authentication, refer to the Clickwise API documentation.

Authenticate

Credentials required

Field	Required	Secret	Description
Base URL	Yes	Yes	Please enter the base URL for your Clickwise API account.
API Key Value	Yes	Yes	Please enter your API Key for Clickwise API.

Create a credential in Nexla

1. After selecting the data source/destination type, click the Add Credential tile to open the Add New Credential overlay.

New Credential Overlay – Clickwise

2. Enter a name for the credential in the Credential Name field and a short, meaningful description in the Credential Description field.

3. Enter your Clickwise base URL in the Base URL field. This is the base URL for your Clickwise API account. The base URL should be provided by your Clickwise account administrator or found in your account settings. The base URL is used to construct the complete API endpoint URLs for all API requests.

4. Enter your Clickwise API key in the API Key Value field. This is the API key you obtained from your Clickwise account settings. The API key is sent in the X-ApiKey header to authenticate all API requests to the Clickwise API.

   Keep your API key and base URL secure and do not share them publicly. The credentials provide access to your Clickwise account and should be treated as sensitive information. The API key is sent in the X-ApiKey header for all API requests to the Clickwise API. The base URL is specific to your Clickwise API account and is used to construct all API endpoint URLs. For detailed information about obtaining and managing API keys, see the Clickwise API documentation.

5. Click the Save button at the bottom of the overlay. The newly added credential will now appear in a tile on the Authenticate screen during data source/destination creation and can be selected for use with a new data source or destination.

Use as a data source

To create a new data flow, navigate to the Integrate section, and click the New Data Flow button. Select the Clickwise connector tile, then select the credential that will be used to connect to the Clickwise instance, and click Next; or, create a new Clickwise credential for use in this flow.

Endpoint templates

Nexla provides pre-built templates that can be used to rapidly configure data sources to ingest data from common Clickwise endpoints. Select the endpoint from which this source will fetch data from the Endpoint pulldown menu. Available endpoint templates are listed in the expandable boxes below.

Fetch Report of Click

This endpoint fetches a report of all clicks over the specified time period. Use this endpoint when you need to access click data, click analytics, or click reporting information for your Clickwise account.

• Enter the start date for fetching report data in the From Date field. The value should be in YYYY-MM-DD format (e.g., 2023-11-11). You can also use Nexla macros like {now} for the current date or {now-1} for one day ago. The default value is {now-1} if not specified.

• Enter the end date for fetching report data in the To Date field. The value should be in YYYY-MM-DD format (e.g., 2023-11-12). You can also use Nexla macros like {now} for the current date or {now-1} for one day ago. The default value is {now} if not specified.

• The endpoint uses GET requests to {base_url}/report/clicks?from={from_date}&to={to_date} where {base_url} is your Clickwise base URL from the credential configuration, {from_date} is the start date, and {to_date} is the end date. The endpoint URL is automatically constructed based on your credential's base URL configuration and the provided date parameters.
• The endpoint does not use pagination and returns all click report data for the specified time period in a single request.
• The endpoint will return all clicks for the specified time period. The response data is extracted from the root-level array in the API response ($.[*]), with each click record processed individually.

Date parameters should be in YYYY-MM-DD format, or you can use Nexla macros like {now} for the current date or {now-1} for one day ago. The endpoint uses a static URL (iteration.type: static.url) and does not require pagination. The response data path is $.[*], which extracts all items from the root-level array in the API response. For detailed information about fetching click reports, see the Clickwise API documentation.

Once the selected endpoint template has been configured, click the Test button to the right of the endpoint selection menu to retrieve a sample of the data that will be fetched. Sample data will be displayed in the Endpoint Test Result panel on the right, allowing you to verify that the source is configured correctly before saving.

Manual configuration

Clickwise data sources can also be manually configured to ingest data from any valid Clickwise API endpoint, including endpoints not covered by the pre-built templates, chained API calls, or custom request parameters. Select the Advanced tab at the top of the configuration screen, and follow the instructions in Connect to Any API to configure the API method, endpoint URL, date/time and lookup macros, path to data, metadata, and request headers.

Clickwise API endpoints typically follow the pattern {base_url}/{endpoint_path}, where {base_url} is your Clickwise base URL from the credential configuration. The endpoint requires API key authentication in the X-ApiKey header, which is handled automatically by your credential configuration.

Once all configuration steps have been completed, click the Save button to save your data source configuration. The data source will now be available in your data flow and will begin ingesting data according to the configured schedule and endpoint settings.