Conduct keyword research in KNIME using the Google Ads Extension. Leverage KNIME Analytics Platform capabilities to create simple or complex workflows for keyword research.
Our use case involves owning an online website to rent holiday houses. We want to create new ads to promote new properties in Mallorca (Spain), targeting our research to the top 5 German cities and people searching on Google in German. We are searching for the best keywords for our ad headlines and descriptions.
You can download and run the workflow locally on your KNIME Analytics Platform. Please use the latest version of the software.
Before you run the workflow, you need to authenticate actively. Using Google APIs with OAuth 2.0 "on your behalf" allows third-party applications to securely access and interact with your Google services, such as Google Ads, enhancing functionality and user experience while maintaining security and control over your data.
Additionally, you will need:
Google Ads Developer Token
Manager Customer Account ID
Account ID
Please refer to the description of the Google Ads Connector to get more information about how to obtain these items.
Workflow Step-by-Step
Authenticate and Connect
Using the Google Authenticator for interactive authentication, provide the custom scope listed in the node comments. Then, connect to the Google Ads Account by providing the specified items in the Google Ads Connector node.
Generate Keyword Ideas
Connection to Google Ads: Connect to the Google Ads Connection node.
Seed Keyword: Use a keyword that acts as a seed keyword to generate ideas. In our example, "Ferienhaus Mallorca," Pass the keyword seed using a simple Table Creator, but you can use more extensive lists.
Location IDs: Use the five location IDs from Germany's top 5 most populated cities. Obtain them by filtering via the Reference Row Filter node from the Google Ads Geo Targets node output.
Google Ads Keywords Ideas Node Configuration
Pass the three inputs, set the language to German (since we are interested in Germans looking for holiday houses in Mallorca searching in German on Google), and set the Rows per Chunk to 5 in advanced settings to get an overview of the Keyword Ideas for all locations. You can set it to 1 to get keyword ideas by city, which can be helpful for keyword localization.
Processing the Output
The output of the Google Ads Keyword Ideas node has two branches:
Top Keyword Ideas: We have the aggregated metric for each keyword idea in the top branch. Filter the top 10 keyword ideas using the Top K Row Filter node and those with an average cost per click of less than two using the Row Filter, then plot them in the Table View.
Monthly Searches: In the second output port, we have the monthly searches for the keyword ideas for the last two years. Use the Reference Row Filter node to filter only the top 10, pivot the keywords, group them by year and month via the Pivot node, and plot the trend in the Stacked Area Chart node. (Click the lens icon to visualize the chart.)