Skip to main content
Premium project

Generating Keywords for Google Ads

Automatically generate keywords for a search engine marketing campaign using Python.

Start Project
8 Tasks1,500 XP12,168 Learners

Loved by learners at thousands of companies

Project Description

You work for a digital marketing agency, which is approached by a massive online retailer of furniture. You are tasked with creating a prototype set of keywords for search campaigns for their sofas section. With your Python skills, you will efficiently create these keywords!

The most important task in structuring a search engine marketing account is mapping the right keywords to the right ads and making sure they send users to the right landing pages. Having figured that out is a big part of the account setup and makes the life of the account manager much easier.

Project Tasks

  1. 1
    The brief
  2. 2
    Combine the words with the product names
  3. 3
    Convert the list of lists into a DataFrame
  4. 4
    Rename the columns of the DataFrame
  5. 5
    Add a campaign column
  6. 6
    Create the match type column
  7. 7
    Duplicate all the keywords into 'phrase' match
  8. 8
    Save and summarize!

Technologies

Python Python

Topics

Data Manipulation
Elias Dabbas HeadshotElias Dabbas

Owner at The Media Supermarket

Elias specializes in online marketing and advertising and has been running advertising accounts for brands of all sizes and in all industries for more than ten years. He believes data science is critical for online marketing success. He is focusing on building tools for improving the productivity of online marketers through his Python package, advertools. You can find him on Twitter at @eliasdabbas.
See More

What do other learners have to say?