AffiliCode System: New Analysis Foundation to Leverage Measurement Data. Accelerating Marketing Strategy Optimization with BigQuery Integration

NQ 56/100

📋 Article Processing Timeline

  • 📰 Published: March 30, 2026 at 07:42

To all members of the press

Press Release

March 26, 2026

Leafworks Inc.

Kenta Sawa, Representative Director

Leafworks Inc. (Headquarters: Otsu City, Shiga Prefecture, Representative Director: Kenta Sawa, URL https://www.leafworks.jp), a provider of cloud services for businesses, announced today (March 26) the launch of a daily integration function to Google Cloud Storage in AffiliCode System Ver. 3.18.

This enables data aggregation and flexible analysis using BigQuery, allowing measurement data to be visualized from various perspectives such as cross-media or by product, facilitating smooth analysis and utilization.

What is AffiliCode System?

A multi-functional subscription-based affiliate system with over 1,500 cumulative introductions. It allows for flexible operation according to objectives, such as ASP operation, advertising effect measurement, and ad distribution management.

AffiliCode System: https://system.affilicode.jp

Challenges Posed by Siloed Advertising Data

As the operation of using multiple advertising media concurrently becomes common, measurement data such as CV, clicks, and accesses are often managed and distributed by media and by product.

The situation of individually accumulated measurement data and the difficulty of cross-sectional comparison are challenges faced by many advertising operators.

Furthermore, report creation through manual extraction and processing leads to an increase in operational costs, making it difficult to perform analysis on multiple axes such as by media or by product.

To solve these challenges, we have started providing this feature.

Daily Integration of Measurement Data to Google Cloud Storage

Measurement data from AffiliCode System will be imported into Google Cloud Storage once a day.

Daily impression, access, click commission, and performance commission data will be output in a format suitable for analysis in BigQuery, and the data will be accumulated. Since the data is stored in the cloud, continuous data analysis is possible without affecting the performance of the measurement system.

Integration with BI tools will expand the scope of data utilization, such as visualization of analysis results and reporting.