Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.upstackdata.com/llms.txt

Use this file to discover all available pages before exploring further.

Upstack Analytics gives you direct access to your identity-resolved, enriched event data. You can explore traffic patterns, measure conversion funnels, compare channel performance, and build custom reports — all from a single dashboard backed by your first-party data.
Unlike ad platform dashboards that only show their own ecosystem, Upstack Analytics queries your unified event stream. You see every channel, every touchpoint, and every conversion in one place with consistent measurement.

What You Can Query

Upstack Analytics organizes data into three primary views:

Events

Query raw events with filters and aggregations. Useful for:
  • Counting events by type over time (e.g., “How many AddToCart events this week?”)
  • Filtering by event properties (e.g., “All Purchase events where value > $100”)
  • Grouping by dimensions (e.g., “PageViews by device type and country”)

Sessions

Query session-level metrics that aggregate events into browsing sessions. Useful for:
  • Understanding engagement patterns (session duration, pages per session, bounce rate)
  • Comparing session quality across traffic sources
  • Identifying high-intent sessions that didn’t convert

Attribution

Query attribution data that assigns conversion credit across marketing touchpoints. Useful for:
  • Comparing channel performance across attribution models
  • Calculating true ROAS per channel
  • Identifying which campaigns drive the highest-value customers

Using the Query Builder

The Upstack Analytics dashboard provides a visual query builder that lets you construct queries without writing SQL.

1. Select Your Measures

Measures are the numeric values you want to calculate. Choose one or more:
  • Total Events — Count of events matching your filters
  • Unique Visitors — Distinct identity count
  • Revenue — Sum of Purchase event values
  • Conversion Rate — Purchases divided by sessions
  • Average Order Value — Revenue divided by purchase count
See Measures & Dimensions for the full list.

2. Choose Your Dimensions

Dimensions break down your measures into categories:
  • Date — Time-series view (daily, weekly, monthly)
  • UTM Source — Group by traffic source
  • Device Type — Compare mobile vs. desktop
  • Country — Geographic breakdown
  • Event Name — Group by event type

3. Set Date Range

Select a predefined range or set custom start and end dates:
PresetRange
TodayCurrent day
Last 7 daysRolling 7-day window
Last 30 daysRolling 30-day window
This monthCalendar month to date
Last monthPrevious calendar month
CustomAny start and end date
All dates are in UTC. Data is available within minutes of the event occurring.

4. Apply Filters

Narrow your results with filters on any dimension or event property:
  • utm_source = facebook — Only Facebook traffic
  • device_type = mobile — Only mobile visitors
  • event_name = Purchase — Only purchase events
  • country = US — Only US visitors
  • value > 50 — Only events with value above $50
Filters can be combined with AND logic. Multiple values for the same field use OR logic (e.g., utm_source = facebook OR google).

5. Set Grouping

Choose how to group your results. You can group by one or more dimensions:
  • Single dimension: Revenue by utm_source → bar chart comparing channels
  • Two dimensions: Revenue by utm_source and date → time series per channel
  • No grouping: Single aggregate number across all matching data

Reading Results

Query results are displayed as both a chart and a data table. You can:
  • Toggle chart types — Line, bar, or table view
  • Export data — Download results as CSV for further analysis
  • Save as report — Save the query configuration for quick access later
  • Share — Generate a shareable link to the report
Saved reports update automatically. When you open a saved report, it re-executes the query against the latest data with the same filters, dimensions, and date range logic.

Common Query Patterns

Conversion funnel: Select measures for PageViews, AddToCart, InitiateCheckout, and Purchase counts. Group by date to see the funnel over time. Channel comparison: Select Revenue and Conversion Rate. Group by utm_source. Filter to last 30 days. Compare which channels drive the most efficient revenue. Device breakdown: Select Sessions and Bounce Rate. Group by device_type. Identify whether mobile experience needs optimization. Top pages: Select PageViews and Unique Visitors. Group by page_path. Sort by PageViews descending to find your highest-traffic pages.

Measures & Dimensions

Full reference for every measure and dimension available in the query builder.

Session & Page Analytics

Dive deeper into session-level and page-level metrics.

Attribution Reporting

Compare attribution models and understand channel credit allocation.

Event Taxonomy

Review the standard events that feed your analytics queries.