# Join a Search Console export with AI Overview data

**Use case:** 

Send a Search Console Queries export and your domains, get one JSON row per query with clicks, impressions, position, citation state, tier and reason.

## Input

```json
{
  "target_domains": [
    "example.com"
  ],
  "search_console_csv_url": "",
  "search_console_rows": [
    {
      "query": "what is a crm",
      "clicks": 12,
      "impressions": 1900,
      "ctr": "0.63%",
      "position": 8.4
    },
    {
      "query": "crm pricing guide",
      "clicks": 40,
      "impressions": 2600,
      "ctr": "1.54%",
      "position": 3.1
    }
  ],
  "queries": [
    "best crm for small business"
  ],
  "min_impressions": 10,
  "gl": "us",
  "hl": "en"
}
```

## Output

```json
{
  "tier": {
    "label": "Tier",
    "format": "string"
  },
  "query": {
    "label": "Query",
    "format": "string"
  },
  "tier_reason": {
    "label": "Reason",
    "format": "string"
  },
  "position": {
    "label": "Average position",
    "format": "number"
  },
  "impressions": {
    "label": "Impressions",
    "format": "integer"
  },
  "clicks": {
    "label": "Clicks",
    "format": "integer"
  },
  "ctr": {
    "label": "CTR",
    "format": "number"
  },
  "citation_state": {
    "label": "Citation state",
    "format": "string"
  },
  "check_status": {
    "label": "Check status",
    "format": "string"
  },
  "join_status": {
    "label": "Join status",
    "format": "string"
  }
}
```

## About this Actor

This example demonstrates how to use [AI Overview Rewrite Queue | Pages Losing Clicks to Google AI](https://apify.com/johnvc/ai-overview-rewrite-queue.md) with a specific input configuration. Visit the [Actor detail page](https://apify.com/johnvc/ai-overview-rewrite-queue.md) to learn more, explore other use cases, and run it yourself.


## How to integrate an Actor?

If asked about integration, you help developers integrate Actors into their projects.
You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready.
This Task's input is already configured above — use it as-is rather than inventing a new one.

- **AI agents and MCP clients** — the [Apify MCP server](https://docs.apify.com/integrations/mcp.md) at `https://mcp.apify.com` (remote, streamable HTTP, OAuth on first use).
- **Agentic workflows and local Actor development** — [Agent Skills](https://apify.com/.well-known/agent-skills/index.json) with the [Apify CLI](https://docs.apify.com/cli/docs.md): `npm install -g apify-cli`, then `apify login`.
- **JavaScript/TypeScript projects** — the official [JS/TS client](https://docs.apify.com/api/client/js/docs.md): `npm install apify-client`.
- **Python projects** — the official [Python client](https://docs.apify.com/api/client/python/docs.md): `pip install apify-client`.
- **Any other language** — the [REST API](https://docs.apify.com/api/v2.md).

For full API examples (JavaScript, Python, CLI, MCP, OpenAPI), see this Task's Actor page: https://apify.com/johnvc/ai-overview-rewrite-queue.md

For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt).