Indexing Marketing Channels in Data Warehouse | Community
Skip to main content
K
KatherineSt3
April 5, 2024
Question

Indexing Marketing Channels in Data Warehouse

  • April 5, 2024
  • 2 replies
  • 682 views
I'm currently doing a weekly pull from Data Warehouse for our Data Engineering team that includes Transaction ID broken out by Marketing Channel interactions with Orders as the metric. They've asked that I add a layer that can give a definitive order to the channels viewed for each order. 
 
I tried adding the Hour dimension to the export to timestamp the channel interactions but the format it delivered in was a time range that I was having trouble deciphering in excel. 
 
Is there another way to index the channels that I'm missing?

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
April 5, 2024

There have been a few questions lately about understanding the format for date/time columns in data warehouse.

The way that format works is: 1YYMMDDHH, but Adobe does it a bit weird. For month, it starts counting at 0, not 1. So January is 0, February = 1.... December = 11.

 

Check out this post for more details (and links to other answers).

Solved: Re: Challenges with Adobe Data Warehouse date form... - Adobe Experience League Community - 663425

 

Once you understand how the format works, it's easy enough to use it to sort.

    Jennifer_Dungan
    Community Advisor and Adobe Champion
    Jennifer_DunganCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    April 5, 2024

    You could also try using Visit Number and Hit Depth?

     

    Visit Number will increment on each visit, and hit depth will increment within the visit... together they should give you an easy to read order?

    Terms & ConditionsAccessibility statement

    Loading footer...