A top P&G advertising exec who overhauled how the CPG giant works with its agencies is leaving for Snapchat