This is from the Recipient RFM example where all Recipients are pulled
in the initial Query and then we add data linked to the filtering
dimension to compute recency, frequency and monetary.INSERT INTO
SELECT DISTINCT Sum(P0.dAmount), Max(P0.tsDate),
Count(P0.iPurchaseHistoryId), P0.iRecipientId FROM NeoPurchaseHistory P0
JOIN wkf505995918_2_1 W ON (W.iLinksKey1_0=P0.iRecipien...
Your client has asked for a list of Coldplay fans to target in an
upcoming CD release promotion. How would you set up the Query? If in
addition, they want to know how much each fan spent on Coldplay music,
how would you include that information in the results?
Grouping by the targeting dimension is not required here, although it
won't cause an error, because there we aren't aggregating as there is
one value of LTV per Individual; the link to the Purchase Summary table
You will get an error when you configure seed addresses to insert by
"respecting the sort order" and then you don't sort the extraction file.
Thanks Sindhu for reporting it.Here is what the error message looks
Let's meet from 6 - 7 PM EST, 5 - 6 CST, 3 - 4 EST to go over the Data
Management screens to compute aggregates.To join the
meeting:https://my.adobeconnect.com/aduacuat1ko/Please enter as Guest
with your full name (first and last)Audio Conference Details:Conference
Number(s): USA (Toll free): (855) 870-5454 International: (408)
773-6768Conference Code: 848 620 3759All are welcome to join.
In this training you learn two approaches to computing aggregates. In
one case, you change the filtering dimension on the Query and then add
data of the filtering dimension. In another case, you keep the filtering
dimension the same as the targeting dimension and then you add data
linked to the filtering (targeting) dimension. Both of these approaches
work when computing aggregates. How will your results differ based on
the approach that you take?
This very well could be Michele. The screens have a lot of options here
and you have to walk through 3 or 4 or even 5 screens to get to what you
want to do. I will step through the screens and explain them during the
weekly call, but if anyone would like to use Office Hours Thursday they
are available. Thanks for your feedback.
From our weekly vILT session:Glen Leavitt 2: wait activityKaren Haas: if
$ > 0 in last 10 days, suggest new product based on product
categoriesKaren Haas: spendTodd Lukowski: purchase date = getdate()-10
or something like that
Karen Haas: risk of alienation - via marking as spam, or unsubscribeTodd
Lukowski: one point i omitted from on site reply...blasts make it harder
to get a good read on resultsDave Post: ISPs can block you if you bulk
Hi Todd, I will look at this now. For anyone who is working through the
conditional content exercise in the Dynamic Content lesson, I recommend
that you instead watch and work through the DCE demo that comes after it
as you might not be able to complete the conditional content exercise
due to a bug in this build of the server.
You are partly right Jennifer, thanks for answering the question!If you
go to the Help menu on the Tool bar and select About... it will show
both the client console build and the Application server build. The
campaign start and end dates default to today and today + validity
period, but the validity period for the Delivery controls how many days
retry is attempted when deliveries fail with a soft bounce. It is set as
part of the delivery properties.
What you are getting in your work inbox is the validation/confirmation
notice to approve content on the delivery. These are actually Operator
notifications going out to your user email address, which is set to the
email address we used for the pilot registration.
In fact, this is a known bug SD7451 that was fixed in build 8104.The bug
is that editing the HTML content introduces erroneous/extraneous
tags into the content. You can go to the Source tab (at the
bottom of the delivery editor) and remove them, however if you have
already confirmed the delivery, you cannot change its content. At that
point the delivery will fail each retry until it reaches the end of the
validity period. So don't confirm if your preview is failing, unless the
tags got inserted...
Jane Marketer wants to run a cross-sell campaign. In this campaign, 10
days following a purchase, the buyer gets an email delivery suggesting
another product category based on the initial product purchased. So for
example, if the customer bought jewelry, the follow-on email would
suggest a handbag purchase. Using techniques you have already learned in
the training, how might you set up this campaign workflow? Discuss
specific Activities and how they would be configured.
Great, meet me on our weekly connect room and conference call number and
we will work through this example. Anyone else who wants to join, feel
free. This will be at 6 PM Eastern, 3 PM Pacific, if I am understanding
my time zones correctly...
Hi Todd, in fact it looks like your proof is not going out at all. That
is because we have a "student only" Typology rule that removes from the
target any Recipient who is not in one of the student e-mail domains:
adobe.com, precisiondialog.com, etc.. Can you forward me the email that
you got in your work Inbox? Linda
By the way, as Administrators (Operators with administration privileges)
you all have unrestricted access to others' campaigns. Marketing
business users would not typically have this level of access. Click on
the image int he previous to see a much clearer version.