Need Help in comparing 3 metrics z score

Am trying to compare which campaign performed better based on 3 KPIs [limited KPIs were captured hence using just these 3 for proto-type]; to do that I computed:
a. each KPIs attainment % (achieved/goal)
b. normalized attainment % by computing z score
c. all 3 KPIs z score was multiplied by the respective KPI weight-age and called it D Comp
d. ranked based on D comp.

Request help in reviewing this and providing feedback on what i may be missing here.

Attaching the image for reference [for some reason i wasn't able to upload the .xlsx file as an attachment].

Am new to doing something like this. Hence, please advise if this is in the right direction.

Appreciate your time and support.