---
title: "Third Tab Api Optimized"
method: POST
path: "/api/v1/new-meta-analytics/third-tab-api-optimized"
tags: ["newMetaAnalytics"]
---

# Third Tab Api Optimized

`POST /api/v1/new-meta-analytics/third-tab-api-optimized`

Optimized Third Tab API - Analyzes creatives based on user-selected metric and categorizes into buckets
Uses efficient SQL joins and optimized queries

Features:
- Search by ad name (returns creatives whose associated ads match)
- Filter by user-selected metric and value
- Categorize creatives into performance buckets

## Query parameters

- `metric` string, required
- `value` number, nullable
- `time_period` integer
- `start_date` string, nullable — Custom start date in YYYY-MM-DD format
- `end_date` string, nullable — Custom end date in YYYY-MM-DD format
- `search` string, nullable — Search by ad name (case-insensitive); returns creatives whose associated ads match
- `post_filter_metric` string, nullable — Optional post-bucket filter metric (e.g., impressions, roas, ctr, cpc, cpm, conversions, conversion_rate, reach, frequency)
- `post_filter_operator` string, nullable — Operator for post filter: >, >=, <, <=, =, !=
- `post_filter_value` number, nullable — Value for post filter comparison

## Response `200`

Successful Response

- unknown

## Other responses

- `422` — Validation Error

---

[API](https://skmtc.dev/brandbooster/apis/fastapi.md) · [All operations](https://skmtc.dev/brandbooster/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/brandbooster/fastapi/revisions/624917d53409/schema)