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.
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.
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
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.
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.
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...
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
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
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...