Processing Logic

# 参数: ads_spend_list, revenue_list
def calculate_roi(ads_data, adsense_data):
    results = []
    for campaign in ads_data:
        # utm_term 匹配 channel_id
        if campaign['id'] in adsense_data:
            rev = adsense_data[campaign['id']]['revenue']
            cost = campaign['cost']
            roi = (rev - cost) / cost
            # 小时级循环 0-23h
            for h in range(24):
                hourly = get_hourly(campaign, h)
                if roi < 0.1:
                    send_alert(campaign)
    return results