Sticky Note Automate

Target Audience

• Marketing Teams: Those looking to gain insights from competitor reviews to improve their advertising strategies.
• Business Owners: Entrepreneurs who want to analyze customer feedback on competitors to refine their own offerings.
• Data Analysts: Professionals who need to extract and analyze review data for market research.
• Digital Marketers: Individuals focused on creating targeted ad campaigns based on customer sentiments and pain points.

Problem Solved

This workflow addresses the challenge of gathering and analyzing customer feedback from competitor reviews on Trustpilot. It helps users to:

• Identify Weaknesses: Understand common complaints and issues faced by competitors.
• Generate Targeted Ads: Create effective advertising content that directly addresses these pain points, enhancing the chances of conversion.
• Streamline Data Collection: Automate the process of fetching and organizing reviews, saving time and effort for marketing teams.

Workflow Steps

1. Form Submission: Users submit a form with their competitor's Trustpilot URL and select a review timeframe (30 days, 3 months, 6 months, or 12 months).
2. API Call to Bright Data: The workflow triggers an API call to Bright Data to fetch reviews based on the provided URL and timeframe.
3. Polling for Data: It waits and checks the status of the dataset until it is ready for retrieval.
4. Data Retrieval: Once the data is available, it retrieves the reviews from Bright Data.
5. Filtering Bad Reviews: The workflow filters the results to isolate negative reviews (1 or 2-star ratings).
6. Aggregation of Reviews: It aggregates the filtered reviews to summarize the key complaints.
7. LLM Analysis: Uses OpenAI's LLM to generate three different Facebook ad copies addressing the identified weaknesses.
8. Email Summary: Finally, it sends an email to the marketing team with the summary of complaints and suggested ad copies.