Affilicode System Launches New Analysis Platform to Utilize Measurement Data, Accelerating Marketing Optimization with BigQuery Integration

LeafWorks Co., Ltd., a provider of cloud services for businesses, announced on March 26th the release of a daily integration function with Google Cloud Storage in Affilicode System Ver. 3.18.

This enables data aggregation and flexible analysis utilizing BigQuery, allowing for the smooth visualization, analysis, and application of measurement data from various perspectives, such as cross-media and by product.

What is Affilicode System? It is a subscription-based, multi-functional affiliate system with a cumulative track record of over 1,500 company installations. It offers flexible operation for various purposes, including ASP management, ad effectiveness measurement, and ad delivery management.

Challenges Posed by Siloed Advertising Data As operating with multiple advertising media becomes common, measurement data like conversions, clicks, and access are often managed dispersedly for each medium and product. This situation, where data is accumulated individually, and the difficulty of cross-sectional matching are common challenges for many ad operators. Furthermore, manual data extraction and processing for report creation increase operational workload, making multi-axis analysis by media or product difficult. To solve these issues, this new feature is now available.

Daily Integration of Measurement Data to Google Cloud Storage Measurement data from the Affilicode System is imported into Google Cloud Storage once a day. Daily data on impressions, access, click rewards, and performance rewards are output in a format suitable for analysis in BigQuery and 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 expands the possibilities for data utilization, including the visualization of analysis results and reporting.