Keyword Research with Google Ads Nodes

<p>Conduct <strong>keyword research</strong> in KNIME using the <em>Google Ads Extension</em>. Leverage KNIME Analytics Platform capabilities to create simple or complex workflows for keyword research.</p><p>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 <strong>keywords </strong>for our ad <em>headlines </em>and <em>descriptions</em>.</p><p>You can download and run the workflow locally on your KNIME Analytics Platform. Please use the latest version of the software.</p><p>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.</p><p>Additionally, you will need:</p><ul><li><p>Google Ads Developer Token</p></li><li><p>Manager Customer Account ID</p></li><li><p>Account ID</p></li></ul><p>Please refer to the description of the Google Ads Connector to get more information about how to obtain these items.</p><p>Workflow Step-by-Step</p><ol><li><p><strong>Authenticate and Connect</strong></p><ul><li><p>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.</p></li></ul></li><li><p><strong>Generate Keyword Ideas</strong></p><ul><li><p><strong>Connection to Google Ads</strong>: Connect to the Google Ads Connection node.</p></li><li><p><strong>Seed Keyword</strong>: 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.</p></li><li><p><strong>Location IDs</strong>: 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.</p></li></ul></li><li><p><strong>Google Ads Keywords Ideas Node Configuration</strong></p><ul><li><p>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.</p></li></ul></li><li><p><strong>Processing the Output</strong></p><ul><li><p>The output of the Google Ads Keyword Ideas node has two branches:</p><ul><li><p><strong>Top Keyword Ideas</strong>: 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.</p></li><li><p><strong>Monthly Searches</strong>: 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.)</p></li></ul></li></ul></li></ol>