I’m trying to create a report that shows the cumulative number of unique articles set live over time. We have a custom event called 'view editorial' that fires when someone views an article, and it includes a property for the article's current URL. I want a graph that shows the total number of unique URLs (i.e., unique articles viewed) set live over time, without manually calculating anything. How can I do this in Mixpanel?
Hi Lara M., 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
To create a report showing the cumulative number of unique articles set live over time in Mixpanel, you can use the Insights report with some specific configurations: 1. First, create an Insights report and select the "view editorial" event 2. For the measurement, you'll want to use "Total" with a property aggregation 3. Select the article URL property for aggregation with "Count Unique" as the aggregation type 4. Set your visualization to a line chart with "Cumulative" option enabledThis approach will show you the cumulative count of unique article URLs viewed over time, effectively tracking how many unique articles have been set live and viewed.Mixpanel's Insights report is designed for this type of analysis, allowing you to visualize trends and compositions within your data, including unique property values over time Insights: Visualize trends and compositions within your data.For more advanced property analysis, you could also consider using custom properties if you need to transform the URL data in any way Custom Properties: Calculate new properties on the fly.If you need to perform more complex analysis, you might want to explore JQL (JavaScript Query Language) which allows for chained aggregations and more sophisticated data manipulation JQL Builtins.
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! 📚
I understand you want to track when articles first appear in your Mixpanel data rather than showing cumulative growth. You can accomplish this using cohort analysis in Mixpanel:
Using First Time Filter in Insights
You can create a report that shows when articles were first viewed using the First Time filter: 1. Create an Insights report with the "view editorial" event 2. Add a First Time filter to this event (this filters to only the first instance of the event for each unique article URL) 3. Break down by the article URL property 4. Group by time (day/week/month) to see when articles first appearedThis approach will show you when each unique article URL was first seen in your Mixpanel data, effectively showing when articles were "set live" from a tracking perspective.Mixpanel's First Time filter is designed specifically for this type of analysis, allowing you to identify the first occurrence of events Analyzing First Time Users.
Alternative: Cohort Analysis
You could also approach this using Mixpanel's cohort analysis features: 1. Create cohorts based on when articles first appeared 2. Analyze these cohorts to see distribution over timeMixpanel offers powerful cohort analysis capabilities that let you group users (or in this case, articles) by when they first performed certain actions Ultimate guide to cohort analysis.Would you like me to provide more specific steps for either of these approaches?Let me know if you need any clarification or have questions about implementing this in your Mixpanel instance.
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! 📚
I understand you want a single line graph showing the total number of unique articles set live over time, without breaking down by individual URLs.Here's how to create this in Mixpanel: 1. Create an Insights report with the "view editorial" event 2. Add a "First Time" filter to this event (this ensures you're only counting each article when it first appears) 3. For the measurement, select "Count Unique" of the article URL property 4. Set your visualization to a line chart 5. Group by time (day/week/month) as neededThis will give you a single line showing the count of new unique articles that appeared for the first time in each time period. If you want to see the running total (cumulative count), you can enable the "Cumulative" option in the chart settings.Mixpanel's Insights report is designed for this type of analysis, allowing you to visualize trends in your data over time Insights: Visualize trends and compositions within your data.The key here is using the "First Time" filter combined with counting unique values of your URL property, which will give you exactly what you're looking for - a count of new articles appearing in your system over time.
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.