{"id":16800,"date":"2025-04-10T19:25:10","date_gmt":"2025-04-10T10:25:10","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16800"},"modified":"2025-08-18T18:43:48","modified_gmt":"2025-08-18T09:43:48","slug":"how-to-use-custom-queries-using-parameters","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/04\/10\/how-to-use-custom-queries-using-parameters\/","title":{"rendered":"\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 &#8211; \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218"},"content":{"rendered":"<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1\">1. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub780?<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2\">2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\uac04\ubcc4 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-1\">2-1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc900\ube44<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2\">2-2. \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec \ucd94\uac00<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-3\">2-3. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ucd94\uac00 \ubc29\ubc95<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-4\">2-4. \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc124\uc815<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-5\">2-5. \ucffc\ub9ac\ubb38 \uc791\uc131<\/a><ul><\/ul><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3\">3. \ub2e4\uc74c \ud3ec\uc2a4\ud2b8 \uc18c\uac1c<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 YoY(Year-over-Year) \ucc28\ud2b8\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc758 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uc120\ud0dd \uc5f0\ub3c4\uc640 \uc804\ub144\ub3c4\uc758 \ub9e4\ucd9c \ucd94\uc774, \uc6d4\ubcc4 \ub9e4\ucd9c\uacfc \uc99d\uac10\uc561, \uc99d\uac10\ub960\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ucc28\ud2b8\ub97c \uc0dd\uc131\ud558\uc600\uc9c0\uc694. \uc774\ub807\uac8c \ud2b9\uc815 \uae30\uac04\uc758 \uc131\uacfc\ub97c \uc774\uc804\uc758 \uae30\uac04\uacfc \ube44\uad50\ud558\uba74, \uacc4\uc808\uc801 \uc694\uc778\uc774\ub098 \ub9c8\ucf00\ud305 \uc804\ub7b5\uc758 \uc131\uacfc, \uc2dc\uc7a5 \ubcc0\ud654\ub85c \uc778\ud55c \uc601\ud5a5\uc744 \uc774\ud574\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"716\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image01-1024x716.png\" alt=\"\" class=\"wp-image-16801\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image01-1024x716.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image01-300x210.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image01-768x537.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image01.png 1058w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p> <br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1YoY(Year-over-Year)\ucc28\ud2b8\uc640 \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uad81\uae08\ud558\uc2dc\ub2e4\uba74 \uc544\ub798\uc758 \uc774\uc804 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%ea%b8%b0%eb%b3%b8-%eb%b9%84%ea%b5%90-%ea%b8%b0%eb%8a%a5\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \uae30\ubcf8 \ube44\uad50 \uae30\ub2a5<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/11\/21\/%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%ec%97%90%ec%84%9c-yoy-year-over-year-%ea%b5%ac%ed%98%84%ed%95%98%ea%b8%b0-%eb%b9%85%ec%bf%bc%eb%a6%ac%eb%a5%bc-%ec%9d%91%ec%9a%a9%ed%95%9c\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c YoY (Year-over-Year) \uad6c\ud604\ud558\uae30: \ube45\ucffc\ub9ac\ub97c \uc751\uc6a9\ud55c \ube44\uad50<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\ub294 \uae30\uac04 \ubcc4\ub85c \ub2e4\uc591\ud55c \uc218\uce58\ub4e4\uc744 \ube44\uad50\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774 \ub0b4\uc7ac\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ubc88\uc5d0\ub294 \ub2e4\uc591\ud55c \uae30\ub2a5 \uc911\uc5d0 \u2018<strong>\ub9de\ucda4 \ucffc\ub9ac<\/strong>\u2019 \ub610\ub294 \u2018<strong>\ucee4\uc2a4\ud140 \ucffc\ub9ac<\/strong>\u2019\ub77c\uace0 \ud558\ub294 \uae30\ub2a5\uc744 \uc0b4\ud3b4\ubcf4\uace0\uc790 \ud569\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac\ub77c\uace0 \ubd80\ub974\ub294 \uc774\uc720\ub294 SQL\ubb38\uc744 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc791\uc131\ud55c \ub4a4\uc5d0, \ube45\ucffc\ub9ac\ub85c \ubcf4\ub0b4\uc5b4 \uc2e4\ud589\ud55c \uacb0\uacfc\ub97c \ubc1b\uc544\uc624\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<br><\/p>\n\n\n\n<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc120\ud0dd \uc5f0\ub3c4\uc758 \ub9e4\ucd9c\uacfc 1\ub144 \uc804 \ub9e4\ucd9c\uc744 \ud558\ub098\uc758 \ud589\uc5d0 \ub9e4\uce6d \ud6c4 \ucffc\ub9ac\uc758 \uacb0\uacfc\ub97c \ud14c\uc774\ube14\uc5d0 \uc800\uc7a5\ud558\uc5ec \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4. \uc989, \uc774\uac83\uc740 \uc815\uc801\uc778 \ub370\uc774\ud130\ub97c \ubd88\ub7ec\uc624\ub294 \uac83\uc774\uc9c0\uc694. <strong><span style=\"text-decoration: underline;\">\uadf8\ub7f0\ub370 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc740 \ub9e4\uac1c\ubcc0\uc218\ub97c \ub123\uc5b4\uc11c \ub370\uc774\ud130\ub97c \ub3d9\uc801\uc73c\ub85c \ubd88\ub7ec\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/strong> \uc624\ub298\uc740 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uace0, \uc608\uc2dc\ub97c \ud1b5\ud574 \uc2e4\uc81c \ud65c\uc6a9 \uc0ac\ub840\ub97c \uc18c\uac1c\ud558\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-1\">1. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub780?<\/h2>\n\n\n\n<p><br>\ub9de\ucda4 \ucffc\ub9ac\ub294 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc73c\ub85c, \uc0ac\uc6a9\uc790\uac00 \uc9c1\uc811 SQL\ubb38\uc744 \uc791\uc131\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \ucd94\ucd9c\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4. \ub9cc\uc57d \ub370\uc774\ud130\ub97c \ub2e8\uc9c0 \uc77c\ubc29\uc801\uc73c\ub85c \ubd88\ub7ec\uc624\uae30\ub9cc \ud558\ub294 \uac83\uc774\ub77c\uba74 \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud560 \ud544\uc694\ub294 \uc5c6\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc <strong><mark style=\"background-color:#fffd79\" class=\"has-inline-color\">\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub9e4\uac1c\ubcc0\uc218\ub97c \uc804\ub2ec\ud558\uace0 \uc5f0\uc0b0\ud558\ub294 \uacfc\uc815\uc744 \uac70\uccd0 \ub370\uc774\ud130\ub97c \ubd88\ub7ec\uc640\uc57c \ud55c\ub2e4\uba74 \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc801\uc808\ud55c \ubc29\uc2dd\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/mark><\/strong><br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uad6c\uae00\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc758 \ub9de\ucda4 \ucffc\ub9ac\uc5d0 \ub300\ud55c \ub808\ud37c\ub7f0\uc2a4\ub294 \uc544\ub798 \ub9c1\ud06c\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/use-parameters-in-a-custom-query?hl=ko&amp;visit_id=638798763494343492-923902725&amp;rd=1\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/nubosoft-google-cloud-5.webp\" alt=\"\" class=\"wp-image-16837\" style=\"width:231px;height:auto\"\/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/support.google.com\/looker-studio\/answer\/10588439?hl=ko\" target=\"_blank\" rel=\"noopener\" title=\"\ub9de\ucda4 \ucffc\ub9ac\uc5d0 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9\ud558\uae30 - \ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624 \ub3c4\uc6c0\ub9d0\">\ub9de\ucda4 \ucffc\ub9ac\uc5d0 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9\ud558\uae30 &#8211; \ub370\uc774\ud130 \uc2a4\ud29c\ub514\uc624 \ub3c4\uc6c0\ub9d0<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 <strong>\uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790 \ub9e4\uac1c\ubcc0\uc218<\/strong>\ub97c \uc804\ub2ec\ud574\uc11c \uc120\ud0dd \uae30\uac04\uacfc \uc5ec\ub7ec \ube44\uad50 \uae30\uac04\uc758 \ub9e4\ucd9c\uc744 \uac00\uc838\uc624\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcfc\uae4c\uc694?<\/p>\n\n\n\n<p>\uc544\ub798\uc758 \ub3c4\uc2dd\uc5d0 \uc788\ub294 \ub9de\ucda4 \ucffc\ub9ac\ub294 \uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790 \ub9e4\uac1c\ubcc0\uc218\ub97c \uae30\uc900\uc73c\ub85c 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \uae30\uac04\uc744 \uc5f0\uc0b0\ud569\ub2c8\ub2e4. \uadf8 \ud6c4\uc5d0\ub294 \uac01 \uae30\uac04\uc5d0 \ud574\ub2f9\ud558\ub294 \ub9e4\ucd9c\uc744 \ubd88\ub7ec\uc635\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"289\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1024x289.png\" alt=\"\" class=\"wp-image-16802\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1024x289.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-300x85.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-768x217.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1.png 1514w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><strong>\uc2e4\uc81c\ub85c \uc791\ub3d9\ud558\ub294 \uc608\uc2dc \ud654\uba74\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n<p>2025\ub144 1\uc6d4 1\uc77c ~ 2025\ub144 1\uc6d4 31\uc77c\ub85c \uae30\uac04\uc744 \uc120\ud0dd\ud558\uba74, \uc120\ud0dd \uae30\uac04\uc758 \uc77c\uc790\ubcc4 \ub9e4\ucd9c\uacfc \uacfc\uac70 \uc2dc\uc810\uc758 \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ucc28\ud2b8\uc785\ub2c8\ub2e4. \uac01\uac01\uc758 \ud589\uc740 \uc120\ud0dd\ud55c \uae30\uac04\uacfc \ub3d9\uc77c\ud55c \uc77c\uc790\uc758 \uc791\ub144, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \uc77c\uc790\uc758 \ub9e4\ucd9c\uc744 \ubcf4\uc5ec\uc8fc\uace0 \uc788\uc9c0\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"450\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1024x450.png\" alt=\"\" class=\"wp-image-16803\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1024x450.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-300x132.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-768x338.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1536x675.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2.png 1594w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc2e4\uc81c\ub85c \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub294 \ud654\uba74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. (\uc608\uc2dc\uc5d0\uc11c \ud65c\uc6a9\ud55c \ucffc\ub9ac\ub97c \uadf8\ub300\ub85c \ubcf4\uc5ec\uc8fc\uba74 \ubcf5\uc7a1\ud558\ub2c8 \uc774\ud574\ub97c \ub3d5\uae30 \uc704\ud574 \uac04\ub2e8\ud558\uac8c \uc791\uc131\ud558\uc600\uc2b5\ub2c8\ub2e4.) \uc2dc\uc791 \ub0a0\uc9dc\uc640 \uc885\ub8cc \ub0a0\uc9dc\ub97c \ub9e4\uac1c\ubcc0\uc218\ub85c \ubc1b\uc544\uc11c \uadf8 \uae30\uac04\uc5d0 \ud574\ub2f9\ud558\ub294 \ubc94\uc704\uc758 \ub370\uc774\ud130\ub9cc \ubd88\ub7ec\uc624\uac8c \ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1025\" height=\"268\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3.png\" alt=\"\" class=\"wp-image-16804\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3.png 1025w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3-300x78.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3-768x201.png 768w\" sizes=\"auto, (max-width: 1025px) 100vw, 1025px\" \/><\/figure>\n\n\n\n<p><br>\uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218\ub098 \uc9c1\uc811 \uc815\uc758\ud55c \ub9e4\uac1c\ubcc0\uc218\ub4e4\uc744 \ub9de\ucda4 \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9e4\uac1c\ubcc0\uc218\ub4e4\uc740 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\ub098 \ub4dc\ub86d\ub2e4\uc6b4 \ub4f1\uc758 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uc5ec \uac04\ud3b8\ud558\uac8c \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"725\" height=\"344\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4.png\" alt=\"\" class=\"wp-image-16805\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4.png 725w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-300x142.png 300w\" sizes=\"auto, (max-width: 725px) 100vw, 725px\" \/><\/figure>\n\n\n\n<p><br>\ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\uc600\uc73c\ub2c8 \uc2e4\uc81c\ub85c \uc608\uc2dc\uc5d0 \uc788\ub294 \ucc28\ud2b8\ub97c \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc18c\uac1c\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac\ub294 \ub2e4\uc591\ud55c \ub9e4\uac1c\ubcc0\uc218\ub97c \ubc1b\uc744 \uc218 \uc788\uc9c0\ub9cc \uc774\ubc88\uc5d0\ub294 \u2018<strong>\uae30\uac04 \ucee8\ud2b8\ub864\ub7ec<\/strong>\u2019\ub97c \ud65c\uc6a9\ud558\uc5ec \ub0a0\uc9dc \ubcc0\uc218\ub85c \ub9de\ucda4 \ucffc\ub9ac\ub97c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcfc \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2\">2. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac)\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\uac04\ubcc4 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/h2>\n\n\n\n<p><br>\uc624\ub298 \uc644\uc131\ud560 \ub300\uc2dc\ubcf4\ub4dc\ub97c \ub2e4\uc2dc \ud55c\ubc88 \uc0b4\ud3b4\ubcfc\uae4c\uc694? \uc544\ub798 \uc774\ubbf8\uc9c0\uc5d0 \ud45c\uc2dc\ub41c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\ub85c \uae30\uac04\uc744 \uc120\ud0dd\ud558\uba74 \ub2e4\uc74c\uc758 \ub370\uc774\ud130\ub4e4\uc744 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\uc120\ud0dd \uae30\uac04\uc758 \uc77c\uc790\ubcc4 \ub9e4\ucd9c<\/li>\n\n\n\n<li>\uc791\ub144 \ub3d9\uc77c\ud55c \uc77c\uc790\uc758 \ub9e4\ucd9c<\/li>\n\n\n\n<li>1\uac1c\uc6d4 \uc804 \ub3d9\uc77c\ud55c \uc77c\uc790\uc758 \ub9e4\ucd9c<\/li>\n\n\n\n<li>2\uac1c\uc6d4 \uc804 \ub3d9\uc77c\ud55c \uc77c\uc790\uc758 \ub9e4\ucd9c<\/li>\n\n\n\n<li>3\uac1c\uc6d4 \uc804 \ub3d9\uc77c\ud55c \uc77c\uc790\uc758 \ub9e4\ucd9c<br><br><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"470\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1024x470.png\" alt=\"\" class=\"wp-image-16806\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1024x470.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-300x138.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-768x353.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1536x705.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5.png 1588w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\uc81c \ub2e8\uacc4\ubcc4\ub85c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-1\">2-1. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc900\ube44<\/h3>\n\n\n\n<p><br>\ub2e4\uc74c\uacfc \uac19\uc740 \uad6c\uae00 \uc2dc\ud2b8\uc758 \ud310\ub9e4 \ub370\uc774\ud130\ub97c \ube45\ucffc\ub9ac\uc5d0 \uc800\uc7a5\ud558\uc600\uc2b5\ub2c8\ub2e4. \ud14c\uc774\ube14\uba85\uc740 \u2018LS_salesData\u2019 \ub85c \uc815\uc758\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"530\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1024x530.png\" alt=\"\" class=\"wp-image-16807\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1024x530.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-300x155.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-768x397.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1536x794.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6.png 1916w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\uad6c\uae00 \uc2dc\ud2b8\uc758 \ub370\uc774\ud130<\/figcaption><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"505\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1024x505.png\" alt=\"\" class=\"wp-image-16808\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1024x505.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-300x148.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-768x379.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1536x758.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7.png 1905w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">\ube45\ucffc\ub9ac\uc758 \ub370\uc774\ud130<\/figcaption><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uad6c\uae00 \uc2dc\ud2b8\ub97c \ube45\ucffc\ub9ac\uc640 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95\uc740 \uc9c0\ub09c \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2024\/02\/05\/%ec%8a%a4%ed%94%84%eb%a0%88%eb%93%9c%ec%8b%9c%ed%8a%b8-%eb%8d%b0%ec%9d%b4%ed%84%b0%eb%a5%bc-%eb%b9%85%ec%bf%bc%eb%a6%ac%ec%99%80-%eb%a3%a8%ec%bb%a4-%ec%8a%a4%ed%8a%9c%eb%94%94%ec%98%a4%eb%a1%9c\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8 \ub370\uc774\ud130\ub97c \ube45\ucffc\ub9ac\uc640 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub85c \uc2dc\uac01\ud654\ud558\uae30<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-2\">2-2. \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec \ucd94\uac00<\/h3>\n\n\n\n<p><br>\uc218\uc815 \ud654\uba74\uc5d0\uc11c \uc0c1\ub2e8\uc758 \u2018<strong>\ucee8\ud2b8\ub864 \ucd94\uac00<\/strong>\u2019 \u2192 \u2018<strong>\uae30\uac04 \ucee8\ud2b8\ub864<\/strong>\u2019\uc744 \uc120\ud0dd\ud558\uc5ec \uc801\uc808\ud55c \uacf3\uc5d0 \ubc30\uce58\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"560\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1024x560.png\" alt=\"\" class=\"wp-image-16809\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1024x560.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-300x164.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-768x420.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8.png 1325w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-3\"><br>2-3. \ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ucd94\uac00 \ubc29\ubc95<\/h3>\n\n\n\n<p><br>\uc0c1\ub2e8\uc758 \u2018<strong>\ub9ac\uc18c\uc2a4<\/strong>\u2019 \u2192 \u2018<strong>\ucd94\uac00\ub41c \ub370\uc774\ud130 \uc18c\uc2a4 \uad00\ub9ac<\/strong>\u2019 \ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4. \uc774 \uba54\ub274\ub294 \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \uc5f0\uacb0\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ud655\uc778\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"428\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-10-1024x428.png\" alt=\"\" class=\"wp-image-16810\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-10-1024x428.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-10-300x126.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-10-768x321.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-10.png 1035w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ub370\uc774\ud130 \uc18c\uc2a4 \uad00\ub9ac \ud654\uba74\uc774 \ub098\uc624\uba74 \ud558\ub2e8\uc5d0 \uc788\ub294 \u2018<strong>\ub370\uc774\ud130 \uc18c\uc2a4 \ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"256\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11-1024x256.png\" alt=\"\" class=\"wp-image-16811\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11-1024x256.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11-300x75.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11-768x192.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11-1536x384.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-11.png 1556w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ube45\ucffc\ub9ac(BigQuery)\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"620\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-12-1024x620.png\" alt=\"\" class=\"wp-image-16812\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-12-1024x620.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-12-300x182.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-12-768x465.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-12.png 1391w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\ub294 \uad6c\uae00 \uc2a4\ud504\ub808\ub4dc\uc2dc\ud2b8, \ube45\ucffc\ub9ac(BigQuery), MySQL, PostgreSQL, \uad6c\uae00 \uc560\ub110\ub9ac\ud2f1\uc2a4 \ub4f1 \ub2e4\uc591\ud55c \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc9c0\uc6d0\ud558\ub294 \ub2e4\uc591\ud55c \ucee4\ub125\ud130\ub97c \uc54c\uc544\ubcf4\uace0 \uc2f6\ub2e4\uba74 \uc544\ub798\uc758 \ub808\ud37c\ub7f0\uc2a4\uc5d0 \uc811\uc18d\ud574\ubcf4\uc2dc\uae30 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/support.google.com\/looker-studio\/topic\/9281288?visit_id=638738826602933221-2279077141&amp;rd=1\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"392\" height=\"129\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/Google-1.png\" alt=\"\" class=\"wp-image-16844\" style=\"width:332px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/Google-1.png 392w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/Google-1-300x99.png 300w\" sizes=\"auto, (max-width: 392px) 100vw, 392px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/support.google.com\/looker-studio\/topic\/9281288?visit_id=638738826602933221-2279077141&amp;rd=1\" target=\"_blank\" rel=\"noopener\" title=\"support.google.com\">support.google.com<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><a href=\"https:\/\/support.google.com\/looker-studio\/topic\/9281288?visit_id=638738826602933221-2279077141&amp;rd=1\"><\/a><\/p>\n\n\n\n<p>\ube45\ucffc\ub9ac\ub97c \ud074\ub9ad\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ud654\uba74\uc774 \ub098\uc635\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac\ub97c \uc138\ud305\ud558\ub294 \uacf3\uc740 \u2018<strong>\ub9de\ucda4 \uac80\uc0c9\uc5b4<\/strong>\u2019 \ud0ed\uc785\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \ud1b5\ud574 \uc9c1\uc811 SQL \ucffc\ub9ac\ub97c \uc785\ub825\ud558\ub294 \uac83\uc774\uc9c0\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"917\" height=\"627\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-13.png\" alt=\"\" class=\"wp-image-16813\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-13.png 917w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-13-300x205.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-13-768x525.png 768w\" sizes=\"auto, (max-width: 917px) 100vw, 917px\" \/><\/figure>\n\n\n\n<p><br>\u2018<strong>\ub9de\ucda4 \uac80\uc0c9\uc5b4<\/strong>\u2019\ub97c \ud074\ub9ad\ud558\uba74 \uc6b0\uce21\uc5d0 \uc0ac\uc6a9\uc790\uc758 \uad6c\uae00 \ud074\ub77c\uc6b0\ub4dc \ub0b4 \ube45\ucffc\ub9ac \ud504\ub85c\uc81d\ud2b8\uc758 \ubaa9\ub85d\uc774 \ub098\uc635\ub2c8\ub2e4. \ud504\ub85c\uc81d\ud2b8\ub97c \uc120\ud0dd\ud558\uba74 \uc544\ub798 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uc6b0\uce21\uc5d0 \ub9de\ucda4 \ucffc\ub9ac \uc785\ub825\ucc3d\uc774 \ub098\uc624\ub294\ub370, \uc774 \uc785\ub825\ucc3d\uc5d0 \ucffc\ub9ac\ub97c \uc785\ub825\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"591\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-14-1024x591.png\" alt=\"\" class=\"wp-image-16814\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-14-1024x591.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-14-300x173.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-14-768x443.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-14.png 1446w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \ube45\ucffc\ub9ac \ub370\uc774\ud130\ub97c \uc5f0\ub3d9\ud560 \ub54c\uc5d0 \ub098\uc624\ub294 \ud504\ub85c\uc81d\ud2b8 \uba85(\uc608\uc2dc\uc5d0\uc11c\ub294 \u2018share\u2019)\uc740 \uad6c\uae00 \ud074\ub77c\uc6b0\ub4dc\uc5d0\uc11c \uc815\uc758\ud588\ub358 \ud504\ub85c\uc81d\ud2b8 \uba85\uc744 \ub73b\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1347\" height=\"541\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-15-1.png\" alt=\"\" class=\"wp-image-16817\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-15-1.png 1347w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-15-1-300x120.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-15-1-1024x411.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-15-1-768x308.png 768w\" sizes=\"auto, (max-width: 1347px) 100vw, 1347px\" \/><\/figure>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-4\">2-4. \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc124\uc815<\/h3>\n\n\n\n<p><br>\ucffc\ub9ac \uc785\ub825 \ucc3d\uc5d0\uc11c \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\ub824\uba74 \ubcc4\ub3c4 \uc124\uc815\uc774 \ud544\uc694\ud569\ub2c8\ub2e4. \uc55e\uc11c \ub300\uc2dc\ubcf4\ub4dc\uc5d0 \ucd94\uac00\ud588\ub358 \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc5d0\uc11c \uc120\ud0dd\ud55c \uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790\ub97c \ub9e4\uac1c\ubcc0\uc218\ub85c \uc0ac\uc6a9\ud558\ub824\uba74 \ub9de\ucda4 \ucffc\ub9ac \uc785\ub825 \ucc3d \ud558\ub2e8\uc758 \u2018<strong>\uae30\uac04 \ub9e4\uac1c\ubcc0\uc218 \uc0ac\uc6a9 \uc124\uc815<\/strong>\u2019 \uc744 \uccb4\ud06c\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub807\uac8c \ud558\uba74 \uc544\ub798 \uc774\ubbf8\uc9c0\uc758 2\ubc88\ucc98\ub7fc \uc2dc\uc791 \uc77c\uc790\uc640 \uc885\ub8cc \uc77c\uc790\ub97c \ucffc\ub9ac\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d SQL \uc2dd\ubcc4\uc790\ub97c \uc54c\ub824\uc8fc\uba70, \uc774 \uc2dd\ubcc4\uc790\ub97c \ud65c\uc6a9\ud558\uc5ec \ucffc\ub9ac\ubb38\uc744 \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc2dc\uc791 \uc77c\uc790\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">@DS_START_DATE<\/mark><\/code><\/strong>, \uc885\ub8cc \uc77c\uc790\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">@DS_END_DATE<\/mark><\/code><\/strong> \ub85c \uc815\uc758\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"943\" height=\"636\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-16-1.png\" alt=\"\" class=\"wp-image-16818\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-16-1.png 943w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-16-1-300x202.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-16-1-768x518.png 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/figure>\n\n\n\n<p><br>\uae30\ubcf8 \uc124\uc815\uc744 \ub9c8\ucce4\uc73c\ub2c8 \ucffc\ub9ac\ubb38\uc744 \uc791\uc131\ud574\ubcfc\uae4c\uc694?<br><br><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"aioseo-2-5\">2-5. \ucffc\ub9ac\ubb38 \uc791\uc131<\/h3>\n\n\n\n<p><br>\ucffc\ub9ac\uc758 \uc8fc\uc694 \ubaa9\ud45c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc120\ud0dd \uae30\uac04\uc758 \uc77c\uc790\ubcc4 \ub9e4\ucd9c \ub370\uc774\ud130 \ubd88\ub7ec\uc624\uae30<\/strong><\/li>\n\n\n\n<li><strong>\uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub3d9 \uae30\uac04\uc758 \ub9e4\ucd9c\uc744 \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30<\/strong><\/li>\n\n\n\n<li><strong>\ube44\uad50 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \ubd88\ub7ec\uc628 \ub370\uc774\ud130\ub4e4\uc744 \uc77c\uc790\ubcc4 \ud558\ub098\uc758 \ud589\uc73c\ub85c \ud1b5\ud569\ud558\uae30<\/strong><\/li>\n<\/ol>\n\n\n\n<p>\uc544\ub798\ub294 \uc644\uc131\ub41c \uc804\uccb4 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc120\ud0dd \uae30\uac04\uc758 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nWITH currentData AS (\n    SELECT salesDate, SUM(revenue) AS currentRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) AND PARSE_DATE('%Y%m%d', @DS_END_DATE)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nlastYearData  AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, SUM(revenue) AS lastYearRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \noneMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, SUM(revenue) AS oneMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\ntwoMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, SUM(revenue) AS twoMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nthreeMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, SUM(revenue) AS threeMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n    GROUP BY salesDate\n)\n-- \uc804\uccb4 \uae30\uac04 \ub370\uc774\ud130 \ud1b5\ud569\ud558\uae30\nSELECT \n    COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n    COALESCE(c.currentRevenue, 0) AS currentRevenue,\n    COALESCE(l.lastYearRevenue, 0) AS lastYearRevenue,\n    COALESCE(m1.oneMonthAgoRevenue, 0) AS oneMonthAgoRevenue,\n    COALESCE(m2.twoMonthAgoRevenue, 0) AS twoMonthAgoRevenue,\n    COALESCE(m3.threeMonthAgoRevenue, 0) AS threeMonthAgoRevenue\nFROM currentData c\nFULL OUTER JOIN lastYearData l \n    ON c.salesDate = l.salesDate\nFULL OUTER JOIN oneMonthAgoData m1 \n    ON COALESCE(c.salesDate, l.salesDate) = m1.salesDate \nFULL OUTER JOIN twoMonthAgoData m2 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate) = m2.salesDate \nFULL OUTER JOIN threeMonthAgoData m3 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate \nORDER BY salesDate;\n<\/code><\/pre>\n\n\n\n<p><br>\ucffc\ub9ac\ub97c CTE\ubcc4\ub85c \ubd84\ub958\ud558\uc5ec \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<strong>CTE\ub780?<\/strong> CTE(Common Table Expression)\ub294 SQL\uc5d0\uc11c \uc784\uc2dc\ub85c \uc0dd\uc131\ud558\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4. \uc774\uac83\uc740 \ucffc\ub9ac\uc758 \uac00\ub3c5\uc131\uc744 \ub192\uc774\uace0 \uc7ac\uc0ac\uc6a9\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. WITH\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc815\uc758\ud569\ub2c8\ub2e4. \uc608\uc2dc\uc5d0\uc11c\ub294 \uac01 \uae30\uac04 \ubcc4\ub85c SELECT\ud558\ub294 \uad6c\ubb38\uc774 \uad04\ud638\ub85c \ubb36\uc5ec\uc788\ub294\ub370, \uc774 \ub2e8\uc704\ub4e4\uc744 CTE\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc804\uccb4 \ucf54\ub4dc\uc5d0\uc11c salesData, lastYearData \ub4f1\uc774 \ubaa8\ub450 CTE\uc785\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-1\"><strong>(1) \uc120\ud0dd \uae30\uac04\uc758 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/strong><br><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>salesData AS (\n    SELECT salesDate, SUM(revenue) AS currentRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) AND PARSE_DATE('%Y%m%d', @DS_END_DATE)\n    GROUP BY salesDate\n)<\/code><\/pre>\n\n\n\n<p><br>\u26a0\ufe0f \uc5ec\uae30\uc11c \uc2dc\uc791 \uc77c\uc790(<code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>@DS_START_DATE<\/strong><\/mark><\/code>)\uc640 \uc885\ub8cc \uc77c\uc790(<code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>@DS_END_DATE<\/strong><\/mark><\/code><\/code>) \ub9e4\uac1c\ubcc0\uc218\ub97c \uc870\uac74\ubb38 WHERE\uc808\uc5d0\uc11c \uc0ac\uc6a9\ud558\uc9c0\uc694? \ud574\ub2f9 \uae30\uac04\uc5d0 \uc18d\ud55c \ub370\uc774\ud130\ub9cc \ubd88\ub7ec\uc624\uae30 \uc704\ud55c \uc870\uac74\ubb38\uc744 \uc0ac\uc6a9\ud55c \uac83\uc778\ub370, \uc720\uc758\ud560 \uc810\uc740 <strong><span style=\"text-decoration: underline;\"><mark style=\"background-color:#fffd79\" class=\"has-inline-color\">\ub0a0\uc9dc\ub97c DATE\ud0c0\uc785\uc73c\ub85c \ud30c\uc2f1<\/mark><\/span><\/strong>\ud558\uc600\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uadf8 \uc774\uc720\ub294 \ubb34\uc5c7\uc77c\uae4c\uc694? \ucffc\ub9ac \uc785\ub825\ucc3d \ud558\ub2e8\uc758 \ub9e4\uac1c\ubcc0\uc218 \uc815\ubcf4\ub97c \ub2e4\uc2dc \ubcf4\uba74, \uc2dc\uc791\uc77c\uacfc \uc885\ub8cc\uc77c \uc2dd\ubcc4\uc790\uc758 SQL\uc720\ud615\uc740 STRING \ud615\ud0dc\ub85c, \ub0a0\uc9dc\ub97c \u2018YYYYMMDD\u2019 \ud615\uc2dd\uc73c\ub85c \ucde8\uae09\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"719\" height=\"141\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-17.png\" alt=\"\" class=\"wp-image-16819\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-17.png 719w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-17-300x59.png 300w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/figure>\n\n\n\n<p><br>\ud558\uc9c0\ub9cc \ucc38\uc870\ud558\ub294 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \ub0a0\uc9dc\ub294 DATE\ud0c0\uc785\uc73c\ub85c \uc800\uc7a5\ub418\uc5b4 \uc788\uc73c\ubbc0\ub85c \uc81c\uacf5\ud558\ub294 \ud30c\ub77c\ubbf8\ud130\uc758 \ub370\uc774\ud130 \ud0c0\uc785\ub3c4 DATE\ud0c0\uc785\uc73c\ub85c \ub3d9\uc77c\ud558\uac8c \ub9de\ucdb0\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. <code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>PARSE_DATE()<\/strong><\/mark><\/code><\/code><\/code> \ud568\uc218\uac00 \ubc14\ub85c \uadf8 \uc5ed\ud560\uc744 \uc218\ud589\ud558\ub294 \uac83\uc774\uc9c0\uc694.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"398\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-18-1024x398.png\" alt=\"\" class=\"wp-image-16820\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-18-1024x398.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-18-300x117.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-18-768x299.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-18.png 1101w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1PARSE_DATE() \uad6c\ubb38\uc758 \uc0ac\uc6a9 \ubc29\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc790\uc138\ud55c \uc0ac\uc6a9 \ubc29\ubc95\uc740 \uad6c\uae00 \ud074\ub77c\uc6b0\ub4dc \ubb38\uc11c\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>PARSE_DATE(\ub0a0\uc9dc \ud615\uc2dd, \ubb38\uc790\uc5f4\ud615\uc2dd\uc758 \ub0a0\uc9dc)<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u2018\ub0a0\uc9dc \ud615\uc2dd\u2019\uc740 \u2018%Y-%m-%d\u2019, \u2018%m\/%d\/%Y\u2019 \ucc98\ub7fc, \uc81c\uacf5\ud558\ub294 STRING\uc758 \ud30c\uc2f1\ud560 \ub0a0\uc9dc \ud615\uc2dd\uc744 \uc785\ub825\ud569\ub2c8\ub2e4. %Y\ub294 4\uc790\ub9ac\uc758 \uc5f0\ub3c4, %m\uc740 2\uc790\ub9ac\uc758 \uc6d4, %d\ub294 2\uc790\ub9ac\uc758 \uc77c\uc744 \ub73b\ud569\ub2c8\ub2e4.<\/li>\n\n\n\n<li>\u2018\ubb38\uc790\uc5f4\ud615\uc2dd\uc758 \ub0a0\uc9dc\u2019\ub294 \ubcc0\ud658\ud560 \ubb38\uc790\uc5f4 \ub0a0\uc9dc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parsedate?hl=ko\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/nubosoft-google-cloud-3.webp\" alt=\"\" class=\"wp-image-16835\" style=\"width:210px;height:auto\"\/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/cloud.google.com\/looker\/docs\/studio\/parsedate?hl=ko\" target=\"_blank\" rel=\"noopener\" title=\"PARSE_DATE | Looker Studio | GoogleCloud\">PARSE_DATE | Looker Studio | GoogleCloud<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n<\/blockquote>\n\n\n\n<p><br><br><\/p>\n\n\n\n<p>\ub610\ud55c \ucd5c\uc885\uc801\uc73c\ub85c \uc77c\uc790\ubcc4 \ub9e4\ucd9c\uacfc \ube44\uad50 \ub9e4\ucd9c\uc744 \uacc4\uc0b0\ud558\uace0, \ud558\ub098\uc758 \ud589\uc73c\ub85c \uacb0\ud569\ud560 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac\uc758 \ub9c8\uc9c0\ub9c9 \uad6c\ubb38\uc5d0\ub294 <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>GROUP BY<\/strong><\/mark><\/code> \uc9d1\uacc4 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-2-1-1-2-3\"><strong>(2) \uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \ubd88\ub7ec\uc624\uae30<\/strong><br><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nlastYearData  AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, SUM(revenue) AS lastYearRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \noneMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, SUM(revenue) AS oneMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\ntwoMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, SUM(revenue) AS twoMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nthreeMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, SUM(revenue) AS threeMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n    GROUP BY salesDate\n)\n<\/code><\/pre>\n\n\n\n<p><br>\uc774 \uad6c\ubb38\uc5d0\uc11c salesDate\ub97c select\ud560 \ub54c\uc5d0\ub294 <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>DATE_ADD()<\/strong><\/mark><\/code> \ud568\uc218\ub97c, where \uc870\uac74\uc808\uc5d0\uc11c\ub294 <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>DATE_SUB()<\/strong><\/mark><\/code><\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 \ud568\uc218\ub294 \ud2b9\uc815 \ub0a0\uc9dc\uc5d0\uc11c \uc77c\uc815 \uae30\uac04(\uc5f0, \uc6d4, \uc77c)\uc744 \ube7c\uac70\ub098 \ub354\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1DATE_ADD(), DATE_SUB() \ud568\uc218\uc758 \uae30\ubcf8 \ubb38\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uac12\uc740 \uac00\uac10\ud558\uace0 \uc2f6\uc740 \uae30\uac04\uc758 \uc22b\uc790\uc774\uba70, \uc22b\uc790 \ub4a4\uc5d0\ub294 YEAR(\uc5f0), MONTH(\uc6d4), DAY(\uc77c) \ub4f1 \ub2e8\uc704\ub97c \uae30\uc785\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc8fc\uc758\ud560 \uc810\uc774 \uc788\ub294\ub370, INTERVAL 1 MONTH \uc640 \uac19\uc774 \uac1c\uc6d4 \ub2e8\uc704\ub85c \ub0a0\uc9dc\uc5d0 \ub354\ud558\uac70\ub098 \ube7c\uba74 \ub9d0\uc77c\uc774 \uc790\ub3d9\uc73c\ub85c \uc870\uc815\ub429\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 3\uc6d4 31\uc77c\uc5d0\uc11c 1\uac1c\uc6d4\uc744 \ube7c\uba74 2\uc6d4 31\uc77c\uc740 \uc5c6\uae30 \ub54c\ubb38\uc5d0 2\uc6d4 28\uc77c\ub85c \uc870\uc815\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DATE_SUB(\ub0a0\uc9dc, INTERVAL \uac12 \ub2e8\uc704) -- \ub0a0\uc9dc\uc5d0\uc11c \uac12 \ub2e8\uc704 \ub9cc\ud07c\uc744 \ube80 \uac12\uc744 \uacc4\uc0b0\nDATE_ADD(\ub0a0\uc9dc, INTERVAL \uac12 \ub2e8\uc704) -- \ub0a0\uc9dc\uc5d0\uc11c \uac12 \ub2e8\uc704 \ub9cc\ud07c\uc744 \ub354\ud55c \uac12\uc744 \uacc4\uc0b0<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/date_functions#date_sub\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"720\" height=\"720\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/nubosoft-google-cloud-4.webp\" alt=\"\" class=\"wp-image-16836\" style=\"width:204px;height:auto\"\/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/standard-sql\/date_functions#date_sub\" target=\"_blank\" rel=\"noopener\" title=\"\">Date functions &nbsp;|&nbsp; BigQuery &nbsp;|&nbsp; Google Cloud<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n<\/blockquote>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ud604\uc7ac \ub0a0\uc9dc\ub97c \ubd88\ub7ec\uc624\uba74\uc11c \ub9e4\ucd9c\uc740 \uacfc\uac70\uc758 \uac83\uc744 \ubd88\ub7ec\uc624\ub294 \uac83\uc774\uae30 \ub54c\ubb38\uc5d0 \uac01 \uac12\uc744 \uad6c\ubd84\ud558\uae30 \uc704\ud574 \uceec\ub7fc\uba85\uc740 <code>AS<\/code> \ub97c \uc0ac\uc6a9\ud558\uc5ec \uac01\uac01 \u2018<strong>lastYearRevenue\u2019<\/strong>, \u2018<strong>lastMonthRevenue\u2019<\/strong>, \u2018<strong>twoMonthAgoRevenue\u2019<\/strong>, \u2018<strong>threeMonthAgoRevenue\u2019<\/strong> \ub85c \uad6c\ubd84\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\uc65c SELECT\uc5d0\uc11c <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>DATE_ADD(salesDate, INTERVAL 1 YEAR)<\/strong><\/mark><\/code> \ucc98\ub7fc \ub0a0\uc9dc\uc5d0 \uae30\uac04\uc744 \ub354\ud574\uc8fc\uc5c8\uc744\uae4c\uc694? salesDate\ub97c \ubd88\ub7ec\uc624\uba74 1\ub144 \uc804\uc758 \ub0a0\uc9dc\ub97c \ubd88\ub7ec\uc635\ub2c8\ub2e4. \uc5ec\uae30\uc5d0 1\ub144\uc744 \ub354\ud574 \uc8fc\uba74 \ud604\uc7ac \uc2dc\uc810\uc758 \ub0a0\uc9dc\ub85c \ubcc0\ud658\uc774 \ub418\ub294\ub370, \uc774\uc5b4\uc9c0\ub294 (3)\uc5d0\uc11c \uc870\uc778\uc744 \ud560 \ub54c\uc5d0 \uc870\uac74\uc73c\ub85c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574 \ub9de\ucd94\uc5b4 \uc900 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h5 class=\"wp-block-heading\" id=\"aioseo-3\"><strong>(3) \ubd88\ub7ec\uc628 \ub370\uc774\ud130\ub4e4\uc744 \uc77c\uc790\ubcc4 \ud558\ub098\uc758 \ud589\uc73c\ub85c \ud1b5\ud569\ud558\uae30<\/strong><br><\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc804\uccb4 \uae30\uac04 \ub370\uc774\ud130 \ud1b5\ud569\ud558\uae30\nSELECT \n    COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n    COALESCE(c.currentRevenue, 0) AS currentRevenue,\n    COALESCE(l.lastYearRevenue, 0) AS lastYearRevenue,\n    COALESCE(m1.oneMonthAgoRevenue, 0) AS oneMonthAgoRevenue,\n    COALESCE(m2.twoMonthAgoRevenue, 0) AS twoMonthAgoRevenue,\n    COALESCE(m3.threeMonthAgoRevenue, 0) AS threeMonthAgoRevenue\nFROM current_sales c\nFULL OUTER JOIN lastYearData l \n    ON c.salesDate = l.salesDate\nFULL OUTER JOIN oneMonthAgoData m1 \n    ON COALESCE(c.salesDate, l.salesDate) = m1.salesDate \nFULL OUTER JOIN twoMonthAgoData m2 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate) = m2.salesDate \nFULL OUTER JOIN threeMonthAgoData m3 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate \nORDER BY salesDate;\n<\/code><\/pre>\n\n\n\n<p><br><br>\uc774 \ucffc\ub9ac\ub294 \uc0dd\uc131\ud558\uc600\ub358 \uc120\ud0dd \uae30\uac04, 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\uc744 \ud55c \ubc88\uc5d0 \ube44\uad50\ud560 \uc218 \uc788\ub3c4\ub85d <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code> \uad6c\ubb38\uc744 \uc774\uc6a9\ud574 \ub370\uc774\ud130\ub97c \uc815\ub9ac\ud558\ub294 \uacfc\uc815\uc73c\ub85c, \ucffc\ub9ac\uc758 \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ud615\uc2dd\uc744 \uc774\ub8f9\ub2c8\ub2e4. \ud558\ub098\uc758 \uc77c\uc790 \ud589\ub9c8\ub2e4 \ud604\uc7ac \uae30\uac04\uc758 \ub9e4\ucd9c, 1\ub144 \uc804 \ub9e4\ucd9c, 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c, 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\uc774 \ud568\uaed8 \ub2f4\uaca8\uc788\ub294 \uac83\uc774 \ubcf4\uc774\uc9c0\uc694?<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"461\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-19-1024x461.png\" alt=\"\" class=\"wp-image-16821\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-19-1024x461.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-19-300x135.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-19-768x346.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-19.png 1109w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774 \ucffc\ub9ac\uc5d0\uc11c \ud575\uc2ec\uc774 \ub418\ub294 \uad6c\ubb38\uc740 <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code> \uad6c\ubb38\uacfc <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>COALESCE()<\/strong><\/mark><\/code><\/code> \uad6c\ubb38\uc785\ub2c8\ub2e4. <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code> \uc740 \ub450 \ud14c\uc774\ube14 \uac04\uc758 \ubaa8\ub4e0 \ud589\uc744 \ud3ec\ud568\ud558\uc5ec \uc870\uc778\ud558\uace0 <code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>COALESCE()<\/strong><\/mark><\/code><\/code><\/code> \ub294 \uc5ec\ub7ec \uc778\uc218 \uc911 NULL\uc774 \uc544\ub2cc \uccab \ubc88\uc9f8 \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \ub450 \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud574\uc11c \ubaa8\ub4e0 \ub0a0\uc9dc\ub97c \ud3ec\ud568\ud558\uc5ec \ub370\uc774\ud130 \uc190\uc2e4 \uc5c6\uc774 CTE\ub4e4\uc744 \ud1b5\ud569\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code> \uad6c\ubb38 <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>COALESCE()<\/strong><\/mark><\/code><\/code> \uad6c\ubb38\uacfc \ubcf8 \ud3ec\uc2a4\ud2b8\uc5d0 \uc801\uc6a9\ub41c \uc6d0\ub9ac\uc5d0 \ub300\ud574 \ub354 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uace0 \uc2f6\ub2e4\uba74 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/04\/10\/how-to-use-full-outer-join-and-coalesce\/\" target=\"_blank\" rel=\"noopener\" title=\"\">FULL OUTER JOIN\uacfc COALESCE\ub97c \ud65c\uc6a9\ud574 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\uc744 \uae54\ub054\ud558\uac8c \uc870\uc778\ud558\uae30<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\ucffc\ub9ac\ub97c \ubaa8\ub450 \uc791\uc131\ud558\uc600\uc73c\ub2c8 \uc774\uc81c \ub370\uc774\ud130\ub97c \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc6b0\uce21 \ud558\ub2e8\uc758 \u2018<strong>\ucd94\uac00<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"661\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-20-1024x661.png\" alt=\"\" class=\"wp-image-16822\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-20-1024x661.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-20-300x194.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-20-768x495.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-20.png 1403w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc815\uc0c1\uc801\uc73c\ub85c \ucd94\uac00\uac00 \ub418\uba74 \u2018<strong>\ub9ac\uc18c\uc2a4<\/strong>\u2019 \u2192 \u2018<strong>\ucd94\uac00\ub41c \ub370\uc774\ud130 \uc18c\uc2a4 \uad00\ub9ac<\/strong>\u2019 \uba54\ub274\uc5d0\uc11c \ub370\uc774\ud130 \uc18c\uc2a4\uac00 \ucd94\uac00\ub41c \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130 \uc18c\uc2a4 \uc774\ub984\uc774 \uc784\uc758\ub85c \uc9c0\uc815\ub418\uc5b4\uc788\uc73c\ub2c8 \u2018<strong>\uc218\uc815<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub370\uc774\ud130 \uc18c\uc2a4\uc758 \uc774\ub984\uc744 \uc218\uc815\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"193\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-21-1024x193.png\" alt=\"\" class=\"wp-image-16823\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-21-1024x193.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-21-300x56.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-21-768x144.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-21.png 1398w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc544\ub798 \ud654\uba74\uc5d0\uc11c \ube68\uac04 \ubc15\uc2a4 \ubd80\ubd84\uc744 \ud074\ub9ad\ud558\uba74 \uc18c\uc2a4 \uc774\ub984\uc774\ub098 \uac01 \ud544\ub4dc\uba85\uc744 \uc218\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"338\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-22-1024x338.png\" alt=\"\" class=\"wp-image-16824\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-22-1024x338.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-22-300x99.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-22-768x253.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-22.png 1298w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc6b0\uce21 \uc0c1\ub2e8\uc758 \u2018<strong>\uc644\ub8cc<\/strong>\u2019 \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uba74 \ub370\uc774\ud130 \uc18c\uc2a4 \uc138\ud305\uc774 \uc644\ub8cc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\ub370\uc774\ud130 \uc18c\uc2a4\uc758 \ud544\ub4dc \uc774\ub984\uc744 \ud55c\ubc88 \ubcc0\uacbd\ud558\uba74 \uc6d0\ubcf8 \ud544\ub4dc \uc774\ub984\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \uc5c6\uc73c\ubbc0\ub85c \uc6b0\uce21 \u2018<strong>\uc124\uba85<\/strong>\u2019 \ub780\uc5d0 \uc6d0\ubcf8 \ud544\ub4dc \uc774\ub984\uc744 \uae30\uc785\ud558\uba74 \uad00\ub9ac\ud558\uae30\uac00 \ub354 \ud3b8\ub9ac\ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-23-1024x335.png\" alt=\"\" class=\"wp-image-16825\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-23-1024x335.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-23-300x98.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-23-768x251.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-23.png 1301w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc774\uc81c \ucc28\ud2b8\ub97c \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc218\uc815 \ud654\uba74\uc5d0\uc11c \uba54\uc778 \ud654\uba74 \uc0c1\ub2e8\uc758 \u2018<strong>\ucc28\ud2b8 \ucd94\uac00<\/strong>\u2019 \u2192 \u2018<strong>\ud53c\ubd07 \ud14c\uc774\ube14<\/strong>\u2019\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"618\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-24-1024x618.png\" alt=\"\" class=\"wp-image-16826\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-24-1024x618.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-24-300x181.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-24-768x464.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-24.png 1121w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ud53c\ubd07 \ud14c\uc774\ube14\uc744 \ucd94\uac00\ud558\uace0, \uce21\uc815 \uae30\uc900\uacfc \uce21\uc815 \ud56d\ubaa9\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc138\ud305\ud569\ub2c8\ub2e4. (\ud45c\ub85c\ub3c4 \uac00\ub2a5\ud569\ub2c8\ub2e4.)<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25-1024x474.png\" alt=\"\" class=\"wp-image-16827\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25-1024x474.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25-300x139.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25-768x356.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25-1536x712.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-25.png 1664w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ucc28\ud2b8\uac00 \uc644\uc131\ub418\uc5c8\uc2b5\ub2c8\ub2e4! \uc774\uc81c \uae30\uac04 \ucee8\ud2b8\ub864\ub7ec\uc758 \uae30\uac04\uc744 2025\ub144 2\uc6d4 1\uc77c\ubd80\ud130 2\uc6d4 10\uc77c\ub85c \ubcc0\uacbd\ud558\uba74, \ub9de\ucda4 \ucffc\ub9ac\ub97c \ud1b5\ud574\uc11c \ub9e4\uac1c\ubcc0\uc218\ub85c \uc804\ub2ec\ud558\uace0, \uc870\uac74\ubb38\uc5d0\uc11c \ud574\ub2f9 \uae30\uac04\uc744 \uc5f0\uc0b0\ud558\uc5ec \uac01 \uae30\uac04\uc5d0 \ub300\ud55c \ub9e4\ucd9c\uc744 \ubd88\ub7ec\uc624\uac8c \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"474\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26-1024x474.png\" alt=\"\" class=\"wp-image-16828\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26-1024x474.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26-300x139.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26-768x356.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26-1536x712.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-26.png 1591w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-3\"><br>3. \ub2e4\uc74c \ud3ec\uc2a4\ud2b8 \uc18c\uac1c<\/h2>\n\n\n\n<p><br>\uc624\ub298 \uc644\uc131\ud55c \ucc28\ud2b8\ub294 \uc77c\uc790\ubcc4\ub85c \uacfc\uac70 \uc2dc\uc810\uacfc \ube44\uad50\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc774\uc5c8\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uba87 \uac00\uc9c0 \uae30\ub2a5\uc744 \ucd94\uac00\ud574\uc11c \uc544\ub798\uc640 \uac19\uc740 \ucc28\ud2b8\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>1\ufe0f\u20e3 \uc120\ud0dd \uae30\uac04\uc5d0 \ub530\ub978 \uac70\ub798\ucc98\ub4e4\uc758 \uae30\uac04\ubcc4 \ub9e4\ucd9c<\/p>\n\n\n\n<p>2\ufe0f\u20e3 \ucc28\ud2b8 \ud5e4\ub354\uc5d0 \uc120\ud0dd \uae30\uac04\uacfc \uacfc\uac70\uc758 \ube44\uad50 \uae30\uac04\ub4e4\uc758 \ubc94\uc704\ub97c \ud45c\uc2dc<\/p>\n\n\n\n<p>\uc624\ub298 \uc0b4\ud3b4\ubcf8 \ucffc\ub9ac\ub97c \uc57d\uac04 \uc218\uc815\ud558\uace0, \ub514\uc790\uc778 \uc694\uc18c\ub97c \uac00\ubbf8\ud558\uba74 \uc544\ub798\uc640 \uac19\uc774 \uacfc\uac70\uc758 \uac01 \uae30\uac04\ub4e4\uc774 \uc5b4\ub290 \uae30\uac04\uc5d0 \ud574\ub2f9\ub418\ub294\uc9c0 \uba38\ub9bf\uc18d\uc73c\ub85c \uacc4\uc0b0\ud558\uc9c0 \uc54a\uace0\ub3c4 \uc9c1\uad00\uc801\uc73c\ub85c \ubcf4\uc5ec\uc904 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"481\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1024x481.png\" alt=\"\" class=\"wp-image-16829\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1024x481.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-300x141.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-768x361.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1536x721.png 1536w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27.png 1593w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br>\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc5d0 \ub300\ud55c \uae30\ubcf8 \uac1c\ub150\uacfc \uc0ac\uc6a9 \ubc29\ubc95\uc744 \uc18c\uac1c\ud558\uc600\uc2b5\ub2c8\ub2e4. \ube44\uad50 \uae30\ub2a5\uc744 \uc815\uc801\uc778 \ub370\uc774\ud130\ub9cc\uc73c\ub85c \uad6c\ud604\ud558\ub294\ub370\uc5d0\ub294 \ud55c\uacc4\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc744 \ud65c\uc6a9\ud558\uba74 \ube44\uad50 \uae30\ub2a5\uc5d0\uc11c \ub354 \ub113\uc740 \ubd84\uc11d\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \ub9de\ucda4 \ucffc\ub9ac \uae30\ub2a5\uc744 \ub354 \uae4a\uc774 \uc788\uac8c \ud65c\uc6a9\ud558\uace0 \uc2f6\uc73c\uc2dc\ub2e4\uba74 \ub2e4\uc74c \ud3ec\uc2a4\ud2b8\ub3c4 \uaf2d \uc77d\uc5b4\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4.<br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1.png\" alt=\"\" class=\"wp-image-17103\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-1-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<br>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n<p><br><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfh9CSxm4aKG4Rhh6Xdh7Y6p5e_8ZhwWS_ryvxGOeQVIpmaRw\/viewform\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n<p><br><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc9c0\ub09c \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 YoY(Year-over-Year) \ucc28\ud2b8\ub97c \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc544\ub798\uc758 \uc774\ubbf8\uc9c0\uc640 \uac19\uc774 \uc120\ud0dd \uc5f0\ub3c4\uc640 \uc804\ub144\ub3c4\uc758 \ub9e4\ucd9c \ucd94\uc774, \uc6d4\ubcc4 \ub9e4\ucd9c\uacfc \uc99d\uac10\uc561, \uc99d\uac10\ub960\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ucc28\ud2b8\ub97c \uc0dd\uc131\ud558\uc600\uc9c0\uc694. \uc774\ub807\uac8c \ud2b9\uc815 \uae30\uac04\uc758 \uc131\uacfc\ub97c \uc774\uc804\uc758 \uae30\uac04\uacfc \ube44\uad50\ud558\uba74, \uacc4\uc808\uc801 \uc694\uc778\uc774\ub098 \ub9c8\ucf00\ud305 \uc804\ub7b5\uc758 \uc131\uacfc, \uc2dc\uc7a5 \ubcc0\ud654\ub85c \uc778\ud55c \uc601\ud5a5\uc744 \uc774\ud574\ud558\ub294\ub370 \ub3c4\uc6c0\uc774 \ub429\ub2c8\ub2e4. \ud83d\udca1YoY(Year-over-Year)\ucc28\ud2b8\uc640 \uad6c\ud604\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uad81\uae08\ud558\uc2dc\ub2e4\uba74 \uc544\ub798\uc758 \uc774\uc804 \ud3ec\uc2a4\ud2b8\ub97c \uba3c\uc800 \uc77d\uc5b4\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4&#8230;.<\/p>\n","protected":false},"author":6,"featured_media":16840,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[6,41],"tags":[551,42,567,100,546,559,54,12],"class_list":["post-16800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookerstudio","category-bigquery","tag-autooffice","tag-bigquery","tag-looker-studio","tag-100","tag-546","tag-559","tag-54","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=16800"}],"version-history":[{"count":8,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16800\/revisions"}],"predecessor-version":[{"id":17124,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16800\/revisions\/17124"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16840"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}