REDS clicks feed columns
The following table lists the Clicks feed columns (also known as stream fields).
NOTE: Certain fields in this feed might be modified to comply with regional regulations. For data scrubbing and retention details, see REDS data practices.
Clicks table reference
| Field (Column) | Data Type | Suggested String Length | Description | Example |
|---|---|---|---|---|
LogEntryTime |
DateTime | N/A | The time stamp that identifies when the event occurred in the format yyyy-MM-ddTHH:mm:ss. |
2025-02-22T22:30:38 |
ClickRedirectId |
GUID | 36 | The unique identifier associated with the click event. | 0ce7c305-74e7-4f25-97bf-433e70f1cb66 |
IPAddress |
String | 100 | The IP address of the device that clicked at the time of the click event. | 50.202.161.178 |
ReferrerUrl |
String | 1000 | The address of the webpage that is linked to the click request. | http://redir.site.com/redir/client/VPAIDClient.swf?adTagUrl=http%3A%2F%2Fads.site.advertising.com%2Fa%2Fh%2FWuipbaNL\_wYBSFY8UN%2BWMaDrdJaix |
RedirectUrl |
String | 1000 | The address of the webpages that a click redirects through before arriving at the landing page | https://redir.com/?utm\_source=hx&utm\_medium=display&utm\_campaign=prospecting&dclid=CLeXwZzyltICFVNfXgodgNwHsA |
CampaignId |
String | 32 | The unique ID for the campaign as assigned by TTD. | cb45ac6 |
ChannelId |
String | 32 | The channel from which the click was recorded. Used to record clicks from sources outside of RTB. | Click here to view a mapping of IDs and names. |
AdvertiserId |
String | 32 | The unique ID for the advertiser as assigned by TTD. | cb12ac3 |
DisplayImpressionId |
GUID | 36 | The unique identifier associated with the impression event. This gets carried through on the click. | w063a21c-8760-42f6-a2c0-08e68b4db125 |
Keyword |
String | 250 | The keyword is a particular word or phrase that describes the content surrounding the click event. | TradeDeskTradeDesk RTBTradeDesk Programmatic |
KeywordId |
String | 25 | The unique identifier associated with the keyword. | abc123 |
MatchType |
String | 100 | The match type determines how closely an input matches your keyword | ExactBroadPhrase |
DistributionNetwork |
String | 25 | Associated with The Trade Desk Click Tag Converter feature, which is used for search clicks. You can pass the distribution network into the search-click URL. | googlebing |
RawUrl |
String | 100 | The full URL that was received to track the click. This can be used to extract custom parameters. | /track/clk?imp=a72306d5-452a-45e8-b307-427f886161d2&ag=8iucaai&crid=zafvmlzs&fq=0&td\_s=site.com&rcats=7sp&mcat=&mste=& |
ProcessedTime |
DateTime | 19 | The timestamp of when the log line was processed in REDS, formatted as yyyy-MM-ddTHH:mm:ss. |
2025-05-15T20:30:00 |
DeviceType |
Integer | 1 | The numeric ID for type of device on which the impression was served. For supported values, see Device types. | 2 |
ChannelId
| ID | Name |
|---|---|
adwords |
Google Adwords |
ae |
Global Wide Media Affiliate Campaign |
ge |
Global Wide Media Email |
google |