Chewy
Performance & Data Report
Midcycle Project
I used VLOOKUPs in Google Sheets to organize the data by quarter and product name.
As the Quality Assurer (QA), I made sure all calculations for CPC, CPA, CTR, CVR, and total sums were correct.
My team was able to articulate that the fish and reptile campaigns were not as successful based on comparisons in costs (CPC & CPA) and conversions to more successful campaigns, like the cat and dog.