Pixel Conversion Rate

Overview

Pixel Conversion Rate refers to the percentage of visitors to your website who make a purchase, as tracked by Triple Whale Pixel.

πŸ“˜

Pixel Conversion Rate = Orders Count / Total Sessions

The calculation is based on data from the Pixel Joined table.

Insights and Actions

Pixel Conversion Rate is an extremely valuable metric that gauges the effectiveness of your website in converting visits into purchases. Efficiently leveraging Pixel Conversion Rate data can guide strategic business decisions:

  • Optimize Landing Pages: Analyze pages with high conversion rates to identify effective elements, and apply these insights to underperforming pages.
  • Refine Marketing Campaigns: Focus your marketing efforts on channels and campaigns that drive high-converting traffic to your site.
  • Improve User Experience (UX): Identify and remove barriers to conversion by analyzing the user journey and implementing a more intuitive navigation and checkout process.
  • A/B Testing: Conduct A/B tests on different website elements, such as CTAs, images, and product descriptions, to see which variations lead to higher conversion rates.

Example Use

Prompt

What's my pixel conversion rate the past 30 days?

Response

Query

SELECT
  COALESCE(
    SUM(bpm.orders_quantity) / NULLIF(SUM(bpm.sessions), 0),
    0
  ) AS conversion_rate
FROM
  pixel_joined_table AS bpm
WHERE
  bpm.model = 'Triple Attribution'
  AND bpm.event_date BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY) AND DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY);