Click House Integration Plugin for Revive Adserver Reporting

This plugin streams Revive Adserver delivery logs and statistics to ClickHouse, a columnar database, and uses it for reporting. Ad networks and publishers whose reporting on MySQL has become slow can move that load off the Revive MySQL database.

What it does

• Heavy reporting work moves off the Revive MySQL database, which is linked to better overall system performance.
• Standard reports are preserved, including impressions, clicks, CTR, eCPM, campaign and zone breakdowns and date filters.
• It is aimed at growing ad volumes and global traffic.
• Data is sent asynchronously, so real-time ad delivery is not affected.
• Batching, error handling and secure connection options come with optimized schema mapping.

How it fits your ad stack

Delivery logs and reporting data go to ClickHouse, while campaigns, banners, zones and advertisers stay on MySQL. Where viewability is reported, the MRC display standard is at least 50% of pixels in view for 1 continuous second; this plugin is not stated to record viewability.

Full feature details

Upgrade your Revive Adserver reporting capabilities with high-performance, scalable analytics powered by ClickHouse.

Revive Adserver traditionally relies on MySQL for data storage and reporting. Our Click House Integration Plugin replaces the default MySQL backend with the ultra-fast, columnar. Designed for scalability and performance, this plugin transforms how you store and query large volumes of ad delivery and impression data. Click House database delivering a significant performance upgrade, especially for large-scale ad operations.

This plugin is designed for ad networks and publishers who need scalable, high-performance analytics without the latency and limitations of traditional databases.

Key Features:

• Seamless Integration: Fully compatible with existing Revive Adserver setup – no disruption to your current ad delivery operations.

• Scalable Architecture: Handles millions of ad impressions per day without compromising on speed or performance.

• High-Speed Data Ingestion: Automatically streams Revive Adserver logs and statistics to ClickHouse with optimized schema mapping.

• Stable & Secure: Designed with robust error handling, batching, and secure connection options.

• Faster Report Generation: Enjoy lightning-fast queries even with billions of impressions, clicks, and conversions.

Benefits:

• High-volume ad networks seeking performance improvements.

• Teams needing enhanced analytics with minimal infrastructure cost.

• Offloads heavy reporting tasks from the Revive MySQL database, ensuring better overall system performance.

• Supports growing ad volumes and global traffic without degradation in performance.

Common questions

Which Revive Adserver versions does this plugin support?
The supported versions are listed in the Product Versions drop-down on this page. If you run a version that is not listed, contact us before ordering.

What does the free support cover?
For 3 weeks from delivery we help with installation, configuration and any bug in the plugin. Custom development and problems caused by other plugins or your hosting are not part of the free support, but we can quote them separately.

Can you adapt the plugin to my setup?
Yes. Custom work is available. Tell us what you need and we will quote it.