Document toolboxDocument toolbox

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 NameDescriptionSource FieldSample Value
idIdentifier field from Opiumid2726562948
Session_IdIdentifier of a unique Opium sessionsessionid0033BFCA0B72FCC750381A272D287367
First_NameFirst Name from Opium (may not actually match Advantage)firstNameJohn
Last_NameLast Name from Opium (may not actually match Advantage)lastNameDoe
Email_AddressEmail addressemailtest@example.com
Customer_NumberAdvantage identifier of this customercustomerNumber000012345678
pageRequestedpageRequested field from OpiumpageRequestedPromotionPage
PromotionPromo Code associated with the Opium efforturlNicknameWEXPS100
Effort_NameOpium effort namepromoCodeWebsite - How To Move Out of the US
DomainDomain that the Opium page was served oneffortNamereports.agorafinancial.com
Time_LoggedTime of the Opium eventtimeLogged2021-02-19 06:49:04 -05:00
Processing_ResultProcessing result from OpiumprocessingResultSUCCESS
Session_StatusSession status from OpiumsessionStatus

SESSION CREATED

Bill_to_CityCustomer's city from Opium (may not actually match Advantage)billToCityBaltimore
ItemItem associated with the Opium effort, concatenated with its descriptionitemNumberILV - International Living
Promotion_ChoiceChoice Code associated with the Opium effortchoiceCode$279WH
AmountAmount from the Opium effortamountCharged279
Owning_OrganizationOrganization that owns the itemowningOrganization120
Contact_IDEmail service provider contact IDcontactId123456
Mailing_IDEmail service provider mailing IDmailingId123456
Order_NumberOpium identifier of an orderorderId25545795
orderAbandonLegacy orderAbandon fieldorderAbandonTRUE
orderPageAbandonedLegacy orderPageAbandoned fieldorderPageAbandonedFALSE
minimumPageInteractionTimeMinimum interaction time from OpiumminimumPageInteractionTime

0

ipAddressIP Address of the user in the Opium sessionipAddress192.168.1.1
eSystemIdEmail service provider system IDeSystemId5
User_AgentUser Agent from the browser sessionuserAgentMozilla/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
refererReferring URL from the browser sessionrefererhttps://secure.realestatetrendalert.com/OH599_ILP//index.htm?pageNumber=2
AffiliateGroup who owns the Opium effort<n/a>International Living
URL_NicknameURL Nickname given to the Opium efforturlNicknameMoveOutOfTheUS_WEB


OPIUM Data

OPIUM determines order form abandons by tracking the user's action on the order form:

  1. User navigates to the OPIUM order form and enters his/her email.
  2. OPIUM determines whether the user has made it to the confirmation page.
  3. If the user does not make it to the conformation page, OPIUM waits 30 minutes for the user's session to expire.
  4. OPIUM then write a row to the OPIUM audit table.
  5. 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.