{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Sponsored Products","Sponsored Brands","Sponsored Display","Command Center","SP Past Data","SP Recent Data","SB Past Data","SB Recent Data","SD Past Data","SD Recent Data","Command Center 2","Version Notes"],"not_rendered":{"charts":0,"images":0,"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":"Sponsored Products","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sponsored Brands","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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

{"sheet":"Command Center","index":3,"n_rows":19,"n_cols":71,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,4,4,9],[4,15,4,23],[4,26,4,28],[4,30,4,32],[4,60,4,62],[4,64,4,66],[4,68,4,70],[14,20,14,22],[16,20,16,22],[18,16,18,17],[18,20,18,22],[6,5,6,6],[8,5,8,6],[10,5,10,6],[12,5,12,6],[12,20,12,22],[14,5,14,6],[16,5,16,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Target ACOS ",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by",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,"Total Ad Spend"]
[]
[null,null,null,null,null,"Low Impressions",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by",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,"Wasted Ad Spend",null,null,{"$f":"IFERROR(BI9/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM9/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ9/BQ7,\"\")","v":""}]
[]
[null,null,null,null,null,"High Clicks",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by",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,"High Clicks and No Sales",null,null,{"$f":"IFERROR(BI11/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM11/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ11/BQ7,\"\")","v":""}]
[]
[null,null,null,null,null,"High Spend",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"Low Impressions, Increase bid by",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,"High ACOS",null,null,{"$f":"IFERROR(BI13/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM13/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ13/BQ7,\"\")","v":""}]
[]
[null,null,null,null,null,"Max Bid ($)",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"Zero Impressions, Increase bid by",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,"Within Target",null,null,{"$f":"IFERROR(BI15/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM15/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ15/BQ7,\"\")","v":""}]
[]
[null,null,null,null,null,"Symbol",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"High Clicks & Spend with no Sales, Reduce bid by",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,"Low ACOS",null,null,{"$f":"IFERROR(BI17/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM17/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ17/BQ7,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clicks and Spend with no Sales, Reduce bid by",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,"In Betweens",null,null,{"$f":"IFERROR(BI19/BI7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BM19/BM7,\"\")","v":""},null,null,null,{"$f":"IFERROR(BQ19/BQ7,\"\")","v":""}]

{"sheet":"SP Past Data","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SP Recent Data","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SB Past Data","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SB Recent Data","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SD Past Data","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SD Recent Data","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Command Center 2","index":10,"n_rows":34,"n_cols":23,"rows_kept":34,"cut":false,"hidden":true,"merged":[[4,4,4,9],[4,15,4,23],[4,26,4,28],[4,30,4,32],[6,5,6,6],[8,5,8,6],[10,5,10,6],[16,5,16,6],[25,1,25,2],[29,1,29,2],[33,1,33,2],[12,5,12,6],[12,20,12,22],[14,5,14,6],[14,20,14,22],[16,20,16,22],[18,16,18,17],[18,20,18,22]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Target ACOS ",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by"]
[]
[null,null,null,null,null,"Low Impressions",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by"]
[]
[null,null,null,null,null,"High Clicks",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"If ACOS <",null,"Increase bid by"]
[]
[null,null,null,null,null,"High Spend",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"Low Impressions, Increase bid by"]
[]
[null,null,null,null,null,"Max Bid",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"Zero Impressions, Increase bid by"]
[]
[null,null,null,null,null,"Symbol",null,null,null,null,null,null,null,null,null,"If ACOS >",null,"Reduce bid by",null,null,"High Clicks & Spend with no Sales, Reduce bid by"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clicks with no Orders, Reduce Bid by"]
[]
[]
[]
[]
[null,"SP WASTED AD SPEND",null,{"$f":"SUMIF(#REF!,\"=0\",#REF!)","v":"#N/A"}]
[null,"SP TOTAL AD SPEND",null,{"$f":"SUM(#REF!)","v":"#REF!"}]
[null,"SPEED TEST (WASTED/TOTAL)",null,{"$f":"D24/D25","v":"#N/A"}]
[]
[null,"SB WASTED AD SPEND",null,{"$f":"SUMIF(#REF!,\"=0\",#REF!)","v":"#N/A"}]
[null,"SB TOTAL AD SPEND",null,{"$f":"SUM(#REF!)","v":"#REF!"}]
[null,"SPEED TEST (WASTED/TOTAL)",null,{"$f":"D28/D29","v":"#N/A"}]
[]
[null,"SD WASTED AD SPEND",null,{"$f":"SUMIF(#REF!,\"=0\",#REF!)","v":"#N/A"}]
[null,"SD TOTAL AD SPEND",null,{"$f":"SUM(#REF!)","v":"#REF!"}]
[null,"SPEED TEST (WASTED/TOTAL)",null,{"$f":"D32/D33","v":"#N/A"}]

{"sheet":"Version Notes","index":11,"n_rows":50,"n_cols":2,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Version 1.7.3"]
[]
[null,"Added"]
[null,"Copy Sheets Button - Copy data and create new sheet for each Ad type "]
[null,"Clear Sheets Button - Clears data on each of three sheets"]
[null,"Clear Fields Button - Clears Fields in Parameters and Bid Adjustments"]
[null,"Max Bid Field - Can now set Max bid to avoid overbidding. "]
[]
[null,"Removed"]
[null,"Pause Fields"]
[]
[null,"Version 1.7.4"]
[]
[null,"Clicks and Spend are optimized separately. But they still use the same Field in Adjustments"]
[null,"New Bids are optimized between CPC and Current Bid. For Reducing, the formula will lean"]
[null," towards the smaller value between CPC and Current Bid. For Increasing, The formula "]
[null,"will lean more towards the higher value between CPC and Current Bid"]
[]
[null,"Version 1.7.6"]
[]
[null,"Wasted Ad Spend has been included"]
[null,"Reverted formula to orginal which optimizes CPC only, except for Optimizing Low & Zero impressions which"]
[null,"optimizes current bid"]
[]
[null,"Version 1.7.7"]
[]
[null,"Compatible with Excel 2016 and below"]
[null,"Added option to optimize per Ad type or Optimize all in one go"]
[]
[null,"Version 1.7.8"]
[]
[null,"Compatible with the new Bulk File format"]
[null,"Includes Long and and Short Term Comparison Tool"]
[null,"Includes Variable Bidding where formula will choose between Bid or CPC "]
[null,"Can optimize the \"in betweens\""]
[]
[null,"Version 1.7.9"]
[]
[null,"Includes Numbers for Wasted AD Spend, High Clicks and No Sales, High ACOS, Low ACOS, In betweens"]
[]
[null,"Version 1.8.1"]
[]
[null,"Improved Numbers for Wasted AD Spend, High Clicks and No Sales, High ACOS, Low ACOS, In betweens"]
[null,"Added Max CPC in Comparison Sheets"]
[]
[null,"Version 1.8.3"]
[]
[null,"Target ACOS Column added in Optimization Sheets to have the ability to change MAX CPC per target"]
[null,"Removed Past Bid column in Comparisons Sheets"]