Difference between rows for A/B test

I am trying to build a dashboard to assess performance of A/B test (test vs control group) for campaigns. This is how my data is :

How do I get % change between test and control groups of Campaign C1, C2 etc. Note that not every campaign has a test and control group.

I have sorted my data based on campaign and group. In simple English what I want to do is “if a campaign has test and control then calculate the % difference in the number of clicks between the two groups”

Any idea how to do this ?

campaign group clicks
C1 test 10
C1 control 2
C2 control 5
C3 test 20
C4 test 15
C4 control 25
0 3 594
3 REPLIES 3
Top Labels in this Space