Century21Stores / SPECIAL

Special Projects
0 stars 0 forks source link

Build a Google Sheet for Homepage Coremetrics Data to Live #17

Closed c21hornak closed 7 years ago

c21hornak commented 7 years ago

Build a Google Sheet for exported homepage Coremetrics data to live, and for Andrea to analyze it.

This Google Sheet was conceived by Juan because when there when there is a lot of tagging, like on the home pages, it is hard to read. This Google Sheet will make it simple.

c21hornak commented 7 years ago

https://docs.google.com/spreadsheets/d/1Pvvd0bs9wZCmOUQUHzs5weNTmob_TjzCyJvXAIDyqYg/edit#gid=1509475575

Home Page Assets Click Event Report Version 1 was completed on 3/2, shared with Andrea, and was ready to work with the data that was going to be collected starting 3/3 once "Coremetrics Tagging for 03Week2 Semicustom Homepage A + All Content Blocks (GLOBAL-61)" got pushed to PROD.

The way to use it is to export the click event data from the Coremetrics plugin from the LiveView area, and paste the Coremetrics data into the Google Sheet. Once you do, the other tabs in the Google Sheet will automatically sort the data in an easily digested way.

The way it works is: • Download the report from live preview download link of the page you want to see the report. Should be in the “link data CSV" form • Paste it in the first tab "IMPORT "LINK DATA” CSV" • All other tabs will fill in automatically and all is sorted so items with more clicks are at the top.