Skip to main content

Adalyser

Connecting the Adalyser API to your Bright Analytics instance.

Updated over a month ago

Adalyser Integration Documentation

Connecting the Adalyser API to your Bright Analytics instance.

This recipe represents a base configuration that we expect to customize as our customers' needs evolve. The tables, metrics, and dimensions documented here may be adjusted to better align with specific business requirements.

Please read more about use cases for our integration with Adalyser here.


Overview

This document explains how to set up and use the Adalyser integration with our ETL platform. The integration imports campaign data from Adalyser, creates relevant tables, and provides metrics and dimensions for analysis.
​

Connection Setup

Authentication Requirements

To establish a connection with Adalyser, you'll need to provide:

  • Adalyser Username: Your login username for the Adalyser platform

  • Adalyser Password: Your Adalyser account password

Both fields are required to establish the connection.
​

Import Configuration

Data Source

The integration connects to Adalyser's reporting system to fetch campaign performance data.

Import Schedule

  • Frequency: Data is imported every 24 hours

  • First Run Hour: 5 (5 AM)

  • Lookback Period: 5 days

  • Job Label: "Adalyser Report Import"

Required User Input

When activating the integration, you need to provide:

  • Adalyser Campaign ID: A comma-delimited list of campaign IDs you wish to import

    • This field is required

    • Maximum length: 255 characters

Tables Created

The integration creates and maintains the following tables:

  1. adalyser_data_spots (Primary data table)

    • Contains the main campaign performance data

    • Update mode: Append (new data is added to existing data)

    • This table will be created if it doesn't exist

  2. adalyser_meta_campaign (Lookup table)

    • Contains campaign metadata

    • Update mode: Refresh (data is replaced during each import)

    • Uses existing table if available

  3. adalyser_meta_creative (Lookup table)

    • Contains creative metadata

    • Update mode: Refresh (data is replaced during each import)

    • Uses existing table if available

Table Relationships

The integration establishes the following joins between tables:

  • adalyser_data_spots.creative joins with adalyser_meta_creative.id

  • adalyser_data_spots.bright_custom_campaign_id joins with adalyser_meta_campaign.id

Available Dimensions

The integration provides the following dimensions for analysis:

  1. Sales House [Adalyser]

    • Source: adalyser_data_spots.salesHouse

  2. Channel [Adalyser]

    • Source: adalyser_data_spots.channel

  3. Programme [Adalyser]

    • Source: adalyser_data_spots.programme

  4. Creative [Adalyser]

    • Source: adalyser_data_spots.creative

  5. Type [Adalyser]

    • Source: adalyser_data_spots.type

Available Metrics

Base Metrics

  1. Spend [Adalyser]

    • Formula: SUM(adalyser_data_spots.clientCost)

    • Display: Rounded to 2 decimal places with £ prefix

  2. Sessions [Adalyser]

    • Formula: SUM(adalyser_data_spots.leadCount)

    • Display: Rounded to whole numbers

  3. Sign Ups [Adalyser]

    • Formula: SUM(adalyser_data_spots.apptCount)

    • Display: Rounded to whole numbers

  4. Sales [Adalyser]

    • Formula: SUM(adalyser_data_spots.saleCount)

    • Display: Rounded to whole numbers

  5. Lead Count [Adalyser]

    • Formula: SUM(adalyser_data_spots.leadCount)

    • Display: Rounded to whole numbers

Composite Metrics

  1. Cost per Session [Adalyser]

    • Formula: Spend [Adalyser] / Sessions [Adalyser]

    • Display: Rounded to 2 decimal places with £ suffix

  2. Cost per Sign-up [Adalyser]

    • Formula: Spend [Adalyser] / Sign Ups [Adalyser]

    • Display: Rounded to 2 decimal places with £ suffix

This integration allows you to analyze your Adalyser campaign performance across multiple dimensions and metrics, providing valuable insights into your marketing effectiveness.

Did this answer your question?