Opium (bi_opium)
Overview: These are events seen by our Opium marketing system. You can tell what promotions and order forms were visited by the user and when they visited. The most common use case for this data is to create abandons audiences in Lytics.
Frequency: Hourly
Data Source: Opium Audit table
Delivery Method: SFTP to csv import work
Filename: Opium_Audit_<Lytics Group>_<Date>_<ModelName>_<DateTime>.csv
LQL Advice: You can capture Opium abandons by creating user fields centered around the referer field. The string "pageNumber=2" in that field typically indicates a visit to an order form page. "pageNumber=5" typically indicates a visit to a confirmation page after an order. If you create fields that capture the last time each of those events took place, you can create a Lytics audience where the order form was recently visited, but the confirmation page was not, essentially an order abandon.
Field Name | Description | Source Field | Sample Value |
---|---|---|---|
id | Identifier field from Opium | id | 2726562948 |
Session_Id | Identifier of a unique Opium session | sessionid | 0033BFCA0B72FCC750381A272D287367 |
First_Name | First Name from Opium (may not actually match Advantage) | firstName | John |
Last_Name | Last Name from Opium (may not actually match Advantage) | lastName | Doe |
Email_Address | Email address | test@example.com | |
Customer_Number | Advantage identifier of this customer | customerNumber | 000012345678 |
pageRequested | pageRequested field from Opium | pageRequested | PromotionPage |
Promotion | Promo Code associated with the Opium effort | urlNickname | WEXPS100 |
Effort_Name | Opium effort name | promoCode | Website - How To Move Out of the US |
Domain | Domain that the Opium page was served on | effortName | reports.agorafinancial.com |
Time_Logged | Time of the Opium event | timeLogged | 2021-02-19 06:49:04 -05:00 |
Processing_Result | Processing result from Opium | processingResult | SUCCESS |
Session_Status | Session status from Opium | sessionStatus | SESSION CREATED |
Bill_to_City | Customer's city from Opium (may not actually match Advantage) | billToCity | Baltimore |
Item | Item associated with the Opium effort, concatenated with its description | itemNumber | ILV - International Living |
Promotion_Choice | Choice Code associated with the Opium effort | choiceCode | $279WH |
Amount | Amount from the Opium effort | amountCharged | 279 |
Owning_Organization | Organization that owns the item | owningOrganization | 120 |
Contact_ID | Email service provider contact ID | contactId | 123456 |
Mailing_ID | Email service provider mailing ID | mailingId | 123456 |
Order_Number | Opium identifier of an order | orderId | 25545795 |
orderAbandon | Legacy orderAbandon field | orderAbandon | TRUE |
orderPageAbandoned | Legacy orderPageAbandoned field | orderPageAbandoned | FALSE |
minimumPageInteractionTime | Minimum interaction time from Opium | minimumPageInteractionTime | 0 |
ipAddress | IP Address of the user in the Opium session | ipAddress | 192.168.1.1 |
eSystemId | Email service provider system ID | eSystemId | 5 |
User_Agent | User Agent from the browser session | userAgent | Mozilla/5.0 (Linux; Android 4.4.4; XT1030 Build/SU6-7.7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.132 Mobile Safari/537.36 |
referer | Referring URL from the browser session | referer | https://secure.realestatetrendalert.com/OH599_ILP//index.htm?pageNumber=2 |
Affiliate | Group who owns the Opium effort | <n/a> | International Living |
URL_Nickname | URL Nickname given to the Opium effort | urlNickname | MoveOutOfTheUS_WEB |
OPIUM Data
OPIUM determines order form abandons by tracking the user's action on the order form:
- User navigates to the OPIUM order form and enters his/her email.
- OPIUM determines whether the user has made it to the confirmation page.
- If the user does not make it to the conformation page, OPIUM waits 30 minutes for the user's session to expire.
- OPIUM then write a row to the OPIUM audit table.
- OPIUM collects First name, last name, email, and pricing option from the order page.
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'html-macro' is unknown.