since ‎04-04-2019
‎17-10-2020
Shaista_L
Level 2
Re: Adobe Analytics raw data feed in Snowflake
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Thank you @khursid_Alam , Can you please let me know is the data in raw data feed same as Adobe DWH .

Views

76

Likes

0

Replies

0
Adobe Analytics raw data feed in Snowflake
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Hi All, Could you please let me know if Adobe Analytics data is available in snowflake ? Is data sharing an option to access the adobe analytics raw data feed ? In our current process we extract the raw data feed through ftp and load in to the SQL DWH. Since we are migrating to Snowflake, I was wondering if Adobe Analytics raw data feed is available in Snowflake and if Yes, is data sharing possible from Adobe's snowflake account to any other snowflake account. Thanks in advance.

Views

93

Likes

0

Replies

3
Re: Device Type Column in Adobe Analytics Clickstream Feed?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Hi Gigazelle​In the raw data feed the mobile id column is an integer (8 digits Eg: 13548343) or a '0'. Does this means if mobile_id=0 then its a desktop and if mobile_id <> 0 then it could be any mobile device( cellphone,tablet) ?Thank you in advance.

Views

1.4K

Likes

0

Replies

0
Does ECID/MID/VisitorId change every time user deletes cookies ?
Avatar

Shaista_L

Shaista_L
- Adobe Experience Cloud
Hi All,We have recently implemented ECID, The reason for implementation was to uniquely identify customers. Can anyone please answer the below questions.1. Does the value of ECID/MID/Visitor Id which is a long string of numbers (17050896330536188461601914392312074335) changes every time the user deletes cookies ?2. Let's assume it does change, is there a way to identify the user as returning visitor and assign back the same value? We have our own customerId that we assign to an evar , The proble...

Views

1.9K

Like

1

Replies

1
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Based on more research, I got the answer to my own question. I used Adobe analytics debugger and visited the site blocking cookies and that was the answer to my question. When a customer blocks cookies or deletes cookies and visits the site, all of these users /customers get assigned the same Adobe Visitor Id.

Views

1.9K

Like

1

Replies

0
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
I am using the data feed , basically we get a raw file with the data feed for previous day that has all the information , please refer to link below we have most of these columns in the raw file and import in to our own datawarehouse. https://marketing.adobe.com/resources/help/en_US/reference/datafeeds-reference.htmlSo I am basically using this information from the raw data and trying to identify the visitor Id, a while ago when this was implemented, the adobe visitor Id has been set up with eva...

Views

1.9K

Like

1

Replies

0
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Hi ankits28281247​. Thank you for taking time to answer this question. Appreciate all your help.Sorry my mistake I was making up dummy data for example purposes but all the fields for the Adobe visitor Id are basically the same ,for instance = 1f5aacf448ed89563oo555605eccc8d3 . I wasn't part of the setup years ago, but now we are trying to make sense of the existing and future data for our analytic needs. I think the way it is setup is out of box variable is being passed to an evar is my conclus...

Views

1.9K

Likes

0

Replies

0
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
Thank you so much sanmeetwalia, Basically the set up we have for Adobe is using visitor Id NOT the cloud experience id. For better explanation purpose. The post_visid_type we use is '3' . Refer below to the look up for post_visid_type.post_visid_type1=IP&UA fallback (cookies were rejected by browser) 2=Wireless (HTTP Mobile Subscriber Header identified as mobile carrier) 3=Adobe (server generated, stored in s_vi on client) Default method.4=Fallback cookie (new fallback ID, JavaScript generated, ...

Views

1.9K

Likes

0

Replies

0
Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Avatar

Shaista_L

Shaista_L
- Adobe Analytics
The Adobe Visitor Id is not unique if its a combination of post_visid_high and post_visid_low then it should be unique. Can you give me an example explaining the generation of visitor id using combination of post_visid_high and post_visid_low, I see in the data the visitor id is alpha numeric ,Is there a conversion?Also , If a person gets assigned a Adobe Visitor Id and comes back (after few days) to visit the same page/website will he/she be assigned the same Adobe visitor Id (assuming they did...

Views

7.9K

Likes

2

Replies

13