Google Tag Manager

reporting and analytics

59 Topics

Challenges with Fetching Spam-Blocked Users from Braze
We've been working on identifying users who have marked our emails as spam, and it's proven to be significantly more complex than expected. Here's a breakdown of the key challenges we've run into: No current-state API — only raw event streams Braze doesn't expose a current-state endpoint for spam status. The only available data is a stream of raw events, which means you have to rely on a data warehouse to ingest and process potentially millions of event logs just to reconstruct user state. Spam status is reversible, requiring cross-referencing two large event tables Because a spam mark can be reversed, you can't simply collect spam events and call it done. Each spam event needs to be cross-referenced against send events to determine whether the spam status is still active — which means scanning two large tables on every run. Events arrive independently with no guaranteed ordering The spam event and the corresponding send event don't arrive together or at consistent times. A user might generate a spam event today and a related send event days later, making real-time or near-real-time processing unreliable. Certain Canvases allow sending to spam-blocked users, causing false positives Some Canvases are configured to bypass spam suppression and send to all users, including those who have marked messages as spam. This means a send event from such a Canvas can overwrite a user's spam status to false, producing false positives in any derived spam blocklist. Heavy infrastructure overhead All of the above ultimately requires building and maintaining a scheduled backend job that runs daily, pulling and processing large volumes of data from the warehouse — adding meaningful operational and compute cost. Has anyone else run into these issues? Would love to hear how others are approaching this, or whether there are better patterns we haven't considered.
Nirnay
2 days ago Place Data
52Views
1like
2Comments
Query Builder, Fetch records from USERS_CANVAS_ENTRY_SHARED view using Canvas Name
I am trying to build a query to find the conversation rate for a set of Canvas Name. When I execute below script select * FROM USERS_CANVAS_ENTRY_SHARED --where "Canvas_Name" ilike '%Promotional%' limit 10 ; I am able to see the "Canvas Name" but when I see the view properties, I do not find the column "Canvas Name" I am trying to fetch the Canvas_ID by providing Canvas Name. Please help.
nishan0804
2 days ago Place Data
70Views
2likes
7Comments
Push Opt-Out Tracking - Workarounds 🤓?
Hello to all the creative workaround masterminds in here. I've been thinking about push-out out tracking approaches and would love to see if you have any other ideas. First, some context: What: I'm looking to set up a Push Opted-Out event or some sort of directional tracking when users revoke the permission on (one of) their device(s). We can use this as a guardrail metric against our push campaigns. Why: It's a nice guardrail, especially for scaling CRM teams/Lifecycle strategies. It helps sense checking what users might get value from vs feel annoyed with. It helps address stakeholder concerns around sending too much/too little in a data-driven way, rather than gut feeling. Even if it's a directional metric. In our case we use Braze + Mixpanel, so the obvious solution to above is to use an "All events" Currents feed and stream the Token State Change event into Mixpanel (users.behaviors.pushnotification.TokenStateChange >> push_token_foreground_push_disabled=true ). However, life is not always that easy and there's a chance I can't get approval on the extra budget to enable that (we have a more limited Currents setup at the moment). I've worked in companies with tricky setups where data activation is hard and Currents is not used, so I guess this might be relevant for other use cases as well... To get ahead on alternative solutions, I thought of below -- but please share if you have other ideas? [No dev dependency] A scheduled Braze Canvas that periodically detects “now push-ineligible” (foreground push enabled for app changes to false) and logs a custom Push Opt-Out Detected event in the users' profile (via a webhook calling brazeBridge.logCustomEvent("completed survey"). Pro: relatively easy setup; can be used as conversion event in campaigns/canvases. Con: probably very close to the TokenStateChange event provided by Braze, but won't be streamed to CDP/Mixpanel (for the same Currents feed limitation); usable only within Braze. [Dev dependency] Client-side instrumentation to detect permission changes and send a custom event from the apps. Pro: as accurate as Braze's TokenStateChange event, and will be available at every data tool we need (CDP/Mixpanel/Braze etc) Con: dev work (+dependency with product roadmap) + is it even worth the effort vs cost of upgrading Currents feed type? Appreciate!
inespais
1 month ago Place Data
114Views
0likes
3Comments
Strategy to Identify Duplicate Profiles
We needed to identify and merge duplicate Braze profiles (same email, different user IDs) across our entire user base. We evaluated two solutions. Solution 1: Identify duplicate profiles via /users/export/ids and attach a custom attribute for segmentation Export each profile, identify duplicates externally, then update profiles with a custom attribute is_duplicated=true and capture them via a segment. {% connected_content https://rest.au-01.braze.com/users/export/ids :method post :headers { "Authorization": "Bearer XXXX" } :body {"email_address":"{{${email_address}}}"} :content_type application/json :no_cache :save result %} {% if result.users.size == 1 %} {% abort_message('User is unique.') %} {% endif %} { "attributes" : [ { "braze_id" : "{{${braze_id}}}", "is_duplicated": true, "_update_existing_only" : true } ] } One caveat with this solution is that we need to export the entire user base, and it will take a couple of days to identify the duplicates. Solution 2: Identify the duplicate profiles via a Segment extension Key Assumptions: Every profile in Braze has at least one entry in USERS_BEHAVIORS_SUBSCRIPTION_GLOBALSTATECHANGE_SHARED (i.e., all profiles have a subscription state change event) Every deleted profile appears in USERS_USERDELETEREQUEST_SHARED Here's the query we're using: -- Purpose: Identify duplicate Braze profiles (same email, different user IDs) for merging via /users/merge endpoint -- Excludes deleted/orphaned users and only returns duplicates where 2+ active profiles remain WITH active_users AS ( -- Get unique user/email pairs, excluding deleted/orphaned users SELECT u.USER_ID, u.EMAIL_ADDRESS FROM USERS_BEHAVIORS_SUBSCRIPTION_GLOBALSTATECHANGE_SHARED u LEFT JOIN USERS_USERDELETEREQUEST_SHARED d ON u.USER_ID = d.USER_ID WHERE u.EMAIL_ADDRESS IS NOT NULL AND d.USER_ID IS NULL -- Exclude deleted/orphaned users GROUP BY u.USER_ID, u.EMAIL_ADDRESS -- Dedupe since source table contains multiple events per user ) SELECT DISTINCT a.USER_ID FROM active_users a INNER JOIN ( -- Find emails with more than one active user profile SELECT EMAIL_ADDRESS FROM active_users GROUP BY EMAIL_ADDRESS HAVING COUNT(*) > 1 ) dup ON a.EMAIL_ADDRESS = dup.EMAIL_ADDRESS; Key findings: This query only takes a couple of minutes to identify duplicates USERS_USERDELETEREQUEST_SHARED contains both explicitly deleted users AND users orphaned via /users/merge - this means the query automatically excludes already-merged profiles. Looks like Braze prunes orphaned profiles after /users/merge is performed. Has anyone else taken this approach? Curious if there are edge cases we should watch out for.
kethiri
3 months ago Place Data
139Views
0likes
2Comments
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!
BradRossman
3 months ago Place Data
206Views
4likes
4Comments
How to tell a recipient's bounce status in an export?
I am using the Braze export API to pull down recently added users, and want to check if any of them are marked as hard bounce, or have already accumulated any soft bounces (and if so, in what time period). Similarly, I'd like to be able to tell if a user has marked as spam. Is there an attribute capturing this information that I'm overlooking? Or is the best/only solution to create segments for those attributes and make multiple requests. Thanks!
Drew
5 months ago Place Data
71Views
0likes
3Comments
Segment Users with Generalized Interactions
I can see how to segment for Users who have opened an email from or clicked a link in a specific campaign. Is there a way to see Users who have received / clicked for any campaigns, either in general or within a given date range? Thanks!
Solved
Drew
5 months ago Place Data
45Views
0likes
2Comments
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?
rkrish
6 months ago Place Data
125Views
1like
4Comments
Email engagement performance reporting by canvas step
Hello community, First time poster with my company being on Braze for 5 months. I am trying to find a way to extract engagement performance metrics (such as open%, CTOR%, deliverability%) for all emails sent during a 7 day time period. the only reports I have found wrap up all canvas step emails as a total canvas result. I am hoping the community can steer me to a solution that my team and I as marketing end users can create a report within 'Report Builder', or similar, so we can monitor individual canvas step emails and campaign email engagement results within a single report. Cheers, Tim
Tim_Walsh
6 months ago Place Ask Me Anything
98Views
3likes
2Comments
Reporting
With so many different areas and software to generate reports from, how do you merge them all together to create a single customer view? Do you have a CDP or do this in another way?
Emma_Oliver93
8 months ago Place Data
165Views
1like
2Comments