Sign in Start free
  • AI-Agent
  • Ready to Run

Import Search Performance

Validate search export rows and load usable reporting figures

Use this Agent instantly or customize it - no programming needed

Import checked organic search performance rows
Reads
  • successful export log
    successful export log

    Your export log identifies each completed page-level export and its revision.

  • prior import reports
    prior import reports

    Your import reports show which export dates and revisions you have already processed.

  • organic search performance rows
    organic search performance rows

    Your organic search performance rows show each page and query's daily search figures.

  • import rules
    import rules

    Your settings define the site, accepted search type, required fields, and grouping columns.

Reporting warehouse
Reporting warehouse

Your reporting warehouse supplies search exports and stores checked figures, rejected rows, and import counts.
Are there no new completed page-level exports?YesNo
Finish the check without changing analysis rows
Does an export lack a required column?YesNo
Record the missing column and leave analysis rows untouched
Writes
  • import report
    import report

    Your import report shows accepted source rows, analysis rows written, rejected rows, and the export revision.

Validate source rows and group accepted figures
Load or replace figures and save import results
Writes
  • analysis rows
    analysis rows

    Your analysis table holds grouped page and query figures for each processed export date.

  • rejected rows
    rejected rows

    Your rejected-row table keeps each excluded source row with its export date and reason.

  • import report
    import report

    Your import report shows accepted source rows, analysis rows written, rejected rows, and the export revision.

This Agent looks for a completed daily search export during its hourly warehouse check. It validates the rows and loads usable figures into your analysis table. You get import counts and rejected rows with reasons.

Modify Agent

Customize this Agent to fit your needs using natural language.

Start Agent for Free

Enter your email address and we will send you a secure link to continue.

Airtable
Used as:
Show all Agents working with Airtable
Kintone
Used as:
Show all Agents working with Kintone

Made for your industry

Import Search Performance is made for businesses in these industries.

Made for your role

Import Search Performance is made for people in these roles.

Made for your department

Import Search Performance is made for people in these departments.

How Import Search Performance works

5 steps, in order, on every run.

  1. Find New ExportsCheck the successful-export log seven minutes past each hour. Skip dates and revisions already in your import report.
  2. Verify Export FieldsConfirm the page, query, date, and metric columns before import. Report missing columns and leave that date's analysis rows untouched.
  3. Check Source RowsCheck each row's page, query, date, and metrics against your rules. Record rejected rows with specific reasons.
  4. Group Usable FiguresGroup accepted rows by your chosen reporting columns. Sum clicks, impressions, and position totals across repeated source rows.
  5. Write Import ResultsReplace older figures when an export changes. Save new analysis rows, import counts, and rejected rows in your warehouse.

How to Get Started

Connect your tools

Connect the tools you already use, such as Airtable or Kintone.

2 tools
Set your rules
  • Connect the site's daily organic search performance export to the reporting warehouse and grant the Agent access to its page-level export and successful-export log.
  • Choose the site property, analysis table, rejected-row table, and import report table in the warehouse.
  • Set the required page, query, date, and metric fields, the accepted search type, and the analysis table's grouping columns.
  • Schedule the warehouse check for seven minutes past each hour and give the analyst access to the report and rejected-row tables.
Launch the Agent

Use safe mode to approve every result before it goes out, or let the Agent run automatically.

FAQs

Frequently asked questions about the Import Search Performance:

Does this handle my Google Search Console to BigQuery export?

Yes, once your daily page-level export reaches BigQuery. You choose the site property and reporting tables for the import.

Which search rows will appear in my analysis table?

You choose the accepted search type and grouping columns. Rows must also pass your page, query, date, and metric checks.

What happens to blank or anonymized queries?

They stay out of your query-level analysis table. You can review those source rows and their reasons in the rejected-row table.

What happens if a warehouse write fails?

The Agent leaves that export revision open for a later check. You can see the failure in the import report when the warehouse can write it.

What happens when the Agent is unsure?

It stops and asks you. The Agent does not guess when it reaches a decision you have not approved.

Can I review its work?

Yes. Every run creates a plain-language log that you can review and export. Logs are kept for twelve months.

What happens if I cancel?

The Agent stops at the end of the billing month and its tool connections are removed. Your run logs remain available for twelve months.

Related Agents

Agents related to Import Search Performance

More ready-to-run Agents for connected work.

Return Incomplete Supplier Forms

Suppliers get a clear list of missing answers or documents, so your team can move complete onboarding forms forward.

Works with
Published by Before We Buy
Return Incomplete Purchase Requests

Your budget owners get clearer purchase requests, and requesters know exactly what to add before review can continue.

Works with
Published by Before We Buy