If I understand this correctly you have the following: evarX =
j43049vj390d90d03jjevarX(classification) = 10% discountetc If this is
the case then assuming you have a database somewhere that has all the
codes and classification values stored then you can setup an automated
FTP upload to Adobe that updates daily from your sql setup.
https://marketing.adobe.com/resources/help/en_US/reference/t_upload_a_saint_data_file_via_ftp.html
It's important to note that every row in the file counts as a hit, ...
There may be better ways to do this but my approach would be to get a
FIXED registration date (using Unix Timestamp) added to your data layer,
which is available on all visits post registration, such as:
registrationTime = 1593172370551 You could set this in Launch, but
personally I would use the data layer for reliability. Then when a
customer makes a purchase, create a "date difference" value in Launch
between (Date.now() - registrationTime), which you can convert to Hours
/ Days / Weeks etc a...
Hi there, Firstly you need to be careful if you capturing this
information because of GDPR. It's worth checking your legal team is
happy but providing they are, I would actually go with the simple
solution of using javascript datediff and a getdate(), so no updating is
required.
https://www.w3resource.com/javascript-exercises/javascript-date-exercise-8.php
Thanks Dave
Hi All, I am a long time user of Analytics, however I have never used
the API (1.4 or 2.0) before now. Keeping it extremely simply, I am
looking to build an Intranet page that shows me the number of visitors
we have had this week, so that non Adobe users can see some metrics
without logging in. So far I have found a few things on github for using
API 1.4 which is now out of date
(https://www.youtube.com/watch?v=xjnRZdlocgA) and how to extract an API
2.0 request with the swagger ui. Whilst I am s...
Hi there, that video shows it working exactly how I would expect it to
work, however as you can see from my screenshot, my work space is not
totally 100% per row.
Hi there, I think I must be missing something but how does "Calculate
percentages by row" work? In the table below the logic seems fine for
columns (total percentage = 300): However when you switch this to Rows I
am shown: Which does not total 300% but rather 126.6%.ThanksDave
Hi There,Please can anyone advise if the fields in Advertising Analytics
are optional? Our PPC team have informed me that they are unable to
supply the keyword. Thanks Dave
At the moment we can analyze the users in our data lake using the feeds
if needed, so A count will do. We assign an evar for the purchaseID an
evar so i will give that a try. Thanks
Hi All, I am trying to work out if it is possible to build a segment in
work space to return the where a product Y was sold for more than EUR 0.
Every single order on our site contains two or more products, the first
(Product X - which should be noted is in a different category) is always
chargeable, the second (Product Y) is chargeable around 50% of the time.
Annoyingly if I build a hit level segment that contains Product Y exists
and Revenue > 0, all orders are returned because on that same hi...
Hi there, I am going to assume it's no but I thought I would check will
others here first. We have a some evars that have saint classifications
for them, so for example evar1 might be "LAX" and there is a
classification which changes this to "Los Angeles International
Airport". Historically these uploads have been done manually and are a
huge pain, however recently this data has been made available to us in
the data layer. I am aware that I could change the structure of the data
from "LAX" to "L...
Forgot to mention - I am keeping a close eye on this. At the moment our
main defence to legal was that there are no large eCommerce companies
doing it and that will should follow their lead for the moment.
Hi Dinesh,My first thought would be deduplication.If I arrive and on hit
1 you do not know my ID but you do on hit 2 then I will be both
unspecified and have a user id.ThanksDave
Hi there,As hyderziaee says, it is because if a visitor visits your
site but does not visit any of the pages in your segment they will be in
the total of the first table but not the second.If you apply your
segment to the entire free form table (near the top left of the table)
you will see the same result for both.
Hi there,This is because of duplication. If you visitor arrives on Paid
Search, then leaves the site and looks for a discount code, returning
shortly after via an affiliate site they will have only had 1 visit,
however their visit will have had 2 marketing channels.I suspect if you
look at the visits metrics against the day/week in question it will show
648k.ThanksDave
Hi there,We use a mixture of Browser Type, Domain and IP (which we use a
prop to capture). We then have a Virtual report suite that has a segment
that excludes that traffic. Works quite well.ThanksDaveWe have also
created the following metric to help identify "bot traffic":
Hi There,We currently have 1 report suite and are building virtual
report suites from it.However what we would love to be able to do is
something like the following:MAIN RSID (Level 0)<-- This contains all
traffic, bots, internal IP traffic etcVIRTUAL REPORT SUITE (Level
1)<----This would be a clean report suite linking to data below with
bots/internal traffic removed. This is currently possibleLIMITED VIEW
VIRTUAL REPORT SUITE (Level 2)<----This would be a limited view of data
which uses the Le...
Hi there,Not sure if this helps, but hopefully it will. We have virtual
report suites to filter our data.In here if there is a domain (such as
Amazon AWS) which is sending bots to our site, we add a segment to
remove the domain here. I have recently discovered it is not perfect,
however it's a great start for automated.Hopefully that helps.
Hi All,This problem has continued on for us, however we have finally
managed to get a really good workaround for it!Firstly we are using
Tealium and as such, can do it out of the box (powered by Open Exchange
Rates ) however, the same can be done with launch using an API pull.When
an order is placed (and only when an order is placed), we fire several
events that uses the current exchange rate:For exampleEUR to GBP (E301)
= 0.9EUR to USD (E302) = 1.11As we only need the 7 European currencies
and ...
Done!Pretty sure the exact feature you want to replicate is "Show Value
As - % of column total" in excel pivot
table.https://www.pryor.com/blog/how-to-show-percentage-of-total-in-an-excel-pivottable/
Dave
Hi,I raised this idea last month (Timestamp as an Evar Type ).I wish
there was a way of merging these ideas as I suspect the desire for this
feature in the travel industry, is stronger than Adobe may imagine.As
you suggest, classifications is one one of doing it (it's how we do it,
using regex), but you can't select greater than or less than.ThanksDave
Hi Gigazelle,I have always found the flows and segments very
confusing.I would expect what Adobe are proposing to be the logical way
that a flow should work.Hopefully we will see it soon.ThanksDave
Hi Robert,It is that it is showing 12,758 visitors your site on the 14th
Jan. Of those 12,758 people, 697 returned on the 15th Jan.Of the 12,758
people, 349 returned on the 16th Jan.You can also right-click on the
cell and "create segment from cell". This allows you to see the exact
logic that Adobe are using.ThanksDave
