Calculating cpl when there’s no conversions (for a pivot table)

Forum White Hat SEO PPC Calculating cpl when there’s no conversions (for a pivot table)

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #26635
    seohelper
    Keymaster

    Hey guys!

    ​

    Iv’e got a database in which some enteries have 0 conversions but let’s say 58 clicks.

    How doi I caluclate the CPL?
    I can’t put it as 0 – which means free leads (omg!)

    I thought about using =IFERROR((G4/F4),” “) , which will leave cpl as blank,

    Which doesn’t tell the whole story – we paid X money for 0 leads. Fail.

    I need those caluclations for a pivot table, for example – showing the average cpl per day of the week.

    Leaving it as blank won’t tell the whole story.

    ​

    What would you do?

    Thanks so much!

    #26636
    Marvel_plant

    Just put cost per lead as 1 billion dollars.

    Kidding aside, I don’t think there’s any real answer. Even when Google has a cost per conversion that’s undefined, it says “0,” so that when you aggregate all of the campaigns, your total cost per conversion is still accurate. Can you use “null” in place of 0?

    #26637
    ColinG86

    0 or ∞

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.
Scroll to Top