Adobe is moving Ad Hoc Analysis to end of life on March 1, 2021. Learn more
You can customize the delivery schedule for reports. You can stop the delivery at a certain time, or specify the number of times you want to send a report. New schedules use the date range defined in the report. For example, if you create a report for the last 90 days and schedule it to run daily, you receive a report for the last 90 days each day. If you create a report with a static date range from the calendar, you’ll see the same report each time it is sent.
You can customize the delivery schedule for reports. You can stop the delivery at a certain time, or specify the number of times you want to send a report. New schedules use the date range defined in the report. For example, if you create a report for the last 90 days and schedule it to run daily, you receive a report for the last 90 days each day. If you create a report with a static date range from the calendar, you’ll see the same report each time it is sent.
When a user account is disabled, any scheduled report deliveries created by that user are suspended.
To ensure that line items in a breakdown are persistent in saved and scheduled reports, use the Edit Items feature in the Table Builder to create fixed dimension lists in breakdowns.
Ad Hoc Analysis lets you quickly define and schedule reports for specific, timely, ad hoc reporting needs. It is not designed for full exports of data with a massive number or rows, columns, metric evaluations, or extensive breakdowns using data extracts.
Practical constraints for scheduled reporting in Ad Hoc Analysis are based on this principle: If your report doesn’t build within ten minutes (the timeout for Ad Hoc Analysis), then your report is most likely too complex.
Most likely your report has too many metrics, too many dimension element breakdowns, too many rows or columns, or other extremes that make it too long a report generation process for Ad Hoc Analysis. This type of report needs to be run in Data Warehouse, an Adobe Analytics capability made for full data extraction running offline with report generation that can take many hours or days.
For example, Ad Hoc Analysis can handle 50,000 rows of data, but breaking down that data for ten browser types means 50,0000 times 10, an exponential increase that may be too complex for an ad hoc reporting tool. Additional breakdowns again increase the rows of data exponentially. Defining the actual number or rows, columns, and breakdowns to constrain for Ad Hoc Analysis reporting cannot be defined in stark terms but is a combination of all these factors.
Steps that describe how to schedule a report for delivery.
Definitions for the settings on Delivery Options.
You can send your information as displayed in the currently selected report to the format you select. You can send it one time or set up a delivery schedule, and specify the file format you prefer. You can create and send a digital signature to assure the receiver of the file that it is authentic. You can send the file to an email address or upload it to an FTP server.
Field |
Definition |
---|---|
Name |
The configurable name of this report. |
ID |
Tells you the report ID. |
File Format |
|
Advanced |
|
File Destination |
Email: Settings to send via email. FTP: Settings for uploading to an FTP server. |
Report Range and Delivery Schedule |
Specifies when to deliver the report. New schedules use the date range defined in the report. For example, if you create a report for the last 90 days and schedule it to run daily, you receive a report for the last 90 days each day. If you create a report with a static date range from the calendar, you'll see the same report each time it is sent. |
Definitions for the settings on Advanced Format Settings.
Field |
Definition |
---|---|
Filename |
A user defined file name. |
Append ID to filename |
Automatically appends the report ID to the file name. |
Append date to filename |
Automatically appends the date of the report to the filename. |
Language |
Lets you select a language for the report. You can send the report in any of the following languages regardless of the language that you use
|
Encoding |
Specifies an encoding type. |
Send Report as a Compressed File |
Compresses the file. |
Send Digital Signature File |
Creates a digital signature to send with the email. |