iraq-make-strata.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "! pip install --quiet environs cyksuid toolz psycopg2-binary typing_json backoff pyyaml facebook_business pystache"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "%load_ext autoreload\n",
    "%autoreload 2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from environs import Env\n",
    "\n",
    "from adopt.malaria import get_confs, get_df, load_basics, window, get_db_conf\n",
    "from adopt.marketing import make_audience_conf, dict_from_nested_type\n",
    "from adopt.marketing import Marketing\n",
    "from adopt.facebook.state import CampaignState, get_api\n",
    "from adopt.malaria import load_typed_json\n",
    "from adopt.marketing import AudienceConf, CampaignConf\n",
    "from adopt.campaign_queries import get_campaigns_for_user, create_campaign_confs, create_campaign_for_user\n",
    "from typing import List\n",
    "import json\n",
    "\n",
    "env = Env()\n",
    "env.read_env('.env-vlab-vlab', override=True)\n",
    "db_conf = get_db_conf(env)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "USER = \"mchatila@worldbank.org\"\n",
    "CAMPAIGN = \"vaccination-iraq\"\n",
    "CAMPAIGNID = next(c['id'] for c in get_campaigns_for_user(USER, db_conf) \n",
    "                  if c['name'] == CAMPAIGN)\n",
    "\n",
    "# create_campaign_for_user(USER, CAMPAIGN, db_conf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "userinfo, config, db_conf, state, m, confs = load_basics(CAMPAIGNID, env)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "state.campaign"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:root:Loaded 24 adsets from campaign embed-mena-iraq-templates\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "INFO:root:Loaded 0 ads from campaign embed-mena-iraq-templates\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "[(<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574860281\",\n",
       "      \"name\": \"Iraq- GEO - Saladin Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1775\",\n",
       "                      \"name\": \"Saladin Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574850281\",\n",
       "      \"name\": \"Iraq- GEO - Najaf Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1774\",\n",
       "                      \"name\": \"Najaf Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574840281\",\n",
       "      \"name\": \"Iraq- GEO - Kirkuk Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1770\",\n",
       "                      \"name\": \"Kirkuk Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574830281\",\n",
       "      \"name\": \"Iraq- GEO - Diyala Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1767\",\n",
       "                      \"name\": \"Diyala Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574820281\",\n",
       "      \"name\": \"Iraq- GEO - Basra Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1759\",\n",
       "                      \"name\": \"Basra Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574810281\",\n",
       "      \"name\": \"Iraq- GEO - Qadisiyyah Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1761\",\n",
       "                      \"name\": \"Al-Q\\u0101disiyyah Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574800281\",\n",
       "      \"name\": \"Iraq- GEO - Al Anbar Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1758\",\n",
       "                      \"name\": \"Al Anbar Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574790281\",\n",
       "      \"name\": \"Iraq- GEO - Halabja and Sulaymaniyah Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1762\",\n",
       "                      \"name\": \"Sulaymaniyah Governorate\"\n",
       "                  },\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"4334\",\n",
       "                      \"name\": \"Halabja Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574780281\",\n",
       "      \"name\": \"Iraq- GEO - Erbil Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1768\",\n",
       "                      \"name\": \"Erbil Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574770281\",\n",
       "      \"name\": \"Iraq- GEO - Dohuk Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1765\",\n",
       "                      \"name\": \"Dohuk Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574760281\",\n",
       "      \"name\": \"Iraq- GEO - Wasit Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1773\",\n",
       "                      \"name\": \"Wasit Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574750281\",\n",
       "      \"name\": \"Iraq- GEO - Nineveh Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1772\",\n",
       "                      \"name\": \"Nineveh Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574740281\",\n",
       "      \"name\": \"Iraq- GEO - Maysan Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1771\",\n",
       "                      \"name\": \"Maysan Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574730281\",\n",
       "      \"name\": \"Iraq- GEO - Karbala Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1769\",\n",
       "                      \"name\": \"Karbala Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574720281\",\n",
       "      \"name\": \"Iraq- GEO - Dhi Qar Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1766\",\n",
       "                      \"name\": \"Dhi Qar Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574710281\",\n",
       "      \"name\": \"Iraq- GEO - Babil Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1763\",\n",
       "                      \"name\": \"Babil Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002574700281\",\n",
       "      \"name\": \"Iraq- GEO - Muthanna Governorate\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1760\",\n",
       "                      \"name\": \"Muthanna Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002568670281\",\n",
       "      \"name\": \"Iraq- GEO - Baghdad\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ],\n",
       "              \"regions\": [\n",
       "                  {\n",
       "                      \"country\": \"IQ\",\n",
       "                      \"key\": \"1764\",\n",
       "                      \"name\": \"Baghdad Governorate\"\n",
       "                  }\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002559220281\",\n",
       "      \"name\": \"Iraq - Age - 50+\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 50,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002559210281\",\n",
       "      \"name\": \"Iraq - Age - 40-49\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 49,\n",
       "          \"age_min\": 40,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002559200281\",\n",
       "      \"name\": \"Iraq - Age - 30-39\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 39,\n",
       "          \"age_min\": 30,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002548610281\",\n",
       "      \"name\": \"Iraq - Age - 18-29\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 29,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002540670281\",\n",
       "      \"name\": \"Iraq - Gender - Men\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"genders\": [\n",
       "              1\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\",\n",
       "                  \"recent\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  []),\n",
       " (<AdSet> {\n",
       "      \"bid_strategy\": \"LOWEST_COST_WITHOUT_CAP\",\n",
       "      \"daily_budget\": \"2000\",\n",
       "      \"destination_type\": \"MESSENGER\",\n",
       "      \"id\": \"23847002098940281\",\n",
       "      \"name\": \"Iraq - Gender - Women\",\n",
       "      \"optimization_goal\": \"LINK_CLICKS\",\n",
       "      \"optimization_sub_event\": \"NONE\",\n",
       "      \"status\": \"ACTIVE\",\n",
       "      \"targeting\": {\n",
       "          \"age_max\": 65,\n",
       "          \"age_min\": 18,\n",
       "          \"brand_safety_content_filter_levels\": [\n",
       "              \"FACEBOOK_STANDARD\"\n",
       "          ],\n",
       "          \"genders\": [\n",
       "              2\n",
       "          ],\n",
       "          \"geo_locations\": {\n",
       "              \"countries\": [\n",
       "                  \"IQ\"\n",
       "              ],\n",
       "              \"location_types\": [\n",
       "                  \"home\"\n",
       "              ]\n",
       "          },\n",
       "          \"targeting_optimization\": \"none\"\n",
       "      }\n",
       "  },\n",
       "  [])]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "template_state = CampaignState(userinfo.token, get_api(env, userinfo.token), '282370023153169', 'embed-mena-iraq-templates')\n",
    "\n",
    "template_state.campaign_state"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "share_lookup = pd.read_csv('outs/iraq-distribution.csv', header=[0,1], index_col=[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from mena.strata import get_groups\n",
    "\n",
    "groups = get_groups(template_state, share_lookup)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "images = {i['name']: i for i in state.account.get_ad_images(fields=['name', 'hash'])}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "images"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "# CREATING CONFS - MNM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# make creatives conf\n",
    "from adopt.marketing import CreativeConf\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# with tt as (with t as (select row_to_json(json_each(details)) d from (select details from adopt_reports where campaignid = '872cc8af-7b11-4a35-8ae0-b0a64059278b' order by created desc limit 1)) select d->>'key' as stratum, (d->'value'->>'goal')::float as goal,  (d->'value'->>'respondent_share')::float as share, (d->'value'->>'budget')::float as budget from t)  select *, goal - share as dif from tt order by dif desc;\n",
    "\n",
    "# with tt as (with t as (select row_to_json(json_each(details)) d, created from (select details, adopt_reports.created from adopt_reports join campaigns on campaignid = campaigns.id where campaigns.name = 'vaccination-iraq')) select created, d->>'key' as stratum, (d->'value'->>'goal')::float as goal,  (d->'value'->>'respondent_share')::float as share, (d->'value'->>'budget')::float as budget from t) select created, sqrt(sum((goal - share)^2)) as dif from tt group by created order by created;"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "c = {'optimization_goal': 'LINK_CLICKS',\n",
    "     'destination_type': 'MESSENGER',\n",
    "     'adset_hours': 48,\n",
    "     'budget': 400000.0,\n",
    "     'min_budget': 100.0,\n",
    "     'opt_window': 2*24,\n",
    "     'end_date': '2021-02-21',\n",
    "     'proportional': True,\n",
    "     'page_id': '101734981838685',\n",
    "     'instagram_id': None,\n",
    "     'ad_account': '282370023153169',\n",
    "     'ad_campaign': 'embed-mena-iraq-1'}\n",
    "\n",
    "config = CampaignConf(**c)\n",
    "\n",
    "create_campaign_confs(CAMPAIGNID, \"opt\", [config._asdict()], db_conf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "RESPONDENT_AUDIENCE = \"vlab-embed-iraq-vaccination-respondents\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.marketing import make_audience_conf, dict_from_nested_type\n",
    "import json\n",
    "\n",
    "audiences = [\n",
    "    {\n",
    "        \"name\": RESPONDENT_AUDIENCE,\n",
    "        \"shortcodes\": [\"vaccwelcomeiraq\"],\n",
    "        \"subtype\": \"CUSTOM\"\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"vlab-embed-iraq-low-education\",\n",
    "        \"shortcodes\": ['vaccinationiraqen', 'vaccinationiraqar', 'vaccinationkrd'],\n",
    "        \"subtype\": \"LOOKALIKE\",\n",
    "        \"question_targeting\": {\n",
    "            \"op\": \"not_equal\",\n",
    "            \"vars\": [\n",
    "                {\"type\": \"response\", \"value\": \"education\"},\n",
    "                {\"type\": \"constant\", \"value\": \"D\"}\n",
    "            ]\n",
    "        },\n",
    "        \"lookalike\": {\n",
    "            \"name\": \"vlab-embed-mena-iraq-low-education-lookalike\",\n",
    "            \"target\": 2000,\n",
    "            \"spec\": {\n",
    "                \"country\": \"IQ\",\n",
    "                \"starting_ratio\": 0.0,\n",
    "                \"ratio\": 0.2\n",
    "            }\n",
    "        },\n",
    "    },\n",
    "    {\n",
    "        \"name\": \"vlab-embed-iraq-high-education\",\n",
    "        \"shortcodes\": ['vaccinationiraqen', 'vaccinationiraqar', 'vaccinationkrd'],\n",
    "        \"subtype\": \"LOOKALIKE\",\n",
    "        \"question_targeting\": {\n",
    "            \"op\": \"equal\",\n",
    "            \"vars\": [\n",
    "                {\"type\": \"response\", \"value\": \"education\"},\n",
    "                {\"type\": \"constant\", \"value\": \"D\"}\n",
    "            ]\n",
    "        },\n",
    "        \"lookalike\": {\n",
    "            \"name\": \"vlab-embed-mena-iraq-high-education-lookalike\",\n",
    "            \"target\": 2000,\n",
    "            \"spec\": {\n",
    "                \"country\": \"IQ\",\n",
    "                \"starting_ratio\": 0.0,\n",
    "                \"ratio\": 0.2\n",
    "            }\n",
    "        },\n",
    "    },\n",
    "]\n",
    "\n",
    "\n",
    "audience_confs = [make_audience_conf(c) for c in audiences]\n",
    "confs = [dict_from_nested_type(a) for a in audience_confs]\n",
    "\n",
    "create_campaign_confs(CAMPAIGNID, \"audience\", confs, db_conf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.marketing import CreativeConf\n",
    "\n",
    "\n",
    "def _creative_conf(name, image, body, headline, welcome_message, button_text, form):\n",
    "    return {\n",
    "        \"name\": name,\n",
    "        \"image\": image['name'],\n",
    "        \"image_hash\": image['hash'],\n",
    "        \"body\": body,\n",
    "        \"link_text\": headline,\n",
    "        \"welcome_message\": welcome_message,\n",
    "        \"button_text\": button_text,\n",
    "        \"form\": form,\n",
    "    }\n",
    "\n",
    "image_confs = [\n",
    "    ('vlab-embed-iraq-back-to-normal-giveaway', \n",
    "     images['Giveaway_Op_2_Arabic.jpg'],\n",
    "     'ساعدونا لاعادة الحياة الى طبيعتها! أجب عن بعض الأسئلة حول لقاح فيروس كورونا',\n",
    "     'شارك رأيك',\n",
    "     'شارك رأيك واحصل على فرصة للفوز بقسيمة شرائية بقيمة 150,000 دينار عراقي انقر ابدأ لتبدء',\n",
    "     'ابدأ'\n",
    "     ),\n",
    "    ('vlab-embed-iraq-back-to-normal-opinion-1', \n",
    "     images['Share-your-opinion-1.png'],\n",
    "     'ساعدونا لاعادة الحياة الى طبيعتها! أجب عن بعض الأسئلة حول لقاح فيروس كورونا',\n",
    "     'شارك رأيك',\n",
    "     'شارك رأيك واحصل على فرصة للفوز بقسيمة شرائية بقيمة 150,000 دينار عراقي انقر ابدأ لتبدء',\n",
    "     'ابدأ'\n",
    "     ),\n",
    "    ('vlab-embed-iraq-back-to-normal-opinion-2', \n",
    "     images['Share-your-opinion-2.png'],\n",
    "     'ساعدونا لاعادة الحياة الى طبيعتها! أجب عن بعض الأسئلة حول لقاح فيروس كورونا',\n",
    "     'شارك رأيك',\n",
    "     'شارك رأيك واحصل على فرصة للفوز بقسيمة شرائية بقيمة 150,000 دينار عراقي انقر ابدأ لتبدء',\n",
    "     'ابدأ'\n",
    "     ),\n",
    "    ('vlab-embed-iraq-lottery', \n",
    "     images['0000_FB AD ARABIC.jpg'],\n",
    "     '!شارك رأيك واحصل على فرصة لفوز قسيمة شرائية بقيمة 150000 الدينار العراقي',\n",
    "     'شارك رأيك',\n",
    "     'شارك رأيك واحصل على فرصة للفوز بقسيمة شرائية بقيمة 150,000 دينار عراقي انقر ابدأ لتبدء',\n",
    "     'ابدأ'\n",
    "     ),\n",
    "]\n",
    "\n",
    "creatives = [CreativeConf(**_creative_conf(*c, 'vaccwelcomeiraq')) for c in image_confs]\n",
    "confs = [c._asdict() for c in creatives]\n",
    "\n",
    "create_campaign_confs(CAMPAIGNID, \"creative\", confs, db_conf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "ALL_CREATIVES = [t[0] for t in image_confs]\n",
    "\n",
    "def make_stratum(id_, quota, targeting):\n",
    "    return { 'id': id_,\n",
    "             'metadata': {'stratumid': id_, 'country': 'iraq'},\n",
    "             'facebook_targeting': targeting, \n",
    "             'creatives': ALL_CREATIVES,\n",
    "             'audiences': ['vlab-embed-mena-iraq-low-education-lookalike'],\n",
    "             'excluded_audiences': [RESPONDENT_AUDIENCE],\n",
    "             'quota': quota,\n",
    "             'shortcodes': ['vaccinationiraqen', 'vaccinationiraqar', 'vaccinationkrd'],\n",
    "             'question_targeting': {\n",
    "                 'op': 'and',\n",
    "                 'vars': [\n",
    "                     { 'op': 'equal',\n",
    "                       'vars': [{'type': 'response', 'value': 'md:stratumid'},\n",
    "                                {'type': 'constant', 'value': id_}]},\n",
    "                     { 'op': 'answered',\n",
    "                       'vars': [{'type': 'response', 'value': 'age_cat'}]}\n",
    "                 ]\n",
    "             }}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.marketing import make_stratum_conf\n",
    "\n",
    "strata = [make_stratum(*g) for g in groups]\n",
    "strata_data = [dict_from_nested_type(make_stratum_conf(c)) for c in strata]\n",
    "create_campaign_confs(CAMPAIGNID, \"stratum\", strata_data, db_conf)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "collapsed": false
   },
   "source": [
    "# TESTING"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "mal = load_basics(CAMPAIGNID, env)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[AudienceConf(name='vlab-embed-iraq-vaccination-respondents', subtype='CUSTOM', shortcodes=['vaccwelcomeiraq'], question_targeting=None, lookalike=None),\n",
       " AudienceConf(name='vlab-embed-iraq-low-education', subtype='LOOKALIKE', shortcodes=['vaccinationiraqen', 'vaccinationiraqar', 'vaccinationkrd'], question_targeting=QuestionTargeting(op='not_equal', vars=[TargetVar(type='response', value='education'), TargetVar(type='constant', value='D')], name=None), lookalike=Lookalike(name='vlab-embed-mena-iraq-low-education-lookalike', target=500, spec=LookalikeSpec(country='IQ', ratio=0.2, starting_ratio=0.0))),\n",
       " AudienceConf(name='vlab-embed-iraq-high-education', subtype='LOOKALIKE', shortcodes=['vaccinationiraqen', 'vaccinationiraqar', 'vaccinationkrd'], question_targeting=QuestionTargeting(op='equal', vars=[TargetVar(type='response', value='education'), TargetVar(type='constant', value='D')], name=None), lookalike=Lookalike(name='vlab-embed-mena-iraq-high-education-lookalike', target=500, spec=LookalikeSpec(country='IQ', ratio=0.2, starting_ratio=0.0)))]"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mal.confs['audience']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "%%time\n",
    "\n",
    "from adopt.malaria import update_ads_for_campaign\n",
    "\n",
    "instructions, report = update_ads_for_campaign(mal)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.campaign_queries import create_adopt_report\n",
    "\n",
    "db_conf['user'] = 'adopt'\n",
    "create_adopt_report(CAMPAIGNID, 'FACEBOOK_ADOPT', report, db_conf)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "rdf = pd.DataFrame(report).T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "finals = (rdf.respondents + (rdf.budget / rdf.price)*4).reset_index(name = 'respondents')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "finals['share'] = finals.respondents / finals.respondents.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "finals = finals.rename(columns={'index': 'stratum'}).sort_values('share', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "share_lookup[['1']].sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "share_lookup[['2']].sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "finals[finals.stratum.str.contains('-2-')].share.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "finals.to_csv('iraq-projection.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.malaria import run_instructions\n",
    "\n",
    "run_instructions(instructions, mal.state)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "from adopt.malaria import get_df\n",
    "\n",
    "userinfo, config, db_conf, state, m, confs = mal\n",
    "audience_confs = confs[\"audience\"]\n",
    "\n",
    "df = get_df(db_conf, userinfo.survey_user, audience_confs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[AudienceConf(name='vlab-embed-iraq-vaccination-respondents', subtype='CUSTOM', shortcodes=['vaccwelcomeiraq'], question_targeting=None, lookalike=None)]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "audience_confs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "argv": [
    "python",
    "-m",
    "ipykernel_launcher",
    "-f",
    "{connection_file}"
   ],
   "display_name": "Python 3",
   "env": null,
   "interrupt_mode": "signal",
   "language": "python",
   "metadata": null,
   "name": "python3"
  },
  "name": "iraq-make-strata.ipynb"
 },
 "nbformat": 4,
 "nbformat_minor": 4
}