Workflow: Cost exposure and rebid decisions
A cost rise only matters where your money actually sits.
Add your data
Adding details ensures a relevant result
Save time by automatically applying details and getting ready-to-use prompts.
Prompt
For {your-domain.com} in {country}, return your current paid keywords.
Return these columns:
• keyword
• position
• search_volume
• cpc
• share_of_your_paid_traffic
• share_of_your_paid_cost
• landing_url
• exposure_class
Set exposure_class to concentrated when share_of_your_paid_cost is 3 per cent or higher, and distributed otherwise.
Sort by share_of_your_paid_cost descending. Limit: 30 keywords.
Before ranking or computing the percentile, normalize the rows: collapse any rows identical in both keyword and position into one, then aggregate the remaining rows per keyword — sum traffic and cost share, keep the best position. The source returns one row per ad slot and can repeat an identical row, so an exposure_class threshold applied without this step misclassifies keywords whose spend is split across rows.
Then join this table to the Workflow 1 Step 2 summary by keyword and carry across cpc_change_pct and cost_pressure_class. Label not_in_history where a keyword did not appear there. If Workflow 1 was not run, or reported no_market_inflection, label both carried columns not_available and continue on the current portfolio alone — this step does not depend on Workflow 1 having found a market-wide rise.
Report below the table the 75th-percentile CPC across your current portfolio — Step 2 uses it.
Is this prompt helpful?
Example Output (illustrative)
- A table of up to 30 rows — your paid keywords ordered by share of your paid cost, each with position, volume, CPC, landing page, an exposure class and the cost-pressure figures carried over from Workflow 1
- A single line underneath giving the 75th-percentile CPC of your current portfolio
