amuller1111
New Member
- Joined
- Mar 15, 2011
- Messages
- 1
I have a table with 5 columns: Ad Group, Keyword, Impressions, Clicks, and Click Through Rate. Each keyword belongs to an Ad Group. Click Through Rate for each keyword is calculated as clicks/impressions.
When I create a pivot table off of this data grouped by Ad Group > Keyword, the click through rates for each keyword display as expected. However, I'm struggling to find a solution to show the correct click through rate in the Subtotal section for each Ad Group. Right now it's averaging the percentages for each keyword within the Ad Group. Is there any way to correctly calculate the Click through rate for Ad Group subtotals?
When I create a pivot table off of this data grouped by Ad Group > Keyword, the click through rates for each keyword display as expected. However, I'm struggling to find a solution to show the correct click through rate in the Subtotal section for each Ad Group. Right now it's averaging the percentages for each keyword within the Ad Group. Is there any way to correctly calculate the Click through rate for Ad Group subtotals?
Last edited:
