1

I've just set up a SFMC send log and have included a few custom fields. But at first glance the data in the send log isn't that useful to me. How can I create a send log that includes data from the core SFMC data tables. Such as: - emailname_ - emailaddr - _subscriberkey - view_email_url - and send date-time, if possible. I.e. a send log that contains send info that's useful to a marketer! Any suggestions are welcome. The best one I've come across is here: Feed a Send Log / Send History Data Extension automatically Surely the system send log can do this, though?

2
  • Hi you can create custom fields in the data extension. If they match a System name for example CampaignName MessageName etc will automatically populate. If you need different names you will need to use some AmpScript to set the variable names..
    – AndrewC
    Jul 19, 2017 at 5:44
  • Thanks, @AndrewC! I appreciate your answer. I'm more than happy to use default System names. I would prefer it, actually. Where can I find a list of System names for default data points in the SFMC documentation? I've been pulling my hair out trying to find useful info for setting up a send log. I've tried using some personalisation strings from the System Data Tables: help.marketingcloud.com/en/documentation/exacttarget/content/… ... although I'm starting to come around to the idea of setting AMPscript variables in every email.
    – Grant Ryan
    Jul 19, 2017 at 23:52

1 Answer 1

3

You can add additional fields using the name Marketing Cloud uses for these values, so they are populated automatically. For the send date you can add a Date column and set a default value of GETDATE() for example. AMPscript variables can also be logged to a column that is named like variable is, so @YourVar would be logged to the column YourVar. Make sure you set these additional columns to be nullable, so there is no error if the value isn't available.

Here are some example column definitions:

  • EmailAddress (Type: EmailAddress, Nullable: True)
  • SubscriberKey (Type: Set type to fit your key, Nullable: True)
  • SendDate (Type: Date, Nullable: True, Default Value: GETDATE())
  • YourVar (Type: According to the data you have in your AMPscript-Variable, Nullable: True)
6
  • 1
    As AndrewC pointed out, you can also log the value of AMPScript personalisation strings and variables to the Send Log. The value of @myVar would be logged if the send log DE contains a field called "myVar".
    – Macca
    Jul 19, 2017 at 9:01
  • Thank you for that piece of information, I added it to the answer! Jul 19, 2017 at 9:29
  • Thanks Markus and @AndrewMcLeod, much appreciated. As mentioned above, I've tried using personalisation strings from the System Data tables in my send log, with varying degrees of success. I already have EmailAddress there and it's not being populated for triggered sends, it seems. I love the GETDATE(), thanks! I wouldn't have thought of that! Embarrassingly. More and more, I'm thinking that I might use AMPscript variables in every email, for flexibility. For example, I could set the send time to my local time then, which is Sydney, Australia.
    – Grant Ryan
    Jul 20, 2017 at 0:04
  • Where can I find a list in the SFMC documentation of the default field names SFMC uses for these common data points? I can't find them ...
    – Grant Ryan
    Jul 20, 2017 at 0:05
  • Are you referring to Personalization Strings - help.marketingcloud.com/en/documentation/exacttarget/content/…? Bare in mind that some of these strings start with underscores and you'll not be able to create fields in your Send Log whose name starts in this way. You may want to consider AMPScript variables for these. A good idea might be to place this type of AMPScript in the Account Header defined in the Admin Section of the Email Application.
    – Macca
    Jul 20, 2017 at 0:09

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .