bug fix: coordinating click tracking between nosql and sql