Help with Pivot Tables

[seoguy2018]

I have spreadsheet with the performance data of 50 search engine search terms across multiple ad campaigns in Google and Bing. For each of the data columns below, I would like to create a formula I would use to aggregate the data in a pivot table:
1) Impressions
2) Clicks
3) Click-Through Rate
4) Cost
5) Cost Per Click
6) Average Position

any help would be appreciated. Thanks in advance.