/elquent

Eloqua automation utilities

Primary LanguagePythonMIT LicenseMIT

ELQuent

Combines multiple utilities automating tasks around Oracle's Eloqua Marketing Automation tool


Main modules

Clean your links

  • RegEx helper
  • Quick deletion of Eloqua Tracking from links
  • Quick swapping of UTM Tracking Scripts in links
  • Allows to update or create e-mail with new code via ELQuent.api module

Constructs your email packages

  • RegEx & API builder
  • Automatically uploads images and adds image links, tracking scripts and pre-header to package
  • Works with both HTML and MJML files
  • Outputs HTML, MJML, updates e-mail or creates new one directly in Eloqua
  • Uses PURL to ensure field merges on linked sites will be working
  • Adds elqTrack=true to all viable link (PURL excluded)
  • Swaps CDN URLs to SSL on the fly
  • Special campaign sub-flow for externally generated mails
  • Renewal offer dynamic content adder

Create landing page

  • RegEx work automator
  • Allows user to automatically swap Eloqua Form in Landing Page
  • Allows to use built-in landing page templates for quick deployment
  • Adds lead by phone mechanism with conditional validation
  • Cleans code, appends snippets, changes form code

Builds Eloqua Campaigns

  • Built-in wizard creating campaigns from scratch (FORM, LP, EML, Campaign)
  • Simple Email Campaign without canvas for newsletters and one-offs
  • Specific flows for autogenerated content
  • Basic campaign canvas for mail+reminder flows
  • Content campaign canvas for e-book/webinar/code flows

ToDo:

  • Randomized subject & pre-header generator for technical e-mail
  • When not recognized product name, try to find best matches from a list

Add viewers to Eloqua

  • ClickMeeting API connector app
  • Automatically gets all needed data via API and restructures it
  • Uploads contacts to Eloqua (shared list)
  • Uploads webinar attendance as Eloqua External Activity

Create Eloqua-compliant contact upload file

  • Gets input from user
  • Allows appending, trimming and intersecting e-mail uploads
  • Outputs .csv file with correct structure and naming convention
  • Uploads contacts to Eloqua shared list via ELQuent.api module
  • Cleans data import dependency after succesful upload

Module focused on exporting data from Eloqua instance

  • Gets all types of eloqua activity data for chosen timeframe
  • Gets predefined campaign data from chosen timeframe
  • Saves exported data to .json/.csv files

Module focused on reporting from Eloqua instance

  • Creates table with links to detailed reports for each of the queried e-mails

Module focused on validating assets & campaigns

  • Exports active multistep campaigns with member count, start and end dates
  • Validates whether Voucher Code App is working correctly on listed campaigns
  • Basic campaign validation (fields, assets, steps) » Work in Progress

Module for modification of multiple assets

  • Adds redirect script to completed campaigns landing pages and saves list in shared content

Module focused on creating certificates for Eloqua campaigns

  • From template.pdf and database.csv creates personalized certificates for every customer
  • Automatically uploads them to Eloqua and gets tracked links for .pdf files
  • Builds contact upload .csv with certificate link for field merging in communication

Specialized utils for core admins made on demand

  • Creates forms and shared lists for e-mail group control based on country splitted json file
  • Creates program canvas and automatically adds above assets to program steps
  • Creates report on subscription related processings steps within eloqua forms
  • Creates report on asset dependencies

Helper modules

Helper module for Eloqua API

  • Authenticates user
  • Uploads contact database to Eloqua shared lists
  • Uploads external activities
  • Cleans import definition after successful upload to clean dependecies
  • Checks if LP, Form, Mail already exists on Eloqua instance
  • Uploads landing page to specified folder
  • Gets all necessary data to upload an e-mail
  • Uploads e-mail to json specified folder
  • Updates e-mail with new code
  • Adds Eloqua tracking to e-mail links
  • Uploads form to json specified folder
  • Updates form with html, css and processing steps
  • Gets form fields and form fills data
  • Creates campaign and program canvas
  • Creates shared filters
  • Uploads and updates images
  • Uploads and updates files in file storage
  • Creates export definition for activity API and downloads data from it
  • Refreshes and download segment counts
  • Gets campaign data
  • Gets user data
  • Gets dynamic content
  • Gets and updates shared content
  • Gets and creates field merges
  • Gets data model fields
  • Gets email groups
  • Gets asset dependencies
  • Gets canvas step contacts

Helper module for Eloqua conventions

  • Gets valid campaign name from user (according to predefined naming convention)
  • Gets converting asset name for the campaign
  • Gets link to the asset
  • Gets promoted product name either from campaign name (via naming convention) or from user
  • Gets optional header text
  • Gets users via api module
  • Changes date format from US to EU and the other way round
  • Converts epoch to readable date format
  • Convert readable date format to epoch
  • Gets date from user and return epoch

Copyright (c) 2020 Mateusz Dąbrowski MIT License

[Version: 1.14.4]