The Custom Pixel Events table captures specific interactions visitors have with your site, as defined by custom events you set up. Querying this table lets you understand nuanced website visitor behaviors, allowing for targeted analysis and optimization of your digital presence.

πŸ“˜

Note

event_date is a required field for queries on this table.

Dimensions

Dimensions are immutable properties that can be used for grouping data.

NameTypeDescriptionSource
event_datedateThe date the custom event occurred. Based on the time zone of the shop at the moment of the event.Triple Pixel
event_date.daydateThe day on which the custom event occurred. Derived from event_date.Triple Pixel
event_date.weekdateThe Sunday of the week during which the custom event occurred. Derived from event_date.Triple Pixel
event_date.monthdateThe month during which the custom event occurred. Derived from event_date.Triple Pixel
event_date.quarterdateThe first month of the quarter during which the custom event occurred. Derived from event_date.Triple Pixel
event_date.yeardateThe year during which the custom event occurred. Derived from event_date.Triple Pixel
event_timestamptimestampThe time the custom event occurred. Formatted according to the ISO 8601 international standard.

Example value: 2022-06-15T19:26:30.000Z
Triple Pixel
triple_idstringThe unique ID assigned by Triple Pixel to track visitors across sessions.

Example value: cltlok4y634IRw62AZ
Triple Pixel
session_idstringThe unique ID for the session during which the custom event occurred. Assigned by Triple Pixel.

Example value: cltlok4y634IRw62AZ_1710700966152
Triple Pixel
event_namestringThe name assigned to the custom event.

Example values: form_fill, start_quiz, quiz_complete, order_sample, answer_question, request_consultation
Triple Pixel
event_custom_datarecord repeatedAn array of all custom properties sent with the custom event.Triple Pixel
event_custom_data.custom_data_keystringThe name of an individual custom property sent with a custom event.

Example value: form_name, quiz_name, question, answer, sample_color, consultation_type
Triple Pixel
event_custom_data.custom_data_valuestringThe value of an individual custom property sent with a custom event.

Example values: Sizing inquiry, color_matching_quiz ,What is your favorite color?, Blue , Custom Jewelry Consultation
Triple Pixel
modelstringThe attribution model used to determine the attributed click source for the event's session.Triple Attribution is applied by default.

Example values: Triple Attribution, Last Click, First Click, Linear All, Total Impact, Triple Attribution + Views, Linear Paid
Triple Pixel
ad_clicksrecord repeatedInformation about clicks on ads leading to the session during which the custom event occurred.Triple Pixel
ad_clicks.click_tstimestampThe time of the ad click. Formatted according to the ISO 8601 international standard .

Example value: 2022-06-15T19:26:30.000Z
Triple Pixel
ad_clicks.sourcestringThe source of the ad click.

Example values: facebook-ads, youtube, tw_referrer
Triple Pixel
ad_clicks.campaign_idstringThe unique ID for the marketing campaign associated with the ad click. Assigned by the publisher platform.

Example values: 23852438666180053, 531011533, 20620285829
Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Yotpo Email and SMS, Taboola, Outbrain
ad_clicks.adset_idstringThe unique ad set ID for the ad set associated with the ad click. Assigned by the publisher platform.

Example value: 120210439890740003
Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Klaviyo, Taboola, Outbrain
ad_clicks.ad_idstringThe unique ad ID for the ad associated with the ad click. Assigned by the publisher platform.

Example value: 120210439891110007
Facebook, Google, TikTok, Twitter, Pinterest, Snapchat, Bing, Amazon, Criteo, Mountain, Klaviyo, Taboola, Outbrain
ad_clicks.utm_mediumstringThe UTM medium parameter captured by Triple Pixel from the ad URL.

Example values: sponsored, paid, profile_link
Triple Pixel
ad_clicks.querystringThe query string captured by Triple Pixel from the ad click URL.Triple Pixel
ad_clicks.linear_weightnumericA numerical weight assigned to the ad click, used in attribution models.Triple Pixel

Derived

Derived fields are metrics that are pre-calculated using multiple measures or advanced formulas.

Field NameTypeDescriptionSource
countformulaTotal number of custom events recorded.

Formula: count(@triple_id) as count
Triple Pixel