When running this script, it completes with nothing new written to the sheet. It is flawed. I will supply a portion of the contents of the spreadsheet below. After analyzing it, rewrite the script to fix the flaws.
Date Customer Search Term Impressions Clicks Click-Thru Rate (CTR) Cost Per Click (CPC) 7 Day Total Sales 
Jun 11, 2022 .75 gallon plant pot decorative 1 1 100.0000% $1.49 $0.00
Jul 01, 2022 "knoikos" + "expandable garden hose" 1 1 100.0000% $2.94 $0.00
Jun 18, 2022 @laila\_haidary：grills,vertical barbecue grills,charcoal bbq grill,smokeless grill,stainless steel portable bbq hanging stove,for indoor and outdoor 15 1 6.6667% $0.78 $0.00
Jun 20, 2022 @laila\_haidary:grills,vertical barbecue grills,charcoal bbq grill,smokeless grill,stainless steel portable bbq hanging stove,for indoor and outdoor 2 1 50.0000% $0.43 $0.00
Jun 21, 2022 🍖grill black portable folding grill barbecue charcoal grill for outdoor cooking camping bbq 1 1 100.0000% $0.77 $0.00
Jun 11, 2022 0 in plastic flower pots 1 1 100.0000% $1.08 $0.00
Jun 10, 2022 1 1/2 inch storage tray 1 1 100.0000% $0.55 $29.54
Jun 29, 2022 1 gallon black acrylic paint 4 1 25.0000% $0.69 $0.00
Jun 08, 2022 1 hole bathroom faucet 10 2 20.0000% $1.79 $0.00
Jun 16, 2022 1 hole bathroom faucet 2 1 50.0000% $1.18 $0.00
Jun 24, 2022 1 hole faucet plate 2 1 50.0000% $1.70 $0.00
Jun 25, 2022 1 hour enamel paint 1 1 100.0000% $0.26 $0.00
Jun 24, 2022 1 hour miracle paint 1 1 100.0000% $0.41 $13.81
Jun 25, 2022 1 inch deep silverware 1 1 100.0000% $0.61 $0.00
Jun 29, 2022 1 inch drawer organizer tray 1 1 100.0000% $0.61 $0.00
Jun 17, 2022 1 inch tall silverware organizer 1 1 100.0000% $0.26 $0.00
Jun 07, 2022 1 litre planter 1 1 100.0000% $0.78 $14.80
Jun 12, 2022 1 planter for indoor plants 3 2 66.6667% $0.41 $0.00
Jun 07, 2022 1 planter pots 1 1 100.0000% $0.78 $0.00
Jun 10, 2022 1.5 gallon planters 1 1 100.0000% $0.47 $0.00
Jun 18, 2022 1" pots 2 1 50.0000% $0.60 $0.00
Jun 24, 2022 1/2 pt acrylic outside paint 1 1 100.0000% $0.30 $0.00
Jun 16, 2022 10 1/2 silverware 1 1 100.0000% $0.51 $0.00
Jun 07, 2022 10 ceramic planters for indoor plants 2 1 50.0000% $0.78 $0.00
Jun 11, 2022 10 flower pots for indoor plants 1 1 100.0000% $0.51 $0.00
Jun 06, 2022 10 gallon planters for outdoor plants 1 1 100.0000% $0.78 $0.00
Jun 11, 2022 10 in ceramic pots for indoor plants 2 1 50.0000% $0.44 $0.00
Jun 07, 2022 10 in flower pot 8 1 12.5000% $0.40 $14.77
Jun 06, 2022 10 in flower pots for indoor plants 3 1 33.3333% $0.78 $0.00
Jun 12, 2022 10 in flower pots indoor 33 1 3.0303% $0.67 $0.00
Jun 12, 2022 10 in large planters for indoor plants 2 1 50.0000% $0.41 $0.00
Jun 08, 2022 10 in outdoor plant pot 2 1 50.0000% $0.91 $0.00
Jun 09, 2022 10 in plant pots 7 1 14.2857% $0.90 $0.00
Jun 06, 2022 10 in planters for indoor plants 9 1 11.1111% $0.78 $0.00
Jun 06, 2022 10 in planters for indoor plants with drainage 2 1 50.0000% $0.78 $0.00
Jun 01, 2022 10 in silverware organizer 5 1 20.0000% $0.83 $14.80
Jun 09, 2022 10 in white plant pot 1 1 100.0000% $0.69 $14.80
Jun 12, 2022 10 in white plant pot plastic 1 1 100.0000% $0.80 $0.00
Jun 07, 2022 10 inch 4 pack planters 1 1 100.0000% $0.33 $17.48

