traffic_api.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "Request made: ClientCustomerId: 2218314699, Host: googleads.googleapis.com, Method: /google.ads.googleads.v15.services.KeywordPlanIdeaService/GenerateKeywordHistoricalMetrics, RequestId: AYKlQI9vQvoWUld23XyHgw, IsFault: True, FaultMessage: The developer token is only approved for use with test accounts. To access non-test accounts, apply for Basic or Standard access.\n"
     ]
    },
    {
     "ename": "GoogleAdsException",
     "evalue": "(<_InactiveRpcError of RPC that terminated with:\n\tstatus = StatusCode.PERMISSION_DENIED\n\tdetails = \"The caller does not have permission\"\n\tdebug_error_string = \"UNKNOWN:Error received from peer ipv4:142.250.180.170:443 {created_time:\"2023-11-02T16:36:01.5487966+00:00\", grpc_status:7, grpc_message:\"The caller does not have permission\"}\"\n>, <_InactiveRpcError of RPC that terminated with:\n\tstatus = StatusCode.PERMISSION_DENIED\n\tdetails = \"The caller does not have permission\"\n\tdebug_error_string = \"UNKNOWN:Error received from peer ipv4:142.250.180.170:443 {created_time:\"2023-11-02T16:36:01.5487966+00:00\", grpc_status:7, grpc_message:\"The caller does not have permission\"}\"\n>, errors {\n  error_code {\n    authorization_error: DEVELOPER_TOKEN_NOT_APPROVED\n  }\n  message: \"The developer token is only approved for use with test accounts. To access non-test accounts, apply for Basic or Standard access.\"\n}\nrequest_id: \"AYKlQI9vQvoWUld23XyHgw\"\n, 'AYKlQI9vQvoWUld23XyHgw')",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mGoogleAdsException\u001b[0m                        Traceback (most recent call last)",
      "\u001b[1;32me:\\python\\script\\Clusterizer\\traffic_api.ipynb Cell 1\u001b[0m line \u001b[0;36m5\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=52'>53</a>\u001b[0m client \u001b[39m=\u001b[39m GoogleAdsClient\u001b[39m.\u001b[39mload_from_storage(config_path)\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=54'>55</a>\u001b[0m \u001b[39m# Esegui la funzione principale\u001b[39;00m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=55'>56</a>\u001b[0m \u001b[39m# account searcus\u001b[39;00m\n\u001b[1;32m---> <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=56'>57</a>\u001b[0m main(client, \u001b[39m\"\u001b[39;49m\u001b[39m2218314651\u001b[39;49m\u001b[39m\"\u001b[39;49m, df[\u001b[39m'\u001b[39;49m\u001b[39mKeywords\u001b[39;49m\u001b[39m'\u001b[39;49m]\u001b[39m.\u001b[39;49mtolist())  \u001b[39m# Sostituisci con il tuo ID cliente\u001b[39;00m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=58'>59</a>\u001b[0m \u001b[39m# account personale\u001b[39;00m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=59'>60</a>\u001b[0m \u001b[39m#main(client, \"5907664432\", df['Keywords'].tolist())  # Sostituisci con il tuo ID cliente\u001b[39;00m\n",
      "\u001b[1;32me:\\python\\script\\Clusterizer\\traffic_api.ipynb Cell 1\u001b[0m line \u001b[0;36m7\n\u001b[0;32m      <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=5'>6</a>\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mmain\u001b[39m(client, customer_id, keywords_list):\n\u001b[1;32m----> <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=6'>7</a>\u001b[0m     generate_historical_metrics(client, customer_id, keywords_list)\n",
      "\u001b[1;32me:\\python\\script\\Clusterizer\\traffic_api.ipynb Cell 1\u001b[0m line \u001b[0;36m2\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=14'>15</a>\u001b[0m request\u001b[39m.\u001b[39mkeywords \u001b[39m=\u001b[39m keywords_list\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=16'>17</a>\u001b[0m \u001b[39m# Qui puoi impostare altri parametri come la geolocalizzazione, la lingua, ecc.\u001b[39;00m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=17'>18</a>\u001b[0m \n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=18'>19</a>\u001b[0m \u001b[39m# Esegui la chiamata API e ottieni la risposta\u001b[39;00m\n\u001b[1;32m---> <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=19'>20</a>\u001b[0m response \u001b[39m=\u001b[39m keyword_plan_idea_service\u001b[39m.\u001b[39;49mgenerate_keyword_historical_metrics(request\u001b[39m=\u001b[39;49mrequest)\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=21'>22</a>\u001b[0m \u001b[39m# Inizializza un DataFrame per conservare i risultati\u001b[39;00m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=22'>23</a>\u001b[0m df_results \u001b[39m=\u001b[39m pd\u001b[39m.\u001b[39mDataFrame(columns\u001b[39m=\u001b[39m[\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=23'>24</a>\u001b[0m     \u001b[39m'\u001b[39m\u001b[39mKeyword\u001b[39m\u001b[39m'\u001b[39m, \u001b[39m'\u001b[39m\u001b[39mAvgMonthlySearches\u001b[39m\u001b[39m'\u001b[39m, \u001b[39m'\u001b[39m\u001b[39mCompetition\u001b[39m\u001b[39m'\u001b[39m, \u001b[39m'\u001b[39m\u001b[39mCompetitionIndex\u001b[39m\u001b[39m'\u001b[39m,\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=24'>25</a>\u001b[0m     \u001b[39m'\u001b[39m\u001b[39mLowTopOfPageBid\u001b[39m\u001b[39m'\u001b[39m, \u001b[39m'\u001b[39m\u001b[39mHighTopOfPageBid\u001b[39m\u001b[39m'\u001b[39m\n\u001b[0;32m     <a href='vscode-notebook-cell:/e%3A/python/script/Clusterizer/traffic_api.ipynb#W0sZmlsZQ%3D%3D?line=25'>26</a>\u001b[0m ])\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\google\\ads\\googleads\\v15\\services\\services\\keyword_plan_idea_service\\client.py:538\u001b[0m, in \u001b[0;36mKeywordPlanIdeaServiceClient.generate_keyword_historical_metrics\u001b[1;34m(self, request, retry, timeout, metadata)\u001b[0m\n\u001b[0;32m    531\u001b[0m metadata \u001b[39m=\u001b[39m \u001b[39mtuple\u001b[39m(metadata) \u001b[39m+\u001b[39m (\n\u001b[0;32m    532\u001b[0m     gapic_v1\u001b[39m.\u001b[39mrouting_header\u001b[39m.\u001b[39mto_grpc_metadata(\n\u001b[0;32m    533\u001b[0m         ((\u001b[39m\"\u001b[39m\u001b[39mcustomer_id\u001b[39m\u001b[39m\"\u001b[39m, request\u001b[39m.\u001b[39mcustomer_id),)\n\u001b[0;32m    534\u001b[0m     ),\n\u001b[0;32m    535\u001b[0m )\n\u001b[0;32m    537\u001b[0m \u001b[39m# Send the request.\u001b[39;00m\n\u001b[1;32m--> 538\u001b[0m response \u001b[39m=\u001b[39m rpc(\n\u001b[0;32m    539\u001b[0m     request,\n\u001b[0;32m    540\u001b[0m     retry\u001b[39m=\u001b[39;49mretry,\n\u001b[0;32m    541\u001b[0m     timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[0;32m    542\u001b[0m     metadata\u001b[39m=\u001b[39;49mmetadata,\n\u001b[0;32m    543\u001b[0m )\n\u001b[0;32m    545\u001b[0m \u001b[39m# Done; return the response.\u001b[39;00m\n\u001b[0;32m    546\u001b[0m \u001b[39mreturn\u001b[39;00m response\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\google\\api_core\\gapic_v1\\method.py:131\u001b[0m, in \u001b[0;36m_GapicCallable.__call__\u001b[1;34m(self, timeout, retry, compression, *args, **kwargs)\u001b[0m\n\u001b[0;32m    128\u001b[0m \u001b[39mif\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_compression \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[0;32m    129\u001b[0m     kwargs[\u001b[39m\"\u001b[39m\u001b[39mcompression\u001b[39m\u001b[39m\"\u001b[39m] \u001b[39m=\u001b[39m compression\n\u001b[1;32m--> 131\u001b[0m \u001b[39mreturn\u001b[39;00m wrapped_func(\u001b[39m*\u001b[39margs, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs)\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\google\\api_core\\grpc_helpers.py:75\u001b[0m, in \u001b[0;36m_wrap_unary_errors.<locals>.error_remapped_callable\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m     72\u001b[0m \u001b[39m@functools\u001b[39m\u001b[39m.\u001b[39mwraps(callable_)\n\u001b[0;32m     73\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39merror_remapped_callable\u001b[39m(\u001b[39m*\u001b[39margs, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs):\n\u001b[0;32m     74\u001b[0m     \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m---> 75\u001b[0m         \u001b[39mreturn\u001b[39;00m callable_(\u001b[39m*\u001b[39margs, \u001b[39m*\u001b[39m\u001b[39m*\u001b[39mkwargs)\n\u001b[0;32m     76\u001b[0m     \u001b[39mexcept\u001b[39;00m grpc\u001b[39m.\u001b[39mRpcError \u001b[39mas\u001b[39;00m exc:\n\u001b[0;32m     77\u001b[0m         \u001b[39mraise\u001b[39;00m exceptions\u001b[39m.\u001b[39mfrom_grpc_error(exc) \u001b[39mfrom\u001b[39;00m \u001b[39mexc\u001b[39;00m\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:277\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable.__call__\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    268\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39m__call__\u001b[39m(\n\u001b[0;32m    269\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[0;32m    270\u001b[0m     request: Any,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    275\u001b[0m     compression: Optional[grpc\u001b[39m.\u001b[39mCompression] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m,\n\u001b[0;32m    276\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m Any:\n\u001b[1;32m--> 277\u001b[0m     response, ignored_call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_with_call(\n\u001b[0;32m    278\u001b[0m         request,\n\u001b[0;32m    279\u001b[0m         timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[0;32m    280\u001b[0m         metadata\u001b[39m=\u001b[39;49mmetadata,\n\u001b[0;32m    281\u001b[0m         credentials\u001b[39m=\u001b[39;49mcredentials,\n\u001b[0;32m    282\u001b[0m         wait_for_ready\u001b[39m=\u001b[39;49mwait_for_ready,\n\u001b[0;32m    283\u001b[0m         compression\u001b[39m=\u001b[39;49mcompression,\n\u001b[0;32m    284\u001b[0m     )\n\u001b[0;32m    285\u001b[0m     \u001b[39mreturn\u001b[39;00m response\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:332\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable._with_call\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    327\u001b[0m         \u001b[39mreturn\u001b[39;00m _FailureOutcome(exception, sys\u001b[39m.\u001b[39mexc_info()[\u001b[39m2\u001b[39m])\n\u001b[0;32m    329\u001b[0m call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_interceptor\u001b[39m.\u001b[39mintercept_unary_unary(\n\u001b[0;32m    330\u001b[0m     continuation, client_call_details, request\n\u001b[0;32m    331\u001b[0m )\n\u001b[1;32m--> 332\u001b[0m \u001b[39mreturn\u001b[39;00m call\u001b[39m.\u001b[39;49mresult(), call\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:171\u001b[0m, in \u001b[0;36m_FailureOutcome.result\u001b[1;34m(self, ignored_timeout)\u001b[0m\n\u001b[0;32m    170\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mresult\u001b[39m(\u001b[39mself\u001b[39m, ignored_timeout: Optional[\u001b[39mfloat\u001b[39m] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m):\n\u001b[1;32m--> 171\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_exception\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:315\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable._with_call.<locals>.continuation\u001b[1;34m(new_details, request)\u001b[0m\n\u001b[0;32m    306\u001b[0m (\n\u001b[0;32m    307\u001b[0m     new_method,\n\u001b[0;32m    308\u001b[0m     new_timeout,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    312\u001b[0m     new_compression,\n\u001b[0;32m    313\u001b[0m ) \u001b[39m=\u001b[39m _unwrap_client_call_details(new_details, client_call_details)\n\u001b[0;32m    314\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> 315\u001b[0m     response, call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_thunk(new_method)\u001b[39m.\u001b[39;49mwith_call(\n\u001b[0;32m    316\u001b[0m         request,\n\u001b[0;32m    317\u001b[0m         timeout\u001b[39m=\u001b[39;49mnew_timeout,\n\u001b[0;32m    318\u001b[0m         metadata\u001b[39m=\u001b[39;49mnew_metadata,\n\u001b[0;32m    319\u001b[0m         credentials\u001b[39m=\u001b[39;49mnew_credentials,\n\u001b[0;32m    320\u001b[0m         wait_for_ready\u001b[39m=\u001b[39;49mnew_wait_for_ready,\n\u001b[0;32m    321\u001b[0m         compression\u001b[39m=\u001b[39;49mnew_compression,\n\u001b[0;32m    322\u001b[0m     )\n\u001b[0;32m    323\u001b[0m     \u001b[39mreturn\u001b[39;00m _UnaryOutcome(response, call)\n\u001b[0;32m    324\u001b[0m \u001b[39mexcept\u001b[39;00m grpc\u001b[39m.\u001b[39mRpcError \u001b[39mas\u001b[39;00m rpc_error:\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:343\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable.with_call\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    334\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mwith_call\u001b[39m(\n\u001b[0;32m    335\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[0;32m    336\u001b[0m     request: Any,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    341\u001b[0m     compression: Optional[grpc\u001b[39m.\u001b[39mCompression] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m,\n\u001b[0;32m    342\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m Tuple[Any, grpc\u001b[39m.\u001b[39mCall]:\n\u001b[1;32m--> 343\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_with_call(\n\u001b[0;32m    344\u001b[0m         request,\n\u001b[0;32m    345\u001b[0m         timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[0;32m    346\u001b[0m         metadata\u001b[39m=\u001b[39;49mmetadata,\n\u001b[0;32m    347\u001b[0m         credentials\u001b[39m=\u001b[39;49mcredentials,\n\u001b[0;32m    348\u001b[0m         wait_for_ready\u001b[39m=\u001b[39;49mwait_for_ready,\n\u001b[0;32m    349\u001b[0m         compression\u001b[39m=\u001b[39;49mcompression,\n\u001b[0;32m    350\u001b[0m     )\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:332\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable._with_call\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    327\u001b[0m         \u001b[39mreturn\u001b[39;00m _FailureOutcome(exception, sys\u001b[39m.\u001b[39mexc_info()[\u001b[39m2\u001b[39m])\n\u001b[0;32m    329\u001b[0m call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_interceptor\u001b[39m.\u001b[39mintercept_unary_unary(\n\u001b[0;32m    330\u001b[0m     continuation, client_call_details, request\n\u001b[0;32m    331\u001b[0m )\n\u001b[1;32m--> 332\u001b[0m \u001b[39mreturn\u001b[39;00m call\u001b[39m.\u001b[39;49mresult(), call\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:171\u001b[0m, in \u001b[0;36m_FailureOutcome.result\u001b[1;34m(self, ignored_timeout)\u001b[0m\n\u001b[0;32m    170\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mresult\u001b[39m(\u001b[39mself\u001b[39m, ignored_timeout: Optional[\u001b[39mfloat\u001b[39m] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m):\n\u001b[1;32m--> 171\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_exception\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:315\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable._with_call.<locals>.continuation\u001b[1;34m(new_details, request)\u001b[0m\n\u001b[0;32m    306\u001b[0m (\n\u001b[0;32m    307\u001b[0m     new_method,\n\u001b[0;32m    308\u001b[0m     new_timeout,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    312\u001b[0m     new_compression,\n\u001b[0;32m    313\u001b[0m ) \u001b[39m=\u001b[39m _unwrap_client_call_details(new_details, client_call_details)\n\u001b[0;32m    314\u001b[0m \u001b[39mtry\u001b[39;00m:\n\u001b[1;32m--> 315\u001b[0m     response, call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_thunk(new_method)\u001b[39m.\u001b[39;49mwith_call(\n\u001b[0;32m    316\u001b[0m         request,\n\u001b[0;32m    317\u001b[0m         timeout\u001b[39m=\u001b[39;49mnew_timeout,\n\u001b[0;32m    318\u001b[0m         metadata\u001b[39m=\u001b[39;49mnew_metadata,\n\u001b[0;32m    319\u001b[0m         credentials\u001b[39m=\u001b[39;49mnew_credentials,\n\u001b[0;32m    320\u001b[0m         wait_for_ready\u001b[39m=\u001b[39;49mnew_wait_for_ready,\n\u001b[0;32m    321\u001b[0m         compression\u001b[39m=\u001b[39;49mnew_compression,\n\u001b[0;32m    322\u001b[0m     )\n\u001b[0;32m    323\u001b[0m     \u001b[39mreturn\u001b[39;00m _UnaryOutcome(response, call)\n\u001b[0;32m    324\u001b[0m \u001b[39mexcept\u001b[39;00m grpc\u001b[39m.\u001b[39mRpcError \u001b[39mas\u001b[39;00m rpc_error:\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:343\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable.with_call\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    334\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mwith_call\u001b[39m(\n\u001b[0;32m    335\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[0;32m    336\u001b[0m     request: Any,\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m    341\u001b[0m     compression: Optional[grpc\u001b[39m.\u001b[39mCompression] \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m,\n\u001b[0;32m    342\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m Tuple[Any, grpc\u001b[39m.\u001b[39mCall]:\n\u001b[1;32m--> 343\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_with_call(\n\u001b[0;32m    344\u001b[0m         request,\n\u001b[0;32m    345\u001b[0m         timeout\u001b[39m=\u001b[39;49mtimeout,\n\u001b[0;32m    346\u001b[0m         metadata\u001b[39m=\u001b[39;49mmetadata,\n\u001b[0;32m    347\u001b[0m         credentials\u001b[39m=\u001b[39;49mcredentials,\n\u001b[0;32m    348\u001b[0m         wait_for_ready\u001b[39m=\u001b[39;49mwait_for_ready,\n\u001b[0;32m    349\u001b[0m         compression\u001b[39m=\u001b[39;49mcompression,\n\u001b[0;32m    350\u001b[0m     )\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\grpc\\_interceptor.py:329\u001b[0m, in \u001b[0;36m_UnaryUnaryMultiCallable._with_call\u001b[1;34m(self, request, timeout, metadata, credentials, wait_for_ready, compression)\u001b[0m\n\u001b[0;32m    326\u001b[0m     \u001b[39mexcept\u001b[39;00m \u001b[39mException\u001b[39;00m \u001b[39mas\u001b[39;00m exception:  \u001b[39m# pylint:disable=broad-except\u001b[39;00m\n\u001b[0;32m    327\u001b[0m         \u001b[39mreturn\u001b[39;00m _FailureOutcome(exception, sys\u001b[39m.\u001b[39mexc_info()[\u001b[39m2\u001b[39m])\n\u001b[1;32m--> 329\u001b[0m call \u001b[39m=\u001b[39m \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_interceptor\u001b[39m.\u001b[39;49mintercept_unary_unary(\n\u001b[0;32m    330\u001b[0m     continuation, client_call_details, request\n\u001b[0;32m    331\u001b[0m )\n\u001b[0;32m    332\u001b[0m \u001b[39mreturn\u001b[39;00m call\u001b[39m.\u001b[39mresult(), call\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\google\\ads\\googleads\\interceptors\\exception_interceptor.py:99\u001b[0m, in \u001b[0;36mExceptionInterceptor.intercept_unary_unary\u001b[1;34m(self, continuation, client_call_details, request)\u001b[0m\n\u001b[0;32m     96\u001b[0m exception \u001b[39m=\u001b[39m response\u001b[39m.\u001b[39mexception()\n\u001b[0;32m     98\u001b[0m \u001b[39mif\u001b[39;00m exception:\n\u001b[1;32m---> 99\u001b[0m     \u001b[39mself\u001b[39;49m\u001b[39m.\u001b[39;49m_handle_grpc_failure(response)\n\u001b[0;32m    100\u001b[0m \u001b[39melse\u001b[39;00m:\n\u001b[0;32m    101\u001b[0m     \u001b[39mreturn\u001b[39;00m _UnaryUnaryWrapper(\n\u001b[0;32m    102\u001b[0m         response, use_proto_plus\u001b[39m=\u001b[39m\u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_use_proto_plus\n\u001b[0;32m    103\u001b[0m     )\n",
      "File \u001b[1;32me:\\python\\ambiente\\lib\\site-packages\\google\\ads\\googleads\\interceptors\\exception_interceptor.py:71\u001b[0m, in \u001b[0;36mExceptionInterceptor._handle_grpc_failure\u001b[1;34m(self, response)\u001b[0m\n\u001b[0;32m     47\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39m_handle_grpc_failure\u001b[39m(\u001b[39mself\u001b[39m, response):\n\u001b[0;32m     48\u001b[0m \u001b[39m    \u001b[39m\u001b[39m\"\"\"Attempts to convert failed responses to a GoogleAdsException object.\u001b[39;00m\n\u001b[0;32m     49\u001b[0m \n\u001b[0;32m     50\u001b[0m \u001b[39m    Handles failed gRPC responses of by attempting to convert them\u001b[39;00m\n\u001b[1;32m   (...)\u001b[0m\n\u001b[0;32m     69\u001b[0m \u001b[39m            will be raised as-is.\u001b[39;00m\n\u001b[0;32m     70\u001b[0m \u001b[39m    \"\"\"\u001b[39;00m\n\u001b[1;32m---> 71\u001b[0m     \u001b[39mraise\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_get_error_from_response(response)\n",
      "\u001b[1;31mGoogleAdsException\u001b[0m: (<_InactiveRpcError of RPC that terminated with:\n\tstatus = StatusCode.PERMISSION_DENIED\n\tdetails = \"The caller does not have permission\"\n\tdebug_error_string = \"UNKNOWN:Error received from peer ipv4:142.250.180.170:443 {created_time:\"2023-11-02T16:36:01.5487966+00:00\", grpc_status:7, grpc_message:\"The caller does not have permission\"}\"\n>, <_InactiveRpcError of RPC that terminated with:\n\tstatus = StatusCode.PERMISSION_DENIED\n\tdetails = \"The caller does not have permission\"\n\tdebug_error_string = \"UNKNOWN:Error received from peer ipv4:142.250.180.170:443 {created_time:\"2023-11-02T16:36:01.5487966+00:00\", grpc_status:7, grpc_message:\"The caller does not have permission\"}\"\n>, errors {\n  error_code {\n    authorization_error: DEVELOPER_TOKEN_NOT_APPROVED\n  }\n  message: \"The developer token is only approved for use with test accounts. To access non-test accounts, apply for Basic or Standard access.\"\n}\nrequest_id: \"AYKlQI9vQvoWUld23XyHgw\"\n, 'AYKlQI9vQvoWUld23XyHgw')"
     ]
    }
   ],
   "source": [
    "#customer_id = \"943-572-1339\"\n",
    "\n",
    "import pandas as pd\n",
    "from google.ads.googleads.client import GoogleAdsClient\n",
    "\n",
    "def main(client, customer_id, keywords_list):\n",
    "    generate_historical_metrics(client, customer_id, keywords_list)\n",
    "\n",
    "def generate_historical_metrics(client, customer_id, keywords_list):\n",
    "    googleads_service = client.get_service(\"GoogleAdsService\")\n",
    "    keyword_plan_idea_service = client.get_service(\"KeywordPlanIdeaService\")\n",
    "    \n",
    "    request = client.get_type(\"GenerateKeywordHistoricalMetricsRequest\")\n",
    "    request.customer_id = customer_id\n",
    "    request.keywords = keywords_list\n",
    "    \n",
    "    # Qui puoi impostare altri parametri come la geolocalizzazione, la lingua, ecc.\n",
    "\n",
    "    # Esegui la chiamata API e ottieni la risposta\n",
    "    response = keyword_plan_idea_service.generate_keyword_historical_metrics(request=request)\n",
    "    \n",
    "    # Inizializza un DataFrame per conservare i risultati\n",
    "    df_results = pd.DataFrame(columns=[\n",
    "        'Keyword', 'AvgMonthlySearches', 'Competition', 'CompetitionIndex',\n",
    "        'LowTopOfPageBid', 'HighTopOfPageBid'\n",
    "    ])\n",
    "    \n",
    "    # Estrai e salva i risultati nel DataFrame\n",
    "    for result in response.results:\n",
    "        metrics = result.keyword_metrics\n",
    "        df_results = df_results.append({\n",
    "            'Keyword': result.text,\n",
    "            'AvgMonthlySearches': metrics.avg_monthly_searches,\n",
    "            'Competition': metrics.competition,\n",
    "            'CompetitionIndex': metrics.competition_index,\n",
    "            'LowTopOfPageBid': metrics.low_top_of_page_bid_micros,\n",
    "            'HighTopOfPageBid': metrics.high_top_of_page_bid_micros,\n",
    "        }, ignore_index=True)\n",
    "    \n",
    "    # Salva il DataFrame in un file CSV\n",
    "    df_results.to_csv('historical_keyword_metrics.csv', index=False)\n",
    "\n",
    "# Carica il DataFrame da un file CSV (o come preferisci)\n",
    "# df = pd.read_csv(\"path/to/your/keyword_file.csv\")\n",
    "\n",
    "# DataFrame di esempio\n",
    "df = pd.DataFrame({\n",
    "    'Keywords': ['pneumatici', 'gomme', 'gomme auto']\n",
    "})\n",
    "\n",
    "# Inizializza il client di Google Ads\n",
    "config_path = \"google-ads.yaml\"  # Sostituisci con il percorso al tuo file di configurazione\n",
    "client = GoogleAdsClient.load_from_storage(config_path)\n",
    "\n",
    "# Esegui la funzione principale\n",
    "# account searcus\n",
    "main(client, \"2218314651\", df['Keywords'].tolist())  # Sostituisci con il tuo ID cliente\n",
    "\n",
    "# account personale\n",
    "#main(client, \"5907664432\", df['Keywords'].tolist())  # Sostituisci con il tuo ID cliente\n",
    "\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "ambiente",
   "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.10.11"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}