What is LiveRamp?

LiveRamp is an outside partner that provides us with matching data.  The LiveRamp process is owned by Engineering.

How does LiveRamp work?

We fire the Liveramp pixel as part of our Clarivoy web tag.  We collect visitor data, which gets shipped to LiveRamp.

We ship to LiveRamp: TD URL, TD client ID, etc.  Essentially all data we get with pageviews.  LiveRamp returns matching customer data.

Data is shipped to LiveRamp daily at 10:15 AM.

Data is received from LiveRamp daily at 10:00 PM, however there is typically a large spike of data returned approximately every 20 days.  There has been no explanation from LiveRamp as to why they function this way.

LiveRamp does NOT typically have data for Canadian clients.  LiveRamp matching will be low/non-existant for Canadian dealers.

About LiveRamp Matching

LiveRamp is part of Online Matching and is viewable on the following Looker boards:

• Ops Prelim QA - Monthly Property Report
• CS QA - Attribution Details

Troubleshooting LiveRamp QA Issues

• LiveRamp is low/non-existant in most Canadian properties. If Canada and there is no LiveRamp, do not be concerned.
• Verify that the LiveRamp? flag is set to TRUE for the property in the DMUI
  • If not, this is the case. Set it to TRUE. It may take up to 22 days for full LiveRamp attribution to appear after setting this to TRUE.
• Check the Looker dashboard SA Health Factors. Look at the LR Attribution chart.
  • This chart is showing how many new LiveRamp attributions were created each day.
    • Red bars indicate days where no LiveRamp attribution was created. It is normal to have some days with no attribution created, based on the delivery schedule.
      • If there are more than 4 days in a row with no LiveRamp attribution at all, there may be an issue. In this case, alert Engineering to investigate by opening a ticket on the Tickets board,
  • LiveRamp delivers data to us every week, with large spikes approximately every 20 days. Attribution can occur in the days in between, but usually occurs in between the spikes when new sales match existing customers in our "identity graph".
  • Because of the delivery schedule, If the dealer submitted a COLLECT sales file and their LiveRamp attribution is low, and we have not received LiveRamp data in the past few days prior to CSL QA, it may simply need more time.
    • If you are seeing 0 LiveRamp matching (and it is not Canada) and it has been >2 days since the sales file was loaded, then no customers in their sales file matched our existing identity graph.
    • If you are seeing low LiveRamp matching (and it is not Canada) and it has been >2 days since the sales file was loaded, then the matching you are seeing is customers in the sales file who were already in our identity graph. The remainder of the matching will be returned when LiveRamp next returns data to us. Look at when the last large spike of attribution occurred, then add 21 days - This is the date the full attribution should occur for your dealer.

Additional Questions

If you have additional questions or cannot find an answer in this article, please open a Ticket on the Tickets board.  The Engineering team will need to investigate and respond.