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
-
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.
2. Revenue Comparison Reports:
- Built visualizations comparing revenue trends in both HitPath and Everflow to ensure a steady transition and growth.
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.
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.
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
