LGE Tableau

Tables (15)

EDL_ACC_CUSTOMER (Untitled8)

  • locale_code__c
  • customer_no__c
  • email_addr__c
  • creation_date__c

EDL_CST_MODEL_M (Untitled15)

  • cs_matched_model_code__c — Primary key
  • cs_category_name__c

EDL_MKT_MODEL_M (Untitled11)

  • model_id (Transaction Id) — Primary key
  • Date
  • TotalRevenue
  • Country
  • Currency

EDL_SALES_ORDER (Untitled9)

  • entity_id__c — Primary key
  • increment_id__c — Primary key
  • OBSKey__c — Primary key
  • created_at__c
  • customer_id__c
  • grand_total__c
  • locale_code__c
  • CouponCheck__c
  • coupon_rule_name__c

EDL_SALES_ORDER_ITEM (Untitled10)

  • order_id__c — Primary key
  • sku__c — Primary key

GA_DirectSales (Untitled13)

  • Transaction Id — Primary key
  • Date
  • TotalRevenue
  • Country
  • Currency

GA_Sessions (Untitled14)

  • Campaign — Primary key
  • Country — Primary key
  • Date
  • Shopping Stage
  • Source / Medium
  • Sessions

Tableau_Bounce_Log (Untitled7)

  • ContactID — Primary key
  • ContactKey — Primary key
  • JobID — Primary key
  • ActivityID — Primary key
  • Country — Primary key
  • EventDate

Tableau_Click_Detail_Log (Untitled5)

  • ContactKey — Primary key
  • ContactID — Primary key
  • jobID — Primary key
  • ActivityID — Primary key
  • Country — Primary key
  • EventDate
  • uq_yn
  • LinkName
  • LinkContent

Tableau_Contact_Master (Untitled2)

  • ContactKey — Primary key
  • ContactID — Primary key
  • email
  • phone
  • Country

Tableau_Journey_Master (Untitled)

  • ActivityID — Primary key
  • Country — Primary key
  • Campaign_Code — Primary key
  • JourneyID
  • JourneyName
  • ActivityName
  • G_JourneyName
  • G_ActivityName
  • Tag
  • channel

Tableau_Open_Log (Untitled4)

  • ContactKey — Primary key
  • ContactID — Primary key
  • JobID — Primary key
  • ActivityID — Primary key
  • Country — Primary key
  • EventDate
  • uq_yn

Tableau_Send_Log (Untitled3)

  • ContactKey — Primary key
  • ContactID — Primary key
  • JobID — Primary key
  • ActivityID — Primary key
  • Country — Primary key
  • EventDate

Tableau_Unsubscribe_Log (Untitled6)

  • ContactKey — Primary key
  • ContactID — Primary key
  • jobid — Primary key
  • ActivityID — Primary key
  • Country — Primary key
  • EventDate

ecrmPdpEntered (Untitled12)

  • ecrmUserId__c — Primary key
  • eventId (Field)