can I call reports that dynmaically build based with url parameters
Hi Tobias, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Yes, you can create dynamic reports in Mixpanel using URL parameters. The JQL (Javascript Query Language) feature in Mixpanel allows you to pass parameters to your queries, making them more flexible and reusable across different date ranges or event types.According to the documentation, you can pass parameters as a JSON blob to the JQL HTTP endpoint. For example, you could create a query that accepts parameters like start date, end date, and event name: LBKSfunction main() { return Events({ from_date: params.start_date, to_date: params.end_date, }).filter(function(event) { return event.name == params.event }) }LBKS
Then you would pass the parameters: LBKSparams = { start_date: "2016-01-01", end_date: "2016-01-10", event: "View Blog" }LBKS
You can also pass multiple events as a list in a params object: LBKSfunction main() { return Events({ from_date: params.start_date, to_date: params.end_date, event_selectors: _.map(params.events, event => ({event: event})) }); }LBKS
With corresponding parameters: LBKSparams = { start_date: "2016-01-01", end_date: "2016-01-10", events: ["View Blog", "View Landing Page", "pageview"] };LBKS
This approach allows you to create reusable query templates that can be dynamically populated with different parameters JQL: Create custom queries using Javascript code.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.
Let me check the knowledge base for you again. One moment! 📚
Yes, you can embed Mixpanel reports in iframes without needing to write JQL function calls. Mixpanel offers an embedding feature that allows you to display reports and boards in third-party tools through iframes.According to the documentation, Mixpanel Boards and reports can be embedded in various tools like Figma, Coda, Jira, and any third-party tool that supports embedding Embeds: View Mixpanel reports in 3rd-party tools.The process is straightforward: 1. Get a shareable URL link from the Board or report you want to embed 2. Paste it into your third-party tool that supports embedding 3. Follow the authentication instructionsFor additional security when sharing reports publicly, you can also use Public Boards with password protection. This allows you to share metrics with stakeholders outside your company while maintaining control over who can access them Public Boards: Share analyses with stakeholders outside your company.The embedded reports will automatically update with your latest data, making it easy to keep everyone aligned on key metrics without requiring them to log into Mixpanel directly.If you're looking to embed reports with dynamic parameters specifically, you might need to use the JQL approach mentioned previously, as the standard embedding feature doesn't explicitly mention URL parameter customization for embedded reports.I hope this helps! Let me know if you need more information about embedding Mixpanel reports.
kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.