News

Time-Saving App for Eloqua

Are relative timeframes giving you a hard time? We created an app for you.

Written by Abby Bell

Published on May 9, 2018

If you are an Oracle Eloqua user looking to save time, this article is for you.

As you guys have probably already heard, Classic Insight within Oracle Eloqua is being replaced with Insight Oracle Business Intelligence Enterprise Edition (OBIEE). As of May 18^th you’ll no longer be able to create new reports within Classic Insight. On that day, Classic Insight will be set to read only mode, and new reports will need to be created in OBIEE.

We’ve been reading up, joining webinars and poking around in OBIEE for several months. We’re excited to share a solution for the relative time frame required in SQL for subscription reports, now known as agents.

Get Your SQL Where Clause

We’ve developed an SQL Where Clause Generator that allows you to select between an Email Analysis or Form Submission Data Report, and select from a large list of relative timeframes. The SQL query is automatically generated and you’re able to input this query in your Insight report by using the Copy Results button.

We hope this generator will save you time. Instead of learning SQL, you can keep on creating amazing marketing campaigns! Carry on, marketers!

Watch how to use the SQL Where Clause for Eloqua

Join the Simantics discussion.

Our monthly marketing know-how for everything you need to know, now.

First Name

Last Name

Country

Stay in the know — email me Simantel's latest news, content and updates.

Yes

Simantel respects your privacy. By choosing to opt-in, we’ll send you news and updates about once per month. If you’re a client, we may also occasionally send you information about your account with us, even if you choose not to subscribe. For more information see our privacy policy.