Expand my Community achievements bar.

Applications for the 2024-2025 Adobe Analytics Champion Program are open!
SOLVED

How to pull a report from data warehouse in adobe analytics

Avatar

Level 2

Hi everyone,

here i am trying to check the values for few of the metrics for a particular report suite through data ware house. for 3 months time period . Can someone help me the steps to follow to create the report, as im facing difficulty, in choosing the custom metrics and custom segment.

Thankyou in advance.

Udaya

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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.

Explore and Analyze:
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.

View solution in original post

5 Replies

Avatar

Level 2

Hi Rajeswari,

Thankyou for the reply.

Usually the report arrives in an email as a .csv file. But im getting an email alert like the email system is not allowing the zip files and have them resend through another system.

please suggest if an alternate method exists.

Avatar

Community Advisor

Okay. If file is heavy then it won't delivered over an email. hence, you can use FTP/sFTP option to receive your file.

 

Avatar

Community Advisor

Yes, any files that are over 5MB will be flagged by Adobe as "too large to send"... even if your email accepts 10MB files.... 

 

The only option here is to set up and sent to an FTP server.

Avatar

Correct answer by
Community Advisor

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.

Explore and Analyze:
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.