Skip to main content

Use Amazon Redshift as a source — pulling events for reporting

With the Amazon Redshift integration, you can streamline data retrieval for targeted campaigns and personalized user experiences.

Key benefits:

  • Enables accurate data collection, improving audience targeting for campaigns customized to meet specific audience needs and preferences.
  • Configure Data Ingestion Tasks to extract data from Redshift efficiently.
note

Data warehouse integrations are available as a premium add-on for our Web Experimentation and Feature Experimentation module. For more information, please contact your Customer Success Manager.

Once you’ve activated Amazon Redshift for a specific project, you can use it to create goals in Kameleoon. These goals are designed to use conversions data from your Amazon Redshift database. Here’s how to create a goal using Amazon Redshift:

  1. Click Configure > Goals > New goal.

  1. In the pop-in, provide the following details:
    • Name
    • Type: Select Data Warehouse Tracking.
    • Data Warehouse: Choose Amazon Redshift.
    • Project
  2. Click Next.
  3. Provide additional details to complete the goal configuration in the next window.
    • Frequency: Define how often you want Kameleoon to update goal data.
    • Amazon Redshift project ID: Enter your Amazon Redshift project ID to direct the data to the correct location.
    • Region: Select the appropriate region from the provided list.
    • Query: Define the SQL query to retrieve the necessary data from Amazon Redshift.
  4. Click Validate.

Query format​

The query must adhere to a specific format:

SELECT visitor_id, conversion_timestamp FROM your_events_table

Where visitor_id is the column representing your visitors' unique ID, and conversion_timestamp is a column that represents the exact time the conversion took place. In Amazon Redshift, the conversion_timestamp column must be a Timestamp type column.

If you want to associate a revenue to each conversion, the query should adhere to an alternate format:

SELECT visitor_id, conversion_timestamp, revenue FROM your_events_table

Where revenue is a column containing each conversion's revenue.

For more complex queries you can adhere to this format by formulating a sub-query as such:

SELECT visitor_id, conversion_timestamp, revenue FROM ( {your_original_query} ) AS subquery

The query you input will run every hour in your Amazon Redshift warehouse, appended with a WITH condition that filters the timestamps. However, please note that while your conversions are polled every hour, they are only merged once a day into your experiment results.

Using your Amazon Redshift goal​

With the goal created, you can now incorporate it into your Kameleoon campaigns. When setting up an experiment or personalization, you’ll have the option to select this goal in the configuration steps, letting you track and analyze specific conversions from your Amazon Redshift database. These conversion are merged with your experiment results once a day, so all conversions polled on a given day will be visible the following morning.

To learn how to set up a goal in an experiment, refer to this article.