Welcome to WebmasterWorld Guest from 3.85.214.0

Forum Moderators: DixonJones & mademetop

Message Too Old, No Replies

Google Analytics Ecommerce Conversion Rate

Need help understanding how it's determined

     
11:09 pm on Dec 29, 2014 (gmt 0)

Junior Member

5+ Year Member

joined:Aug 17, 2010
posts: 188
votes: 2


I'm trying to figure out out how GA shows Ecommerce Conversion Rate. The report I'm exporting is broken down by Date, Day of Week Name, Hour and Default Channel Grouping. When I open the csv in excel I can see the total conversion rate, yet when I average up all the rows I get a smaller percentage. Ultimately, I want to use this data in a PivotTable.

Is there a trick to handling GA's conversion data? Any help is greatly appreciated!
4:21 pm on Jan 2, 2015 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:June 20, 2006
posts:2166
votes: 92


How are you doing "average up all the rows"?

If you're just averaging the CR, each row is a different size (it's an average itself). Averaging the averages ignores the size differences. Instead, add up the total clicks and total sales, then divide.
4:45 pm on Jan 2, 2015 (gmt 0)

Junior Member

5+ Year Member

joined:Aug 17, 2010
posts: 188
votes: 2


Thank you, I ended up doing that exactly!