since ‎01-03-2017
‎10-12-2019
thomash82948276
Level 2
Selecting the first of several customer references thomash82948276 - Adobe Campaign Classic
Within my data a customer can have numerous activity IDs assigned to them. They're assigned a new ID for each activity that they complete on our website.Each activity ID has an activity date/time attached to it. How can I add an activity ID as Additional Data within an enrichment that is the first activity ID of any given day?Furthermore, a customer is also given an IdentityIDSo the data would look like this. How would I add only ActivityID 011d to the data within the workflow?IdentityIDActivity...
753
Views
0
Likes
1
Answers and Comments
Re: Filtering on Event Date thomash82948276 - Adobe Campaign Classic
Thanks JonWhen you say "truncate the right hand side so it’s a day", what syntax is needed to do that exactly?Many thanksTom
1090
Views
0
Likes
0
Answers
Filtering on Event Date thomash82948276 - Adobe Campaign Classic
I'm trying to filter on Event Date in the Recipient Delivery Log.My filter says: Include Event Dates that are equal to today.When I do this, I get no records. I have confirmed that there are records with an Event date of today in the table; so I've discounted that as an issue. I'm also using DateOnly as Event date is stored as Date / Time in that table. That hasn't helped either.Is there something I've forgotten here?ThanksTom
1540
Views
1
Like
3
Answers and Comments
Do bounces from a Message Center email get flagged in the Recipient table? thomash82948276 - Adobe Campaign Classic
If an email is sent from Message Center and bounces, does a flag get added to the Recipient (or whichever relevant) table in the Marketing instance to ensure that that recipient isn't contacted again?Or does Message Center not "speak" to the Marketing instance in this way?ThanksTom
959
Views
1
Like
1
Answers and Comments
Re: IF statement to handle no firstName in Recipient table thomash82948276 - Adobe Campaign Classic
So, I've put this into the email, but it's incorrect. It's failing to proof. Can anybody point out where I've gone wrong please?<% if ( recipient.firstName IS NULL ) { %>You're almost there!<% } else { %> <%=recipient.firstName %>, you're almost there!<% } %>
1403
Views
0
Likes
0
Answers
Re: IF statement to handle no firstName in Recipient table thomash82948276 - Adobe Campaign Classic
Thank you, is there an equivalent of this in Adobe Campaign Classic?
1435
Views
0
Likes
0
Answers
IF statement to handle no firstName in Recipient table thomash82948276 - Adobe Campaign Classic
As is pretty standard, I'm including Firstname in our emails:<%= recipient.firstName %>, you're almost there!Could someone let me know how I would add some logic to the above so that in the unlikely event of firstName being blank, the intro line reads only "You're almost there".So something like:IF <%= recipient.firstName = null%> THEN "You're almost there", ELSE, <%= recipient.firstName %>, you're almost there!Just need help with the precise syntax.ThanksTom
2931
Views
0
Likes
4
Answers and Comments
Re: Which schema should I query? thomash82948276 - Adobe Campaign Standard
Thank you, that worked. Sorry for being slow on that one.Can you help me with one more thing please?I went to add an extra filter item, I only want people with an Event date of 3 days ago. The Event date field is date & time though, so when I select "today minus 3 days" nothing is selected. What is the syntax to trim the date & time so that Campaign only looks at the date portion of the field?
1210
Views
1
Like
0
Answers
Re: Which schema should I query? thomash82948276 - Adobe Campaign Standard
I'm using BroadLogRcp and targeting as Recipient yes.I've run the query to output where Primary Key is not empty, and that has confirmed that I have data in this table.Within this result I can see the emails that I'm trying to filter by...However, when I then update the main query to Label contains Buy, I get a result of zero.
1168
Views
0
Likes
0
Answers
Re: Which schema should I query? thomash82948276 - Adobe Campaign Standard
Thank you.I'm trying to get all email addresses who were sent an email with "buy" in the Delivery Label.Here it is in the data. And here is my query.I'm getting no records though. Is it because of the way that Buy is formatted in the Value field or something?Thanks
1167
Views
0
Likes
0
Answers
Which schema should I query? thomash82948276 - Adobe Campaign Standard
I've sent a few deliveries manually using ad hoc data.How do I setup a Campaign Workflow to query these sends to send a follow up email?I've tried to query the Archived Event Tracking Logs for all Labels containing a certain word. That produces a count of zero. I've also tried the Recipient Tracking Logs and Tracking Log.Can someone help with this please?
3921
Views
2
Likes
7
Answers and Comments
Connecting Archived Event Tracking Logs and the Recipient schema thomash82948276 - Adobe Campaign Classic
Which field can be used to connect the Archived Event Tracking Logs and the Recipient schema?I'm trying to create a Campaign Workflow that queries the Tracking Log to include everyone who has ever opened an email. I can't seem to link that back to the Recipient schema to get the email sent though.ThanksTom
1127
Views
1
Like
1
Answers and Comments
Neatest way to ensure a Recipient isn't in more than one Campaign Workflow at the same time thomash82948276 - Adobe Campaign Classic
We're setting up multiple Campaign Workflows currently.Some target Recipients following interaction with our website, some target Recipients who were on our website 6 or 12 months ago.What is the neatest way of ensuring that a Recipient isn't in more than Workflow at any one time?The solution I have in mind is to run the Workflows at different times based on an assigned hierarchy, then exclude anyone who received a previous Workflow Delivery from any subsequent Campaign Workflow that runs.Or is ...
1435
Views
0
Likes
1
Answers and Comments
Limiting the number of email sends per hour thomash82948276 - Adobe Campaign Classic
As the title suggests, how do I limit the number of sends within an email to say, 10,000 emails per hour.In previous tools I've used this was called "Metering", I can't work out what it's called in Adobe Campaign though.ThanksTom
1221
Views
0
Likes
1
Answers and Comments
Google Analytics tracking not working in Marketing emails thomash82948276 - Adobe Campaign Classic
We're applying Google Analytics tracking to our emails using the External Accounts, Web Analytics tool in Campaign. The code we're using is as follows:<%@ include option='NmsTracking_ClickFormula' %><% // Parameters expected by the Web Analytics partnervar pattern = new RegExp("(https://)", 'i');if( $(urlstring).match(pattern) && delivery.FCP == false ){%> &utm_source=auto&utm_medium=Email&utm_campaign=<%= message.delivery.internalName %><% } %>This works for our Message Center emails. In so far...
720
Views
0
Likes
0
Answers and Comments
Adding a date and campaign drill-down to Report statisticsPerDelivery thomash82948276 - Adobe Campaign Standard
The out of the box statisticsPerDelivery Report shows me opens and clicks by email domain for my campaigns.This is useful, but I need to add the ability to view this data by date and by campaign.How do I amend the Report Workflow to add this data into the query and then update the Page component of the Workflow.Obviously I'd be copying the out of the box first, and not amending the original.Many thanksTom
633
Views
0
Likes
0
Answers and Comments
Filtering by date in a bespoke table that has no date thomash82948276 - Adobe Campaign Standard
I'm trying to create a query containing everyone who did a certain action on our website.That data is in its own schema. Unfortunately, there is no date written to that schema as to when this action happened.Is there a system date that I can use (Date Record Added or something) to filter on this value? I only need the query to contain these actions from the last 3 days. Currently the query is taking a long time to load as it's pulling in everyone who did the action.Thanks, Tom
884
Views
0
Likes
1
Answers and Comments
Which Entity Schema? thomash82948276 - Adobe Campaign Standard
I'm trying to create an Export to export the following:- The email addresses of everyone who received an email yesterday- The UIDs of everyone that was sent, opened and clicked an email yesterdayWhich stock Entity Schema should I use to create this export?ThanksTom
756
Views
0
Likes
1
Answers and Comments
Re: Web Application not loading - getting error message "Error rc=-57" thomash82948276 - Adobe Campaign Standard
ACCThanksTom
1171
Views
0
Likes
0
Answers
Web Application not loading - getting error message "Error rc=-57" thomash82948276 - Adobe Campaign Standard
I have a Web Application that is not loading. I'm getting the error message "Error rc=-57".Does anyone know what this is and how it can be fixed?Thanks, Tom
1758
Views
0
Likes
3
Answers and Comments
Linking to a Web Application from an Email Delivery thomash82948276 - Adobe Campaign Classic
How do I put a link for a Web Application into a hyperlink in an Email Delivery?Or, the question could also be, where do I get the URL related to a Web Application so that I can insert this into an Email Delivery?ThanksTom
1268
Views
1
Like
1
Answers and Comments
Difference between a Union and an Intersection thomash82948276 - Adobe Campaign Classic
Can someone let me know the difference between a Union and an Intersection in a Workflow please?How do they differ, and when and why would I use one, but not the other.Many thanks
2158
Views
4
Likes
1
Replies
Re: Adobe Campaign Delivery Reporting thomash82948276 - Adobe Campaign Standard
Hello Rajesh, I've since found out that you can only edit Dimensions in Cube Reports in Adobe Campaign if you're also signed up to Adobe Analytics - which we're not.I need to edit the Dimensions in this pre-loaded Cube in order to get the date to display.Therefore, this doesn't help me unfortunately. I think the User Activities pre-loaded report under Administration > Configuration can give me what I want. There are just two problems with it though:- It only shows day, I need date. Any ideas on ...
1374
Views
0
Likes
0
Answers
Re: Adobe Campaign Delivery Reporting thomash82948276 - Adobe Campaign Standard
Great, thank you. How can I add in sent date to this report? Also, how can I filter by date?
1384
Views
0
Likes
0
Answers
Re: Adobe Campaign Delivery Reporting thomash82948276 - Adobe Campaign Standard
Thank you Rajesh.Just to confirm, are these possible to build in Campaign? Or only in Adobe Analytics?ThanksTom
1381
Views
0
Likes
0
Answers
Adobe Campaign Delivery Reporting thomash82948276 - Adobe Campaign Standard
I'm looking to create a simple daily overview report showing the following:Email nameSentOpen RateClick RateUnsub RateBounce RateNo. Spam ComplaintsPassword Reset1050%10%0%0.1%0Welcome300025%5%0.4%0.8%2Which template do I need to use to generate a report with these dimensions and measures. I can’t find it from the pre-set list.
6282
Views
3
Likes
13
Answers and Comments