since ‎01-03-2017
‎10-12-2019
thomash82948276
Level 2
Selecting the first of several customer references
Avatar

thomash82948276

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

Views

800

Likes

0

Replies

1
Re: Filtering on Event Date
Avatar

thomash82948276

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

Views

1.2K

Likes

0

Replies

0
Filtering on Event Date
Avatar

thomash82948276

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

Views

1.6K

Like

1

Replies

3
Do bounces from a Message Center email get flagged in the Recipient table?
Avatar

thomash82948276

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

Views

1.0K

Like

1

Replies

1
Re: IF statement to handle no firstName in Recipient table
Avatar

thomash82948276

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

Views

1.6K

Likes

0

Replies

0
Re: IF statement to handle no firstName in Recipient table
Avatar

thomash82948276

thomash82948276
- Adobe Campaign Classic
Thank you, is there an equivalent of this in Adobe Campaign Classic?

Views

1.7K

Likes

0

Replies

0
IF statement to handle no firstName in Recipient table
Avatar

thomash82948276

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

Views

3.2K

Likes

0

Replies

4
Re: Which schema should I query?
Avatar

thomash82948276

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?

Views

1.3K

Like

1

Replies

0
Re: Which schema should I query?
Avatar

thomash82948276

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.

Views

1.3K

Likes

0

Replies

0
Re: Which schema should I query?
Avatar

thomash82948276

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

Views

1.3K

Likes

0

Replies

0
Which schema should I query?
Avatar

thomash82948276

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?

Views

4.1K

Likes

2

Replies

7
Connecting Archived Event Tracking Logs and the Recipient schema
Avatar

thomash82948276

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

Views

1.2K

Like

1

Replies

1
Neatest way to ensure a Recipient isn't in more than one Campaign Workflow at the same time
Avatar

thomash82948276

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

Views

1.5K

Likes

0

Replies

1
Limiting the number of email sends per hour
Avatar

thomash82948276

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

Views

1.3K

Likes

0

Replies

1
Google Analytics tracking not working in Marketing emails
Avatar

thomash82948276

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

Views

770

Likes

0

Replies

0
Adding a date and campaign drill-down to Report statisticsPerDelivery
Avatar

thomash82948276

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

Views

701

Likes

0

Replies

0
Filtering by date in a bespoke table that has no date
Avatar

thomash82948276

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

Views

961

Likes

0

Replies

1
Which Entity Schema?
Avatar

thomash82948276

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

Views

826

Likes

0

Replies

1
Re: Web Application not loading - getting error message "Error rc=-57"
Avatar

thomash82948276

thomash82948276
- Adobe Campaign Standard
ACCThanksTom

Views

1.3K

Likes

0

Replies

0
Web Application not loading - getting error message "Error rc=-57"
Avatar

thomash82948276

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

Views

1.9K

Likes

0

Replies

3
Linking to a Web Application from an Email Delivery
Avatar

thomash82948276

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

Views

1.3K

Like

1

Replies

1
Difference between a Union and an Intersection
Avatar

thomash82948276

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

Views

2.3K

Likes

4

Replies

1
Re: Adobe Campaign Delivery Reporting
Avatar

thomash82948276

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

Views

1.6K

Likes

0

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

thomash82948276

thomash82948276
- Adobe Campaign Standard
Great, thank you. How can I add in sent date to this report? Also, how can I filter by date?

Views

1.6K

Likes

0

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

thomash82948276

thomash82948276
- Adobe Campaign Standard
Thank you Rajesh.Just to confirm, are these possible to build in Campaign? Or only in Adobe Analytics?ThanksTom

Views

1.6K

Likes

0

Replies

0
Adobe Campaign Delivery Reporting
Avatar

thomash82948276

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.

Views

6.5K

Likes

3

Replies

13