BI Tools

The REST API is designed for read-only reporting exports.

Power BI

1. Choose Get data.
2. Choose Web.
3. Paste the API URL.
4. Add the Authorization header in advanced options.
5. Use JSON or CSV depending on your model.

Example URL:

https://app.citlyze.com/api/v1/aggregate-scores?format=csv

Looker Studio

Citlyze ships a community connector that feeds Looker Studio directly from the API — visibility score, citation rate, mention rate, source rate, and run counts per measurement window, brand, prompt, engine, and market.

Requires a plan with API export and an API key from workspace settings.

1. Download the connector: citlyze-looker-studio-connector.zip (contains Code.gs and appsscript.json).
2. Open script.new to create a Google Apps Script project, and replace the default Code.gs with the one from the download.
3. In Project Settings, enable Show "appsscript.json" manifest file, and replace its contents with the appsscript.json from the download.
4. Choose Deploy → Test deployments and copy the Head deployment ID.
5. In Looker Studio, create a data source, pick Build your own under community connectors, and paste the deployment ID.
6. Authorize the script, then paste your Citlyze API key (aeo_live_...) when prompted.

The connector requires a date range; add a date-range control to scope reports. Fields arrive pre-aggregated (averages weighted equally per row) — for run-weighted math, blend with the n_runs metric.

If you prefer not to use Apps Script, any connector that supports custom headers works against the CSV endpoints, or schedule API exports into a Google Sheet first.

Google Sheets

For one-off analysis, download CSV from any endpoint:

curl "https://app.citlyze.com/api/v1/citations?format=csv" \
  -H "Authorization: Bearer aeo_live_..." \
  -o citations.csv

For scheduled updates, use a script or connector that can set the Authorization header.

Modeling tips

• Start with measurement-windows, prompts, brands, and aggregate-scores.
• Add runs and brand-detections when you need answer-level evidence.
• Add citations and sources for source analysis.