tracker |
Link Tracker
Catalog: Odoo
Schema: link
Documentation:
Link trackers allow users to wrap any URL into a short URL that can be
tracked by Odoo. Clicks are counter on each link. A tracker is linked to
UTMs allowing to analyze marketing actions.
This model is also used in mass_mailing where each link in html body is
automatically converted into a short link that is tracked and integrates
UTMs.
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table tracker are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
absolute_url |
string |
Absolute URL |
☐ |
|
campaign_id_label |
string |
|
☐ |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
campaign_id |
string |
|
☐ |
This is a name that helps you keep track of your different campaign efforts, e.g. Fall_Drive, Christmas_Special |
code |
string |
Short URL code |
☐ |
|
count |
int32 |
Number of Clicks |
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
display_name |
string |
Display Name |
☐ |
|
id |
int32 |
ID |
☐ |
|
label |
string |
Button label |
☐ |
|
link_click_ids |
string |
|
☐ |
|
link_code_ids |
string |
|
☐ |
|
mass_mailing_id_label |
string |
|
☐ |
|
mass_mailing_id |
string |
|
☐ |
|
medium_id_label |
string |
|
☐ |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
medium_id |
string |
|
☐ |
This is the method of delivery, e.g. Postcard, Email, or Banner Ad |
redirected_url |
string |
Redirected URL |
☐ |
|
short_url_host |
string |
Host of the short URL |
☐ |
|
short_url |
string |
Tracked URL |
☐ |
|
source_id_label |
string |
|
☐ |
This is the source of the link, e.g. Search Engine, another domain, or name of email list |
source_id |
string |
|
☐ |
This is the source of the link, e.g. Search Engine, another domain, or name of email list |
title |
string |
Page Title |
☐ |
|
url |
string |
Target URL |
☑ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826