数据中心
Data Explorer
Data Hub > Data Explorer builds a query and shows the result right away. Any query you build here can be reused as a Google Sheets formula, an API URL or a scheduled export.
1. Build a query
- Connector —
all(blended),adstage, or one ad platform. It is preselected when you arrive from a connector's Query data button. - Fields — tick dimensions (date, campaign, ad set …) and metrics (spend, clicks, installs …). The order you tick is the column order.
- The default list uses windsor.ai names (
campaign,adset,ad_name,clicks,cpc,cpm,conversions…). Turn on Show all report fields to see every Attribution Report metric and dimension. - ad platform marks cost data from the platform; AdStage marks SDK event data.
- Add event metrics in the box below, e.g.
purchase_count_total,sign_up_count_app,purchase_value_total.
- The default list uses windsor.ai names (
- Date range — a preset (yesterday, last 7/14/30/90 days, this month, last month, this year, last 12 months) or Custom range. Presets end yesterday in the organization timezone (today is still being collected). Up to 366 days.
- Filters (optional) — pick field, operator and value; from the second row, click
AND/ORto toggle. Use the JSON editor for complex conditions in windsor.ai syntax (filter syntax). - Accounts (optional) — limit to some connected ad accounts. Empty means all.
- Set Max rows (default 1,000, up to 10,000) and Sort, then press Run query.
2. Reading the result
- The Total row covers all matching rows, not only the rows on screen. It is omitted when the query has a metric comparison (e.g.
spend > 100000) or anORfilter. - Money is in the organization base currency; PERCENT fields such as
roas*,ctr,cvr*are ×100 (250= 2.5×). - Rows whose metrics are all zero are omitted (except date-only breakdowns).
- CSV downloads the result (with a BOM so Excel opens non-Latin text correctly).
- The table draws the first 500 rows. Above that a notice appears under the table; the CSV always contains every row that was queried.
3. Reuse the query
| Button | Result |
|---|---|
| Google Sheets formula | =IMPORTDATA("https://api.adstage.app/datahub/v1/...&_renderer=csv") — paste into a cell |
| CSV URL / JSON URL | For Excel, Power BI, Python or your own scripts |
| Schedule export | Opens a scheduled export prefilled with this connector, fields, range and filters |
Replace YOUR_DATA_API_KEY in copied URLs with a Data API key.
4. Common queries
| Goal | Connector | Fields |
|---|---|---|
| Daily performance by channel | all | date, datasource, spend, impressions, clicks, installs, revenue, roas_adstage |
| Meta ad set efficiency | facebook | campaign, adset, spend, impressions, clicks, ctr, cpm, conversions, purchases |
| Google keyword cost | google_ads | campaign, keyword, match_type, spend, clicks, cpc, conversions |
| Naver search terms | naver_searchad | keyword, search_term, spend, clicks, cpc |
| Sign-ups and purchases incl. organic | adstage | date, source, signups, purchases, revenue |
| Instagram vs Facebook placements | facebook | placement, spend, clicks, installs, revenue |

