Insight | SQL quick tip

For more information and tips visit the Eloqua Insight Resource page.

Recently, I was looking into a blind form submit challenge where anti-malware protections were causing a lot of fake form submits. We wanted to make sure that in form submission data reporting, we were only getting the valid data.

Based on the email recipients and the use case, we decided to only report on the last form submit from a given contact.

OBIEE SQL filter to achieve this:

"Form Data"."User Form Submit ID" = MAX( "Form Data"."User Form Submit ID" By "Contact"."Eloqua Contact ID")

Got any SQL tips for Insight users?