Reporting on User Activity in Oracle Eloqua

November 13, 2014 Uberflip Customer Success

Some basic Oracle Eloqua terminology before we get started: "Lead" can also refer to a "Contact" in Oracle Eloqua; "List" refers to a "Segment" 

The Basics

Tracking Leads

Tracking how many times a Lead viewed an Item

Conversion Type Attribute Changes

Hub Page View Events

Flipbook Page View Events

Submitted Form Events

The Basics

When viewing your users’ activity in Oracle Eloqua, the Field Names on the contact profiles will look like: ItemType Viewed [Hub ID:XXXXX].  

  • ItemType will be replaced with something like Articles, Flipbooks, Videos etc.
  • XXXXX will be the ID of the specific Hub that the user was viewing.  

We do this just in case you have multiple Hubs that are being used to target different audiences. For example, in the below screenshot we can see that user Nathan Virtue has viewed 2 articles, or blog posts, in Hub 1362 and 2 articles, or blog posts, in Hub 15595.

Tracking Leads

This is the most straightforward way to report upon the Leads being generated or being updated from your Hubs Form CTAs. 

When submitting a Form CTA, a Lead can either be created or updated with the given information. This data is stored on the Lead’s profile.  Reporting on this information is as simple as creating a List and setting a filter to find leads with the specific value for this attribute.

You can create a new Segment to find all users who submitted a particular Form CTA. Please note that with this approach, it would be a best practice to create a new form to use exclusively with your Form CTAs to ensure that you can accurately track who is a member of the segment.

In the example below, we have created a new Segment in Oracle Eloqua to find all users who filled out cta-form-1:

  1. Click on the '+' button in the left side menu and click on Filter Criteria
  2. In the search box in the right hand menu, search for Submitted Specific Forms and double click on the Filter to apply it to your segment; 
  3. Double click on the Filter once it's been added to customize it; and 
  4. Select the form to add from the dropdown menu. 

When you're done, click Save in the top right corner of your screen.

Tracking how many times a Lead viewed an Item

Reporting on the number of Hub Item views inside Oracle Eloqua will allow you to easily tailor workflows based on user activity. 

When a Lead views a specific piece of content inside a Hub, a counter attribute is attached to the Lead’s profile based on the content’s type.  

If the content being viewed was a video for example, and a lead viewed a video a three times, the video counter attribute on the lead’s profile would change from 3 to 4 upon the fourth view of a video in the Hub.  

The name of this field would be given in the format of “Videos Viewed [Hub ID:XXXX]” (where XXXX is your Hub ID).  These fields are numeric, so when reporting on them in Eloqua you can set the filter to say where “Videos Viewed [Hub ID:XXXX]” is greater than 3, for example.

In the example below, the Contact Fields Articles Viewed [Hub ID:1362] and Articles Viewed [Hub ID:15595] would update as a user views more articles in each Hub. 

Conversion Type Attribute Changes

When a Lead interacts with an Item in various ways, these interactions are sent to Oracle Eloqua in the format of updating special Lead attributes.  

When a user views a Hub Item, the field uf_last_visited_item_id is updated on the Lead with the specific Item ID that was viewed.  

When a user fills out a Form CTA that is associated with a particular Hub Item (a Form CTA appearing on an Item page or when your Form CTA links to an Item through the Link to Content feature), the fields uf_conversion_Item_id and uf_conversion_item_title will be updated.  These attributes can be reported on just like all other Lead attributes.

Click here to learn more about these custom fields.

In the example below, we have created a new Segment to find all users who have submitted a Form CTA on item 32409486. Here's how: 

  1. Click on the '+' button in the left side menu and click on Filter Criteria
  2. In the search box in the right hand menu, search for Submitted Specific Forms and double click on the Filter to apply it to your segment. From there, find the form that is being used by the Form CTA in Uberflip we're interested in reporting on;  
  3. Again, in the search box in the right hand menu, search for Compare Contact Fields and double click on the Filter to apply it to your segment. Then double click the Filter to customize it. Ensure you select uf_conversion_item_title or uf_conversion_item_title for the first field, make sure the second field is 'exactly' (do not check the "don't" box), and make sure the third field contains the item id or item title you would like to track;  

When you're done, click Save in the top right corner of your screen.

Hub Page View Events

You can have information on which pages were viewed by a Lead automatically sent to that Lead's profile in Eloqua. 

To report on this information and understand which pages of your Hub have been viewed, set-up a filter on a Lead or Prospect List to specify that a Lead or Prospect has visited the URL from your Hub that you wish to report on.  

For example, if you wanted to generate a report on every user that has visited a specific Item in your Hub, you would just need to create a filter based on visits to that specific Hub URL.

  1. Click on the '+' button in the left side menu and click on Filter Criteria
  2. In the search box in the right hand menu, search for Visited Websites and double click on the Filter to apply it to your segment; 
  3. Double click on the Filter once it's been added to customize it; and 
  4. Using the dropdown menu, select the item's URL for the page you wish to track.

When you're done, click Save in the top right corner of your screen.

Flipbook Page View Events

When a Lead views a Flipbook page, this information is automatically sent to the Lead’s profile page in Oracle Eloqua. 

In Oracle Eloqua, much like when viewing a normal web page, this data is entered as a web page visit.  The difference between a Flipbook Page View and a typical web page visit is that extra data is saved in the query parameters.  The query parameters are: Flipbook_page, Flipbook_id, Flipbook_title, hub_Item_id.  

The only optional query parameter is hub_Item_id and this will show up if you are viewing the Flipbook from within a Hub.  An example of a URL you will see from viewing a Flipbook page is:

http://hub.uberflip.com/h/i/124312?Flipbook_page=3&Flipbook_id=123&Flipbook_title=Welcome&hub_Item_id=124312

In order to see if a contact has been viewing a Flipbook, find the contact in the Contacts section of Oracle Eloqua as a starting point. Enter the Edit Contact section by double clicking on the entry. Under the starting tab (Summary), click “Launch in Profiler”. The profiler will come up with all of the contact's activity; we want to view the “Web” activity.

In the top left beside the highlighted eye, click the button beside it (upon hover the button should say Web). This will give you a more detailed view of the user’s web activity. The Query Strings can now be viewed. Sort or scroll through the Query Strings to view the Flipbook page view data you are looking for.

Submitted Form Event

When a Lead submits a Form CTA that is connected to Eloqua, a form submission will occur inside of Oracle Eloqua.   

Because any Form CTAs that have been created tie in directly to a form that already exists inside of Oracle Eloqua, it's easy to report on whether a user has filled out the form that has been tied to that Form CTA.   

For example, in the below Summary of a Contact's activity, you can see the Form Submission from the Uberflip Form CTA named cta-keri-1 came yesterday after a website visit.

Eloqua supports creating a list filter based on the submitted form’s name as well.

 

Previous Article
Important! Oracle Eloqua Form Processing Step - Use Email as Unique Contact Identifier
Important! Oracle Eloqua Form Processing Step - Use Email as Unique Contact Identifier

Steps to add processing step to Eloqua forms to uniquely identify contacts by the default Eloqua Email Addr...

Next Article
Disconnecting Your Oracle Eloqua Integration
Disconnecting Your Oracle Eloqua Integration

Disconnecting your Eloqua integration can be done through the Integrations page of your Hub.

More questions about your Eloqua integration?

Contact Us!