Microsoft CTR

ctr

Overview

Microsoft Click-Through Rate (CTR) represents the percentage of users who clicked on your Microsoft ad after seeing it.

📘

Microsoft CTR = Microsoft Clicks / Microsoft Impressions

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Clicks = SUM(clicks) --> Ads table
Impressions = SUM(impressions) --> Ads table
Microsoft Ads = where channel = 'bing'

Insights and Actions

Microsoft CTR helps assess the engagement level of your Microsoft Ads. Use this data to:

• Optimize Ad Creatives: Ads with low CTR may need more engaging visuals or copy to attract clicks.
• Refine Audience Targeting: Test different audience segments to improve CTR by focusing on more relevant or engaged groups.
• Adjust Ad Placements: Analyze the impact of various placements and formats to identify which ones boost CTR.
• Improve Ad Timing: Experiment with running ads at different times to see if CTR improves during certain hours or days.

Example Use

Prompt

What's my Microsoft CTR for the last 7 days?

Response

Query

SQL

SELECT
  am.channel AS channel,
  COALESCE(
    SUM(am.clicks) / NULLIF(SUM(am.impressions), 0),
    0
  ) AS CTR
FROM
  ads_table AS am
WHERE
  am.channel = 'bing'
  AND am.event_date BETWEEN CURRENT_DATE() - 7 AND CURRENT_DATE()  - 1
GROUP BY
  am.channel;