Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED
How to pull a report from data warehouse in adobe analytics
1 Accepted Solution
Correct answer by
Hi @UdayashriGo , Steps to follow to create the report:
1) Create a New Report:
Select the relevant report suite, look for an option to create a new report. It might be labeled as "New Report" or something similar.
2) Choose Report Type:
Select the type that best matches your analysis goals. For custom metrics and segments, you might want to choose a "Custom" or "Freeform" report type.
3) Configure Date Range:
Set the date range for the report. In your case, you mentioned a 3-month time period, so select the appropriate start and end dates.
4) Add Metrics:
Here's where you'll add the custom metrics you want to analyze. Click on the "Metrics" section and look for the option to add or customize metrics. Depending on your analysis needs, you might need to search for and select the specific custom metrics you're interested in. If these metrics aren't readily available, you might need to work with your Adobe Analytics admin or implementation team to ensure the custom metrics are properly set up.
5) Add Dimensions:
Dimensions provide context to your metrics. Add the dimensions that you want to analyze alongside your custom metrics. This could include things like page views, traffic sources, geography, etc.
Create Custom Segment:
For creating a custom segment, navigate to the "Segments" section of the report builder. Look for the option to create a new segment. Depending on your analysis goals, you can define conditions and criteria that the segment should meet. This could involve user behavior, visit attributes, etc.
6) Apply Custom Segment:
Once you've created your custom segment, apply it to your report. This will filter the data based on the criteria you defined in your custom segment.
7) Generate Report:
After configuring your custom metrics, dimensions, and segment, you should be able to generate the report. This report will show you the data for the specified 3-month time period, filtered by your custom segment.
With the report generated, you can explore the data, analyze trends, and draw insights based on the custom metrics and segment you've applied.
9) FTP Server:
As @Rajeshwari and @Jennifer_Dungan mentioned that any files that are over 5MB will be flagged by Adobe as "too large to send" so you need to set up and sent to an FTP server.
Correct answer by
Hi @UdayashriGo , Steps to follow to create the report:
1) Create a New Report:
Select the relevant report suite, look for an option to create a new report. It might be labeled as "New Report" or something similar.
2) Choose Report Type:
Select the type that best matches your analysis goals. For custom metrics and segments, you might want to choose a "Custom" or "Freeform" report type.
3) Configure Date Range:
Set the date range for the report. In your case, you mentioned a 3-month time period, so select the appropriate start and end dates.
4) Add Metrics:
Here's where you'll add the custom metrics you want to analyze. Click on the "Metrics" section and look for the option to add or customize metrics. Depending on your analysis needs, you might need to search for and select the specific custom metrics you're interested in. If these metrics aren't readily available, you might need to work with your Adobe Analytics admin or implementation team to ensure the custom metrics are properly set up.
5) Add Dimensions:
Dimensions provide context to your metrics. Add the dimensions that you want to analyze alongside your custom metrics. This could include things like page views, traffic sources, geography, etc.
Create Custom Segment:
For creating a custom segment, navigate to the "Segments" section of the report builder. Look for the option to create a new segment. Depending on your analysis goals, you can define conditions and criteria that the segment should meet. This could involve user behavior, visit attributes, etc.
6) Apply Custom Segment:
Once you've created your custom segment, apply it to your report. This will filter the data based on the criteria you defined in your custom segment.
7) Generate Report:
After configuring your custom metrics, dimensions, and segment, you should be able to generate the report. This report will show you the data for the specified 3-month time period, filtered by your custom segment.
With the report generated, you can explore the data, analyze trends, and draw insights based on the custom metrics and segment you've applied.
9) FTP Server:
As @Rajeshwari and @Jennifer_Dungan mentioned that any files that are over 5MB will be flagged by Adobe as "too large to send" so you need to set up and sent to an FTP server.
Related Conversations
