<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Alerts - Orders above a certain discount % in Adobe Analytics Discussions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256289#M1017</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks for the idea &lt;IMG src="https://experienceleaguecommunities.adobe.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I tried 1) to 3) previously but not yet 4).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;==&amp;gt; I just did it and created a "column sum discount exceeds revenue" calculated metric, then created an hourly alert on it to be sent everytime there is a 1% change on it. So far it estimates the alert should have triggered last Wednesday but I do not see any order ID qualifying to trigger it on that date. I'm not sure it is working but i'll let the alert on a few days to analyze the results&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So, to be continued... &lt;BR /&gt;And thanks again for your help &lt;IMG src="https://experienceleaguecommunities.adobe.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 23 May 2018 07:43:25 GMT</pubDate>
    <dc:creator>sfabri</dc:creator>
    <dc:date>2018-05-23T07:43:25Z</dc:date>
    <item>
      <title>Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256283#M1011</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Everyone,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I'm trying to build the following alert but I'm falling short, maybe I'm not seeing a simple solution in front of my eyes. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Tigger an &lt;SPAN style="text-decoration: underline;"&gt;hourly&lt;/SPAN&gt; alert when :&lt;/P&gt;&lt;P&gt;Total discount on an order &amp;gt;= (revenue * 110%)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;BR /&gt;E.g. : &lt;BR /&gt;If an order has 200€ worth of merchandise, where 140€ is revenue and 60€is total discount ==&amp;gt; Do not trigger.&lt;BR /&gt;If an order has 200€ worth of merchandise, where 85€ is revenue and 115€is total discount ==&amp;gt; Do trigger.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thus each hour an order like the last one is made, an alert should be sent.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;NB : The total discount dimension and revenue dimension are "real dimensions", not calculated ones.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Is it possible to do with the current alert system? &lt;BR /&gt;I tried to implement a workaround similar to this one : &lt;A href="https://forums.adobe.com/thread/2415069"&gt;Adobe Analytics Alerts&lt;/A&gt;&amp;nbsp; or &lt;A href="https://forums.adobe.com/message/10371116"&gt;Creating Hourly Alert when Revenue = 0&lt;/A&gt;&amp;nbsp; from &lt;A href="https://experienceleaguecommunities.adobe.com/people/urs.boller"&gt;urs.boller&lt;/A&gt; but with no success yet.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks !&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 12:28:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256283#M1011</guid>
      <dc:creator>sfabri</dc:creator>
      <dc:date>2018-05-22T12:28:46Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256284#M1012</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;do you have the revenue and the discount only as dimensions? if yes, i think its not possible to get an alert&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;best would be to have a counter event for „discount percentage“ (calculate discount/revenue), but this needs implementation in the DTM/Launch...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 12:45:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256284#M1012</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-05-22T12:45:58Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256285#M1013</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks, Yes they are dimensions&lt;/P&gt;&lt;BLOCKQUOTE&gt;&lt;/BLOCKQUOTE&gt;&lt;P&gt;&lt;BR /&gt;Is there any way yo do it without dtm in your opinion?&lt;BR /&gt;(we do have DTM and everything setup for this ReportSuite, but if there is a workaround not to use it I would prefer that)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 13:00:59 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256285#M1013</guid>
      <dc:creator>sfabri</dc:creator>
      <dc:date>2018-05-22T13:00:59Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256286#M1014</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;do you have both values in the same eVar/Prop? if yes, you could do a manual classification... don‘t see any other way ...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 13:40:53 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256286#M1014</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-05-22T13:40:53Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256287#M1015</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We are talking metrics here (revenue &amp;amp; discount) not dimensions I think, they are in seperate events&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 14:05:39 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256287#M1015</guid>
      <dc:creator>sfabri</dc:creator>
      <dc:date>2018-05-22T14:05:39Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256288#M1016</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;just an idea, don‘t know if it works (because i can‘t test it)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1) create a table with metrics „revenue“ and „discount“, broken down by dimension „order ID“&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2) create a new calculated metric „discount %“ with formula {„discount“ / „revenue“ * 100}&lt;/P&gt;&lt;P&gt;and add it to the table. it should show the discount percentage for each order ...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;3) create a new calculated metric „discount exceeds revenue“ with formula&lt;/P&gt;&lt;P&gt;{ if (“discount %“ greater than “100“) then “1“ else „0“}&lt;/P&gt;&lt;P&gt;and add it to the table. it should show a „1“ for each order where „discount“ is greater than revenue&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;4) create a new calculated meteic where you sum up the values of the last added column. formula is like&lt;/P&gt;&lt;P&gt;{column sum „discount exceeds revenue“}&lt;/P&gt;&lt;P&gt;and add it to the table. in every field it will show you the total of orders where the discount exceeded the revenue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i don‘t know if you can create an alert out of this last metric...&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;but now you can add other calculations, eg. divide the last calc. metric by the total of orders (approx distinct count „orders“) to get a percentage value.&lt;/P&gt;&lt;P&gt;by using „number visualization„ and hiding the table you have at least a cool number for a dashboard&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;perfectdashboard.rocks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 22 May 2018 22:09:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256288#M1016</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-05-22T22:09:10Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256289#M1017</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks for the idea &lt;IMG src="https://experienceleaguecommunities.adobe.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I tried 1) to 3) previously but not yet 4).&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;==&amp;gt; I just did it and created a "column sum discount exceeds revenue" calculated metric, then created an hourly alert on it to be sent everytime there is a 1% change on it. So far it estimates the alert should have triggered last Wednesday but I do not see any order ID qualifying to trigger it on that date. I'm not sure it is working but i'll let the alert on a few days to analyze the results&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So, to be continued... &lt;BR /&gt;And thanks again for your help &lt;IMG src="https://experienceleaguecommunities.adobe.com/legacyfs/online/emoticons/happy.png" /&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 23 May 2018 07:43:25 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256289#M1017</guid>
      <dc:creator>sfabri</dc:creator>
      <dc:date>2018-05-23T07:43:25Z</dc:date>
    </item>
    <item>
      <title>Re: Alerts - Orders above a certain discount %</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256290#M1018</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;great, let me know if it works!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;btw: you can set the alert to „greater than 0“ onstead of a change. maybe this way it will trigger faster ...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 23 May 2018 08:45:17 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-analytics-discussions/alerts-orders-above-a-certain-discount/m-p/256290#M1018</guid>
      <dc:creator>Urs_Boller</dc:creator>
      <dc:date>2018-05-23T08:45:17Z</dc:date>
    </item>
  </channel>
</rss>

