Webinar Recording: Customer Roundtable: SQL Tools in Braze
Hi everyone! Braze Learning recently hosted a customer roundtable on SQL Tools in Braze (Query Builder and SQL Segment Extensions) with Braze Product Manager Guransh Singh and Braze customer Qliro. We explored: Overview - What are Query Builder and Segment Extensions? Why use these tools? Live Product Demo - What data we make accessible for querying, how it's stored in Braze, and how to get started with these tools in Braze Use cases and examples from real Braze customers - Braze customer Qliro joined us to share more about their implementation of SQL Segment Extensions Q&A If you didn't see it live, you can check it out at this link! Want more webinars? Our next webinar will be hosted with our 427 Innovation Lab - we'll be covering exciting new AI use cases in Braze from their Melting Points AI Guide - sign up here to join us on July 2nd or receive the recording! Curious about the latest product updates in Braze? Check out our latest monthly Discover What's New webinars covering product updates from April and May - and sign up to receive June's webinar!Braze MCP Server - Prompts and Use Cases
Hey all, I was very excited to see the release of the Braze MCP server and set it up with Claude this morning. It's very impressive, so far I've gotten nice analytics reports for overall Canvas performance, but limited to 14 days at a time with the canvas data series analytics API, or to ask for the 'top performing Push campaigns for July 2025'. I wanted to hear some other prompts people were using to get reporting value quickly from Braze. I also was interested to pull in messaging templates (Email, IAM) and see how well it could add/edit liquid. Disclaimer: Of course don't give the MCP API key more than read access while we play around with the functionality as we don't want it to go and edit anything in Prod!
Findings from our December campaign analytics and performance survey
We recently conducted a survey to gain insights into how and when our marketing users review the analytics and performance of their campaigns and Canvases. We had an impressive response, with 1300 submissions. Thank you to everyone who participated! Timing of campaign/Canvas review survey findings: Within 24 hours after launch: 45% of you check your analytics right after launching a campaign or Canvas. This quick review allows for quick adjustments and optimizations of ongoing campaigns. If your campaign or Canvas will add users over time, don’t panic over early performance indicators, but keep an eye out for any warning signs. On specific days of the week: 20% of you prefer to check performance on set days, like Mondays and Fridays, which helps plan and strategize for the week ahead. Daily checks: 19% monitor active campaigns and Canvases daily, ensuring they stay on top of performance metrics. Varied by campaign/Canvas: A notable 46% of you also indicated your frequency depends on the specific campaign or Canvas and the metrics you track. This flexibility is key to adapting to different goals and strategies. Other: 8% of you have unique approaches that don’t fit into the other categories. Best practices for reviewing campaigns and Canvases: 🗓️ Set a review schedule: Whether daily, weekly, or after a specific milestone, having a consistent schedule helps you stay organized and proactive as you launch new one-off and ever-green campaigns. 📈 Focus on key metrics: Identify which metrics matter most for each campaign or Canvas. This could include engagement rates, conversion rates, or customer feedback. 🤸 Be flexible: As many of you noted, the approach can vary by campaign. Be open to adjusting your review process based on the goal of your campaign or Canvas. 📃 Document your learnings: Keep track of insights gained from each review, and share your findings with other internal teams! This will help refine your marketing strategies and improve future campaigns or messaging tactics. How do you approach reviewing your campaigns and Canvases? What metrics do you find most valuable? Let's learn from each other! Share your analytics practices and insights in the comments below. Happy analyzing and happy holidays! 🎄Data migration Braze <> Braze best practice
Hi! I'm working on migrating data from one braze instance to another and I have some questions regarding best practices that I haven't been able to find in any braze documentation. Is there a QA template or checklist for testing after a data migration or a new integration with another platform? What would be the best practice? For example, is sample testing on a few user profiles recommended, or how do you approach QA post-migration in the best way according to Braze? Is possible to clone any of the below via API or do they need to me manually recreated in the new instance? Campaigns Internal Users Email Templates Content Blocks Media Templates Thanks! BR, Emilia
Abandoned Cart Journey and Revenue Calculation
We have launched an Abandoned Cart Journey (Canvas) for an eCommerce site and we are setting it up with this configuration "Cart Updated" event as entry criteria "Cart Updated" event as exit criteria to support moving the "Abandoned Cart" email delay to start at the last time the user updates the cart "Make Purchase" event as exit criteria to not email folks who made a purchase and "Purchase" as the conversion event and Two Abandon Cart emails with a X and Y duration delay After we launched this journey, we are finding that the revenue reported in canvas reflects the full revenue of the site and not just the revenue from folks who have received an abandoned cart email. This is because all e-commerce buyers will have "Cart Updated" events and hence will be added to this journeys. Customers who finish making the purchase will be removed from this journey due to the exit criteria but are still considered as part of the conversion event and revenue calculation. Is there a way around this? Is the roadmap feature for "Deeper Conversion Attribution" in the Planned Set aimed at solving this?Tracking Comms Cadence Across Manual and Automated Messages
I'm looking to get a sense of the average comms cadence our members typically receive. It’s a bit tricky to assess since our messaging is highly targeted and includes a mix of automated and manual communications. Just wanted to see if anyone else has successfully tackled this—I’d love to hear what’s worked for you!Help with Query around custom event properties
Hey all! Trying to run a query to output volume of a specific custom event (with a specific property) performed by users who entered a specific canvas. I'm using the USERS_BEHAVIORS_CUSTOMEVENT_SHARED table, which includes event "name" and "properties" (according to the documentation --- Custom properties of the event stored as a JSON encoded string). I managed to output the total event occurrences but got stuck when it came to filtering by event property and pretty sure it's a syntax issue... Query - Total Voucher Redemptions: This looks at total "Voucher Redeem" events from users who entered the specified canvas. WITH canvas_users AS ( SELECT DISTINCT user_id FROM USERS_CANVAS_ENTRY_SHARED WHERE canvas_api_id = 'XXXXXXXXXXXXXXXXXXXXXXXX' ), voucher_redeems AS ( SELECT DISTINCT user_id FROM USERS_BEHAVIORS_CUSTOMEVENT_SHARED WHERE name = 'Voucher Redeem' ) SELECT COUNT(DISTINCT cr.user_id) AS users_redeemed_voucher FROM canvas_users cr JOIN voucher_redeems vr ON cr.user_id = vr.user_id; Query - Filter by specific property: I need to basically filter above to only include event occurrences where the "Voucher Redeem" property "campaign_name" matches a specific string. Just can't figure out how to do it. Chat GPT advised me the following, but I get zero results. WITH canvas_users AS ( SELECT DISTINCT user_id FROM USERS_CANVAS_ENTRY_SHARED WHERE canvas_api_id = 'XXXXXXXXXXXXXXXXXXXXXXXX' ), voucher_redeems AS ( SELECT DISTINCT user_id FROM USERS_BEHAVIORS_CUSTOMEVENT_SHARED WHERE name = 'Voucher Redeem' AND REGEXP_LIKE( PARSE_JSON(properties):campaign_name::STRING, '[XXXX]' ) ) SELECT COUNT(DISTINCT cr.user_id) AS users_redeemed_voucher FROM canvas_users cr JOIN voucher_redeems vr ON cr.user_id = vr.user_id; Has anyone successfully queried event properties and can shed some light on the solution here? Much appreciated!