"""
이 스크립트를 실행하면 시트에 새로 작성된 내용이 없는 상태로 완료됩니다. 결함이 있습니다. 아래 스프레드시트 내용의 일부를 제공하겠습니다. 이를 분석한 후 스크립트를 다시 작성하여 결함을 수정하세요.날짜 고객 검색어 노출 수 클릭 수 클릭률(CTR) 클릭당 비용(CPC) 7일 총 판매액 Jun 11, 2022 .75갤런 화분 장식 1 1 100.0000% $1.49 $0.00Jul 01, 2022 "knoikos" + "확장형 정원 호스" 1 1 100.0000% $2.94 $0.00Jun 18, 2022 @laila\_haidary：그릴, 수직 바베큐 그릴, 숯불 바베큐 그릴, 무연 그릴, 스테인리스 스틸 휴대용 바베큐 행잉 스토브, 실내외용 15 1 6.6667% $0.78 $0.00Jun 20, 2022 @laila\_haidary:그릴, 수직 바베큐 그릴, 숯불 바베큐 그릴, 무연 그릴, 스테인리스 스틸 휴대용 바베큐 걸이 스토브, 실내 및 실외용 2 1 50.0000% $0.43 $0.00Jun 21, 2022 🍖그릴 블랙 휴대용 접이식 그릴 바베큐 숯불 그릴 야외 요리 캠핑 바베큐 용 1 1 100.0000% $ 0.77 $ 0.00Jun 11, 2022 0 플라스틱 화분 1 1 100.0000% $1.08 $0.00Jun 10, 2022 1 1/2인치 보관 트레이 1 1 100.0000% $0.55 $29.54Jun 29, 2022 1 갤런 검정 아크릴 페인트 4 1 25.0000% $0.69 $0.00Jun 08, 2022 1 홀 욕실 수전 10 2 20.0000% $1.79 $0.00Jun 16, 2022 1 홀 욕실 수전 2 1 50.0000% $1.18 $0.00Jun 24, 2022 1 홀 수도꼭지 플레이트 2 1 50.0000% $1.70 $0.00Jun 25, 2022 1시간 에나멜 페인트 1 1 100.0000% $0.26 $0.00Jun 24, 2022 1시간 미라클 페인트 1 1 100.0000% $0.41 $13.81Jun 25, 2022 1인치 깊은 은제품 1 1 100.0000% $0.61 $0.00Jun 29, 2022 1인치 서랍 정리 트레이 1 1 100.0000% $0.61 $0.00Jun 17, 2022 1인치 식기 정리함 1 1 100.0000% $0.26 $0.00Jun 07, 2022 1 리터 화분 1 1 100.0000% $0.78 $14.80Jun 12, 2022 실내 식물용 화분 1개 3 2 66.6667% $0.41 $0.00Jun 07, 2022 화분 1개 1 1 100.0000% $0.78 $0.00Jun 10, 2022 1.5갤런 화분 1 1 100.0000% $0.47 $0.00Jun 18, 2022 1" 화분 2 1 50.0000% $0.60 $0.00Jun 24, 2022 1/2pt 아크릴 외부 페인트 1 1 100.0000% $0.30 $0.00Jun 16, 2022 10 1/2 은식기 1 1 100.0000% $0.51 $0.00Jun 07, 2022 10 실내식물용 세라믹 화분 2 1 50.0000% $0.78 $0.00Jun 11, 2022 실내식물용 화분 10개 1 1 100.0000% $0.51 $0.00Jun 06, 2022 야외 식물용 10갤런 화분 1 1 100.0000% $0.78 $0.00Jun 11, 2022 10 실내 식물용 세라믹 화분 2 1 50.0000% $0.44 $0.00Jun 07, 2022 10 in 화분 8 1 12.5000% $0.40 $14.77Jun 06, 2022 10 실내식물용 화분 3 1 33.3333% $0.78 $0.00Jun 12, 2022 10 실내용 화분 33 1 3.0303% $0.67 $0.00Jun 12, 2022 10 실내 식물용 대형 화분 2 1 50.0000% $0.41 $0.00Jun 08, 2022 10 in 야외 화분 2 1 50.0000% $0.91 $0.00Jun 09, 2022 10 화분 7 1 14.2857% $0.90 $0.00Jun 06, 2022 10 실내 식물용 화분 9 1 11.1111% $0.78 $0.00Jun 06, 2022 10 배수가 있는 실내 식물용 화분 2 1 50.0000% $0.78 $0.00Jun 01, 2022 10 은식기 정리함 5 1 20.0000% $0.83 $14.80Jun 09, 2022 10 in 흰색 화분 1 1 100.0000% $0.69 $14.80Jun 12, 2022 10 in 흰색 화분 플라스틱 1 1 100.0000% $0.80 $0.00Jun 07, 2022 10인치 4팩 화분 1 1 100.0000% $0.33 $17.48"""