{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Setup","Impressions by Keyword","Query Results","All Individual Words","ᴁ Analytics Edge Macros"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Setup","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Date","Website","Filter"]
[{"$f":"TEXT(TODAY()-2,\"yyyy-MM-dd\")","v":"2018-07-21"},"http://www.analyticsedge.com",2]
[]
[]
[]
[]
["This report requires the Analytics Edge Core Add-in and Connector for Google Search."]
[null,"Try them free for 30 days","link"]
[]
[]
["Instructions"]
[null,"the date is automatically calculated as 2 days ago, but you can change it"]
[null,"the date MUST be formatted as text and yyyy-MM-dd format"]
[null,"enter your Website in cell B2 above"]
[null,"modify the Filter value in cell C2 to eliminate low-impression queries"]
[null,"click the Analytics Edge Refresh All button to run the report"]
[]
[]
["The results of this report reflect the weekly period ending on the date specified. "]
["You can run the report for previous weeks, upto 90 days back."]

{"sheet":"Impressions by Keyword","index":1,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Soundex","Query","Clicks","Phrases"]

{"sheet":"Query Results","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"All Individual Words","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ᴁ Analytics Edge Macros","index":4,"n_rows":134,"n_cols":1,"rows_kept":134,"cut":false,"hidden":true,"merged":[]}
["refresh"]
["FUNCTION »ReadWorksheet Setup"]
["set worksheet=Setup"]
["set datarange=A1:C2"]
["set ranges=true"]
["Call ReadWorksheet"]
["FUNCTION »WT Search Analytics"]
["set account=*"]
["set use_siteurl_value=true"]
["set siteurl={Website}"]
["set query=no filter"]
["set queryValue="]
["set page=no filter"]
["set pageValue="]
["set country=no filter"]
["set device=no filter"]
["set searchtype=web"]
["set durationnumber=1"]
["set durationperiod=weeks"]
["set end={Date}"]
["set dimensions=query"]
["set sortorder=clicks"]
["set sortorder=impressions"]
["set sortorder=ctr"]
["set sortorder=position"]
["Call WebmasterTools.SearchAnalytics"]
["FUNCTION Arrange by position"]
["set byposition=true"]
["set rename=A Query"]
["set rename=B Clicks"]
["set rename=C Impressions"]
["set rename=D CTR"]
["set rename=E Position"]
["Call Arrange"]
["FUNCTION Filter"]
["set matchingrows=remove"]
["set removeemptyrows=true"]
["set filterexpression=Impressions ♦ Less Than ♦ [Filter]"]
["Call Filter"]
["FUNCTION «WriteToWorksheet Query Results"]
["set worksheet=Query Results"]
["Call WriteToWorksheet"]
["FUNCTION »ReadWorksheet Query Results"]
["set worksheet=Query Results"]
["Call ReadWorksheet"]
["FUNCTION Replace ([a-zA-Z]*).([a-zA-Z]*)"]
["set useregex=true"]
["set byposition=true"]
["set findtext=([a-zA-Z]*).([a-zA-Z]*)"]
["set replacetext=$1 $2"]
["set keycolumnletters=A"]
["Call Replace"]
["FUNCTION Split"]
["set spliton=delimiter"]
["set delimiter=Space"]
["set splitintorows=true"]
["set removeduplicates=true"]
["set byposition=true"]
["set keycolumnletters=A"]
["Call Split"]
["FUNCTION Duplicates"]
["set byposition=true"]
["set keycolumnletters=A"]
["set keepsingles=true"]
["set keepaggregates=true"]
["set textaggregation=First"]
["set dateaggregation=Latest"]
["set numericaggregation=Sum"]
["set ignorecase=true"]
["set addcount=true"]
["Call Duplicates"]
["FUNCTION Sort"]
["set method=specificcolumns"]
["set sortoption=B ♦ Values ♦ Descending ♦ ByPosition"]
["Call Sort"]
["FUNCTION Formula"]
["set formula==soundex({@A])"]
["set name=Soundex"]
["Call Formula"]
["FUNCTION «WriteToWorksheet All Individual Words"]
["set worksheet=All Individual Words"]
["Call WriteToWorksheet"]
["FUNCTION »ReadWorksheet All Individual Words"]
["set worksheet=All Individual Words"]
["Call ReadWorksheet"]
["FUNCTION Duplicates"]
["set keycolumnname=Soundex"]
["set keepsingles=true"]
["set keepaggregates=true"]
["set textaggregation=All (list)"]
["set dateaggregation=Latest"]
["set numericaggregation=Sum"]
["Call Duplicates"]
["FUNCTION Sort"]
["set method=specificcolumns"]
["set sortoption=C ♦ Values ♦ Descending ♦ ByPosition"]
["set sortoption=F ♦ Values ♦ Descending ♦ ByPosition"]
["Call Sort"]
["FUNCTION Arrange by name"]
["set byname=true"]
["set columnname=Query"]
["set columnname=Impressions"]
["set columnname=Clicks"]
["set columnname=Count"]
["set columnname=Soundex"]
["Call Arrange"]
["FUNCTION TableName is ThisWeek"]
["set table=ThisWeek"]
["Call TableName"]
["FUNCTION Arrange by name"]
["set byname=true"]
["set columnname=Soundex"]
["set columnname=Query"]
["set columnname=Clicks"]
["set columnname=Count"]
["set columnname=Impressions"]
["Call Arrange"]
["FUNCTION Arrange by position"]
["set byposition=true"]
["set rename=D Phrases"]
["set rename=E [Date]"]
["Call Arrange"]
["FUNCTION Update Worksheet Impressions by Keyword"]
["set worksheet=Impressions by Keyword"]
["set keycolumnname=Soundex"]
["set replaceempty=true"]
["set ignoreempty=true"]
["set addrows=true"]
["set addcolumns=true"]
["Call Update"]
["FUNCTION «WriteToWorksheet Impressions by Keyword"]
["set worksheet=Impressions by Keyword"]
["set preserveformat=true"]
["Call WriteToWorksheet"]