seo_news.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/dadashzadeh/seo-news/blob/main/seo_news.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from lxml import html\n",
        "import datetime\n",
        "import pandas as pd"
      ],
      "metadata": {
        "id": "Gdw-SPx70nFL"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## googlenews"
      ],
      "metadata": {
        "id": "pfLfwMQ60f-L"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install GoogleNews"
      ],
      "metadata": {
        "id": "mDLkXTD90l0s"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "AhDoXQwZu34C"
      },
      "outputs": [],
      "source": [
        "# Importing necessary libraries\n",
        "from GoogleNews import GoogleNews\n",
        "\n",
        "# Setting up the parameters for GoogleNews search\n",
        "googlenews = GoogleNews()\n",
        "googlenews.set_period('1d')\n",
        "googlenews.set_lang('en')\n",
        "googlenews.set_encode('utf-8')\n",
        "\n",
        "# keyword GoogleNews search\n",
        "googlenews.search('SEO')\n",
        "\n",
        "# Creating a dataframe from the results of the GoogleNews search\n",
        "data = pd.DataFrame.from_dict(googlenews.results())\n",
        "data = data.drop(columns=[\"img\", \"date\", \"media\"])\n",
        "data['datetime'] = pd.to_datetime(data['datetime']).dt.strftime('%Y/%m/%d %H:%M:%S')\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "5kYvJzfaOoqU",
        "outputId": "135fb71a-965d-4d3d-c140-7ac398154ff8"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                               title             datetime  \\\n",
              "0                   Affordable SEO Insights Platform  2024/01/12 19:49:00   \n",
              "1  12 Most Common SEO Issues with E-Commerce Webs...  2024/01/12 17:52:04   \n",
              "2                The latest jobs in search marketing  2024/01/12 16:52:04   \n",
              "3  Satwiksairaj Rankireddy-Chirag Shetty Vs Kang ...  2024/01/12 16:52:04   \n",
              "4  World champions Kang/Seo go toe-to-toe against...  2024/01/12 15:52:04   \n",
              "5  Optimizing Excellence: Balancing Cost and Qual...  2024/01/12 14:52:04   \n",
              "6        5 Reasons to Hire Professional SEO Services  2024/01/12 14:52:04   \n",
              "7  Disclosing the Insider Facts of Picking the Ri...  2024/01/12 13:52:04   \n",
              "8  The Importance of Backlinks in Digital Marketi...  2024/01/12 13:52:04   \n",
              "9  Video: Google Web & Local Ranking Updates, Qua...  2024/01/12 13:52:04   \n",
              "\n",
              "  desc                                               link  \n",
              "0       https://www.trendhunter.com/trends/seo-stuff&v...  \n",
              "1       https://techbullion.com/12-most-common-seo-iss...  \n",
              "2       https://searchengineland.com/latest-jobs-in-se...  \n",
              "3       https://www.outlookindia.com/sports/satwiksair...  \n",
              "4       https://www.youtube.com/watch%3Fv%3DSqxuAzTT3F...  \n",
              "5       https://www.asiaone.com/business/optimizing-ex...  \n",
              "6       https://techbullion.com/5-reasons-to-hire-prof...  \n",
              "7       https://theinscribermag.com/disclosing-the-ins...  \n",
              "8       https://beststocks.com/the-importance-of-backl...  \n",
              "9       https://www.seroundtable.com/video-01-12-2024-...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-000c28c5-c59c-4265-9639-8dfd6d754a15\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>title</th>\n",
              "      <th>datetime</th>\n",
              "      <th>desc</th>\n",
              "      <th>link</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Affordable SEO Insights Platform</td>\n",
              "      <td>2024/01/12 19:49:00</td>\n",
              "      <td></td>\n",
              "      <td>https://www.trendhunter.com/trends/seo-stuff&amp;v...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>12 Most Common SEO Issues with E-Commerce Webs...</td>\n",
              "      <td>2024/01/12 17:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://techbullion.com/12-most-common-seo-iss...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>The latest jobs in search marketing</td>\n",
              "      <td>2024/01/12 16:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://searchengineland.com/latest-jobs-in-se...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Satwiksairaj Rankireddy-Chirag Shetty Vs Kang ...</td>\n",
              "      <td>2024/01/12 16:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://www.outlookindia.com/sports/satwiksair...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>World champions Kang/Seo go toe-to-toe against...</td>\n",
              "      <td>2024/01/12 15:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://www.youtube.com/watch%3Fv%3DSqxuAzTT3F...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Optimizing Excellence: Balancing Cost and Qual...</td>\n",
              "      <td>2024/01/12 14:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://www.asiaone.com/business/optimizing-ex...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>5 Reasons to Hire Professional SEO Services</td>\n",
              "      <td>2024/01/12 14:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://techbullion.com/5-reasons-to-hire-prof...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Disclosing the Insider Facts of Picking the Ri...</td>\n",
              "      <td>2024/01/12 13:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://theinscribermag.com/disclosing-the-ins...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>The Importance of Backlinks in Digital Marketi...</td>\n",
              "      <td>2024/01/12 13:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://beststocks.com/the-importance-of-backl...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Video: Google Web &amp; Local Ranking Updates, Qua...</td>\n",
              "      <td>2024/01/12 13:52:04</td>\n",
              "      <td></td>\n",
              "      <td>https://www.seroundtable.com/video-01-12-2024-...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-000c28c5-c59c-4265-9639-8dfd6d754a15')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-000c28c5-c59c-4265-9639-8dfd6d754a15 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-000c28c5-c59c-4265-9639-8dfd6d754a15');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-bd472d92-820a-4c63-8436-97f4a2fa7c2b\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bd472d92-820a-4c63-8436-97f4a2fa7c2b')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-bd472d92-820a-4c63-8436-97f4a2fa7c2b button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## rss data"
      ],
      "metadata": {
        "id": "InaODgjE0syy"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install feedparser"
      ],
      "metadata": {
        "id": "udvE1Cye0v6s"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import feedparser"
      ],
      "metadata": {
        "id": "XYNrcRIO09mE"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# List of RSS feeds related to SEO\n",
        "lists_rss_seo = [\"http://feeds.seroundtable.com/SearchEngineRoundtable1\",\n",
        "                 \"https://www.searchenginejournal.com/category/seo/feed/\",\n",
        "                 \"https://searchengineland.com/feed\",\n",
        "                 \"https://moz.com/posts/rss/blog\", ]\n",
        "\n",
        "# Function to convert the time format of the RSS feed entries\n",
        "def time_rss(input_time: str):\n",
        "    try:\n",
        "        dt = datetime.datetime.strptime(input_time, '%a, %d %b %Y %H:%M:%S %z')\n",
        "    except:\n",
        "        dt = datetime.datetime.fromisoformat(input_time)\n",
        "    return dt.strftime('%Y/%m/%d %H:%M:%S')\n",
        "\n",
        "# Function to strip HTML tags from the RSS feed entries\n",
        "def strip_html(s):\n",
        "    return html.fromstring(s).text_content().strip()\n",
        "\n",
        "# Creating a dataframe from the RSS feed entries\n",
        "df = pd.DataFrame(columns=[\"title\", \"datetime\", \"desc\", \"link\"])\n",
        "for list_rss in lists_rss_seo:\n",
        "    d = feedparser.parse(list_rss)\n",
        "    for datarss in d['entries']:\n",
        "        link = datarss[\"link\"]\n",
        "        title = datarss[\"title\"].strip()\n",
        "        summary = strip_html(datarss[\"summary\"])\n",
        "        published = time_rss(datarss[\"published\"])\n",
        "        df.loc[len(df)] = [title, published, summary, link]"
      ],
      "metadata": {
        "id": "6Q-L-uwWO0Qt"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df"
      ],
      "metadata": {
        "id": "d0SLYFkQO32N",
        "outputId": "10fc8725-d8ad-4e28-aa8a-f02bdd074731",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        }
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                                title             datetime  \\\n",
              "0   Search News Buzz Video Recap: Google Web & Loc...  2024/01/12 08:01:00   \n",
              "1   Google Says Ignore Spammy Links From AI-Genera...  2024/01/12 07:51:00   \n",
              "2   Did Search Win With The Google Assistant Featu...  2024/01/12 07:41:00   \n",
              "3   Microsoft Advertising Dropping Hotel Center Ac...  2024/01/12 07:31:00   \n",
              "4   Google Updates Structured Data Examples To Use...  2024/01/12 07:21:00   \n",
              "5            What's Google Ads Sensitive Event Policy  2024/01/12 07:11:00   \n",
              "6          Daily Search Forum Recap: January 11, 2024  2024/01/11 16:00:00   \n",
              "7   Google Ads PMax Auction Insights Box Adds Comp...  2024/01/11 07:51:00   \n",
              "8   Google Local Services Ads Direct Business Sear...  2024/01/11 07:41:00   \n",
              "9   Google SGE Some Products To Consider Shopping ...  2024/01/11 07:31:00   \n",
              "10  Google Still Working On Site Name Issues Withi...  2024/01/11 07:21:00   \n",
              "11  Google Search Refine This Search Overlay Filte...  2024/01/11 07:11:00   \n",
              "12         Daily Search Forum Recap: January 10, 2024  2024/01/10 16:00:00   \n",
              "13  Mid-Week Google Search Algorithm Ranking Volat...  2024/01/10 08:01:00   \n",
              "14  Google: No Such Thing As Perfect Formula For R...  2024/01/10 07:51:00   \n",
              "15  Google Explains The Index, Follow Meta Tag via...  2024/01/12 10:17:39   \n",
              "16  Adapting Your Digital Marketing Strategy To Lo...  2024/01/12 09:30:22   \n",
              "17  Brave Launches Mistral-Powered CodeLLM In Sear...  2024/01/10 21:51:41   \n",
              "18  Google: Author Bylines Not A Ranking Factor vi...  2024/01/10 17:26:12   \n",
              "19  Google Alters Purpose Of SpecialAnnouncement S...  2024/01/10 10:20:44   \n",
              "20  How To Do Keyword Research For Very Specific, ...  2024/01/10 10:00:23   \n",
              "21  Google: No Perfect Formula For Search Rankings...  2024/01/09 17:54:53   \n",
              "22  Google’s John Mueller Offers Help With Spammy ...  2024/01/09 16:49:37   \n",
              "23  Google Clarifies Job Posting Structured Data G...  2024/01/09 13:05:17   \n",
              "24  Google Eases Third-Party Cookie Restrictions: ...  2024/01/08 16:25:24   \n",
              "25  Google Clarifies How Algorithm Chooses Search ...  2024/01/08 10:17:50   \n",
              "26  The Top 3 Google Ranking Factors That Really M...  2024/01/05 11:00:37   \n",
              "27  How To Use ChatGPT For Keyword Research (Festi...  2024/01/05 09:15:30   \n",
              "28  Add Me To Search: How To Create Your Google Pe...  2024/01/05 00:08:43   \n",
              "29  Google: It’s Easy To Mess Up A Site Revamp via...  2024/01/03 11:17:25   \n",
              "30  How To Use ChatGPT To Be More Productive & Cre...  2024/01/03 10:00:27   \n",
              "31  How Google Blends Search, Social, Local, Shopp...  2024/01/03 02:01:56   \n",
              "32  The Three Pillars Of Content Marketing Strateg...  2024/01/02 11:30:08   \n",
              "33  Are Homepages The Most Important To Google? vi...  2024/01/02 10:17:13   \n",
              "34  How To Build A Future-Proofed SEO Strategy Whe...  2024/01/02 09:15:04   \n",
              "35  Lawsuit: Meta placed ads next to content sexua...  2024/01/12 19:32:42   \n",
              "36                The latest jobs in search marketing  2024/01/12 16:50:00   \n",
              "37         YouTube rolls out new Shorts editing tools  2024/01/12 16:22:25   \n",
              "38  Google Ads support is at an ‘all-time low’ – w...  2024/01/12 14:49:14   \n",
              "39  Google Business Profile performance insights: ...  2024/01/12 14:00:00   \n",
              "40  9 strategies for removing negative content fro...  2024/01/12 13:00:00   \n",
              "41  Power up your marketing programs with Google A...  2024/01/11 19:09:50   \n",
              "42  TikTok reports non-skippable video ads may har...  2024/01/11 15:36:57   \n",
              "43  GPT-4 vs. Google Cloud: Performance comparison...  2024/01/11 14:00:00   \n",
              "44  The list of features being removed from Google...  2024/01/11 13:26:29   \n",
              "45  CRO Misconceptions Every SEO Should Know — Whi...  2024/01/12 00:00:00   \n",
              "46  What I Have Learned From Conducting Over 100 W...  2024/01/11 00:00:00   \n",
              "47  Breaking the Boundaries of Branding: Harness N...  2024/01/10 00:00:00   \n",
              "48  Driving Sales with Digital PR: What E-commerce...  2024/01/09 00:00:00   \n",
              "49  Link Building for Lawyers: 10 Strategies to He...  2024/01/08 00:00:00   \n",
              "50  SEO-Driven Content Architecture — Whiteboard F...  2024/01/05 00:00:00   \n",
              "51  What To Do After You've Exhausted Your High-In...  2024/01/04 00:00:00   \n",
              "52  Convince Your Boss to Send You to MozCon 2024 ...  2024/01/03 00:00:00   \n",
              "53  We Will Rock You: Whiteboard Friday Episodes T...  2023/12/29 00:00:00   \n",
              "54  16 Local Search Developments You Need to Know ...  2023/12/28 00:00:00   \n",
              "\n",
              "                                                 desc  \\\n",
              "0   We reported on three different Google algorith...   \n",
              "1   A site owner posted on Reddit his concerns aft...   \n",
              "2   Google announced major changes to Google Assis...   \n",
              "3   Microsoft announced it is going to do away wit...   \n",
              "4   Google has updated its structured data documen...   \n",
              "5   Google has posted a clarification of what it c...   \n",
              "6   Here is a recap of what happened in the search...   \n",
              "7   Google has updated the auction insights box wi...   \n",
              "8   Google Local Services Ads added a new setting ...   \n",
              "9   Google SGE, the Search Generative Experience, ...   \n",
              "10  Google has been battling with site name issues...   \n",
              "11  Google seems to have rolled out the refine thi...   \n",
              "12  Here is a recap of what happened in the search...   \n",
              "13  For the past several unconfirmed Google Search...   \n",
              "14  Danny Sullivan, Google's Search Liaison, said ...   \n",
              "15  Google's John Mueller explains how Google trea...   \n",
              "16  Seamlessly blend community engagement with sea...   \n",
              "17  Brave Search launches CodeLLM, a programming a...   \n",
              "18  Google clarifies author bylines don't directly...   \n",
              "19  Google's revision of the SpecialAnnouncement s...   \n",
              "20  Discover how to navigate a particularly tough ...   \n",
              "21  Google debunks myths of ranking formulas, urgi...   \n",
              "22  Google's John Mueller advises how to regain se...   \n",
              "23  The JobPosting structured data guidance sectio...   \n",
              "24  As Google starts restricting third-party cooki...   \n",
              "25  Google clarified the search snippets guidance ...   \n",
              "26  Discover the importance of understanding Googl...   \n",
              "27  Unleash the power of ChatGPT in keyword resear...   \n",
              "28  Learn how to create a people card for Google S...   \n",
              "29  Google's John Mueller answers question about S...   \n",
              "30  Discover new use cases and explore its capabil...   \n",
              "31  Explore how Google Search and Discover integra...   \n",
              "32  Discover how this organized approach, which ca...   \n",
              "33  Do multiple statements by Googlers indicate th...   \n",
              "34  Explore the challenges and promises of AI-gene...   \n",
              "35  Meta has allegedly been \"duping\" corporate cli...   \n",
              "36  Land your next job in SEO or PPC. These brands...   \n",
              "37  The new editing feature is currently only avai...   \n",
              "38  We reached out to Google to address your conce...   \n",
              "39  Learn how to access and understand your Google...   \n",
              "40  Here are ways to remove webpages and online po...   \n",
              "41  Incorporate a data strategy that will give you...   \n",
              "42  New research also found that ad duration is un...   \n",
              "43  GPT-4 isn't the be-all for SEO automation. Com...   \n",
              "44  Google said these changes are to \"focus on qua...   \n",
              "45  Conversion Rate Optimization doesn't happen in...   \n",
              "46  Conducting your first migration or looking to ...   \n",
              "47  This article will teach you how to attract and...   \n",
              "48  When done correctly, digital public relations ...   \n",
              "49  Looking to improve your law firm's presence in...   \n",
              "50  Does all of your content come together in a st...   \n",
              "51  Reached the end of your high-intent keyword li...   \n",
              "52  MozCon is one unforgettable experience that li...   \n",
              "53  We had a year full of learnings from all of ou...   \n",
              "54  Learn about the most recent local search devel...   \n",
              "\n",
              "                                                 link  \n",
              "0   https://www.seroundtable.com/video-01-12-2024-...  \n",
              "1   https://www.seroundtable.com/google-ignore-spa...  \n",
              "2   https://www.seroundtable.com/google-assistant-...  \n",
              "3   https://www.seroundtable.com/microsoft-adverti...  \n",
              "4   https://www.seroundtable.com/google-structured...  \n",
              "5   https://www.seroundtable.com/google-ads-sensit...  \n",
              "6   https://www.seroundtable.com/recap-01-11-2024-...  \n",
              "7   https://www.seroundtable.com/google-ads-pmax-a...  \n",
              "8   https://www.seroundtable.com/google-local-serv...  \n",
              "9   https://www.seroundtable.com/google-sge-some-p...  \n",
              "10  https://www.seroundtable.com/google-search-sit...  \n",
              "11  https://www.seroundtable.com/google-search-ref...  \n",
              "12  https://www.seroundtable.com/recap-01-10-2024-...  \n",
              "13  https://www.seroundtable.com/google-search-alg...  \n",
              "14  https://www.seroundtable.com/google-seo-perfec...  \n",
              "15  https://www.searchenginejournal.com/google-exp...  \n",
              "16  https://www.searchenginejournal.com/adapting-s...  \n",
              "17  https://www.searchenginejournal.com/brave-laun...  \n",
              "18  https://www.searchenginejournal.com/google-aut...  \n",
              "19  https://www.searchenginejournal.com/google-alt...  \n",
              "20  https://www.searchenginejournal.com/how-to-key...  \n",
              "21  https://www.searchenginejournal.com/google-no-...  \n",
              "22  https://www.searchenginejournal.com/googles-jo...  \n",
              "23  https://www.searchenginejournal.com/google-cla...  \n",
              "24  https://www.searchenginejournal.com/google-giv...  \n",
              "25  https://www.searchenginejournal.com/google-cla...  \n",
              "26  https://www.searchenginejournal.com/top-3-goog...  \n",
              "27  https://www.searchenginejournal.com/how-to-use...  \n",
              "28  https://www.searchenginejournal.com/add-me-to-...  \n",
              "29  https://www.searchenginejournal.com/google-its...  \n",
              "30  https://www.searchenginejournal.com/how-to-use...  \n",
              "31  https://www.searchenginejournal.com/how-google...  \n",
              "32  https://www.searchenginejournal.com/the-three-...  \n",
              "33  https://www.searchenginejournal.com/are-homepa...  \n",
              "34  https://www.searchenginejournal.com/how-to-bui...  \n",
              "35  https://searchengineland.com/meta-accused-plac...  \n",
              "36  https://searchengineland.com/latest-jobs-in-se...  \n",
              "37  https://searchengineland.com/youtube-new-short...  \n",
              "38  https://searchengineland.com/google-ads-reps-c...  \n",
              "39  https://searchengineland.com/google-business-p...  \n",
              "40  https://searchengineland.com/strategies-remove...  \n",
              "41  https://searchengineland.com/power-up-your-mar...  \n",
              "42  https://searchengineland.com/tiktok-report-non...  \n",
              "43  https://searchengineland.com/gpt-4-vs-google-c...  \n",
              "44  https://searchengineland.com/the-list-of-featu...  \n",
              "45  https://moz.com/blog/cro-misconceptions-whiteb...  \n",
              "46        https://moz.com/blog/100-website-migrations  \n",
              "47   https://moz.com/blog/harness-non-branded-traffic  \n",
              "48   https://moz.com/blog/drive-sales-with-digital-pr  \n",
              "49     https://moz.com/blog/link-building-for-lawyers  \n",
              "50  https://moz.com/blog/seo-driven-content-archit...  \n",
              "51   https://moz.com/blog/beyond-high-intent-keywords  \n",
              "52  https://moz.com/blog/convince-boss-to-send-you...  \n",
              "53  https://moz.com/blog/best-of-whiteboard-friday...  \n",
              "54  https://moz.com/blog/local-search-developments...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2982c0b1-8857-49aa-8b51-380785c93ae7\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>title</th>\n",
              "      <th>datetime</th>\n",
              "      <th>desc</th>\n",
              "      <th>link</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Search News Buzz Video Recap: Google Web &amp; Loc...</td>\n",
              "      <td>2024/01/12 08:01:00</td>\n",
              "      <td>We reported on three different Google algorith...</td>\n",
              "      <td>https://www.seroundtable.com/video-01-12-2024-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Google Says Ignore Spammy Links From AI-Genera...</td>\n",
              "      <td>2024/01/12 07:51:00</td>\n",
              "      <td>A site owner posted on Reddit his concerns aft...</td>\n",
              "      <td>https://www.seroundtable.com/google-ignore-spa...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Did Search Win With The Google Assistant Featu...</td>\n",
              "      <td>2024/01/12 07:41:00</td>\n",
              "      <td>Google announced major changes to Google Assis...</td>\n",
              "      <td>https://www.seroundtable.com/google-assistant-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Microsoft Advertising Dropping Hotel Center Ac...</td>\n",
              "      <td>2024/01/12 07:31:00</td>\n",
              "      <td>Microsoft announced it is going to do away wit...</td>\n",
              "      <td>https://www.seroundtable.com/microsoft-adverti...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Google Updates Structured Data Examples To Use...</td>\n",
              "      <td>2024/01/12 07:21:00</td>\n",
              "      <td>Google has updated its structured data documen...</td>\n",
              "      <td>https://www.seroundtable.com/google-structured...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>What's Google Ads Sensitive Event Policy</td>\n",
              "      <td>2024/01/12 07:11:00</td>\n",
              "      <td>Google has posted a clarification of what it c...</td>\n",
              "      <td>https://www.seroundtable.com/google-ads-sensit...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Daily Search Forum Recap: January 11, 2024</td>\n",
              "      <td>2024/01/11 16:00:00</td>\n",
              "      <td>Here is a recap of what happened in the search...</td>\n",
              "      <td>https://www.seroundtable.com/recap-01-11-2024-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Google Ads PMax Auction Insights Box Adds Comp...</td>\n",
              "      <td>2024/01/11 07:51:00</td>\n",
              "      <td>Google has updated the auction insights box wi...</td>\n",
              "      <td>https://www.seroundtable.com/google-ads-pmax-a...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Google Local Services Ads Direct Business Sear...</td>\n",
              "      <td>2024/01/11 07:41:00</td>\n",
              "      <td>Google Local Services Ads added a new setting ...</td>\n",
              "      <td>https://www.seroundtable.com/google-local-serv...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Google SGE Some Products To Consider Shopping ...</td>\n",
              "      <td>2024/01/11 07:31:00</td>\n",
              "      <td>Google SGE, the Search Generative Experience, ...</td>\n",
              "      <td>https://www.seroundtable.com/google-sge-some-p...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Google Still Working On Site Name Issues Withi...</td>\n",
              "      <td>2024/01/11 07:21:00</td>\n",
              "      <td>Google has been battling with site name issues...</td>\n",
              "      <td>https://www.seroundtable.com/google-search-sit...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Google Search Refine This Search Overlay Filte...</td>\n",
              "      <td>2024/01/11 07:11:00</td>\n",
              "      <td>Google seems to have rolled out the refine thi...</td>\n",
              "      <td>https://www.seroundtable.com/google-search-ref...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Daily Search Forum Recap: January 10, 2024</td>\n",
              "      <td>2024/01/10 16:00:00</td>\n",
              "      <td>Here is a recap of what happened in the search...</td>\n",
              "      <td>https://www.seroundtable.com/recap-01-10-2024-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Mid-Week Google Search Algorithm Ranking Volat...</td>\n",
              "      <td>2024/01/10 08:01:00</td>\n",
              "      <td>For the past several unconfirmed Google Search...</td>\n",
              "      <td>https://www.seroundtable.com/google-search-alg...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Google: No Such Thing As Perfect Formula For R...</td>\n",
              "      <td>2024/01/10 07:51:00</td>\n",
              "      <td>Danny Sullivan, Google's Search Liaison, said ...</td>\n",
              "      <td>https://www.seroundtable.com/google-seo-perfec...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Google Explains The Index, Follow Meta Tag via...</td>\n",
              "      <td>2024/01/12 10:17:39</td>\n",
              "      <td>Google's John Mueller explains how Google trea...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-exp...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Adapting Your Digital Marketing Strategy To Lo...</td>\n",
              "      <td>2024/01/12 09:30:22</td>\n",
              "      <td>Seamlessly blend community engagement with sea...</td>\n",
              "      <td>https://www.searchenginejournal.com/adapting-s...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Brave Launches Mistral-Powered CodeLLM In Sear...</td>\n",
              "      <td>2024/01/10 21:51:41</td>\n",
              "      <td>Brave Search launches CodeLLM, a programming a...</td>\n",
              "      <td>https://www.searchenginejournal.com/brave-laun...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Google: Author Bylines Not A Ranking Factor vi...</td>\n",
              "      <td>2024/01/10 17:26:12</td>\n",
              "      <td>Google clarifies author bylines don't directly...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-aut...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Google Alters Purpose Of SpecialAnnouncement S...</td>\n",
              "      <td>2024/01/10 10:20:44</td>\n",
              "      <td>Google's revision of the SpecialAnnouncement s...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-alt...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>How To Do Keyword Research For Very Specific, ...</td>\n",
              "      <td>2024/01/10 10:00:23</td>\n",
              "      <td>Discover how to navigate a particularly tough ...</td>\n",
              "      <td>https://www.searchenginejournal.com/how-to-key...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Google: No Perfect Formula For Search Rankings...</td>\n",
              "      <td>2024/01/09 17:54:53</td>\n",
              "      <td>Google debunks myths of ranking formulas, urgi...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-no-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Google’s John Mueller Offers Help With Spammy ...</td>\n",
              "      <td>2024/01/09 16:49:37</td>\n",
              "      <td>Google's John Mueller advises how to regain se...</td>\n",
              "      <td>https://www.searchenginejournal.com/googles-jo...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Google Clarifies Job Posting Structured Data G...</td>\n",
              "      <td>2024/01/09 13:05:17</td>\n",
              "      <td>The JobPosting structured data guidance sectio...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-cla...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Google Eases Third-Party Cookie Restrictions: ...</td>\n",
              "      <td>2024/01/08 16:25:24</td>\n",
              "      <td>As Google starts restricting third-party cooki...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-giv...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Google Clarifies How Algorithm Chooses Search ...</td>\n",
              "      <td>2024/01/08 10:17:50</td>\n",
              "      <td>Google clarified the search snippets guidance ...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-cla...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>The Top 3 Google Ranking Factors That Really M...</td>\n",
              "      <td>2024/01/05 11:00:37</td>\n",
              "      <td>Discover the importance of understanding Googl...</td>\n",
              "      <td>https://www.searchenginejournal.com/top-3-goog...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>How To Use ChatGPT For Keyword Research (Festi...</td>\n",
              "      <td>2024/01/05 09:15:30</td>\n",
              "      <td>Unleash the power of ChatGPT in keyword resear...</td>\n",
              "      <td>https://www.searchenginejournal.com/how-to-use...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Add Me To Search: How To Create Your Google Pe...</td>\n",
              "      <td>2024/01/05 00:08:43</td>\n",
              "      <td>Learn how to create a people card for Google S...</td>\n",
              "      <td>https://www.searchenginejournal.com/add-me-to-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Google: It’s Easy To Mess Up A Site Revamp via...</td>\n",
              "      <td>2024/01/03 11:17:25</td>\n",
              "      <td>Google's John Mueller answers question about S...</td>\n",
              "      <td>https://www.searchenginejournal.com/google-its...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>How To Use ChatGPT To Be More Productive &amp; Cre...</td>\n",
              "      <td>2024/01/03 10:00:27</td>\n",
              "      <td>Discover new use cases and explore its capabil...</td>\n",
              "      <td>https://www.searchenginejournal.com/how-to-use...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>How Google Blends Search, Social, Local, Shopp...</td>\n",
              "      <td>2024/01/03 02:01:56</td>\n",
              "      <td>Explore how Google Search and Discover integra...</td>\n",
              "      <td>https://www.searchenginejournal.com/how-google...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>The Three Pillars Of Content Marketing Strateg...</td>\n",
              "      <td>2024/01/02 11:30:08</td>\n",
              "      <td>Discover how this organized approach, which ca...</td>\n",
              "      <td>https://www.searchenginejournal.com/the-three-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>Are Homepages The Most Important To Google? vi...</td>\n",
              "      <td>2024/01/02 10:17:13</td>\n",
              "      <td>Do multiple statements by Googlers indicate th...</td>\n",
              "      <td>https://www.searchenginejournal.com/are-homepa...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>How To Build A Future-Proofed SEO Strategy Whe...</td>\n",
              "      <td>2024/01/02 09:15:04</td>\n",
              "      <td>Explore the challenges and promises of AI-gene...</td>\n",
              "      <td>https://www.searchenginejournal.com/how-to-bui...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Lawsuit: Meta placed ads next to content sexua...</td>\n",
              "      <td>2024/01/12 19:32:42</td>\n",
              "      <td>Meta has allegedly been \"duping\" corporate cli...</td>\n",
              "      <td>https://searchengineland.com/meta-accused-plac...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>The latest jobs in search marketing</td>\n",
              "      <td>2024/01/12 16:50:00</td>\n",
              "      <td>Land your next job in SEO or PPC. These brands...</td>\n",
              "      <td>https://searchengineland.com/latest-jobs-in-se...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>YouTube rolls out new Shorts editing tools</td>\n",
              "      <td>2024/01/12 16:22:25</td>\n",
              "      <td>The new editing feature is currently only avai...</td>\n",
              "      <td>https://searchengineland.com/youtube-new-short...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>Google Ads support is at an ‘all-time low’ – w...</td>\n",
              "      <td>2024/01/12 14:49:14</td>\n",
              "      <td>We reached out to Google to address your conce...</td>\n",
              "      <td>https://searchengineland.com/google-ads-reps-c...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>Google Business Profile performance insights: ...</td>\n",
              "      <td>2024/01/12 14:00:00</td>\n",
              "      <td>Learn how to access and understand your Google...</td>\n",
              "      <td>https://searchengineland.com/google-business-p...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>9 strategies for removing negative content fro...</td>\n",
              "      <td>2024/01/12 13:00:00</td>\n",
              "      <td>Here are ways to remove webpages and online po...</td>\n",
              "      <td>https://searchengineland.com/strategies-remove...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>Power up your marketing programs with Google A...</td>\n",
              "      <td>2024/01/11 19:09:50</td>\n",
              "      <td>Incorporate a data strategy that will give you...</td>\n",
              "      <td>https://searchengineland.com/power-up-your-mar...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>TikTok reports non-skippable video ads may har...</td>\n",
              "      <td>2024/01/11 15:36:57</td>\n",
              "      <td>New research also found that ad duration is un...</td>\n",
              "      <td>https://searchengineland.com/tiktok-report-non...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>GPT-4 vs. Google Cloud: Performance comparison...</td>\n",
              "      <td>2024/01/11 14:00:00</td>\n",
              "      <td>GPT-4 isn't the be-all for SEO automation. Com...</td>\n",
              "      <td>https://searchengineland.com/gpt-4-vs-google-c...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>The list of features being removed from Google...</td>\n",
              "      <td>2024/01/11 13:26:29</td>\n",
              "      <td>Google said these changes are to \"focus on qua...</td>\n",
              "      <td>https://searchengineland.com/the-list-of-featu...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>CRO Misconceptions Every SEO Should Know — Whi...</td>\n",
              "      <td>2024/01/12 00:00:00</td>\n",
              "      <td>Conversion Rate Optimization doesn't happen in...</td>\n",
              "      <td>https://moz.com/blog/cro-misconceptions-whiteb...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>What I Have Learned From Conducting Over 100 W...</td>\n",
              "      <td>2024/01/11 00:00:00</td>\n",
              "      <td>Conducting your first migration or looking to ...</td>\n",
              "      <td>https://moz.com/blog/100-website-migrations</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Breaking the Boundaries of Branding: Harness N...</td>\n",
              "      <td>2024/01/10 00:00:00</td>\n",
              "      <td>This article will teach you how to attract and...</td>\n",
              "      <td>https://moz.com/blog/harness-non-branded-traffic</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Driving Sales with Digital PR: What E-commerce...</td>\n",
              "      <td>2024/01/09 00:00:00</td>\n",
              "      <td>When done correctly, digital public relations ...</td>\n",
              "      <td>https://moz.com/blog/drive-sales-with-digital-pr</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Link Building for Lawyers: 10 Strategies to He...</td>\n",
              "      <td>2024/01/08 00:00:00</td>\n",
              "      <td>Looking to improve your law firm's presence in...</td>\n",
              "      <td>https://moz.com/blog/link-building-for-lawyers</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>SEO-Driven Content Architecture — Whiteboard F...</td>\n",
              "      <td>2024/01/05 00:00:00</td>\n",
              "      <td>Does all of your content come together in a st...</td>\n",
              "      <td>https://moz.com/blog/seo-driven-content-archit...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>What To Do After You've Exhausted Your High-In...</td>\n",
              "      <td>2024/01/04 00:00:00</td>\n",
              "      <td>Reached the end of your high-intent keyword li...</td>\n",
              "      <td>https://moz.com/blog/beyond-high-intent-keywords</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>Convince Your Boss to Send You to MozCon 2024 ...</td>\n",
              "      <td>2024/01/03 00:00:00</td>\n",
              "      <td>MozCon is one unforgettable experience that li...</td>\n",
              "      <td>https://moz.com/blog/convince-boss-to-send-you...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>We Will Rock You: Whiteboard Friday Episodes T...</td>\n",
              "      <td>2023/12/29 00:00:00</td>\n",
              "      <td>We had a year full of learnings from all of ou...</td>\n",
              "      <td>https://moz.com/blog/best-of-whiteboard-friday...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>16 Local Search Developments You Need to Know ...</td>\n",
              "      <td>2023/12/28 00:00:00</td>\n",
              "      <td>Learn about the most recent local search devel...</td>\n",
              "      <td>https://moz.com/blog/local-search-developments...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2982c0b1-8857-49aa-8b51-380785c93ae7')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-2982c0b1-8857-49aa-8b51-380785c93ae7 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-2982c0b1-8857-49aa-8b51-380785c93ae7');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-2960de02-fef2-4aa1-bcf5-620735ea6322\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2960de02-fef2-4aa1-bcf5-620735ea6322')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-2960de02-fef2-4aa1-bcf5-620735ea6322 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "    </div>\n",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    }
  ],
  "metadata": {
    "accelerator": "GPU",
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyOKIzHMj7+5TnzuJMyadeEp",
      "include_colab_link": true
    },
    "gpuClass": "standard",
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}