Quickstart guide

Tag Manager

Consent & Privacy

Analytics

Performance

API Reference

Advanced analytics reporting

If you want to interrogate your analytics data in more complex ways than the dashboard allows, head to the Data Explorer tab. This screen allows you to write SQLite queries to access all of your Etiquetta data. You can access frequently used queries through the History tab, and export your data for visualisation or use in another platform in CSV or JSON format, or copy it directly to your clipboard.

Tip: If you are not familiar with SQL or SQLite, copy the prompt below into your AI of choice and describe the data you want to receive, then copy and paste the query it gives you into the Data Explorer.

Expand for sample query 
Please write an SQLite query to return the following data:

--- describe your query here ---

The table structure is below, with fields names and data formats in a name/FORMAT pairings:

table: campaigns
id/TEXT
name/TEXT
utm_source/TEXT
utm_medium/TEXT
utm_campaign/TEXT
cpc/REAL
cpm/REAL
budget/REAL
start_date/INTEGER
end_date/INTEGER
created_at/INTEGER

table: domains
id/TEXT
name/TEXT
domain/TEXT
created_by/TEXT
created_at/INTEGER
is_active/INTEGER
site_id/TEXT

table: errors
id/TEXT
timestamp/INTEGER
session_id/TEXT
visitor_hash/TEXT
domain/TEXT
url/TEXT
path/TEXT
error_type/TEXT
error_message/TEXT
error_stack/TEXT
error_hash/TEXT
script_url/TEXT
line_number/INTEGER
column_number/INTEGER
browser_name/TEXT
geo_country/TEXT

table: events
id/TEXT
timestamp/INTEGER
event_type/TEXT
event_name/TEXT
session_id/TEXT
visitor_hash/TEXT
user_id/TEXT
domain/TEXT
url/TEXT
path/TEXT
page_title/TEXT
referrer_url/TEXT
referrer_type/TEXT
utm_source/TEXT
utm_medium/TEXT
utm_campaign/TEXT
geo_country/TEXT
geo_city/TEXT
geo_region/TEXT
browser_name/TEXT
os_name/TEXT
device_type/TEXT
is_bot/INTEGER
props/TEXT
bot_score/INTEGER
bot_signals/TEXT
bot_category/TEXT
has_scroll/INTEGER
has_mouse_move/INTEGER
has_click/INTEGER
has_touch/INTEGER
click_x/INTEGER
click_y/INTEGER
page_duration/INTEGER
datacenter_ip/INTEGER
ip_hash/TEXT
geo_latitude/REAL
geo_longitude/REAL

table: performance
id/TEXT
timestamp/INTEGER
session_id/TEXT
visitor_hash/TEXT
domain/TEXT
url/TEXT
path/TEXT
lcp/REAL
cls/REAL
fcp/REAL
ttfb/REAL
inp/REAL
page_load_time/REAL
device_type/TEXT
connection_type/TEXT
geo_country/TEXT

table: visitor_sessions
id/TEXT
session_id/TEXT
visitor_hash/TEXT
domain/TEXT
start_time/INTEGER
end_time/INTEGER
duration/INTEGER
pageviews/INTEGER
entry_url/TEXT
exit_url/TEXT
is_bounce/INTEGER
bot_score/INTEGER
bot_category/TEXT

Example queries

Conversions by campaign for the last month

SELECT 
    utm_campaign,
    COUNT(*) AS conversion_count
FROM events 
WHERE id = 'Your-Conversion' 
  AND timestamp >= date('now', '-30 days')
GROUP BY utm_campaign
ORDER BY conversion_count DESC;

Average page load times across the last two weeks

SELECT 
    DATE(timestamp) AS day,
    AVG(page_load_time) AS avg_load_time
FROM performance 
WHERE timestamp >= date('now', '-14 days')
GROUP BY DATE(timestamp)
ORDER BY day DESC;

Number of bots who have visited from Facebook in the last 6 months

SELECT 
    COUNT(DISTINCT session_id) AS bot_sessions
FROM events 
WHERE is_bot = '1' 
  AND utm_source = 'facebook'
  AND timestamp >= date('now', '-6 months');