Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Matching Users across Platforms

Hi Community and PowerBi Masters,   I am currently working on an analysis for which I try to understand the consumer behavior in detail.  The corresponding data that I have is (name of table: All_...
lbendlin's avatar
lbendlin
Super User
4 years ago

how are you planning to identify the users if you don't have anything but your eyeballs to match them?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello, 

     

    sorry for being unclear: I wanted to match them with their phone numbers. 

    Assuming that they kept their numbers constant across platforms.

     

    Thanks

    Jannnn04

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      that's a bold assumption 🙂

      Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) .

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Here the data

         

        Order NumberOrder TimeUser NameBGR_ALL.Product NameBGR_ALL.CategoryValuePlatformPhone Number
        1111101.01.2021OscaaarrriphonePhones155Facebook1925526
        2222202.01.2021LunalenovoLaptops111Amazon1164070
        3333303.01.2021EmilappleTablets69Google1618350
        4444404.01.2021Lisa-MariaandroidPhones53Instagram1702213
        5555505.01.2021LisamacbookLaptops90Ebay1571808
        6666606.01.2021JansamsungTablets102Alibaba1701882
        7777707.01.2021markusiphonePhones48Saturn1213889
        8888808.01.2021RosalenovoLaptops16Facebook1892353
        9999909.01.2021YO_OscarappleTablets168Amazon1925526
        11111002.03.2021JoseandroidPhones161Google1164070
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        12222103.03.2021EmilmacbookLaptops112Saturn1618350
        12222103.03.2021EmilmacbookLaptops112Facebook1618350
        12222103.03.2021EmilmacbookLaptops112Amazon1618350
        12222103.03.2021EmilmacbookLaptops112Google1618350
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        12222103.03.2021EmilmacbookLaptops112Instagram1618350
        13333204.03.2021Lisa-MariasamsungTablets192Ebay1702213
        14444305.03.2021LisaiphonePhones110Alibaba1571808
        15555406.03.2021FeblenovoLaptops175Saturn1492420
        16666507.03.2021MarkusappleTablets125Facebook1213889
        17777608.03.2021RosaandroidPhones175Amazon1892353
        18888709.03.2021Oscar32macbookLaptops100Google1925526