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

Use a connector that supports custom headers, 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.