Eloqua

Oracle Eloqua Reports to Google Spreadsheets | Eloqua Series | Part 7

December 21, 2022January 25, 2023 nikkipunjabi Leave a comment

Nowadays, we always look for ways to automate. This blog post explains how to automate the process of exporting the Eloqua reports to Google Spreadsheets and share them with different stakeholders.

In Eloqua Series – Part 5, we created the reports using Oracle BI, in this blog post you’ll see how can you send that data directly to Google Spreadsheet and also create Data Studio Dashboards.

By making use of the scheduler within the Oracle BI tool you can send the required report by email. You might not have heard about Microsoft Power Automate – but using Power Automate you can send that report to Google Spreadsheets or Google Drive or Microsoft Onedrive and you can do a lot more processing and automation by using Power Automate.

Eloqua Insight | Oracle Business Intelligence (BI) | Eloqua Series | Part 5

October 10, 2022December 14, 2022 nikkipunjabi Leave a comment

Oracle Business Intelligence (BI) is very useful for Reporting. It is one of the powerful tools by Oracle which provides very good reporting and insights into all the activity happening with your account on Eloqua.

With Oracle BI, we get an option to obtain reports for all the Email Campaigns, Individual Emails, Forms, Custom Data Objects, Contacts, and a lot more. The very good part with Insights is that you can schedule these reports to your Email Inbox Daily/Weekly or on a specific day as per your needs. We have configured almost 100+ reports that are sent to stakeholders in accordance with the business needs. And all of this is automated! We try to avoid manual work as much as possible and insight helps us to achieve easily.

By default, when you first load the Oracle BI – You need to navigate to the Shared Folder and you’ll see the list of all the default reporting options that are available. Oracle has done a great job of defining the default useful reports for all the business domains.

Custom Data Objects [CDO] | Eloqua Series | Part 4

September 1, 2022December 14, 2022 nikkipunjabi Leave a comment

On Oracle Eloqua, Custom Data Objects [CDO] play an important role because they allow you to store 25 million entries.

If you already have Eloqua you might be aware that it only allows a certain number of records in the Contacts database/table and that depends on the package that you go with. Let’s suppose it’s 1 million. The size of your contacts database will also grow as you enhance your application, and Eloqua Contacts won’t be able to handle all the information.

With the help of CDO, you can store a large set of data in an organized manner. You can have one-to-one or one-to-many relationships. you need to set any unique field as a Key so with the form submission you need some Unique ID. For a one-to-one, If you set an Email Address as a Unique ID – then the system will always update that same email address record with the new set of updates. For a one-to-many, If you set the Submission ID as a Unique ID – the system will always add the new record. You’ll have an option to set the Unique Code Field which will define that an entry is of a specific Email Address. In the above diagram, I’ve shown a one-to-many relationship.

Eloqua Forms | Oracle Eloqua Series | Part 3

August 8, 2022December 14, 2022 nikkipunjabi Leave a comment

In a previous blog post, we discussed Email Campaigns. We’ll take a closer look at Eloqua forms and the different post-processing options available that can help you organize contacts properly.

Eloqua’s forms are one of the key entry points for Leads. Eloqua Consultants recommend using Eloqua Forms API to push data from websites to Eloqua. We can apply post-processing steps in Eloqua Forms where we provide all the necessary rules for each submission. This practice will give you more control over user contact, allowing you to create different strategies for organizing and planning user journeys.

Email Campaigns | Oracle Eloqua Series | Part 2

August 1, 2022December 14, 2022 nikkipunjabi Leave a comment

The main reason you go with Eloqua is Email Campaigns which is obvious. A campaign allows you to give your contacts an engaging, personalized, and unique experience. In this post, we’ll see different types of Email Campaigns and what kinds of scenarios you can play around with on Eloqua.

You need to keep the following things in place before sending an email:

Email:
- Header
- Email Body
- Footer
Email is associated with the following:
- Email Preference Center: To allow the user to provide more preferences to get their interest, country, and so on.
- Newsletter Unsubscribe: This is a mandate by default for all newsletters.
- Email Group: To define to which group the user will be unsubscribed. With email groups, you can classify emails for different audiences and allow subscribers and unsubscribers within those specific newsletters, or you can use it for different brands. This has to be used very carefully. If I unsubscribe from one brand I should still receive an email from other brands from the same Eloqua instance. We have a proper strategy in place defining when and in what case we need to define an email group. If you are going to start working on Eloqua then you need to define the ground rules of creating an Email Group in the beginning. Email groups can also be helpful to create reports.
- Segment – To define to which audience this email should reach. Segmentation is a very important topic and needs a detailed understanding of how you can make use of your data to properly define the segments. Our email campaign requirements dictate the types of segments we create for different audiences. In order to send an email campaign, it is necessary to determine what the requirements are ahead of time. For example, we create a specific segment to send a monthly newsletter to a certain audience, the different segments for sending an email based on user interest, and so on. Recommend you to go through the Eloqua guide for segmentation and if you have any queries you can reach out to me.
  If you are already familiar with segmentation on Mailchimp then you can easily understand this on Eloqua but one thing to keep in mind here is that Mailchimp allows you to store the same email address in multiple audiences while on Eloqua it doesn’t work that way. In Eloqua, an Email Address is a unique identifier for each contact. And you create segments based on your user data and to which brand (Email Group) they are subscribed.

Oracle Eloqua – Marketing Automation Review | Part 1

July 21, 2022December 14, 2022 nikkipunjabi Leave a comment

As a result of this blog post, you will gain a better understanding of how Oracle Eloqua works as well as what some of its advantages and disadvantages are.

Having worked on Eloqua for over 4 years now, I hope my experience with the tool will help you better understand it. Moreover, I am an Oracle Eloqua CX Marketing 2020 Certified Implementation Specialist.

I would like to clarify that Oracle Eloqua is a Marketing Automation tool and not a CRM. Often, people claim Oracle Eloqua is a CRM tool, but it is not.

Around 25+ of my colleagues are responsible for creating and writing emails directly on Eloqua, which I think is a very good point. Our team is responsible for segmenting, grouping, and sending B2B/B2C emails to the right people. Email communication is handled entirely through Eloqua, including transactional and marketing emails. Day-to-day, we do a lot of stuff using Eloqua, including a lot of automation and reporting. In the upcoming blog post, I will describe it in more detail. Some features on Eloqua are extra cost features, so we do not use them.