{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Directions","Analysis","Twitter Raw Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":1},"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":"Directions","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"In just a few simple steps, your Twitter analysis spreadsheet will be up and running."]
[]
[null,"1. Export your Twitter Analytics data"]
[null,"http://chrismakara.com/social-media/tweet-analytics/#analytics"]
[]
[null,"2. Paste the data from the export in the \"Twitter Raw Data\" file of this tab (Cell A2). Depending on how many rows of data you have, this could take awhile."]
[null,"http://chrismakara.com/social-media/tweet-analytics/#export"]
[]
[null,"3. View your analysis (Be sure to refresh the data on the \"Analysis\" tab)"]
[null,"http://chrismakara.com/social-media/tweet-analytics/#pivot"]
[]
[null,"That's it. If you get stuck, leave a comment in the post and I'll jump in to help out."]

{"sheet":"Analysis","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Date","(All)"]
[]
["Row Labels","Count of Tweet No URLs","Sum of impressions","Sum of retweets","Sum of replies","Sum of likes","Sum of url clicks","Average of engagement rate"]
["Grand Total"]

{"sheet":"Twitter Raw Data","index":2,"n_rows":2,"n_cols":46,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Tweet id","Tweet permalink","Tweet text","time","impressions","engagements","engagement rate","retweets","replies","likes","user profile clicks","url clicks","hashtag clicks","detail expands","permalink clicks","app opens","app installs","follows","email tweet","dial phone","media views","media engagements","promoted impressions","promoted engagements","promoted engagement rate","promoted retweets","promoted replies","promoted likes","promoted user profile clicks","promoted url clicks","promoted hashtag clicks","promoted detail expands","promoted permalink clicks","promoted app opens","promoted app installs","promoted follows","promoted email tweet","promoted dial phone","promoted media views","promoted media engagements","Short URL","Unshort URL","URL - Clean","Tweet No URL","Tweet No URLs","Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(MID(C2,FIND(\"http\",C2),IFERROR(FIND(\" \",C2,FIND(\"http\",C2))-1,LEN(C2))-FIND(\"http\",C2)+1),\"\")","v":""},{"$f":"IFERROR(unshorten(Table1[[#This Row],[Short URL]]),\"\")","v":""},{"$f":"IFERROR(LEFT(AP2,FIND(\"?\",AP2&\" \")-1),Table1[[#This Row],[Unshort URL]])","v":""},{"$f":"IFERROR(TRIM(SUBSTITUTE(C2,MID(C2,FIND(\"http\",C2),IFERROR(FIND(\" \",C2,FIND(\"http\",C2))-1,LEN(C2))-FIND(\"http\",C2)+1),\"[URL]\")),\"\")","v":""},{"$f":"TRIM(IFERROR(SUBSTITUTE(AR2,MID(AR2,FIND(\"http\",AR2),IFERROR(FIND(\" \",AR2,FIND(\"http\",AR2))-1,LEN(AR2))-FIND(\"http\",AR2)+1),\"[URL]\"),Table1[[#This Row],[Tweet No URL]]))","v":""},{"$f":"(IFERROR(DATEVALUE(LEFT(TRIM(TEXT(D2,\"yyyyy-mm-dd hh:mm:ss\")),FIND(\" +0000\",TRIM(TEXT(D2,\"yyyyy-mm-dd hh:mm:ss\"))&\" \")-1)),\"\"))*1","v":{"$error":"#VALUE!"}}]