Dynamic Content Click Through Reporting

Version 9

    It's not currently possible to report on click throughs for dynamic content and links with those rules without some manual updating. Apparently this should be covered in the Summery 2019 release according to the thread here.

     

    In the meantime I have a semi automated method. It involves adding query strings to links in dynamic content manually and a modification of an Insight report using formula's to automatically pull out the individual query strings. In the future the report can be re-used. The end result will look like this:

     

    Email Name

    Dynamic Content Rule

    Dynamic Content Link

    Contact

    Total Clicks

    Unique Clicks

    Email_A

    1

    1

    Bob

    2

    1

    Email_A

    2

    1

    Tony

    1

    1

    Email_A

    2

    3

    Bob

    3

    2

     

    The link structure we would follow something like this but you could also change for UTM parameters.

     

    http://company.com?DCRU=1&DCLI=1

     

    The method follows this approach where we have one dynamic content used in an  email with multiple rules and multiple links with those rules.

     

     

     

    Please note that you will need the Analyzer license for Insight to do this.

     

    --------------------------------------------------------------------------------------------

     

    Adding the query string parameters to the email

     

    As Eloqua doesn't automatically add parameters to these links that can identify which link it is and which rule it is from, we need to create our own identifiers. In this example I have used these. Slightly longer than needed to prevent clashing with other common parameters:

     

    DCRU – Dynamic Content Rule – The Rule Identifier
    DCLI – Dynamic Content Link – The Link Identifier

     

    An example URL that would appear in Email A, Rule 1, Link 1 would be:

     

    http://company.com?DCRU=1&DCLI=1

     

    This bit “DCRU=1&DCLI=1” would need to be added to the first link in the first dynamic content rule. Each link would have a slightly different parameter.

    An example that would be for link 3 inside dynamic content rule 2 would be:

     

    http://company.com?DCRU=2&DCLI=3

     

    Here is how the final dynamic content rule might look once finished:

    Here are how the parameters that have been added into the HTML code view:

     



    https://company.com/?dcru=1&dcli=1
    https://company.com/?dcru=1&dcli=2
    https://company.com/?dcru=1&dcli=3


    Once you have added parameters to the link and save Eloqua will then be automatically add in additional parameters that it uses for other purposes. You don’t need to remove them as they will work together.

    Next I need to add this dynamic content to an email and send it to myself and someone else so that I can generate so click data for the report to pick up.

     

    --------------------------------------------------------------------------------------------

     

    Creating the report

     

    Go to “New” > “Analysis” > “Email Clickthrough”

     

    Drag and drop the required fields from the left-hand side to the “Selected Columns” section per my example below. Please note that I have two "Clickthrough Query String Value" fields as I'm going to convert these into columns for my "dcru" and "dcli" parameters

     

     

    Edit the formula for one of the columns. We are going to add the formula to find the "dcru" parameter first.

     

    Add this into the formula. Should you want to understand this formula more, I have included some detail at the end.

     

    CASE WHEN (Locate('dcru', "Email Clickthrough Attributes"."Clickthrough Query String Value") = '0') THEN '' ELSE (REPLACE(SUBSTRING("Email Clickthrough Attributes"."Clickthrough Query String Value" FROM (Locate('dcru', "Email Clickthrough Attributes"."Clickthrough Query String Value")) FOR (Locate('&', SUBSTRING(CONCAT(("Email Clickthrough Attributes"."Clickthrough Query String Value"), '&') FROM (Locate('dcru', "Email Clickthrough Attributes"."Clickthrough Query String Value"))))-1)), 'dcru=', '')) END

     

    (If you are thinking of modifying this in the future to cover different parameters, please pay attention to the “dcru” values. This is the dynamic content rule parameter that this column will report on. It appears 4 times in the code.)

     

     

     

    You can then relabel the column by selecting a “Custom Heading”.

     

     

     

    Repeat the same process for the second column but this time use this code. This will be finding the “dcli” value or the link ID.

     

    CASE WHEN (Locate('dcli', "Email Clickthrough Attributes"."Clickthrough Query String Value") = '0') THEN '' ELSE (REPLACE(SUBSTRING("Email Clickthrough Attributes"."Clickthrough Query String Value" FROM (Locate('dcli', "Email Clickthrough Attributes"."Clickthrough Query String Value")) FOR (Locate('&', SUBSTRING(CONCAT(("Email Clickthrough Attributes"."Clickthrough Query String Value"), '&') FROM (Locate('dcli', "Email Clickthrough Attributes"."Clickthrough Query String Value"))))-1)), 'dcli=', '')) END

     

    Remember to change the column name

     

    Finally, it would probably be best to add in a filter so that in the future when there are lots of emails using the same parameters you can focus on the correct email. Lets set this to find the email that we created the dynamic content for earlier.

     

     

     

     

     

     

    Now we need to run the report by clicking on “Results”

     

     

    My final report looks like this:

     

     

     

     

    --------------------------------------------------------------------------------------------

     

    The Formula

     

    Here is a break down as to how the formula is structure should it need error checking or for future use. I'm sure I'm going to forget what this does unless I write it down