.ipynb_checkpoints/My_tresure-checkpoint.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 122,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "from selenium import webdriver\n",
    "import pandas as pd\n",
    "import openpyxl as op\n",
    "import time\n",
    "import re\n",
    "from datetime import date, timedelta\n",
    "get_number = re.compile('.*(?=\\n)')\n",
    "get_percent = re.compile('.*(?=%)')\n",
    "get_url_without_slash = re.compile(\".*[0-9a-z]\")\n",
    "password = !echo %password%"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 255,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "def login():\n",
    "    driver.get(\"https://analytics.google.com/analytics/web/?authuser=0#management/Settings/a10587421w80067081p84826225/\")\n",
    "    #아이디입력\n",
    "    driver.find_element_by_css_selector('#Email').send_keys('taehun9312@gmail.com')\n",
    "    driver.find_element_by_css_selector('#next').click()\n",
    "    time.sleep(1)\n",
    "    #비밀번호입력\n",
    "    driver.find_element_by_css_selector('#Passwd').send_keys(password[0])\n",
    "    driver.find_element_by_css_selector('#signIn').click()\n",
    "    \n",
    "def s_to_i(value):\n",
    "    value = value.replace(\",\",\"\")\n",
    "    value = int(value)\n",
    "    return value\n",
    "\n",
    "def check(compared_value):\n",
    "    if type(compared_value) == list:\n",
    "        for value in compared_value:\n",
    "            if value in global_value: raise ValueError\n",
    "    elif compared_value in global_value: raise ValueError\n",
    "    else: print(\"No_duplication\")\n",
    "        \n",
    "def get_pure_url(url):\n",
    "    splited_url = url.split(\"/%\")\n",
    "    url = splited_url[0]\n",
    "    url = get_url_without_slash.findall(url)[0]\n",
    "    return url\n",
    "\n",
    "def get_number_item(unprocessed_number):\n",
    "    processed_number = unprocessed_number.split(\"(\")[0]\n",
    "    return s_to_i(processed_number)\n",
    "\n",
    "        \n",
    "def calculate_date(origin_date, interval, multiple_number):\n",
    "    date_set = _get_date(origin_date)\n",
    "    d1 = date(date_set[\"year\"], date_set[\"month\"], date_set[\"day\"])\n",
    "    d2 = d1 + timedelta(days = interval*multiple_number)\n",
    "    next_date = _to_date(d2)\n",
    "    return next_date\n",
    "\n",
    "def _get_date(date):\n",
    "    date = str(date)\n",
    "    year = \"20\" + date[0:2]\n",
    "    month = date[2:4]\n",
    "    day = date[4:6]\n",
    "    if month[0] == \"0\":\n",
    "        month = month.replace(\"0\",\"\")\n",
    "    return {\"year\": int(year), \"month\": int(month), \"day\": int(day)}\n",
    "\n",
    "def _to_date(date):\n",
    "    year = str(date.year)[2:4]\n",
    "    if date.month < 10:\n",
    "        month = \"0\" + str(date.month)\n",
    "    else:\n",
    "        month = str(date.month)\n",
    "    if date.day < 10:\n",
    "        day = \"0\" + str(date.day)\n",
    "    else:    \n",
    "        day = str(date.day)\n",
    "    return year+month+day"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 276,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "class GA:\n",
    "    \n",
    "    def __init__(self, url):\n",
    "        global start\n",
    "        global end \n",
    "        self.df = pd.DataFrame()\n",
    "        self.date = \"/%3F_u.date00%3D20{start}%26_u.date01%3D20{end}/\".format(start= start, end=end)\n",
    "        self.original_url = url\n",
    "        self.url = get_pure_url(url) + self.date\n",
    "        self.start = start\n",
    "        self.end = end\n",
    "        self.retry = 40\n",
    "        self.number = 1\n",
    "        self.df_start = str(start)\n",
    "        self.df_end = str(end)\n",
    "        self.dic_values = {}\n",
    "        driver.get(self.url)\n",
    "        \n",
    "    def set_date(self, interval, number):\n",
    "        self.interval = interval\n",
    "        self.number = number\n",
    "\n",
    "        \n",
    "    def set_segment_url(self):\n",
    "        self.url = get_url_without_slash.findall(self.url)[0] + \"%26_.useg%3Duser-3-OozmyTj6PoaE9MqRGzQ\"\n",
    "        \n",
    "    def set_tab(self, n_tab):\n",
    "        self.tab = n_tab\n",
    "        \n",
    "    def set_value(self, n_value):\n",
    "        if type(n_value) != list:\n",
    "            self.value = [n_value]\n",
    "        else:\n",
    "            self.value = n_value\n",
    "        \n",
    "    def set_retry(self, n):\n",
    "        self.retry = n\n",
    "    \n",
    "    def go_changed_url(self, n_try):\n",
    "        start = calculate_date(self.start, self.interval, n_try)\n",
    "        end = calculate_date(self.end, self.interval, n_try)\n",
    "        self.df_start = str(start)\n",
    "        self.df_end = str(end)\n",
    "        self.date =  \"/%3F_u.date00%3D20{start}%26_u.date01%3D20{end}/\".format(start= start, end=end)\n",
    "        self.url = get_pure_url(self.original_url) + self.date\n",
    "        driver.get(self.url)\n",
    "        \n",
    "    def get(self, numbers):\n",
    "        for n_try in range(1, self.number+1):\n",
    "            if type(numbers) == int:\n",
    "                value = self._come_to_me(numbers)\n",
    "                return value\n",
    "            else:\n",
    "                for n in numbers:\n",
    "                    self.dic_values = self._fill_dic_values(n, self.dic_values)\n",
    "            for title, value in self.dic_values.items():\n",
    "                    self.df.loc[self.df_start+\" - \"+self.df_end, title] = value\n",
    "            if self.number > 1 and n_try < self.number: \n",
    "                    self.dic_values = {}\n",
    "                    self.go_changed_url(n_try)                          \n",
    "        \n",
    "    def _fill_dic_values(self, numbers, dic_values):\n",
    "            n = numbers\n",
    "            value = self._come_to_me(n)\n",
    "            titles = self._get_title(self.value[n-1])\n",
    "            \n",
    "            if type(value) != list:\n",
    "                if type(self.value[n-1]) != list:\n",
    "                    #title 1, value 1\n",
    "                    title = titles[0]\n",
    "                    if title in dic_values:\n",
    "                        title = title + str(n)\n",
    "                    dic_values[title] = value\n",
    "                else:\n",
    "                    #titile more, value 1\n",
    "                    nth = self.value[n-1][1]\n",
    "                    title = titles[nth]\n",
    "                    if title in dic_values:\n",
    "                        title = title + str(n)\n",
    "                    dic_values[title] = value\n",
    "            else:\n",
    "                #title more, value more\n",
    "                for i, v in enumerate(value):\n",
    "                    title = titles[i]\n",
    "                    if title in dic_values:\n",
    "                        title = title + str(n)\n",
    "                    dic_values[title] = v \n",
    "            return dic_values\n",
    "    \n",
    "    def _come_to_me(self, n):\n",
    "        global global_value\n",
    "        error_check = \"on\"\n",
    "        self._click_tab(n)\n",
    "\n",
    "        if type(self.value) == list:\n",
    "            value_spec = self.value[n-1]\n",
    "        else:\n",
    "            value_spec = self.value\n",
    "\n",
    "        if type(value_spec) == list: \n",
    "            number = value_spec[0] \n",
    "            nth = value_spec[1]\n",
    "        else: \n",
    "            number = value_spec\n",
    "            nth = value_spec\n",
    "\n",
    "        if type(value_spec) == list or value_spec == 1:\n",
    "            value = self._get_value(nth, error_check)\n",
    "            error_check = \"off\"\n",
    "            value_for_compare = self._get_values(number, error_check)\n",
    "        else:\n",
    "            value_for_compare = self._get_values(number, error_check)\n",
    "            value = value_for_compare\n",
    "        global_value = value_for_compare\n",
    "        return value\n",
    "\n",
    "    def _get_title(self, n):\n",
    "        arr_title = []\n",
    "        unprocessed_titles = driver.find_elements_by_css_selector(\"._GArO\")\n",
    "        for title in unprocessed_titles:\n",
    "            arr_title.append(title.text)\n",
    "        return arr_title\n",
    "    \n",
    "    def get_percent(self, n):\n",
    "        arr_value = driver.find_elements_by_css_selector(\"._GAj8\")\n",
    "        percent = arr_value[n-1].text\n",
    "        processed_percent = float(get_percent.findall(percent)[0])\n",
    "        print(processed_percent)\n",
    "        return processed_percent\n",
    "        \n",
    "            \n",
    "    def get_item(self, name, nth):\n",
    "        for i in range(0, self.retry):\n",
    "            try:\n",
    "                items = driver.find_elements_by_css_selector(\"._GApu\")\n",
    "                dataset = driver.find_elements_by_css_selector(\"._GAtjb\")\n",
    "                for item in items:\n",
    "                    if item.text == name:\n",
    "                        value = get_number_item(dataset[i*2+nth-1].text)\n",
    "                        check(value)\n",
    "                        print(\"It's ok\")\n",
    "                        arr_data = []\n",
    "                        for data in dataset:\n",
    "                            arr_data.append(data.text)\n",
    "                        global_value = arr_data\n",
    "                        print(value)\n",
    "                        return value\n",
    "                time.sleep(1)\n",
    "            except:\n",
    "                time.sleep(4)\n",
    "                print(\"It's not ok\")\n",
    "                continue\n",
    "                        \n",
    "\n",
    "    #n번째 값 가져오기\n",
    "    def _get_value(self, n, error_check):\n",
    "        for i in range(0, self.retry):\n",
    "            try:\n",
    "                print(i)\n",
    "                value = driver.find_element_by_css_selector(\".ID-stage{n}-top._GAhFb > ._GAXm > ._GAoCb\".format(n = n)).text\n",
    "                if n != 1: value = get_number.findall(value)[0]\n",
    "                value = s_to_i(value)\n",
    "                print(\"value is\", value)\n",
    "                if error_check == \"on\":\n",
    "                    check(value)\n",
    "                print(\"It's ok\")\n",
    "                break\n",
    "            except:\n",
    "                time.sleep(4)\n",
    "                print(\"It's not ok\")\n",
    "                continue\n",
    "        print(value)\n",
    "        return value\n",
    "    \n",
    "    #n개의 값 가져오기\n",
    "    def _get_values(self, range_n, error_check):\n",
    "        arr_value = []\n",
    "        for n in range(1, range_n+1):\n",
    "            value = self._get_value(n, error_check)\n",
    "            arr_value.append(value)\n",
    "        print(arr_value)\n",
    "        return arr_value\n",
    "\n",
    "    #커스텀 리포트 내 탭\n",
    "    def _click_tab(self, n):\n",
    "        if n == 1:\n",
    "            driver.get(self.url)\n",
    "        else:\n",
    "            driver.find_elements_by_css_selector(\"._GAit._GAl\")[n-1].click()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 268,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "driver = webdriver.Chrome(executable_path=r\"C:\\Users\\joseph_th\\Downloads\\chromedriver_win32\\chromedriver\")\n",
    "login()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 273,
   "metadata": {
    "collapsed": true,
    "deletable": true,
    "editable": true
   },
   "outputs": [],
   "source": [
    "global_value = []\n",
    "start = 170301\n",
    "end = 170301"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 325133\n",
      "No_duplication\n",
      "It's ok\n",
      "325133\n",
      "0\n",
      "value is 325133\n",
      "It's ok\n",
      "325133\n",
      "[325133]\n",
      "0\n",
      "value is 325133\n",
      "It's not ok\n",
      "1\n",
      "value is 162176\n",
      "No_duplication\n",
      "It's ok\n",
      "162176\n",
      "0\n",
      "value is 162176\n",
      "It's ok\n",
      "162176\n",
      "[162176]\n",
      "0\n",
      "value is 162176\n",
      "It's not ok\n",
      "1\n",
      "value is 77445\n",
      "No_duplication\n",
      "It's ok\n",
      "77445\n",
      "0\n",
      "value is 77445\n",
      "It's ok\n",
      "77445\n",
      "[77445]\n",
      "0\n",
      "value is 77445\n",
      "It's not ok\n",
      "1\n",
      "value is 505741\n",
      "No_duplication\n",
      "It's ok\n",
      "505741\n",
      "0\n",
      "value is 505741\n",
      "It's ok\n",
      "505741\n",
      "[505741]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1757208\n",
      "No_duplication\n",
      "It's ok\n",
      "1757208\n",
      "0\n",
      "value is 1757208\n",
      "It's ok\n",
      "1757208\n",
      "[1757208]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 1261474\n",
      "No_duplication\n",
      "It's ok\n",
      "1261474\n",
      "0\n",
      "value is 162967\n",
      "No_duplication\n",
      "It's ok\n",
      "162967\n",
      "0\n",
      "value is 46674\n",
      "No_duplication\n",
      "It's ok\n",
      "46674\n",
      "[1261474, 162967, 46674]\n",
      "0\n",
      "value is 1261474\n",
      "It's not ok\n",
      "1\n",
      "value is 383599\n",
      "No_duplication\n",
      "It's ok\n",
      "383599\n",
      "0\n",
      "value is 37039\n",
      "No_duplication\n",
      "It's ok\n",
      "37039\n",
      "0\n",
      "value is 6811\n",
      "No_duplication\n",
      "It's ok\n",
      "6811\n",
      "[383599, 37039, 6811]\n",
      "0\n",
      "value is 383599\n",
      "It's not ok\n",
      "1\n",
      "value is 1577861\n",
      "No_duplication\n",
      "It's ok\n",
      "1577861\n",
      "0\n",
      "value is 199058\n",
      "No_duplication\n",
      "It's ok\n",
      "199058\n",
      "0\n",
      "value is 53416\n",
      "No_duplication\n",
      "It's ok\n",
      "53416\n",
      "[1577861, 199058, 53416]\n",
      "0\n",
      "value is 53416\n",
      "It's not ok\n",
      "1\n",
      "value is 45570\n",
      "No_duplication\n",
      "It's ok\n",
      "45570\n",
      "0\n",
      "value is 262270\n",
      "It's ok\n",
      "262270\n",
      "0\n",
      "value is 86417\n",
      "It's ok\n",
      "86417\n",
      "0\n",
      "value is 45570\n",
      "It's ok\n",
      "45570\n",
      "[262270, 86417, 45570]\n",
      "0\n",
      "value is 45570\n",
      "It's not ok\n",
      "1\n",
      "value is 6502\n",
      "No_duplication\n",
      "It's ok\n",
      "6502\n",
      "0\n",
      "value is 60890\n",
      "It's ok\n",
      "60890\n",
      "0\n",
      "value is 14607\n",
      "It's ok\n",
      "14607\n",
      "0\n",
      "value is 6502\n",
      "It's ok\n",
      "6502\n",
      "[60890, 14607, 6502]\n",
      "0\n",
      "value is 6502\n",
      "It's not ok\n",
      "1\n",
      "value is 52012\n",
      "No_duplication\n",
      "It's ok\n",
      "52012\n",
      "0\n",
      "value is 312246\n",
      "It's ok\n",
      "312246\n",
      "0\n",
      "value is 100656\n",
      "It's ok\n",
      "100656\n",
      "0\n",
      "value is 52012\n",
      "It's ok\n",
      "52012\n",
      "[312246, 100656, 52012]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 62966\n",
      "No_duplication\n",
      "It's ok\n",
      "62966\n",
      "0\n",
      "value is 21558\n",
      "No_duplication\n",
      "It's ok\n",
      "21558\n",
      "[62966, 21558]\n",
      "0\n",
      "value is 62966\n",
      "It's not ok\n",
      "1\n",
      "value is 62966\n",
      "It's not ok\n",
      "2\n",
      "value is 62966\n",
      "It's not ok\n",
      "3\n",
      "value is 32280\n",
      "No_duplication\n",
      "It's ok\n",
      "32280\n",
      "0\n",
      "value is 26662\n",
      "No_duplication\n",
      "It's ok\n",
      "26662\n",
      "[32280, 26662]\n",
      "0\n",
      "value is 26662\n",
      "It's not ok\n",
      "1\n",
      "value is 26662\n",
      "It's not ok\n",
      "2\n",
      "value is 26662\n",
      "It's not ok\n",
      "3\n",
      "value is 9300\n",
      "No_duplication\n",
      "It's ok\n",
      "9300\n",
      "0\n",
      "value is 62966\n",
      "It's ok\n",
      "62966\n",
      "0\n",
      "value is 9300\n",
      "It's ok\n",
      "9300\n",
      "[62966, 9300]\n",
      "0\n",
      "value is 9300\n",
      "It's not ok\n",
      "1\n",
      "value is 9300\n",
      "It's not ok\n",
      "2\n",
      "value is 9300\n",
      "It's not ok\n",
      "3\n",
      "value is 18823\n",
      "No_duplication\n",
      "It's ok\n",
      "18823\n",
      "0\n",
      "value is 62966\n",
      "It's ok\n",
      "62966\n",
      "0\n",
      "value is 18823\n",
      "It's ok\n",
      "18823\n",
      "[62966, 18823]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "It's not ok\n",
      "3\n",
      "value is 10496\n",
      "No_duplication\n",
      "It's ok\n",
      "10496\n",
      "0\n",
      "value is 10496\n",
      "It's ok\n",
      "10496\n",
      "[10496]\n",
      "0\n",
      "value is 10496\n",
      "It's not ok\n",
      "1\n",
      "value is 8019\n",
      "No_duplication\n",
      "It's ok\n",
      "8019\n",
      "0\n",
      "value is 8019\n",
      "It's ok\n",
      "8019\n",
      "[8019]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 11368\n",
      "No_duplication\n",
      "It's ok\n",
      "11368\n",
      "0\n",
      "value is 3237\n",
      "No_duplication\n",
      "It's ok\n",
      "3237\n",
      "[11368, 3237]\n",
      "0\n",
      "value is 11368\n",
      "It's not ok\n",
      "1\n",
      "value is 126\n",
      "No_duplication\n",
      "It's ok\n",
      "126\n",
      "0\n",
      "value is 126\n",
      "It's ok\n",
      "126\n",
      "[126]\n",
      "0\n",
      "value is 126\n",
      "It's not ok\n",
      "1\n",
      "value is 126\n",
      "It's not ok\n",
      "2\n",
      "value is 22091\n",
      "No_duplication\n",
      "It's ok\n",
      "22091\n",
      "0\n",
      "value is 2565\n",
      "No_duplication\n",
      "It's ok\n",
      "2565\n",
      "[22091, 2565]\n",
      "0\n",
      "value is 22091\n",
      "It's not ok\n",
      "1\n",
      "value is 22091\n",
      "It's not ok\n",
      "2\n",
      "value is 11037\n",
      "No_duplication\n",
      "It's ok\n",
      "11037\n",
      "0\n",
      "value is 7768\n",
      "No_duplication\n",
      "It's ok\n",
      "7768\n",
      "[11037, 7768]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 24314\n",
      "No_duplication\n",
      "It's ok\n",
      "24314\n",
      "0\n",
      "value is 4451\n",
      "No_duplication\n",
      "It's ok\n",
      "4451\n",
      "[24314, 4451]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "It's not ok\n",
      "3\n",
      "value is 21035088\n",
      "No_duplication\n",
      "It's ok\n",
      "21035088\n",
      "0\n",
      "value is 95444\n",
      "No_duplication\n",
      "It's ok\n",
      "95444\n",
      "[21035088, 95444]\n",
      "0\n",
      "value is 95444\n",
      "It's not ok\n",
      "1\n",
      "value is 95444\n",
      "It's not ok\n",
      "2\n",
      "value is 11381\n",
      "No_duplication\n",
      "It's ok\n",
      "11381\n",
      "0\n",
      "value is 21035088\n",
      "It's ok\n",
      "21035088\n",
      "0\n",
      "value is 11381\n",
      "It's ok\n",
      "11381\n",
      "[21035088, 11381]\n",
      "0\n",
      "value is 21035088\n",
      "It's not ok\n",
      "1\n",
      "value is 21035088\n",
      "It's not ok\n",
      "2\n",
      "value is 21035088\n",
      "It's not ok\n",
      "3\n",
      "value is 92339\n",
      "No_duplication\n",
      "It's ok\n",
      "92339\n",
      "0\n",
      "value is 92339\n",
      "It's ok\n",
      "92339\n",
      "[92339]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 1741278\n",
      "No_duplication\n",
      "It's ok\n",
      "1741278\n",
      "0\n",
      "value is 2915\n",
      "No_duplication\n",
      "It's ok\n",
      "2915\n",
      "[1741278, 2915]\n",
      "0\n",
      "value is 2915\n",
      "It's not ok\n",
      "1\n",
      "value is 7\n",
      "No_duplication\n",
      "It's ok\n",
      "7\n",
      "0\n",
      "value is 1741278\n",
      "It's ok\n",
      "1741278\n",
      "0\n",
      "value is 7\n",
      "It's ok\n",
      "7\n",
      "[1741278, 7]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 548824\n",
      "No_duplication\n",
      "It's ok\n",
      "548824\n",
      "0\n",
      "value is 140629\n",
      "No_duplication\n",
      "It's ok\n",
      "140629\n",
      "[548824, 140629]\n",
      "0\n",
      "value is 140629\n",
      "It's not ok\n",
      "1\n",
      "value is 140629\n",
      "It's not ok\n",
      "2\n",
      "value is 140629\n",
      "It's not ok\n",
      "3\n",
      "value is 40925\n",
      "No_duplication\n",
      "It's ok\n",
      "40925\n",
      "0\n",
      "value is 548824\n",
      "It's ok\n",
      "548824\n",
      "0\n",
      "value is 40925\n",
      "It's ok\n",
      "40925\n",
      "[548824, 40925]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "40925"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#국내, 해외, 항공호텔, 전체카테고리\n",
    "And_1 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/XAzFnmCtTl6SM1Cmc9OVNw/a10587421w80067081p102782120/\")\n",
    "And_1.set_tab(5)\n",
    "And_1.set_value([1,1,1,0,1])\n",
    "And_1.get(1)\n",
    "And_1.get(2)\n",
    "And_1.get(3)\n",
    "And_1.get(5)\n",
    "\n",
    "#티몬 전체 카테고리\n",
    "And_2 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/gmdw7utOS6OyMdXRs_jizg/a10587421w80067081p102782120/\")\n",
    "And_2.set_tab(1)\n",
    "And_2.set_value(1)\n",
    "And_2.get(1)\n",
    "\n",
    "#국내, 해외, 여행전체 딜\n",
    "And_3 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/c9agY1srRx2PaD8JAkK0yw/a10587421w80067081p102782120/\")\n",
    "And_3.set_tab(3)\n",
    "And_3.set_value([3,3,3])\n",
    "And_3.get(1)\n",
    "And_3.get(2)\n",
    "And_3.get(3)\n",
    "And_3.set_segment_url()\n",
    "And_3.set_value([[3,3],[3,3],[3,3]])\n",
    "And_3.get(1)\n",
    "And_3.get(2)\n",
    "And_3.get(3)\n",
    "\n",
    "#항공검색 해외, 국내, 해외->호텔메인, 해외->국내항공메인\n",
    "And_4 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/5fyYOU-QTN6tQSwRlObkUw/a10587421w80067081p102782120/%3F_u.date00%3D20170101%26_u.date01%3D20170301%26_.useg%3Duser-3-OozmyTj6PoaE9MqRGzQ/\")\n",
    "And_4.set_tab(4)\n",
    "And_4.set_value([2,2,[2,2],[2,2]])\n",
    "And_4.get(1)\n",
    "And_4.get(2)\n",
    "And_4.get(3)\n",
    "And_4.get(4)\n",
    "\n",
    "#항공예약 클릭 국내, 해외 \n",
    "And_5 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/_yDrAZzXTaeMOGlYkwqqbw/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D%26_r.tabId%3D6028/\")\n",
    "And_5.set_tab(2)\n",
    "And_5.set_value([1,1])\n",
    "And_5.get(1)\n",
    "And_5.get(2)\n",
    "\n",
    "#부킹닷컴 큐레이션, 호텔배너, 주말특가, 검색모듈\n",
    "And_6 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/urNzazUpRDu9q-17-qtmtw/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "And_6.set_tab(4)\n",
    "And_6.set_value([2,1,2,2])\n",
    "And_6.get(1)\n",
    "And_6.get(2)\n",
    "And_6.get(3)\n",
    "And_6.get(4)\n",
    "\n",
    "#부킹닷컴 이벤트페이지\n",
    "And_7 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/qWyiPek-Tsqgkok-rZsIjA/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "And_7.set_tab(1)\n",
    "And_7.set_value(2)\n",
    "And_7.get(1)\n",
    "\n",
    "#홈 -> 딜상세 국내, 해외, 카테고리숏컷\n",
    "And_8 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/4rkbjB7zTGmgcRAlJaVzrg/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "And_8.set_tab(3)\n",
    "And_8.set_value([2,[2,2],1])\n",
    "And_8.get(1)\n",
    "And_8.get(2)\n",
    "And_8.get(3)\n",
    "\n",
    "#홈 -> 콜렉션(국내), 해외\n",
    "And_9 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/lUOk-ms-R966phrt04_yfA/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "And_9.set_tab(2)\n",
    "And_9.set_value([2,[2,2]])\n",
    "And_9.get(1)\n",
    "And_9.get(2)\n",
    "\n",
    "#여행탭 -> 카테고리, 항공검색결과\n",
    "And_11 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/rUsbr2MuTou-MkNzI27mfw/a10587421w80067081p102782120/\")\n",
    "And_11.set_tab(3)\n",
    "And_11.set_value([2,[2,2]])\n",
    "And_11.get(1)\n",
    "And_11.get(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 109489\n",
      "No_duplication\n",
      "It's ok\n",
      "109489\n",
      "0\n",
      "value is 109489\n",
      "It's ok\n",
      "109489\n",
      "[109489]\n",
      "0\n",
      "value is 109489\n",
      "It's not ok\n",
      "1\n",
      "value is 109489\n",
      "It's not ok\n",
      "2\n",
      "value is 59440\n",
      "No_duplication\n",
      "It's ok\n",
      "59440\n",
      "0\n",
      "value is 59440\n",
      "It's ok\n",
      "59440\n",
      "[59440]\n",
      "0\n",
      "value is 59440\n",
      "It's not ok\n",
      "1\n",
      "value is 59440\n",
      "It's not ok\n",
      "2\n",
      "value is 52435\n",
      "No_duplication\n",
      "It's ok\n",
      "52435\n",
      "0\n",
      "value is 52435\n",
      "It's ok\n",
      "52435\n",
      "[52435]\n",
      "0\n",
      "value is 52435\n",
      "It's not ok\n",
      "1\n",
      "value is 191285\n",
      "No_duplication\n",
      "It's ok\n",
      "191285\n",
      "0\n",
      "value is 191285\n",
      "It's ok\n",
      "191285\n",
      "[191285]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1757208\n",
      "No_duplication\n",
      "It's ok\n",
      "1757208\n",
      "0\n",
      "value is 1757208\n",
      "It's ok\n",
      "1757208\n",
      "[1757208]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1261474\n",
      "No_duplication\n",
      "It's ok\n",
      "1261474\n",
      "0\n",
      "value is 162967\n",
      "No_duplication\n",
      "It's ok\n",
      "162967\n",
      "0\n",
      "value is 46674\n",
      "No_duplication\n",
      "It's ok\n",
      "46674\n",
      "[1261474, 162967, 46674]\n",
      "0\n",
      "value is 1261474\n",
      "It's not ok\n",
      "1\n",
      "value is 383599\n",
      "No_duplication\n",
      "It's ok\n",
      "383599\n",
      "0\n",
      "value is 37039\n",
      "No_duplication\n",
      "It's ok\n",
      "37039\n",
      "0\n",
      "value is 6811\n",
      "No_duplication\n",
      "It's ok\n",
      "6811\n",
      "[383599, 37039, 6811]\n",
      "0\n",
      "value is 383599\n",
      "It's not ok\n",
      "1\n",
      "value is 1577861\n",
      "No_duplication\n",
      "It's ok\n",
      "1577861\n",
      "0\n",
      "value is 199058\n",
      "No_duplication\n",
      "It's ok\n",
      "199058\n",
      "0\n",
      "value is 53416\n",
      "No_duplication\n",
      "It's ok\n",
      "53416\n",
      "[1577861, 199058, 53416]\n",
      "0\n",
      "value is 53416\n",
      "It's not ok\n",
      "1\n",
      "value is 45570\n",
      "No_duplication\n",
      "It's ok\n",
      "45570\n",
      "0\n",
      "value is 262270\n",
      "It's ok\n",
      "262270\n",
      "0\n",
      "value is 86417\n",
      "It's ok\n",
      "86417\n",
      "0\n",
      "value is 45570\n",
      "It's ok\n",
      "45570\n",
      "[262270, 86417, 45570]\n",
      "0\n",
      "value is 45570\n",
      "It's not ok\n",
      "1\n",
      "value is 6502\n",
      "No_duplication\n",
      "It's ok\n",
      "6502\n",
      "0\n",
      "value is 60890\n",
      "It's ok\n",
      "60890\n",
      "0\n",
      "value is 14607\n",
      "It's ok\n",
      "14607\n",
      "0\n",
      "value is 6502\n",
      "It's ok\n",
      "6502\n",
      "[60890, 14607, 6502]\n",
      "0\n",
      "value is 6502\n",
      "It's not ok\n",
      "1\n",
      "value is 52012\n",
      "No_duplication\n",
      "It's ok\n",
      "52012\n",
      "0\n",
      "value is 312246\n",
      "It's ok\n",
      "312246\n",
      "0\n",
      "value is 100656\n",
      "It's ok\n",
      "100656\n",
      "0\n",
      "value is 52012\n",
      "It's ok\n",
      "52012\n",
      "[312246, 100656, 52012]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 45057\n",
      "No_duplication\n",
      "It's ok\n",
      "45057\n",
      "0\n",
      "value is 17183\n",
      "No_duplication\n",
      "It's ok\n",
      "17183\n",
      "[45057, 17183]\n",
      "0\n",
      "value is 45057\n",
      "It's not ok\n",
      "1\n",
      "value is 45057\n",
      "It's not ok\n",
      "2\n",
      "value is 45057\n",
      "It's not ok\n",
      "3\n",
      "value is 19088\n",
      "No_duplication\n",
      "It's ok\n",
      "19088\n",
      "0\n",
      "value is 15762\n",
      "No_duplication\n",
      "It's ok\n",
      "15762\n",
      "[19088, 15762]\n",
      "0\n",
      "value is 15762\n",
      "It's not ok\n",
      "1\n",
      "value is 6695\n",
      "No_duplication\n",
      "It's ok\n",
      "6695\n",
      "0\n",
      "value is 45057\n",
      "It's ok\n",
      "45057\n",
      "0\n",
      "value is 6695\n",
      "It's ok\n",
      "6695\n",
      "[45057, 6695]\n",
      "0\n",
      "value is 6695\n",
      "It's not ok\n",
      "1\n",
      "value is 12485\n",
      "No_duplication\n",
      "It's ok\n",
      "12485\n",
      "0\n",
      "value is 45057\n",
      "It's ok\n",
      "45057\n",
      "0\n",
      "value is 12485\n",
      "It's ok\n",
      "12485\n",
      "[45057, 12485]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 10496\n",
      "No_duplication\n",
      "It's ok\n",
      "10496\n",
      "0\n",
      "value is 10496\n",
      "It's ok\n",
      "10496\n",
      "[10496]\n",
      "0\n",
      "value is 10496\n",
      "It's not ok\n",
      "1\n",
      "value is 10496\n",
      "It's not ok\n",
      "2\n",
      "value is 8019\n",
      "No_duplication\n",
      "It's ok\n",
      "8019\n",
      "0\n",
      "value is 8019\n",
      "It's ok\n",
      "8019\n",
      "[8019]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 11368\n",
      "No_duplication\n",
      "It's ok\n",
      "11368\n",
      "0\n",
      "value is 3237\n",
      "No_duplication\n",
      "It's ok\n",
      "3237\n",
      "[11368, 3237]\n",
      "0\n",
      "value is 11368\n",
      "It's not ok\n",
      "1\n",
      "value is 126\n",
      "No_duplication\n",
      "It's ok\n",
      "126\n",
      "0\n",
      "value is 126\n",
      "It's ok\n",
      "126\n",
      "[126]\n",
      "0\n",
      "value is 126\n",
      "It's not ok\n",
      "1\n",
      "value is 126\n",
      "It's not ok\n",
      "2\n",
      "value is 22091\n",
      "No_duplication\n",
      "It's ok\n",
      "22091\n",
      "0\n",
      "value is 2565\n",
      "No_duplication\n",
      "It's ok\n",
      "2565\n",
      "[22091, 2565]\n",
      "0\n",
      "value is 22091\n",
      "It's not ok\n",
      "1\n",
      "value is 22091\n",
      "It's not ok\n",
      "2\n",
      "value is 22091\n",
      "It's not ok\n",
      "3\n",
      "value is 11037\n",
      "No_duplication\n",
      "It's ok\n",
      "11037\n",
      "0\n",
      "value is 7768\n",
      "No_duplication\n",
      "It's ok\n",
      "7768\n",
      "[11037, 7768]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 24314\n",
      "No_duplication\n",
      "It's ok\n",
      "24314\n",
      "0\n",
      "value is 4451\n",
      "No_duplication\n",
      "It's ok\n",
      "4451\n",
      "[24314, 4451]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 21035088\n",
      "No_duplication\n",
      "It's ok\n",
      "21035088\n",
      "0\n",
      "value is 95444\n",
      "No_duplication\n",
      "It's ok\n",
      "95444\n",
      "[21035088, 95444]\n",
      "0\n",
      "value is 95444\n",
      "It's not ok\n",
      "1\n",
      "value is 11381\n",
      "No_duplication\n",
      "It's ok\n",
      "11381\n",
      "0\n",
      "value is 21035088\n",
      "It's ok\n",
      "21035088\n",
      "0\n",
      "value is 11381\n",
      "It's ok\n",
      "11381\n",
      "[21035088, 11381]\n",
      "0\n",
      "value is 21035088\n",
      "It's not ok\n",
      "1\n",
      "value is 92339\n",
      "No_duplication\n",
      "It's ok\n",
      "92339\n",
      "0\n",
      "value is 92339\n",
      "It's ok\n",
      "92339\n",
      "[92339]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1741278\n",
      "No_duplication\n",
      "It's ok\n",
      "1741278\n",
      "0\n",
      "value is 2915\n",
      "No_duplication\n",
      "It's ok\n",
      "2915\n",
      "[1741278, 2915]\n",
      "0\n",
      "value is 2915\n",
      "It's not ok\n",
      "1\n",
      "value is 7\n",
      "No_duplication\n",
      "It's ok\n",
      "7\n",
      "0\n",
      "value is 1741278\n",
      "It's ok\n",
      "1741278\n",
      "0\n",
      "value is 7\n",
      "It's ok\n",
      "7\n",
      "[1741278, 7]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "7"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#국내, 해외, 항공호텔, 전체카테고리\n",
    "iOS_1 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/f6fCST7zQwalCMN1dpSuPw/a10587421w80067081p88823264/\")\n",
    "iOS_1.set_tab(5)\n",
    "iOS_1.set_value([1,1,1,0,1])\n",
    "iOS_1.get(1)\n",
    "iOS_1.get(2)\n",
    "iOS_1.get(3)\n",
    "iOS_1.get(5)\n",
    "\n",
    "#티몬 전체 카테고리\n",
    "iOS_2 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/gmdw7utOS6OyMdXRs_jizg/a10587421w80067081p102782120/\")\n",
    "iOS_2.set_tab(1)\n",
    "iOS_2.set_value(1)\n",
    "iOS_2.get(1)\n",
    "\n",
    "#국내딜, 해외딜, 전체딜\n",
    "iOS_3 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/c9agY1srRx2PaD8JAkK0yw/a10587421w80067081p102782120/\")\n",
    "iOS_3.set_tab(3)\n",
    "iOS_3.set_value([3,3,3])\n",
    "iOS_3.get(1)\n",
    "iOS_3.get(2)\n",
    "iOS_3.get(3)\n",
    "iOS_3.set_segment_url()\n",
    "iOS_3.set_value([[3,3],[3,3],[3,3]])\n",
    "iOS_3.get(1)\n",
    "iOS_3.get(2)\n",
    "iOS_3.get(3)\n",
    "\n",
    "#항공검색 해외, 국내, 해외 -> 호텔메인, 해외 -> 국내메인\n",
    "iOS_4 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/2K60xdJeT2isKsPe4tgpEQ/a10587421w80067081p88823264/%3F_u.date00%3D20170301%26_u.date01%3D20170320/\")\n",
    "iOS_4.set_tab(4)\n",
    "iOS_4.set_value([2,2,[2,2],[2,2]])\n",
    "iOS_4.get(1)\n",
    "iOS_4.get(2)\n",
    "iOS_4.get(3)\n",
    "iOS_4.get(4)\n",
    "\n",
    "#항공예약클릭 국내, 해외\n",
    "iOS_5 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/_yDrAZzXTaeMOGlYkwqqbw/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D%26_r.tabId%3D6028/\")\n",
    "iOS_5.set_tab(2)\n",
    "iOS_5.set_value([1,1])\n",
    "iOS_5.get(1)\n",
    "iOS_5.get(2)\n",
    "\n",
    "#부킹닷컴 큐레이션, 호텔배너, 주말특가, 해외호텔검색모듈\n",
    "iOS_6 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/urNzazUpRDu9q-17-qtmtw/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "iOS_6.set_tab(4)\n",
    "iOS_6.set_value([2,1,2,2])\n",
    "iOS_6.get(1)\n",
    "iOS_6.get(2)\n",
    "iOS_6.get(3)\n",
    "iOS_6.get(4)\n",
    "\n",
    "#부킹닷컴 이벤트\n",
    "iOS_7 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/qWyiPek-Tsqgkok-rZsIjA/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "iOS_7.set_tab(1)\n",
    "iOS_7.set_value(2)\n",
    "iOS_7.get(1)\n",
    "\n",
    "#홈 -> 딜상세(국내), 해외, 여행카테고리숏컷\n",
    "iOS_8 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/4rkbjB7zTGmgcRAlJaVzrg/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "iOS_8.set_tab(3)\n",
    "iOS_8.set_value([2,[2,2],1])\n",
    "iOS_8.get(1)\n",
    "iOS_8.get(2)\n",
    "iOS_8.get(3)\n",
    "\n",
    "#홈 -> 콜렉션(국내), 해외\n",
    "iOS_9 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/lUOk-ms-R966phrt04_yfA/a10587421w80067081p102782120/%3F_u.date00%3D20170227%26_u.date01%3D20170305%26_.useg%3D/\")\n",
    "iOS_9.set_tab(2)\n",
    "iOS_9.set_value([2,[2,2]])\n",
    "iOS_9.get(1)\n",
    "iOS_9.get(2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 186207\n",
      "No_duplication\n",
      "It's ok\n",
      "186207\n",
      "0\n",
      "value is 186207\n",
      "It's ok\n",
      "186207\n",
      "[186207]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 4497\n",
      "No_duplication\n",
      "It's ok\n",
      "4497\n",
      "0\n",
      "value is 67893\n",
      "It's ok\n",
      "67893\n",
      "0\n",
      "value is 4497\n",
      "It's ok\n",
      "4497\n",
      "[67893, 4497]\n",
      "0.61\n",
      "0\n",
      "value is 67893\n",
      "It's not ok\n",
      "1\n",
      "value is 90932\n",
      "No_duplication\n",
      "It's ok\n",
      "90932\n",
      "0\n",
      "value is 90932\n",
      "It's ok\n",
      "90932\n",
      "[90932]\n",
      "0\n",
      "value is 90932\n",
      "It's not ok\n",
      "1\n",
      "value is 90932\n",
      "It's not ok\n",
      "2\n",
      "value is 302935\n",
      "No_duplication\n",
      "It's ok\n",
      "302935\n",
      "0\n",
      "value is 4497\n",
      "No_duplication\n",
      "It's ok\n",
      "4497\n",
      "[302935, 4497]\n",
      "0.38\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 954900\n",
      "No_duplication\n",
      "It's ok\n",
      "954900\n",
      "0\n",
      "value is 954900\n",
      "It's ok\n",
      "954900\n",
      "[954900]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 988871\n",
      "No_duplication\n",
      "It's ok\n",
      "988871\n",
      "0\n",
      "value is 57455\n",
      "No_duplication\n",
      "It's ok\n",
      "57455\n",
      "0\n",
      "value is 19157\n",
      "No_duplication\n",
      "It's ok\n",
      "19157\n",
      "[988871, 57455, 19157]\n",
      "0\n",
      "value is 988871\n",
      "It's not ok\n",
      "1\n",
      "value is 731677\n",
      "No_duplication\n",
      "It's ok\n",
      "731677\n",
      "0\n",
      "value is 42859\n",
      "No_duplication\n",
      "It's ok\n",
      "42859\n",
      "0\n",
      "value is 14751\n",
      "No_duplication\n",
      "It's ok\n",
      "14751\n",
      "[731677, 42859, 14751]\n",
      "0\n",
      "value is 731677\n",
      "It's not ok\n",
      "1\n",
      "value is 286354\n",
      "No_duplication\n",
      "It's ok\n",
      "286354\n",
      "0\n",
      "value is 14652\n",
      "No_duplication\n",
      "It's ok\n",
      "14652\n",
      "0\n",
      "value is 4290\n",
      "No_duplication\n",
      "It's ok\n",
      "4290\n",
      "[286354, 14652, 4290]\n",
      "0\n",
      "value is 4290\n",
      "It's not ok\n",
      "1\n",
      "value is 4290\n",
      "It's not ok\n",
      "2\n",
      "value is 4290\n",
      "It's not ok\n",
      "3\n",
      "value is 4290\n",
      "It's not ok\n",
      "4\n",
      "value is 4290\n",
      "It's not ok\n",
      "5\n",
      "value is 18887\n",
      "No_duplication\n",
      "It's ok\n",
      "18887\n",
      "0\n",
      "value is 81887\n",
      "It's ok\n",
      "81887\n",
      "0\n",
      "value is 25969\n",
      "It's ok\n",
      "25969\n",
      "0\n",
      "value is 18887\n",
      "It's ok\n",
      "18887\n",
      "[81887, 25969, 18887]\n",
      "0\n",
      "value is 18887\n",
      "It's not ok\n",
      "1\n",
      "value is 18887\n",
      "It's not ok\n",
      "2\n",
      "value is 18887\n",
      "It's not ok\n",
      "3\n",
      "value is 14549\n",
      "No_duplication\n",
      "It's ok\n",
      "14549\n",
      "0\n",
      "value is 62437\n",
      "It's ok\n",
      "62437\n",
      "0\n",
      "value is 20155\n",
      "It's ok\n",
      "20155\n",
      "0\n",
      "value is 14549\n",
      "It's ok\n",
      "14549\n",
      "[62437, 20155, 14549]\n",
      "0\n",
      "value is 14549\n",
      "It's not ok\n",
      "1\n",
      "value is 14549\n",
      "It's not ok\n",
      "2\n",
      "value is 14549\n",
      "It's not ok\n",
      "3\n",
      "value is 14549\n",
      "It's not ok\n",
      "4\n",
      "value is 14549\n",
      "It's not ok\n",
      "5\n",
      "value is 4221\n",
      "No_duplication\n",
      "It's ok\n",
      "4221\n",
      "0\n",
      "value is 21509\n",
      "It's ok\n",
      "21509\n",
      "0\n",
      "value is 5741\n",
      "It's ok\n",
      "5741\n",
      "0\n",
      "value is 4221\n",
      "It's ok\n",
      "4221\n",
      "[21509, 5741, 4221]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 41525\n",
      "No_duplication\n",
      "It's ok\n",
      "41525\n",
      "0\n",
      "value is 21655\n",
      "No_duplication\n",
      "It's ok\n",
      "21655\n",
      "[41525, 21655]\n",
      "0\n",
      "value is 41525\n",
      "It's not ok\n",
      "1\n",
      "value is 28703\n",
      "No_duplication\n",
      "It's ok\n",
      "28703\n",
      "0\n",
      "value is 17868\n",
      "No_duplication\n",
      "It's ok\n",
      "17868\n",
      "[28703, 17868]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "It's not ok\n",
      "2\n",
      "value is 34000\n",
      "No_duplication\n",
      "It's ok\n",
      "34000\n",
      "0\n",
      "value is 5138\n",
      "No_duplication\n",
      "It's ok\n",
      "5138\n",
      "[34000, 5138]\n",
      "0\n",
      "value is 34000\n",
      "It's not ok\n",
      "1\n",
      "value is 34000\n",
      "It's not ok\n",
      "2\n",
      "value is 28383\n",
      "No_duplication\n",
      "It's ok\n",
      "28383\n",
      "0\n",
      "value is 5212\n",
      "No_duplication\n",
      "It's ok\n",
      "5212\n",
      "[28383, 5212]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 9424\n",
      "No_duplication\n",
      "It's ok\n",
      "9424\n",
      "0\n",
      "value is 3804\n",
      "No_duplication\n",
      "It's ok\n",
      "3804\n",
      "[9424, 3804]\n",
      "0\n",
      "value is 9424\n",
      "It's not ok\n",
      "1\n",
      "value is 4497\n",
      "No_duplication\n",
      "It's ok\n",
      "4497\n",
      "0\n",
      "value is 4497\n",
      "It's ok\n",
      "4497\n",
      "[4497]\n",
      "0\n",
      "value is 4497\n",
      "It's not ok\n",
      "1\n",
      "value is 4497\n",
      "It's not ok\n",
      "2\n",
      "value is 4497\n",
      "It's not ok\n",
      "3\n",
      "value is 21605\n",
      "No_duplication\n",
      "It's ok\n",
      "21605\n",
      "0\n",
      "value is 1223\n",
      "No_duplication\n",
      "It's ok\n",
      "1223\n",
      "[21605, 1223]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 5775\n",
      "No_duplication\n",
      "It's ok\n",
      "5775\n",
      "0\n",
      "value is 5775\n",
      "It's ok\n",
      "5775\n",
      "[5775]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "5775"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 카테고리 국내, 해외, 항공호텔, 전체\n",
    "PC_1 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/RFQ6OlJDT5-6MMKnjtJkcA/a10587421w80067081p84826225/\")\n",
    "PC_1.set_tab(4)\n",
    "PC_1.set_value([1,1,[2,2],2])\n",
    "PC_1.get(1)\n",
    "PC_1.get(3)\n",
    "PC_1.get_percent(1)\n",
    "PC_1.get(2)\n",
    "PC_1.get(4)\n",
    "PC_1.get_percent(1)\n",
    "\n",
    "# 티몬 전체 카테고리\n",
    "PC_2 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/ZcNefO8cTRe75IKFbPcCWw/a10587421w80067081p84826225/%3F_.useg%3D/\")\n",
    "PC_2.set_tab(1)\n",
    "PC_2.set_value(1)\n",
    "PC_2.get(1)\n",
    "\n",
    "# 여행 전체, 국내, 해외딜\n",
    "PC_3 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/hRoEL4w4RCyYpcmhDbvgWw/a10587421w80067081p84826225/%3F_.useg%3D/\")\n",
    "PC_3.set_tab(3)\n",
    "PC_3.set_value([3,3,3])\n",
    "PC_3.get(1)\n",
    "PC_3.get(2)\n",
    "PC_3.get(3)\n",
    "PC_3.set_segment_url()\n",
    "PC_3.set_value([[3,3],[3,3],[3,3]])\n",
    "PC_3.get(1)\n",
    "PC_3.get(2)\n",
    "PC_3.get(3)\n",
    "\n",
    "# 항공검색 국내, 해외\n",
    "PC_4 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/KkWuVj5-SCOH7ddtrf4bOA/a10587421w80067081p84826225/\")\n",
    "PC_4.set_tab(2)\n",
    "PC_4.set_value([2,2])\n",
    "PC_4.get(1)\n",
    "PC_4.get(2)\n",
    "\n",
    "# 예약클릭 국내, 해외\n",
    "PC_5 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/YspUfeZLQ7KyhFzRxehRcQ/a10587421w80067081p84826225/%3F_.useg%3D/\")\n",
    "PC_5.set_tab(2)\n",
    "PC_5.set_value([2,2])\n",
    "PC_5.get(1)\n",
    "PC_5.get(2)\n",
    "\n",
    "# 부킹닷컴 큐레이션, 해외호텔 카테고리, 주말특가\n",
    "PC_6 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/jQo-QVnGRrG1Y_Dtaoz0FQ/a10587421w80067081p84826225/%3F_.useg%3D/\")\n",
    "PC_6.set_tab(3)\n",
    "PC_6.set_value([2,1,2])\n",
    "PC_6.get(1)\n",
    "PC_6.get(2)\n",
    "PC_6.get(3)\n",
    "\n",
    "# 부킹닷컴 이벤트\n",
    "PC_7 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/K68VmWT0QxSxn2j0wohK4A/a10587421w80067081p84826225/%3F_.useg%3D/\")\n",
    "PC_7.set_tab(1)\n",
    "PC_7.set_value(1)\n",
    "PC_7.get(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false,
    "deletable": true,
    "editable": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 585261\n",
      "No_duplication\n",
      "It's ok\n",
      "585261\n",
      "0\n",
      "value is 585261\n",
      "It's ok\n",
      "585261\n",
      "[585261]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1466935\n",
      "No_duplication\n",
      "It's ok\n",
      "1466935\n",
      "0\n",
      "value is 70428\n",
      "No_duplication\n",
      "It's ok\n",
      "70428\n",
      "0\n",
      "value is 15489\n",
      "No_duplication\n",
      "It's ok\n",
      "15489\n",
      "[1466935, 70428, 15489]\n",
      "0\n",
      "value is 1466935\n",
      "It's not ok\n",
      "1\n",
      "value is 1165222\n",
      "No_duplication\n",
      "It's ok\n",
      "1165222\n",
      "0\n",
      "value is 56744\n",
      "No_duplication\n",
      "It's ok\n",
      "56744\n",
      "0\n",
      "value is 12970\n",
      "No_duplication\n",
      "It's ok\n",
      "12970\n",
      "[1165222, 56744, 12970]\n",
      "0\n",
      "value is 1165222\n",
      "It's not ok\n",
      "1\n",
      "value is 315722\n",
      "No_duplication\n",
      "It's ok\n",
      "315722\n",
      "0\n",
      "value is 13774\n",
      "No_duplication\n",
      "It's ok\n",
      "13774\n",
      "0\n",
      "value is 2522\n",
      "No_duplication\n",
      "It's ok\n",
      "2522\n",
      "[315722, 13774, 2522]\n",
      "0\n",
      "value is 2522\n",
      "It's not ok\n",
      "1\n",
      "value is 15394\n",
      "No_duplication\n",
      "It's ok\n",
      "15394\n",
      "0\n",
      "value is 77813\n",
      "It's ok\n",
      "77813\n",
      "0\n",
      "value is 22823\n",
      "It's ok\n",
      "22823\n",
      "0\n",
      "value is 15394\n",
      "It's ok\n",
      "15394\n",
      "[77813, 22823, 15394]\n",
      "0\n",
      "value is 15394\n",
      "It's not ok\n",
      "1\n",
      "value is 12886\n",
      "No_duplication\n",
      "It's ok\n",
      "12886\n",
      "0\n",
      "value is 61724\n",
      "It's ok\n",
      "61724\n",
      "0\n",
      "value is 18965\n",
      "It's ok\n",
      "18965\n",
      "0\n",
      "value is 12886\n",
      "It's ok\n",
      "12886\n",
      "[61724, 18965, 12886]\n",
      "0\n",
      "value is 12886\n",
      "It's not ok\n",
      "1\n",
      "value is 2511\n",
      "No_duplication\n",
      "It's ok\n",
      "2511\n",
      "0\n",
      "value is 16832\n",
      "It's ok\n",
      "16832\n",
      "0\n",
      "value is 3873\n",
      "It's ok\n",
      "3873\n",
      "0\n",
      "value is 2511\n",
      "It's ok\n",
      "2511\n",
      "[16832, 3873, 2511]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 18835\n",
      "No_duplication\n",
      "It's ok\n",
      "18835\n",
      "0\n",
      "value is 4423\n",
      "No_duplication\n",
      "It's ok\n",
      "4423\n",
      "[18835, 4423]\n",
      "0\n",
      "value is 18835\n",
      "It's not ok\n",
      "1\n",
      "value is 7945\n",
      "No_duplication\n",
      "It's ok\n",
      "7945\n",
      "0\n",
      "value is 4053\n",
      "No_duplication\n",
      "It's ok\n",
      "4053\n",
      "[7945, 4053]\n",
      "0\n",
      "value is 4053\n",
      "It's not ok\n",
      "1\n",
      "value is 2027\n",
      "No_duplication\n",
      "It's ok\n",
      "2027\n",
      "0\n",
      "value is 18835\n",
      "It's ok\n",
      "18835\n",
      "0\n",
      "value is 2027\n",
      "It's ok\n",
      "2027\n",
      "[18835, 2027]\n",
      "0\n",
      "value is 2027\n",
      "It's not ok\n",
      "1\n",
      "value is 4577\n",
      "No_duplication\n",
      "It's ok\n",
      "4577\n",
      "0\n",
      "value is 18835\n",
      "It's ok\n",
      "18835\n",
      "0\n",
      "value is 4577\n",
      "It's ok\n",
      "4577\n",
      "[18835, 4577]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 1030\n",
      "No_duplication\n",
      "It's ok\n",
      "1030\n",
      "0\n",
      "value is 1030\n",
      "It's ok\n",
      "1030\n",
      "[1030]\n",
      "0\n",
      "value is 1030\n",
      "It's not ok\n",
      "1\n",
      "value is 1835\n",
      "No_duplication\n",
      "It's ok\n",
      "1835\n",
      "0\n",
      "value is 1835\n",
      "It's ok\n",
      "1835\n",
      "[1835]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 6399\n",
      "No_duplication\n",
      "It's ok\n",
      "6399\n",
      "0\n",
      "value is 970\n",
      "No_duplication\n",
      "It's ok\n",
      "970\n",
      "[6399, 970]\n",
      "0\n",
      "value is 6399\n",
      "It's not ok\n",
      "1\n",
      "value is 3038\n",
      "No_duplication\n",
      "It's ok\n",
      "3038\n",
      "0\n",
      "value is 1802\n",
      "No_duplication\n",
      "It's ok\n",
      "1802\n",
      "[3038, 1802]\n",
      "0\n",
      "It's not ok\n",
      "1\n",
      "value is 733\n",
      "No_duplication\n",
      "It's ok\n",
      "733\n",
      "0\n",
      "value is 148\n",
      "No_duplication\n",
      "It's ok\n",
      "148\n",
      "[733, 148]\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[733, 148]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#국내카테고리, 해외, 항공호텔, 전체\n",
    "Mo_1 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/V-T6iNbTQWi5USC2dSi5tA/a10587421w80067081p89357101/\")\n",
    "Mo_1.set_tab(5)\n",
    "Mo_1.set_value([1,1,1,0,2])\n",
    "\n",
    "#티몬 홈 전체\n",
    "Mo_2 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/zoovm6xETN-Cd6JF9s2_hQ/a10587421w80067081p89357101/\")\n",
    "Mo_2.set_tab(1)\n",
    "Mo_2.set_value(1)\n",
    "Mo_2.get(1)\n",
    "\n",
    "#여행딜 전체, 국내, 해외\n",
    "Mo_3 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/upJUz96ERVGUIE2WWd8Tgg/a10587421w80067081p89357101/\")\n",
    "Mo_3.set_tab(3)\n",
    "Mo_3.set_value([3,3,3])\n",
    "Mo_3.get(1)\n",
    "Mo_3.get(2)\n",
    "Mo_3.get(3)\n",
    "Mo_3.set_segment_url()\n",
    "Mo_3.set_value([[3,3],[3,3],[3,3]])\n",
    "Mo_3.get(1)\n",
    "Mo_3.get(2)\n",
    "Mo_3.get(3)\n",
    "\n",
    "#항공검색 해외, 국내, 해외->호텔, 해외->국내\n",
    "Mo_4 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/7aMTsZECQu2GVnxwp3IXRg/a10587421w80067081p89357101/\")\n",
    "Mo_4.set_tab(4)\n",
    "Mo_4.set_value([2,2,[2,2],[2,2]])\n",
    "Mo_4.get(1)\n",
    "Mo_4.get(2)\n",
    "Mo_4.get(3)\n",
    "Mo_4.get(4)\n",
    "\n",
    "#항공예약클릭 국내, 해외\n",
    "Mo_5 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/Shs74NpmR1Wcy5isHt_ZGA/a10587421w80067081p89357101/\")\n",
    "Mo_5.set_tab(2)\n",
    "Mo_5.set_value([1,1])\n",
    "Mo_5.get(1)\n",
    "Mo_5.get(2)\n",
    "\n",
    "#부킹닷컴 큐레이션, 호텔메인\n",
    "Mo_6 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/W52iAReKSeydMYwmwkpBbA/a10587421w80067081p89357101/\")\n",
    "Mo_6.set_tab(2)\n",
    "Mo_6.set_value([2,2])\n",
    "Mo_6.get(1)\n",
    "Mo_6.get(2)\n",
    "\n",
    "#부킹닷컴 이벤트\n",
    "Mo_7 = GA(\"https://analytics.google.com/analytics/web/?authuser=0#my-reports/gY8HkfiiQaqkTZOucG8YFQ/a10587421w80067081p89357101/\")\n",
    "Mo_7.set_tab(1)\n",
    "Mo_7.set_value(2)\n",
    "Mo_7.get(1)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}