Using Date Ranges and Comparisons in Analysis Workspace
- Topics:
- Calendar
CREATED FOR:
- Beginner
- User
In this video, you will learn how to use dates, date ranges, and date comparisons to customize your tables and visualizations to the right time frame.
Transcript
Hey what’s up everybody? This is Doug. In this video we’re going to talk about using dates and date ranges and date comparisons in our project in Analysis Workspace. Now in previous videos we’ve talked about adding panels and visualizations and tables and then filling them with the different components like dimensions and metrics, as we can see over here. And now we’re really going to start to define this data a little bit more by changing the dates that are assigned to those graphs and visualizations and tables and such. Now at the hightest level and really the first thing to know is that there is a date or a date range associated with the different panels. And so here we have this panel that has last 30 days assigned to it. So all of the visualizations and tables and everything on this panel by default will use last 30 days unless we assign a different time period to a specific visualization or table. And we’ll talk about that in a minute. But by default everything on this panel, we’ll use this. And if I collapse this panel and we look at our other ones you’ll see that they also have a date associated with them and these just happen to all be last 30 days right now but we can, of course, change any of them or all of them. So I’ll just go back up to this top one and then we’ll click into that. And this is really just basic stuff, right? We can set a time range by saying maybe the 10th through the 12th and say the 15th through the 16th of January, whatever. We can also use presets. So in this case I’m going to select maybe something like last month. Let’s find that. There it is. And so since it’s in January right now it will show me December numbers and as soon as we move to February in real life it’ll show me January numbers because it says use rolling dates right here. So real basic stuff. I’m going to go ahead and apply that to this panel. And now all of our visualizations and our tables are now last month, or in other words December one to 31 of 2019 since that was last month as of the recording of this video. And it even changed the dates in this table to be daily for that month as well, et cetera, okay. Super-basic stuff but really useful. Now let’s dive a little deeper. Now when I added this free-form table you might remember if you saw that video that I added a blank free-form table and then I just dropped in a metric and it automatically added these days as the dimension. And so that’s one way to quickly get to a day-based dimension here on a table is to just drop a metric in and it’ll add it. However day is not the only time-based dimension and so if you wanted to create one, say, for a week let me go ahead and add another free-form table.
And I can come up to here. I need to select dimensions and then I can type in week and there is a week dimension right there. So I can just drop it in and it’ll show me the weeks for that month, for last month. There’s some other great dimensions that are time-based. You see that I can do weekday versus weekend and I’ll replace that.
Or I can even do day of week and drop that in, et cetera, as well. But I just wanted to show you that we do have these dimensions that are time-based. Okay, I don’t really need that so I’m going to go ahead and nuke that table. And we’re back to what we had before.
Now another cool thing you can do is you can actually use these dimensions as filters. If I scroll down, for example, to my pages report and I’m going to go ahead and add page views again. I’ll just add that and now I have page views and page views, right? Why would I do that? Because once again if I go down to some date ranges I can select things like last month and drop it in there and this month and drop it in there. And I can easily see different timeframes and use those as filters right in these columns. And this allows me to use custom date ranges as well which I will show in a few minutes. But let me go ahead and get rid of that for a second. And we’ll go back to where we were because I want to show you another really cool thing is that you can actually simply just click on the metric and you can do a comparison of different time periods. So this is very handy. If you want to understand how your page views for your pages, for example, this is one example, how they’re doin’ in different time periods, and I have this monthly data, I can click on compare time periods. And because I’m looking at last month it’ll give me month options here. And I can say prior month or this month last year, so a year ago the same month. And I’m going to add that one. And since I’m doin’ a comparison, when I click on that, it’s going to add a couple of columns. First of all, it adds the pages for last year the same month and then it gives me a column for percent change. So I can see that in comparison to last year I’m doing better on some pages and I’m not doing as well on other pages and it will automatically add those colors, et cetera. So very helpful to be able to right-click on a metric in a column and to be able to do that comparison and see if you’re doing better or worse compared to other time periods. Now this is one way to look at it but let me go ahead and scroll up 'cause I want to go up here to this other time frame here and I’m going to add a few columns and then we’ll add a line graph to be able to visualize the data as well. So just like I did before, I’m going to right-click on visits but this time I’m going to add a time period column. Click on that. And I’ll say this month last year to date. It adds that column. I’m going to do it again, add a time period, and say prior month. And so now I have a year ago, I have the month before, and then I have the month which is again is this last month in December. And you can also see then that those dates are in there, just kind of gray so that you can see them, exactly what the time periods are. And then I have my unique visitors here still which is, again, for last month. But I’m able to see, in this case, visits for last month, the month before that, and then that same month, or December, a year ago, and be able to compare those. Now the cool thing I can do is I can create a visualization for this. So if I click on this table, basically highlight the table of visits anyway, I just want the visits. So I’m going to grab that. I’m going to go down to the bottom of this and I’m going to select Shift, click, and I’ve selected all those. And now I’m going to go to my visualizations and add a line chart. Line, drag that over right there. And now I have all of that data in a line chart and I need to lock that so that it doesn’t change as I click around. So lock that and then close it. And now I have that data that I’ve highlighted there with the visits all in these different lines. And so a great way to be able to visualize that. In fact now I can potentially even just come down here and I can collapse the data so that it’s a little bit easier to see the visualizations and maybe I don’t need to see each individual cell of data. So anyway, this is a great way to be able to use dates in a visualization and a table to do these comparisons. Now as I mentioned when we click over to our components down at the bottom there are these date ranges. And if I say show all I can see all the different date ranges here and you can scroll down through them and you can use those and you can drag those over to your different tables and your visualizations and such, and you can even create custom ones. And it’s a little out of the scope for this video so I’m going to let you watch another video on actually creating those. But, for example, this year to date right here was created as a custom one and if I click on that little info bubble I can see that it was created for year to date, in this case January 1st through the 9th, which is rolling yearly on the start and rolling daily on the end of it. But in any case, go ahead and find the video on ExperienceLeague.Adobe.com to look at creating custom date ranges. But that should give you a good idea on how to use the dates in your analysis workspace project. Remember again that there is a date or a date range assigned to each panel but then you can use those dates in the specific visualizations and tables to get a little bit more granular. Hope that was helpful, good luck!
For more information, visit the documentation.
Analytics
- Analytics tutorials
- Introduction to Analytics
- What is analytics
- What Can Adobe Analytics Do For Me?
- How Adobe Analysis Workspace Can Change Your Business
- It’s More Than Data. It’s Customer Intelligence
- Adobe Sensei and Adobe Analytics
- Customer Use Case - ServiceNow
- Customer Use Case - Accent Group
- Customer Use Case - The Home Depot
- Summit 2019 Super Session - Travel and Hospitality
- Summit 2019 Super Session - Retail
- Summit 2019 Super Session - High Tech
- Strategy & thought leadership
- Transitioning from other platforms
- Analytics Basics
- Customizing the UI
- Getting Help
- Analysis Workspace
- Analysis Workspace Basics
- Analysis Workspace quick intro
- Analysis Workspace overview
- Navigate the new landing page
- Start your analysis with a pre-built report
- Building a Workspace project from scratch
- Create and manage custom templates in Analysis Workspace
- Understanding how data gets into your Analysis Workspace project
- Foundational metrics in Adobe Analytics
- Component management in Analysis Workspace
- Selecting a report suite in Analysis Workspace
- View Analysis Workspace performance metrics
- Create bot reports
- Tips and Tricks
- Navigating Workspace Projects
- Data Dictionary in Analysis Workspace
- Starting your first project
- Training tutorial template
- Use folders in Analysis Workspace
- Copy and insert panels and visualizations
- Create a table of contents
- Right-click for Workspace efficiency
- Keyboard shortcuts
- Annotations
- View density
- Use filters
- Use multi-select drop-down filters
- Real-time reports
- Using Panels
- Using Tables, Visualizations, and Panels in Analysis Workspace
- Quick Insights Panel in Analysis Workspace
- Using the Attribution IQ Panel
- Media Concurrent Viewers Panel in Analysis Workspace
- Media Playback Time Spent Panel
- Using Drop-down Filters
- Using Panels to Organize your Analysis Workspace Projects
- Choose segments for a panel
- Multiple Report Suites in Analysis Workspace
- Next/Previous and Page Summary Workspace Panels & Reports
- Understanding attribution panel and lookback windows
- Building Freeform Tables
- Understand your data–freeform tables
- Use the left rail to build freeform tables
- Easy drag and drop to blank projects
- Work with dimensions in a freeform table
- Work with metrics in a freeform table
- Row and column settings in freeform tables
- Freeform table totals
- Use the freeform table builder
- Right-click for workspace efficiency
- Reorder static rows
- Use Attribution IQ in freeform tables
- Cross-sell analysis
- Freeform table filters
- Time-parting dimensions
- Visualizations
- Visualization types and overview
- Visualization use cases
- Data visualization playbook
- Getting data into visualizations
- Using component drop-downs in Workspace
- Area and area stacked visualizations
- Bar and bar stacked visualizations
- Bullet graph visualization
- Donut visualization
- Histogram visualization
- Unlocking insights with histograms
- Line visualization
- Combo charts
- Adding trend lines to line visualizations
- Map visualization
- Summary number and summary change visualizations
- Key metric summary visualization
- Text visualization
- More than words - Using text visualizations and descriptions
- Scatterplot visualization
- Treemap visualization
- Venn diagram visualization
- Use the cumulative average function to apply metric smoothing
- Flexible layouts
- Changing the scale/axis on visualizations
- Dimension-graph live linking
- Set the granularity for visualizations
- Link inside or outside of your project
- Customize visualization legends
- 100% stacked visualizations
- Table and visualization data source settings
- Build a time-parting heatmap
- Analyzing Customer Journeys
- Applying Segments
- Apply segments to your Analysis Workspace project
- Apply ad hoc segments
- Use different Attribution IQ models with segments
- Choose segments for a panel
- Use segments as Dimensions in Analysis Workspace
- Use segments to limit data in Analysis Workspace
- Quick segments in Analysis Workspace
- Building Customer Journey Segments
- Building Customer Journey Segments - Part 2
- Metrics
- Dimensions
- Calendar and Date Ranges
- Curate and Share Projects
- Attribution IQ
- Using Cross-tab Analysis to Explore Basic Marketing Attribution
- Adding side-by-side comparisons of Attribution IQ Models
- Attribution IQ in Calculated Metrics
- Using Attribution IQ in Freeform Tables
- Using the Attribution IQ Panel
- Using different Attribution IQ models with segments
- Algorithmic Model in Attribution IQ
- Custom Look-back Windows in Attribution IQ
- Cohort Analysis
- Cohort Analysis in Analysis Workspace
- Understand your data–Cohort Tables
- Overview of Cohort Tables
- Cohort Table Settings
- Churn Analysis with Cohort Tables
- Cohort Analysis Using Any Dimension
- Latency Analysis with Cohort Tables
- Calculate Rolling Retention in Cohort Tables
- Use Cohort Analysis to Understand Customer Behavior
- Voice Analytics
- How to Manage and Track Your Voice Assistant App Data
- Understand Differences Across Voice-Enabled Devices
- Finding Opportunities To Increase Engagement for Voice Apps
- Reducing Error Rates and Improving Success Rates in Your Voice App
- Understand User Behavior on Voice Assistants
- Understanding the User’s Voice Journey
- Analysis Workspace Basics
- Administration
- Key Admin Skills
- Creating an empowered community
- Simplify and spend less time training users
- Getting the Right People on Your Analytics Team
- Gaining a seat at the table
- Telling impactful stories with data
- Translating Adobe Analytics technical language in a non-technical way
- Working cross-functionally
- Are you asking the right questions?
- Admin Tips and Best Practices
- Download the implementation playbook
- Audit your data dictionary
- Create standardized naming conventions
- Create standardized code templates
- Create basic videos and training
- Create an internal Adobe Analytics site
- Use a global report suite
- Create a news & announcements project
- Drive success with executive summary dashboards
- Create Operational Dashboards
- Company Settings
- User Management
- Manage Report Suites
- How to Configure General Account Settings
- Customize Calendar Settings
- Configure Paid Search Detection
- Set up marketing channels
- Create marketing channel processing rules
- Manipulating incoming data with Processing Rules
- Configuring Traffic Variables (props)
- Configure traffic classifications
- Configure hierarchy variables
- Configuring Variables in the Admin Console
- Configure conversion classifications
- Configuring List Variables
- Configure Finding Methods
- Set Internal URL Filters
- Configuring Zip and Postal Code Settings
- Enable the Timestamp Optional setting
- Configure bot rules in Analytics
- Data Governance and GDPR
- Traffic Management
- Logs
- Key Admin Skills
- Implementation
- Implementation Basics
- Experience Platform Tags
- Implement Experience Cloud solutions in websites using Tags
- Basic configuration of the Analytics extension
- Configure library management in the Analytics extension
- Configure general settings in the Analytics extension
- Configure global variable settings in the Analytics extension
- Use custom code in the Analytics extension
- Use a data layer to set variables
- Use doPlugins and implementation plug-ins
- Configure easy download link tracking
- Configure easy exit link tracking
- Prepare Tags for your Analytics implementation
- Create data elements for the Analytics implementation
- Create a global page load rule
- Validate the global page load rule
- Create rules for special pages
- Create rules for success events
- Publish Tags libraries to stage and production
- Using JavaScript
- Components
- Segmentation
- Segment builder overview
- Finding and creating segments
- Rolling date ranges in segments
- Segment comparison in Analysis Workspace
- Segment containers
- Segment management and sharing
- Applying segments in Analysis Workspace
- Using segments as dimensions
- Using segments to limit data
- Differences between the segment builder and quick segments
- Sequential segmentation
- Before/After sequences in sequential segmentation
- Segmentation on distinct dimension counts
- Dimension models in segmentation
- Use ‘equals any of’ in segmentation
- Analytics Insider Webinar - Customer Segmentation Strategies
- Now just wait a segment… Using segmentation to discover new insights
- Calculated Metrics
- Calculated metric builder overview
- Calculated metrics - implementation-less metrics
- Calculated metrics - segmented metrics
- Calculated metrics - functions
- Approximate count distinct function in calculated metrics
- Quick calculated metrics in Analysis Workspace
- Manage your calculated metrics
- Attribution IQ in calculated metrics
- Use dimensions in calculated metrics
- Take your data analysis to the next level with calculated metrics
- Classifications
- Virtual Report Suites
- Activity Map
- Segmentation
- Additional Tools
- Exporting
- From the UI
- Data Warehouse
- Data Feeds
- Report Builder
- Upgrade and reschedule workbooks
- Add Segments to Multiple Requests at Once in Report Builder
- Anomaly Detection in Report Builder
- Edit Metrics across Requests
- Using Report Builder to learn the Adobe Analytics API
- Get started with Report Builder
- Schedule a Report Builder request
- Use Report Builder advanced delivery options for Power BI
- Integrations
- Experience Cloud
- Audience Manager
- Target
- Adobe Advertising DSP
- Configuring Advertising Analytics
- Implementing tracking templates into search engines
- Introduction to the Adobe Advertising DSP integration
- Create a Pre-launch campaign analysis
- Report on Advertising DSP marketing channels
- Create Analytics site journey profiles
- Create Analytics segments for activation and reporting
- Create Advertising DSP alerts with Adobe Analytics
- Create Analytics custom metrics with Advertising DSP data
- Create Advertising DSP site entry reports
- Create Advertising DSP dashboards
- Ad Hoc Analytics
- Power BI
- Magento
- Data Science
- Vertical-Specific
- Media Analytics
- Mobile App Analytics
- APIs
- Analysis Use Cases