since ‎02-03-2020
‎29-08-2020
wpomeroy
Level 1
Help -- Temporary Work Table Limit by Percent of Total wpomeroy - Adobe Campaign Classic
I have a workflow that is grouped by a numeric indicator (Sponsor External ID) and zip code. I then count the customers by zip code and display in relation to the total customers associated with the indicator. My next step, which is tripping me up, is that i'm trying to sort descending by count of customers (count of CONTACT_ID) and then calculate a rolling percentage so that any zip codes that fall after 85% of the total are removed (i.e. i'm trying to capture the zip codes that have the most c...
98
Views
0
Likes
3
Answers and Comments
Re: Campaign Report using Offer Schema - Help wpomeroy - Adobe Campaign Classic
This worked, thank you! I also had to change the offer start date field (non local variable) to DateOnly so that it the time stamps would match. This allowed me to say vars/startDate = @startDate
136
Views
0
Likes
0
Comments
Campaign Report using Offer Schema - Help wpomeroy - Adobe Campaign Classic
I am trying to build a report that shows information from our offer schema (label, start date, end date, HTML Rendering, etc.) based on use input of offer name and date. I.e. user enters the offer name or start and end date and they are able to see the offer information. I am defining local variables and then using the query to filter by the defined variables. Searching by offer label works fine but start or end date throws the following error. ORA-210000 Oracle error: ORA-00932: inconsistent da...
153
Views
0
Likes
2
Answers and Comments
Re: How to filter a web form static element using a form... wpomeroy - Adobe Campaign Classic
Thank you for the response. I had already defined the variables and have fields in the page writing to the variables. I am struggling with the JS piece within the page to then define the table based on the form response. Is there a place within the list to call the variable or are you suggesting updating the JS on the code tab of the Web App?if( (ctx.vars.OfferLabel == undefined || NL.String.trim(ctx.vars.OfferLabel.toString()).length == 0) ){// The context is empty for this non hidden input => ...
3163
Views
0
Likes
0
Comments
How to filter a web form static element using a form variable wpomeroy - Adobe Campaign Classic
I am trying to allow a user to define a local variable in a web form and then pass that variable (offer label, start date, end date) into a table (list with group) in order to filter the table by the variable. It seems like this should exist in the UI but i can't find a way to align the table fields with the variables. Does anyone know a way to accomplish this either in the web form interface or via JS?
4014
Views
0
Likes
3
Answers and Comments
HELP - Understanding Delivery Indicators wpomeroy - Adobe Campaign Classic
I'm hoping someone can help me understand how delivery indicators are calculated. When i look at the estimation of the number of recipients who have opened the emails ([indicators/@estimatedRecipientOpen]) i see a number that is different my individual count when i sum the individual recipients who have opened the email. I'm not sure if this is due to recipients opened the email on multiple days or on multiple devices but i'm trying to figure out the exact criteria that defines a unique open and...
2426
Views
0
Likes
1
Answers and Comments
Help - Adding a calendar invite to an email delivery wpomeroy - Adobe Campaign Classic
Has anyone added a calendar invite fora meeting or as an appointment reminder to an email campaign delivery? I haven't seen this done am not sure if there is an easy / standard way to accomplish this with HTML / JS. Any help would be much appreciated.
2087
Views
0
Likes
2
Answers and Comments
Likes given to