How Peak Ace Automatically Customizes Ads with KNIME

Manual data manipulation for ads

Peak Ace runs ad campaigns for clients and identifies products with the most attractive offers or discounts to promote to make ads more effective. To do this, they used to spend hours in Excel manually comparing regular and sale prices across large product datasets to identify the most compelling deals to promote. This process was slow and error prone.

Another challenge involved running advertising campaigns on Meta platforms such as Facebook and Instagram. Some Peak Ace clients stored their data in systems that provided information through JSON endpoints—a technical data format that Meta's advertising platform couldn't directly use. This created a bottleneck where team members had to manually extract data from these JSON sources, reformat it, and move it into platforms that Meta could access.

Additionally, the team had to manually collect product reviews from Trust Pilot to use in ad content, a highly time consuming process.

Peak Ace automated data processing for dynamic ad campaigns with KNIME 

Peak Ace implemented KNIME Analytics Platform along with KNIME Team plan's automation capabilities to speed up the data manipulation tasks required to feed ads with up-to-date product information.

Automatically identifying products with the highest discounts  

Peak Ace’s performance marketing team built data workflows in KNIME Analytics Platform using customer product catalogs to identify items with sale prices and calculate metrics like highest discount or lowest price per category. 

These workflows are scheduled to run automatically every day using KNIME Team plan’s automation capabilities. The results are then pushed directly to Google Ads, ensuring potential customers always see the latest discounts when searching for products. Automation with the KNIME Team Plan allows Peak Ace to dynamically adjust ad elements – such as sale price or product name – based on real-time inventory data.

Automated data pipeline for Meta advertising platforms

For Meta advertising campaigns, Peak Ace created KNIME workflows that:

• Connected to and retrieved data from the client's JSON endpoint
• Transformed this data into a format suitable for advertising
• Stored the processed data in Google Sheets, which Meta platforms can access
• Automated this entire process to run regularly through KNIME Team plan

This solution eliminated manual data handling, creating an automated data pipeline from client systems to Meta advertising platforms. For example, a hotel client now has their latest room availability and pricing automatically fed into Meta advertising campaigns without any manual intervention, saving time and manual effort and reducing the risk of human error.

Automated scraping of product reviews

Similarly, they created a workflow to automatically scrape Trustpilot reviews, store them in Google Sheets, and push them to Google Ads, with the entire process scheduled to run weekly through KNIME Team plan.

Automated translation of vacation rental ads

Peak Ace also created a KNIME workflow for a vacation rental company that generates consistent ad text across multiple countries by analyzing sentence structures in one language and translating them appropriately for others. This solution alone saves hundreds of hours of manual work.

Automated scraping of vacation property data

Peak Ace also created a KNIME workflow for the vacation rental company that generates property feeds for dynamic remarketing by analyzing sitemap files. The workflow is scheduled to run on the KNIME Team plan, enabling them to automatically retarget customers by displaying ads that feature previously viewed vacation homes. The solution opened up completely new advertising possibilities for the customer.

Relevant offers available for ad campaigns in seconds 

Tasks that previously took hours to complete manually in Excel now run in under 10 seconds and are automated to run on a schedule. This has saved Peak Ace a significant amount of time and effort. Automating these processes also increases the speed at which ad campaigns can be optimized for greater clicks and engagement and reduces any human error creeping into the process.

Peak Ace’s ability to quickly process data, identify opportunities, and automatically update campaigns has enabled them to offer new services and dynamic advertising solutions that were impossible with their previous manual methods. This has increased their competitive advantage in the digital marketing space.

If you are interested in automating some of your own repetitive marketing activities, you can get started with a free trial of the KNIME Team plan.