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