Query Looker Studio report data
curl --request POST \
--url https://api.athenahq.ai/api/v1/looker-studio/data \
--header 'Content-Type: application/json' \
--header 'x-api-key: <api-key>' \
--data '
{
"website_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"dimensions": [],
"metrics": [],
"filters": {
"start_date": "2024-01-01T00:00:00.000Z",
"end_date": "2024-12-31T23:59:59.999Z",
"schedule_id": "default",
"models": [
"chatgpt",
"perplexity"
],
"prompt_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"competitor_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"location_ids": [
"123e4567-e89b-12d3-a456-426614174111"
],
"prompt_tags": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
]
},
"looker_studio_filters": [
[
{
"value": [
"<string>"
]
}
]
]
}
'import requests
url = "https://api.athenahq.ai/api/v1/looker-studio/data"
payload = {
"website_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"dimensions": [],
"metrics": [],
"filters": {
"start_date": "2024-01-01T00:00:00.000Z",
"end_date": "2024-12-31T23:59:59.999Z",
"schedule_id": "default",
"models": ["chatgpt", "perplexity"],
"prompt_ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"competitor_ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"location_ids": ["123e4567-e89b-12d3-a456-426614174111"],
"prompt_tags": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"]
},
"looker_studio_filters": [[{ "value": ["<string>"] }]]
}
headers = {
"x-api-key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-api-key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
website_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
dimensions: [],
metrics: [],
filters: {
start_date: '2024-01-01T00:00:00.000Z',
end_date: '2024-12-31T23:59:59.999Z',
schedule_id: 'default',
models: ['chatgpt', 'perplexity'],
prompt_ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
competitor_ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
location_ids: ['123e4567-e89b-12d3-a456-426614174111'],
prompt_tags: ['3c90c3cc-0d44-4b50-8888-8dd25736052a']
},
looker_studio_filters: [[{value: ['<string>']}]]
})
};
fetch('https://api.athenahq.ai/api/v1/looker-studio/data', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.athenahq.ai/api/v1/looker-studio/data",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'website_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'dimensions' => [
],
'metrics' => [
],
'filters' => [
'start_date' => '2024-01-01T00:00:00.000Z',
'end_date' => '2024-12-31T23:59:59.999Z',
'schedule_id' => 'default',
'models' => [
'chatgpt',
'perplexity'
],
'prompt_ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'competitor_ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'location_ids' => [
'123e4567-e89b-12d3-a456-426614174111'
],
'prompt_tags' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
]
],
'looker_studio_filters' => [
[
[
'value' => [
'<string>'
]
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-api-key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.athenahq.ai/api/v1/looker-studio/data"
payload := strings.NewReader("{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-api-key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.athenahq.ai/api/v1/looker-studio/data")
.header("x-api-key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.athenahq.ai/api/v1/looker-studio/data")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-api-key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}"
response = http.request(request)
puts response.read_body{
"data": [
{
"date": "<string>",
"model": "<string>",
"company_name": "<string>",
"is_self": true,
"location": "<string>",
"topic_name": "<string>",
"prompt": "<string>",
"response": "<string>",
"citation_rate": 123,
"mention_rate": 123,
"share_of_voice": 123,
"position": 123,
"mentions": 123,
"citations": 123,
"total_responses": 123
}
]
}Utilities
Query Looker Studio report data
Return report rows for one website and streaming schedule. filters.schedule_id accepts default, manual, or a custom schedule UUID; omission selects Default. Schedule selection applies to every metric and dimension and is part of the report cache key. Archived schedules retain history. Response-grain reports are bounded before response text hydration; narrow the filters if the row limit is exceeded.
POST
/
api
/
v1
/
looker-studio
/
data
Query Looker Studio report data
curl --request POST \
--url https://api.athenahq.ai/api/v1/looker-studio/data \
--header 'Content-Type: application/json' \
--header 'x-api-key: <api-key>' \
--data '
{
"website_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"dimensions": [],
"metrics": [],
"filters": {
"start_date": "2024-01-01T00:00:00.000Z",
"end_date": "2024-12-31T23:59:59.999Z",
"schedule_id": "default",
"models": [
"chatgpt",
"perplexity"
],
"prompt_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"competitor_ids": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
],
"location_ids": [
"123e4567-e89b-12d3-a456-426614174111"
],
"prompt_tags": [
"3c90c3cc-0d44-4b50-8888-8dd25736052a"
]
},
"looker_studio_filters": [
[
{
"value": [
"<string>"
]
}
]
]
}
'import requests
url = "https://api.athenahq.ai/api/v1/looker-studio/data"
payload = {
"website_id": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"dimensions": [],
"metrics": [],
"filters": {
"start_date": "2024-01-01T00:00:00.000Z",
"end_date": "2024-12-31T23:59:59.999Z",
"schedule_id": "default",
"models": ["chatgpt", "perplexity"],
"prompt_ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"competitor_ids": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"],
"location_ids": ["123e4567-e89b-12d3-a456-426614174111"],
"prompt_tags": ["3c90c3cc-0d44-4b50-8888-8dd25736052a"]
},
"looker_studio_filters": [[{ "value": ["<string>"] }]]
}
headers = {
"x-api-key": "<api-key>",
"Content-Type": "application/json"
}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'x-api-key': '<api-key>', 'Content-Type': 'application/json'},
body: JSON.stringify({
website_id: '3c90c3cc-0d44-4b50-8888-8dd25736052a',
dimensions: [],
metrics: [],
filters: {
start_date: '2024-01-01T00:00:00.000Z',
end_date: '2024-12-31T23:59:59.999Z',
schedule_id: 'default',
models: ['chatgpt', 'perplexity'],
prompt_ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
competitor_ids: ['3c90c3cc-0d44-4b50-8888-8dd25736052a'],
location_ids: ['123e4567-e89b-12d3-a456-426614174111'],
prompt_tags: ['3c90c3cc-0d44-4b50-8888-8dd25736052a']
},
looker_studio_filters: [[{value: ['<string>']}]]
})
};
fetch('https://api.athenahq.ai/api/v1/looker-studio/data', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://api.athenahq.ai/api/v1/looker-studio/data",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'website_id' => '3c90c3cc-0d44-4b50-8888-8dd25736052a',
'dimensions' => [
],
'metrics' => [
],
'filters' => [
'start_date' => '2024-01-01T00:00:00.000Z',
'end_date' => '2024-12-31T23:59:59.999Z',
'schedule_id' => 'default',
'models' => [
'chatgpt',
'perplexity'
],
'prompt_ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'competitor_ids' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
],
'location_ids' => [
'123e4567-e89b-12d3-a456-426614174111'
],
'prompt_tags' => [
'3c90c3cc-0d44-4b50-8888-8dd25736052a'
]
],
'looker_studio_filters' => [
[
[
'value' => [
'<string>'
]
]
]
]
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"x-api-key: <api-key>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "https://api.athenahq.ai/api/v1/looker-studio/data"
payload := strings.NewReader("{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("x-api-key", "<api-key>")
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("https://api.athenahq.ai/api/v1/looker-studio/data")
.header("x-api-key", "<api-key>")
.header("Content-Type", "application/json")
.body("{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}")
.asString();require 'uri'
require 'net/http'
url = URI("https://api.athenahq.ai/api/v1/looker-studio/data")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["x-api-key"] = '<api-key>'
request["Content-Type"] = 'application/json'
request.body = "{\n \"website_id\": \"3c90c3cc-0d44-4b50-8888-8dd25736052a\",\n \"dimensions\": [],\n \"metrics\": [],\n \"filters\": {\n \"start_date\": \"2024-01-01T00:00:00.000Z\",\n \"end_date\": \"2024-12-31T23:59:59.999Z\",\n \"schedule_id\": \"default\",\n \"models\": [\n \"chatgpt\",\n \"perplexity\"\n ],\n \"prompt_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"competitor_ids\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ],\n \"location_ids\": [\n \"123e4567-e89b-12d3-a456-426614174111\"\n ],\n \"prompt_tags\": [\n \"3c90c3cc-0d44-4b50-8888-8dd25736052a\"\n ]\n },\n \"looker_studio_filters\": [\n [\n {\n \"value\": [\n \"<string>\"\n ]\n }\n ]\n ]\n}"
response = http.request(request)
puts response.read_body{
"data": [
{
"date": "<string>",
"model": "<string>",
"company_name": "<string>",
"is_self": true,
"location": "<string>",
"topic_name": "<string>",
"prompt": "<string>",
"response": "<string>",
"citation_rate": 123,
"mention_rate": 123,
"share_of_voice": 123,
"position": 123,
"mentions": 123,
"citations": 123,
"total_responses": 123
}
]
}Body
application/json
Available options:
date, model, company_name, is_self, location, topic_name, prompt, response Available options:
citation_rate, mention_rate, share_of_voice, position, mentions, citations, total_responses Filters for querying responses and metrics. Pass location filters in the JSON body as filters.location_ids.
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Response
Report rows
Show child attributes
Show child attributes
Was this page helpful?