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

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

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

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

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!<% } %>

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?

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

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?

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.

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

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?

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

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

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

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

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

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

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

Re: Web Application not loading - getting error message "Error rc=-57" thomash82948276 - Adobe Campaign Standard

ACCThanksTom

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

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

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

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

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?

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

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.

Likes given to

User

Count

Likes from

User

Count

Guidelines

Cookie preferences