Factual's Measurement Intelligence solution enables you to measure the impact of your campaign by having Factual receive your campaign’s ad exposures and then tie them to post-ad-exposure store visits for attribution. Factual delivers a detailed analysis of your campaign's performance via a Measurement Intelligence dashboard. Through Factual’s partnership with LiveRamp, we are able to provide this offering to digital campaigns tied to any cookie or custom ID recognized by LiveRamp IdentityLink.
If you have ad exposure log files for your digital campaigns that are tied to a cookie or custom ID, you can submit that data to LiveRamp who will then initiate Factual’s measurement workflow for your campaign. This document describes general guidelines for how to format your ad exposure files for delivery to LiveRamp.
If you do not have a LiveRamp IdentityLink agreement that covers exposure data use cases — Factual will create a LiveRamp IdentityLink client on your behalf and configure the SFTP filepath where you can upload your ad exposure log files. Please contact your Factual account representative for details on how to initiate this setup process. Note that this may take ~1-2 weeks to setup.
If you do have a LiveRamp IdentityLink agreement that covers exposure data use cases — Please reach out to your LiveRamp account team for specific details on how to initiate the LiveRamp IdentityLink for Measurement workflow with Factual.
For the filename, please include the platform name, chain name, campaign start month, and campaign end month in the file name, separated by dashes (“-”). Use the following format:
Do not include any non-alphanumeric characters (spaces, underscores, apostrophes, etc.) in the platform name, chain name or in the start or end dates. As an example, if your campaign was delivered using PlatformX, and it measured visits to Amy’s Back-to-Basics Hardware from Jan to Mar 2018, the filename should be:
Note: You can only have one cookie partner or ID type per file. So if your ad exposures occurred on multiple platforms that use different cookies, you will need to submit a separate exposure file for each platform you used.
If your campaign was not delivered using a third-party platform, you can use the term Digital in place of a platform name. If you are measuring visits to more than one chain, you can simply use the name of the largest chain or the name of the category in place of a chain name (e.g., HomeImprovementStores).
The exposure file you send to LiveRamp must be:
- Rectangular (same number of fields in each row; individual records should be delimited by a newline)
- Flat (no internal hierarchy)
- No fewer than 25 records in length
Please refer to LiveRamp's documentation on File Formatting requirements for guidelines for formatting files to be processed by LiveRamp. For Factual’s measurement workflow, we recommend that your file be a tab-separated value (TSV) file. Your file should contain the fields described in the table below.
You must ensure the columns in the exposure file(s) are ordered as indicated by the index numbers below.
|1||Cookie or Custom_ID||String; required||This is the cookie or “Custom ID” that you use to identify a user in your system. You are required to provide only one type of identifier per file, you cannot mix different cookie or ID types in the same exposure file.|
|2||Exposure_Timestamp||String; required||Number of seconds since the Unix epoch — 00:00:00 UTC on 1 January 1970.|
|3||Campaign_ID||String; optional||Campaign identifier.|
|4||Placement_ID||String; optional||Placement identifier.|
|5||Ad_ID||String; optional||Ad creative identifier.|
|6||Ext1||String; optional||Optional custom parameter (up to 5 custom parameters supported)|
|7||Ext2||String; optional||Optional custom parameter (up to 5 custom parameters supported)|
|8||Ext3||String; optional||Optional custom parameter (up to 5 custom parameters supported)||-|
|9||Ext4||String; optional||Optional custom parameter (up to 5 custom parameters supported)||-|
|10||Ext5||String; optional||Optional custom parameter (up to 5 custom parameters supported)||-|
Note: For digital campaigns (non-TV), please include headers in the ad exposure file submitted to LiveRamp. Please also send your Factual account representative the ordered list of fields you will be using to ensure correct processing of your file. For example, if your file contains Cookie, Exposure_Timestamp and Campaign_ID (in that exact order), but no other fields, then tell your Factual account representative prior to submitting your exposure file to LiveRamp.
The following is an example of a compliant file for a digital campaign to be submitted to LiveRamp. Note the header is included in the first line of the file.
Custom_ID Exposure_Timestamp Campaign_ID Placement_ID Ad_ID abc123 1495383384 campaignId1 placementId1 adId0 abc123 1495383384 campaignId1 placementId0 adId2 abc123 1495383384 campaignId1 placementId2 adId1 def456 1495383384 campaignId1 placementId0 adId3 def456 1495383384 campaignId1 placementId3 adId2 def456 1495383384 campaignId1 placementId1 adId4 ghi789 1499610910 campaignId1 placementId1 adId4 ghi789 1499610910 campaignId1 placementId4 adId0 ghi789 1499610910 campaignId1 placementId2 adId1
When setting up Factual measurement for your campaign, you will need to tell your Factual account representative what places you want to measure visits to (e.g., a nationwide retail chain, a retail chain’s locations in specific DMAs, etc.). We recommend utilizing locations from Factual’s Global Places for your campaign. If you need to use your own custom list of places, you may do so by following this guideline.
After your campaign’s end date, you will need to deliver the exposure file as described above. LiveRamp will then activate the IdentityLink for Measurement workflow with Factual and Factual will tie the matching store visits to the corresponding exposures for attribution.
The final output will be a conversions data file (spreadsheet) and/or a campaign wrap-up report (pdf) analyzing the results of your campaign in driving traffic to the store. For more details on this deliverable (timing of delivery, sample report, etc.), please contact your Factual account representative.
Updated over 2 years ago