{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Your Data","Metrics Parameters"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Instructions:"]
["- Be sure macros are enabled (the \"Score\" column in the \"Your Data\" tab should have a number, and not \"NAME?\" error)"]
["- From Google Analytics, run a traffic report for the last six months (Behavior > Site Content > All Pages)"]
["- You may also wish to filter your GA report on Blog content only, and show 100 rows"]
["- Export GA report and open as Excel file"]
["- Copy the following columns from your GA report into the \"Your Data\" tab of this file:"]
["      PAGE"]
["      PAGEVIEWS"]
["      TIME ON PAGE"]
["      BOUNCE RATE"]
["- Fill in PUBLISH DATE column by visiting each blog post and entering date it was published"]
["- Fill in WORD COUNT column by visiting copying each blog post into Microsoft Word and getting word count"]
["- Score will calculate automatically"]
["       Content scored in GREEN is your highest-performing content"]
["       This represents the biggest areas of opportunity for optimization and improvement"]
["       You can tweak the relative values of all the scoring factors on the \"Metrics Parameters\" tab of this sheet"]
[]
[]
["The Media Shower platform pulls all these numbers for you, in one convenient dashboard."]
["Sign up for a free trial, install our tracking code, and see for yourself!"]
["http://www.mediashower.com"]

{"sheet":"Your Data","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Page","Publish Date","Score","Post Age (d)","Page Views","Conversions","Time on Page","Words ","Bounce Rate","Read Coverage","Page View Score","Click Score","Read Score","Bounce Score"]
["/blog/the-ultimate-list-of-b2b-content-marketing-ideas/","2017-03-07",{"$f":"K2+L2+M2+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},{"$f":"NOW()-B2","v":210.39172789351869},7052,460,217.73134328358208,800,0.65,{"$f":"MIN(G2/(H2/200*60),1)","v":0.9072139303482587},{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D2,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":91.15913555992141},{"$f":"J2*read_weight","v":9.0721393034825866},{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":7}]
["/blog/how-to-create-a-content-marketing-plan/","2017-05-26",{"$f":"K3+L3+M3+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},130.39172789351869,12290,270,286.81111111111113,1700,0.89429373246024324,0.56237472766884533,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D3,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":85.893416927899693},5.6237472766884533,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":2.1141253507951352}]
["/blog/top-10-content-writing-services-rated-and-reviewed/","2016-01-15",{"$f":"K4+L4+M4+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},627.39172789351869,7640,250,210.24,1900,0.68582375478927204,0.36884210526315792,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D4,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":84.949832775919731},3.688421052631579,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":6.2835249042145591}]
["/blog/the-ultimate-list-of-content-marketing-analytics-tools/","2017-02-24",{"$f":"K5+L5+M5+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},221.39172789351869,4956,190,240.55405405405406,328,0.89317507418397624,1,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D5,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":81.171548117154813},10,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":2.1364985163204753}]
["/blog/the-comprehensive-guide-to-lead-generation-tools/","2017-07-12",{"$f":"K6+L6+M6+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},83.391727893518691,6078,90,198.52272727272728,4384,0.93243243243243246,0.15094489604069897,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D6,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":67.625899280575538},1.5094489604069896,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":1.3513513513513509}]
["/blog/the-5-most-viral-buzzfeed-posts-of-all-time/","2013-06-24",{"$f":"K7+L7+M7+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},1562.3917278935187,1350,12,53.6,400,0.97692307692307689,0.44666666666666666,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D7,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":26.229508196721312},4.4666666666666668,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":0.46153846153846212}]
["/blog/the-5-most-viral-posts-on-reddit/","2013-05-31",{"$f":"K8+L8+M8+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},1586.3917278935187,380,8,732.5,733,0.94444444444444442,1,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D8,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":21.05263157894737},10,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":1.1111111111111116}]
["/blog/how-to-write-a-good-article-pitch/","2015-12-11",{"$f":"K9+L9+M9+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},662.39172789351869,299,6,202.5,1448,0.93333333333333335,0.46616022099447513,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D9,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":18.181818181818183},4.6616022099447516,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":1.333333333333333}]
["/blog/good-content-in-boring-industries-the-car-loan-calculator/","2014-02-06",{"$f":"K10+L10+M10+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},1335.3917278935187,280,2,8.8000000000000007,429,0.82608695652173914,6.8376068376068383E-2,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D10,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":11.764705882352942},0.68376068376068377,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":3.4782608695652173}]
["/blog/value-of-content-marketing/","2017-03-24",{"$f":"K11+L11+M11+Table1[[#This Row],[Bounce Score]]","v":{"$error":"#NAME?"}},193.39172789351869,312,1,0,1073,1,0,{"$f":"PageViewScore(Table1[[#This Row],[Page Views]],view_max_value,view_rate)*SigDecay(D11,time_onset,time_decay,time_weight,1,0)","v":{"$error":"#NAME?"}},{"$f":"ActionScore(Table1[[#This Row],[Conversions]],clicks_max_value,clicks_rate,clicks_base_value)","v":10},0,{"$f":"(1-Table1[[#This Row],[Bounce Rate]])*bounce_weight","v":0}]

{"sheet":"Metrics Parameters","index":2,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Views",null,null,null,"Clicks",null,null,null,"Time Multiplier",null,null,null,"Read Coverage",null,null,"Bounce Rate"]
["Max Value","Upper bound limit",100,null,"Max Value","Upper bound limit",100,null,"Max Value",null,2,null,"Weight",10,null,"Weight",20]
["Target","Set this target to the pageviews you feel the majority of your content will receive, or below.",1000,null,"Base Value","Value when clicks is 1",10,null,"Decay Rate","How fast it falls from the max value to 1. The smaller the value, the slower it decause from Max to 1",10]
["Averages","Your average pageviews. The Media Shower platform averages all sites across our network, so you can see how your results compare.",{"$f":"(SUM(Table1[Page Views]))/(COUNT(Table1[Page Views]))","v":4063.7},null,"Target","Set this target to the clicks you feel the majority of your content will receive, or below.",50,null,"Onset","How many days before it starts dropping from max value",60]
[null,null,null,null,"Averages","Your average clicks. The Media Shower platform averages all sites across our network, so you can see how your results compare.",{"$f":"(SUM(Table1[Conversions]))/(COUNT(Table1[Conversions]))","v":128.9}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Views","Score",null,null,"Clicks","Score",null,null,"Days","Multiplier",null,null,"Read Coverage",null,null,"Bounce Rate"]
[10,{"$f":"PageViewScore(A21,view_max_value,view_rate)","v":0.99009900990099009},null,null,0,{"$f":"ActionScore(E21,clicks_max_value,clicks_rate,clicks_base_value)","v":0},null,null,1,{"$f":"SigDecay(I21,time_onset,time_decay,time_weight,1,0)","v":1.997268039236989},null,null,0,{"$f":"M21*read_weight","v":0},null,1,{"$f":"(1-P21)*bounce_weight","v":0}]
[100,9.0909090909090917,null,null,1,10,null,null,10,1.993307149075715,null,null,0.1,{"$f":"M22*read_weight","v":1},null,0.8,{"$f":"(1-P22)*bounce_weight","v":3.9999999999999991}]
[200,16.666666666666668,null,null,2,11.764705882352942,null,null,20,1.9820137900379085,null,null,0.5,{"$f":"M23*read_weight","v":5},null,0.5,{"$f":"(1-P23)*bounce_weight","v":10}]
[400,28.571428571428573,null,null,4,15.09433962264151,null,null,30,1.9525741268224333,null,null,1,{"$f":"M24*read_weight","v":10},null,0.2,{"$f":"(1-P24)*bounce_weight","v":16}]
[1000,50,null,null,8,21.05263157894737,null,null,40,1.8807970779778824,null,null,null,null,null,0,{"$f":"(1-P25)*bounce_weight","v":20}]
[2000,66.666666666666671,null,null,16,30.76923076923077,null,null,50,1.7310585786300048]
[4000,80,null,null,32,44.444444444444443,null,null,60,1.5]
[null,null,null,null,64,60.176991150442475,null,null,70,1.2689414213699952]
[null,null,null,null,128,74.576271186440678,null,null,80,1.1192029220221176]
[null,null,null,null,256,85.245901639344268,null,null,90,1.0474258731775667]
[null,null,null,null,{"$f":"E30*2","v":512},91.978609625668454,null,null,120,1.0024726231566348]
[null,null,null,null,null,null,null,null,160,1.0000453978687025]
[null,null,null,null,null,null,null,null,180,1.0000061441746022]
[null,null,null,null,null,null,null,null,360,1.0000000000000935]