With the query builder, you can generate reports using Braze data in Snowflake. The query builder comes with pre-built SQL query templates to get you started. Currently only the templated queries are allowed, support for custom SQL queries will follow.
The query builder is in early access. If you’d like to participate in the early access, reach out to your customer success manager.
Running reports in the query builder
To run a report:
- Go to Query Builder, under Data.
- Select the report you’d like to run.
- Click Run Report.
- To download a CSV of your report, click Export.
Results from each report can be generated once a day. If you run the same report more than once in one calendar day, you’ll see the same results in both reports.
Reports that take longer than 6 minutes to run will time out. If this is the first query you’re running in some time, it may take longer to process and therefore has a higher likelishood of timing out. If this happens, try running the report again.
If a report times out or runs into errors even after retrying, please contact support.
All templates surface data from the last 30 days.
|Channel engagement and revenue||For each channel, you’ll see all engagement metrics for that channel (opens, clicks, etc), revenue, number of transactions, and average price.||- Number of transactions: number of purchase events
- Average price: revenue divided by transactions
|Email bounces per domain||Number of bounces per email domain|
|Email performance by country||For each country, you’ll see the following metrics: sends, indirect open rate, and direct open rate. Country is the country of the user at the time of push send.|
|Email subscription group opt-ins and opt-outs||For each week, you’ll see the number of unique user opt-ins and opt-outs of any email subscription groups.|
|Email URLs clicked||This report shows the number of clicks each link in an email had. To run this report, you’ll need to specify the API identifier for a campaign or Canvas. You can find a campaign’s API identifier at the bottom of that campaign’s details page, and you can find the Canvas API identifier under Analyze Variants.
For each de-personalized link, you’ll see a count of clicks. Your CSV download will include the user IDs of all users that clicked, the link they clicked on, and a timestamp of when they clicked.
|De-personalized URLs: URLs that are stripped of any Liquid tags|
|Revenue by country||This report provides revenue per country for a specific campaign/Canvas. To run this report, you’ll need to specify the API identifier for a campaign or Canvas. You can find a campaign’s API identifier at the bottom of that campaign’s details page, and you can find the Canvas API identifier under Analyze Variants.
For each country, you’ll see the amount of revenue generated, number of orders, number of returns, net revenue, and gross revenue.
|- Number of orders: number of purchase events
- Number of returns: number of purchase events with negative revenue values
- Net revenue: revenue of all non-returns
- Gross revenue: revenue that includes the value of returns
|Push performance by country||For each country, you’ll see the following metrics: deliveries, open rate, and click rate. Country is the country of the user at the time of email send.|