Get this template

Track Paid Ads with SE Ranking SEO Data API

Track Paid Ads with SE Ranking SEO Data API

Get this template
Make template animation background

Apps used in template

About

Share

Automates competitor intelligence for paid ads. It searches SE Ranking for domains advertising on a target keyword, logs their ad creatives to a Google Sheet, and sends a Slack notification upon completion.

Template Description

This template automates competitor ad monitoring. It retrieves a list of domains running paid ads for your specified keyword using the SE Ranking Data API, logs the ad creatives into a Google Sheet for historical analysis, and sends a completion alert to Slack.

Template configuration requires the following:

  1. SE Ranking SEO Data:

    • Establish your connection using your SE Ranking API Key.
      • Set the source parameter to the desired regional database using the alpha-2 country code (e.g., "us").
      • Enter the keyword you want to monitor.
      • (Optional) You can specify a date range using from and to parameters in "YYYY-MM" format to narrow down the search.
  2. Google Sheets:

    • Connect your Google Sheets account.
    • Select the destination spreadsheet and sheet.
    • Map the response data from SE Ranking to your sheet columns. Key available fields include domain, snippet_title, snippet_description, and snippet_display_url.
  3. Slack:

    • Authorize your Slack connection.
    • Choose the channel to receive the notification.
    • Customize the message content to summarize the operation.

Trusted by thousands of fast-scaling organizations around the globe

Logo for FINN
Logo for Bamboo HR
Logo for Spotify
Logo for BNY
Logo for Bolt

Similar templates for inspiration

Looking to get more out of your apps? With Make, you can visually integrate any app into any workflow to save time and resources - no coding required. Try any of these templates in just a few clicks.

Create your own workflow

Create custom workflows by choosing triggers, actions, and searches. A trigger is an event that launches the workflow, an action is the event.

SE Ranking SEO Data
AI Search - Discover Brand by URL

Identify brand names associated with a domain.

Action
SE Ranking SEO Data
AI Search - Get Overview

Retrieve high-level performance metrics including: Link presence in AI responses Average position in AI-generated lists AI opportunity traffic estimates Historical trends (time series data)

Action
SE Ranking SEO Data
AI Search - Get Prompts by Brand

Retrieve prompts where your brand is mentioned.

Action
SE Ranking SEO Data
AI Search - Get Prompts by Target

Retrieve prompts where your domain/URL appears in LLM results.

Action
SE Ranking SEO Data
AI Search - Leaderboard

Compares a primary domain against up to 10 competitors across multiple LLM engines and returns a share of voice leaderboard showing which domains have the highest AI search visibility. The leaderboard is calculated based on both brand and link presence across the selected engines.

Action
Google Sheets
Add a Conditional Format Rule

Creates a new conditional format rule at the given index. All subsequent rules' indexes are incremented.

Action
Slack
Add a Reaction

Adds a reaction to a message.

Action
Google Sheets
Add a Row

Appends a new row to the bottom of the table.

Action
Google Sheets
Add a Sheet

Adds a new sheet.

Action

FAQ

How it works

Traditional no-code iPaaS platforms are linear and non-intuitive. Make allows you to visually create, build, and automate without limits.

Trusted by 350,000+ customers

"Make really helped us to scale our operations, take the friction out of our processes, reduce costs, and relieved our support team. It is difficult to not become a fan."

Head of Operations at Teleclinic portrait

Philipp Weidenbach

Head of Operations at Teleclinic

"Make drives unprecedented efficiency within our business in ways we never imagined. It’s having an extra employee (or 10) for a fraction of the cost."

COO at Shop Accelerator Martech portrait

Cayden Phipps

COO at Shop Accelerator Martech

"The simplicity, flexibility and ability to build real complex automations without any knowledge of programming makes it the best thing since sliced bread."

Product Owner at Smaily portrait

Erkki Markus

Product Owner at Smaily

"True citizen development in the entire company. Make is present in every department, empowering the company to offer a unique customer experience."

CTO & Co-founder at FINN portrait

Andreas Stryz

CTO & Co-founder at FINN

"I can't count the number of hours I've saved by using Make. Every single day is simpler because of Make's automation."

Owner of Media Production portrait

Kimberly D

Owner of Media Production