- Flag if impression exists

tve_leads_unique

1

30 days

- Stores a page visit on the form

tl_{group_id}_{form_id}_{variation_id}

{log_id, refferer}

30 days

- Stores a page visit on a form variation included in the A/B test

t_{test_id}_f_{form_type_id}

{content_id} //if the content is part of A/B Testin shows the same content for the same user;

30 days

- Stores a conversion event for the form variation

tl-conv-{content_id}

1

1 year

- Stores a conversion event for the campaign

tl_conversion_{group_id}

1

1 year

- Flag if conversion exists for the campaign

tl_conversion_{key}

1

1 year

Notes:

- {log_id} - which represents an entry in DB for the following data: some internal IDs, IP, refferer, utm_source, utm_medium, utm_campaign, EMAIL

- {referrer} - URL of the site from where the user came from

- {utm_{cols}} - standard marketing query string variables

- {key} = encrypt(array(user_email, {group_id}))

- Stores unique impression/

conversion (based on event_type) for a page included in a test

top-variation-{event_type}-{test_id}-{page_id}

{variation_id}

30 days

- Stores a page visit on a page included in a test

top-impression-{test_item_id}

{test_item_id}

5 seconds

Notes:
- event_type = [1,2]
- test_id = autoincrement
- page_id = autoincrement
- variation_id = autoincrement
- test_item_id = autoincrement

- Flag if impression exists

tqb-impression-{page_id}

true(bool)

30 days

- Unique cookie for each user (used for unique visits)

tqb-impression-{page_id}-{user_unique_id}

true(bool)

30 days

- Flag if conversion exists

tqb-conversion-{page_id}

true(bool)

30 days

- Unique cookie for each user (used for unique conversion)

tqb-conversion-{page_id}-{user_unique_id}

true(bool)

30 days

- Flag if social media conversion exists

tqb-conversion-social-media-{page_id}

true(bool)

30 days

- Unique cookie for each user (used for unique social media conversion)

tqb-conversion-social-media-{page_id}-{user_unique_id}

true(bool)

30 days

- Identify a campaign's unique impression

tu_campaign_impression_{campaign_ID}

lockdown: {
email: {USER_EMAIL},
log_id: {LOG_ID}
}
start_date: {
date: CURRENT_DATE()
time: CURRENT_TIME()
},

1 year or value set from admin

- Automatically marks a related campaign as started when it’s setup as a conversion event for another campaign; and the conversion for the original campaign has been triggered.

tu_campaign_{campaign_ID}

serialize([start_date => NOW()]))

The duration set for the campaign (from admin)

- Forces a related campaign to be displayed for the user, even though other campaigns could be displayed.

tu_force_campaign_{campaign_ID}

NOW()

The duration set for the campaign (from admin)

- Identifies the fact that the current visitor has made a conversion for a campaign.

tu_campaign_conversion_{campaign_ID}

NOW()

For evergreen campaigns, as setup from admin; for the rest of them 1 year

- Makes sure this campaign will not be displayed anymore for the visitor that made a conversion.

tu_campaign_end_{campaign_ID}

‘end’

10 years

SUMMARY:

We store the encrypted user email in order to prevent duplicated access to campaigns. The email is stored when the user is accessing the lockdown page with &email= query string parameter (received via marketing email most likely)

NOTES:
- lockdown saved only for Lockdown campaigns
- LOG_ID - database log id

- USER_EMAIL is encrypted one-way

- Used to prevent comment spam

tve_secret

rand()

1 year

- Stores the information from a successfully logged user using social platforms ( FB, Google )

social-login

{name, email, picture}

session cookie

- Used to retain the fact that the user has commented once in the current session

tcm_commenter_first

1 / 0

30 mins

- So that the user can see his/her comment even if it’s not approved

tcm_cookie_{comment_id}

{comment_ID}

30 days

- Used to prefill form inputs

tcm_cookie_user_name

{comment_author}

session cookie

- Used to prefill form inputs

tcm_cookie_user_email

{comment_author_email}

session cookie

- Used to prefill form inputs

tcm_cookie_user_website

{comment_author_url}

session cookie

- Used to keep count of how many times has a user commented on a specific post

tcm_commenters

array of commenter identifiers

30 mins

- Used to keep count of what type of vote a certain user gave

vote-comment-{comment_id}

upvote / downvote

365 days

- Remembers the indexes of variations from the test that the user has seen, so we can display them again. Test won’t be relevant if this is removed.

tho_post_title

array of variations indexes for the titles the user has seen - ids are stored, not strings

1 year

- Remembers what engagements a user has done on a specific test. We need this, so we can generate reports for the specific test and provide a winner.

tho_post_cookie_{post_id}

{
post_id: {post_id},
test_id: {test_id},
no_click: true/false,
impressions: [engagement_type_impressions], values - 1,2,3
engagements: [engagement_type_engagements], values - 1,2,3
}

1 year

- Used to mark learned lessons from each course and to build the progress bar widget from the sidebar, if used

tva_learned_lessons:

course id, lesson id

+1 year

- Holds each conversion from every single lesson

tva_conversions

course id

+1 year

- Used to display various data regarding a comment, if it is in approval stage

tva_comment_cookie_{comment_id}

{
comment_id: comment id,
comment_email:email address
}

+30 days

- Used to auto-fill the username, if the user want to post a comment again

tva_cookie_user_name

comment_author: comment author,

+30 days

- Will autofill the email, when the user will want to post a comment again

tva_cookie_user_email

comment_author_email: comment author email,

+30 days

- Will autofill user site URL, if the user will post a comment again

tva_cookie_user_url

comment_author_url: comment author url,

+30 days

- Stores the lesson from the user that has been redirected on TA login page.

After successful login the user will be redirected to that lesson.

tva_lesson_to_redirect

url to redirect

session cookie

- Saves data for autofill on Lead Generation forms, if Autofill form inputs checkbox is checked

account_create_fields

{email, name}

session cookie

- Used on countdown_evergreen for restart timer

evergreen_{random_id}

{expiration time for countdown}

never

- Used by Facebook for shared session

self::FBSS_COOKIE_NAME . '_' . $this->getAppId();

$cookie_value = $this->makeSignedRequest(
array(
'domain' => $base_domain,
'id' => $this->sharedSessionID,
)
);

1 year

- Used by Facebook for login

'fbsr_' . $this->getAppId();

‘ ‘

1 second

- Allows the user to choose whether to have a single or a double optin for the form being edited.

- It will hold the latest selected value in a cookie, so that the user is presented by default with the same option selected the next time he/she edits such a form.

'tve_api_drip_optin'

$params['optin']

6 months

- Allows the user to choose whether to have a single or a double optin for the form being edited.

- It will hold the latest selected value in a cookie, so that the user is presented by default with the same option selected the next time he/she edits such a form.

'tve_api_mailchimp_optin'

$params['optin']

6 months

- Generates secret and set cookie

TVE_SECRET

$rand

1 year