Insight frequently asked questions
Where can I find Oracle Eloqua out-of-the-box reports?
You can find the Oracle Eloqua out-of-the-box reports in the Shared Folders in the Insight report catalog. Click Catalog in the menu bar and then click Shared Folders.
Any custom reports created by your organization are in the Company Shared folder.
How can I manage access to reports and folders?
Admins can control access to reports through the Insight Folder Security feature, which allows access management at the folder level. When a user is granted access to a folder, they automatically gain access to all reports, agents, and dashboards within that folder. Additionally, if a folder has sub-folders, granting access to the main (parent) folder will also grant access to all its sub-folders and their contents.
Learn more about roles and permissions.
Can users with the reporter role schedule reports?
In Insight, subscription and email services are provided by agents. Yes, all Insight users can create and run agents. Learn more about Creating Insight agents.
What level of granularity is the data in Insight?
Insight stores data at the day level. This means that you can drill down to data from a single specific day, but not down to the hour.
How often is the data updated in Insight?
Typically, it can take up to 24 hours before you see the most recent data in Insight. Insight data is stored at the day level and is refreshed every few hours. This spreads the processing throughout the day.
Certain data may take longer. For example, the device metrics included in the Email Open subject area is provided by a third party and can take up to a few days to populate all records.
What time zone is used for Insight data?
Oracle Eloqua stores all data in Eastern Time and Insight uses the same data. Although you can change your time zone in Insight, the Insight data will not change. It will always display Eastern Time. This knowledge base article provides more information on Oracle Eloqua and time zone. Learn more about the time zone of Insight reports, agent schedules, and the Insight server.
What is the time zone of Insight reports, agent schedules, and the Insight server?
All insight data is in Eastern Time and reflects daylight savings time. The time zone of your Insight account (User name > My Account) is used for:
- The scheduled time of agents.
- The generated time of an analysis.
- The time on which objects in catalog are created, modified, and accessed.
Custom SQL formulas that use calendar date/time functions are evaluated against the Insight server time zone, which is Universal Time (UTC). For example, CURRENT_DATE or CURRENT_TIME will reflect the date or time of the Insight server.
What are the export limits in Insight?
You can export Oracle Eloqua reports, or a custom analysis in the following formats:
- Microsoft Excel 2007+
- Microsoft PowerPoint 2007+
- Web Archive (.mht)
- CSV
- Tab delimited format
- XML Format
You can export an entire dashboard or a single dashboard page to Microsoft Excel 2007+.
-
Display limits for Pivot Tables and Tables For Display values:
- Up to 200,000 rows
- Max Cells: 1,400,000
- Max Visible Pages: 1,000
- Max Visible Rows: 200,000
- Max Visible Sections: 250
- Default Rows Displayed: 64,000
- Note: Reports will not run if the limits are exceeded
- Export limits:
- Up to 200,000 rows to export
- Up to 1.4 M cells to export
-
Agent limits:
- Up to 200,000 rows
- Data is truncated if it analysis exceeds 200,000 limit
Learn more about exporting and agents.
Why are aggregated unique metrics different in Insight?
Columns containing unique metrics are totaled in Insight differently than in Classic Insight. Unique metrics are metrics such as unique clickthrough, unique visitors, unique form submissions, and so on.
Instead of calculating the total value by adding up all cells in a column, Insight recalculates uniqueness across the column. So, a unique clickthrough in a single campaign is not the same as a unique clickthrough across multiple campaigns. This change in Insight provides you a more accurate calculation.
In the following image, you can see that the total Unique Opens and total Unique Clickthroughs are not simply adding up all the values in the column. Whereas the other column totals are calculated by adding all column values.
Oracle Eloqua tracks and stores the following automatic engagement metrics separately from those generated by an actual email contact:
- Auto-opens and clicks by email scanning tools
- Apple email privacy auto-opens
How does contact security impact reports in Insight?
If your organization uses contact security, any contact related report in Insight is limited to the contacts that a user can access. For example, a campaign report will show data related to all campaign members. If you then drill through to a report that includes contact details, you will see only those contacts that you can access. This could result in differences between reports and between users. Dashboards also behave the same way.
Contact your administrator for more information on the contact security implementation at your organization. Learn more about contact security.
Why do I receive Error 403--Forbidden when I open Insight?
This might be because you previously had open Insight sessions. Try the following:
- Close all browser windows
- Open a new browser window
- Login to Eloqua and try opening Insight again
Do the folder paths support non-ASCII characters?
The folder paths only support ASCII characters. Ensure that you do not use any non-ASCII characters when creating folder paths.