Reporting Migration from HitPath to Everflow

Industry: Affiliate Marketing

Challenge: The client, a prominent affiliate marketing network, needed a smooth transition from HitPath to Everflow without losing critical performance data or disrupting operations.

Data Integration and Standardization

  • Pulled raw clicks and conversions from both HitPath and Everflow APIs.
  • Standardized column naming conventions to maintain consistency across platforms.
  • Stored data in a MySQL database while keeping data from both systems separate at the database level.
  • Before loading data into Domo BI, standardized data queries to avoid duplicating ETLs and preserve existing Domo logic.

Monitoring the Migration

  1. Affiliate Transition Reports:

  • Created detailed reports to track the number of affiliates transitioning from HitPath to Everflow.
  • Monitored performance metrics such as revenue and active affiliates across both platforms during the migration.
Number of affiliates

2. Revenue Comparison Reports:

  • Built visualizations comparing revenue trends in both HitPath and Everflow to ensure a steady transition and growth.
Revenue migration

3. Duplicate Conversion Prevention:

  • Developed a Domo alert to detect if affiliates were running the same offer on both systems, potentially triggering duplicate conversions.
  • Analyzed scenarios where affiliates could have posted identical conversions on both platforms by triggering URLs in both systems.
Alert affiliates with sales in both systems

Custom Alerts in Domo

  • Real-time notifications were implemented to flag potential issues, such as discrepancies in performance metrics such as offer conversion rates
  • Alerts enabled the network team to act swiftly to ensure the accuracy of their data and prevent any financial discrepancies.
Line chart comparing weekly conversion rates between HitPath and Everflow platforms from November 2022 to May 2023.

Result

  • Achieved a seamless transition from HitPath to Everflow without any data loss or operational downtime.
  • Prevented duplicate conversions by implementing a robust monitoring and alert system.
  • Standardized the data pipeline, saving significant time and effort by maintaining a single ETL process in Domo.
  • Provided real-time insights into migration progress, empowering the client to track affiliate activity and revenue trends across both systems.
  • Increased efficiency by transitioning 100% of affiliates and their campaigns to Everflow.

Technologies and Tools

Hitpath, Everflow, MySQL, Domo, Python