Report number of clicks total

I want to create a report in which I can find the number of clicks clicks in total, for every campaign, so I can import this as a CSV file into the Cost Data in Analytics.

When I group by ID, or campaign + clicks. And add count clicks as a calculated column. The other info (like total emails sent changes) and the amount of clicks is a lot lower than it should be.

Does anyone have a suggestion how I can make a report like this? Just an overview of the number of clicks and sent emails in a campaign.