Data Dictionary

Amazon CPC

cpc

Overview

Amazon Cost Per Click (Amazon CPC) refers to the Amazon-reported cost for each click on a Amazon ad.

📘

Amazon CPC = Amazon Ad Spend / Amazon Ad Clicks

The calculation is based on data from the Ads table.

Detailed Breakdown

The formula above is derived from the following components:

Ad Spend = SUM(spend) --> Ads table
Clicks = SUM(clicks) --> Ads table
Amazon Ads = where channel = 'amazon'

Insights and Actions

Amazon CPC helps you understand the cost of driving traffic to your product listings through ads. By monitoring this metric, you can optimize ad spend and campaign performance:

  • Evaluate Ad Effectiveness: Review CPC trends to gauge the cost efficiency of your Amazon ads in attracting customers.
  • Optimize Bid Strategy: If CPC is high, adjust your bids to better control ad costs while maintaining performance.
  • Identify High-Cost Campaigns: Look for campaigns with rising CPC and evaluate whether they’re delivering adequate returns.
  • Compare Across Channels: Use Amazon CPC alongside CPC from other platforms (Google, Facebook) to assess where your ad budget is best spent.

Example Use

Prompt

What was my Amazon CPC for yesterday?

Response

Query

SELECT
  COALESCE(SUM(adt.spend) / NULLIF(SUM(adt.clicks), 0), 0) AS amazon_cpc
FROM
  ads_table AS adt
WHERE
  adt.event_date = CURRENT_DATE() - 1
  AND adt.channel = 'amazon';

Updated 2 months ago