Library › Data AI › Marketing and content

Fill in a funnel table with step conversion

  • For Marketing and content
  • You practice Asking for a format you can use
  • Time about 5 minutes
  • Level Beginner

About this exercise

Your marketing director wants the signup funnel in one table. Write a markdown table with columns Step, Users, % of previous step and % of visits, one row per funnel step after Visits, then one last line 'Weakest step: ...' naming the step with the lowest % of previous step. Percent of previous step means this step divided by the step above it, and percent of visits means this step divided by the 12,000 visits, with one decimal only where needed like 7.5%. Under 75 words. Use the corrected Account created number.

Common mistakes when you ask AI for this

  • Using the stale number. The AI uses 1,500 because it appears first in the list. Try: Add: "Account created is 1,200, the corrected number."
  • Mixing up the two percents. The AI divides every step by visits or by the start only. Try: Add: "% of previous step = users / the row above; % of visits = users / 12,000."
  • Picking the biggest raw drop. The AI names the step where the most people were lost, not the lowest rate. Try: Add: "Weakest step = the lowest % of previous step."
  • Leaving the format to chance. The AI picks its own length and layout unless told the exact shape. Try: Add: "Plain text, no bold or headings."
  • Trusting the AI to count words. AI is bad at counting. Ask for a total word limit and it often lands over it. Try: Cap each part instead, for example "each line under 15 words."

What a strong prompt includes

  • Names the columns
  • Uses the correction
  • Defines each percent
  • Asks for the weakest step
  • Cuts the chatter

Practice this now ↑

Related exercises