adstage
数据中心

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

  1. Connector — all (blended), adstage, or one ad platform. It is preselected when you arrive from a connector's Query data button.
  2. 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.
  3. 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.
  4. Filters (optional) — pick field, operator and value; from the second row, click AND/OR to toggle. Use the JSON editor for complex conditions in windsor.ai syntax (filter syntax).
  5. Accounts (optional) — limit to some connected ad accounts. Empty means all.
  6. 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 an OR filter.
  • 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

ButtonResult
Google Sheets formula=IMPORTDATA("https://api.adstage.app/datahub/v1/...&_renderer=csv") — paste into a cell
CSV URL / JSON URLFor Excel, Power BI, Python or your own scripts
Schedule exportOpens 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

GoalConnectorFields
Daily performance by channelalldate, datasource, spend, impressions, clicks, installs, revenue, roas_adstage
Meta ad set efficiencyfacebookcampaign, adset, spend, impressions, clicks, ctr, cpm, conversions, purchases
Google keyword costgoogle_adscampaign, keyword, match_type, spend, clicks, cpc, conversions
Naver search termsnaver_searchadkeyword, search_term, spend, clicks, cpc
Sign-ups and purchases incl. organicadstagedate, source, signups, purchases, revenue
Instagram vs Facebook placementsfacebookplacement, spend, clicks, installs, revenue

目录