Joined the community
04-04-2019
2:22:03 PM
Offline
Customize the badges you want to showcase on your profile
Re: Adobe Analytics raw data feed in Snowflake
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
730
0
0
Likes
Total Posts
Correct reply
Thank you @khursid_Alam , Can you please let me know is the data in raw
data feed same as Adobe DWH .
Views
Likes
Replies
Adobe Analytics raw data feed in Snowflake
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
758
0
4
Likes
Total Posts
Correct reply
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
Likes
Replies
Re: Device Type Column in Adobe Analytics Clickstream Feed?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
2.8K
0
0
Likes
Total Posts
Correct reply
Hi GigazelleIn 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
Likes
Replies
Does ECID/MID/VisitorId change every time user deletes cookies ?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Experience Cloud
2.2K
1
1
Likes
Total Posts
Correct reply
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
Like
Replies
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
2.9K
1
0
Likes
Total Posts
Correct reply
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
Like
Replies
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
2.9K
1
0
Likes
Total Posts
Correct reply
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
Like
Replies
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
2.8K
0
0
Likes
Total Posts
Correct reply
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
Likes
Replies
Re: Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
2.8K
0
0
Likes
Total Posts
Correct reply
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
Likes
Replies
Why do we have the same visitor id for multiple sessions (web-traffic from different countries)?
Shaista_L
Level 2
5 likes
9 posts
1 solution
Top badges earned
View profile
Shaista_L
- Adobe Analytics
9.0K
2
13
Likes
Total Posts
Correct reply
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
Likes
Replies
Community
Resources
Adobe account
Change language
Copyright © 2021 Adobe. All rights reserved.
