Discrepancy in Grand Total column total?

Geoff_Krajeski1
Level 10 - Champion Alumni

Discrepancy in Grand Total column total?

I was wondering if anyone else using RCE sees a discrepancy in the Grand Total of Unique clicks?

When I run a Subtotal formula in an excel export of my RCE Email Performance by Name report, I am getting different values.

Please see screenshot and formula.

As an FYI, I have no filters currently enabled on this spreadsheet!

Is this potentially Marketo telling me that people had unique clicks across emails?  That does not make sense to me as the Grand Total should be a sum of all clicks.

UniqueClickDiscrepancy.png

7 REPLIES 7
Kenny_Elkington
Marketo Employee

Re: Discrepancy in Grand Total column total?

Can you give a screenshot of your report in RCE?

Geoff_Krajeski1
Level 10 - Champion Alumni

Re: Discrepancy in Grand Total column total?

It's the same as the export, just with the filters exposed, but here you go.

Thanks!

pastedImage_0.png

Geoff_Krajeski1
Level 10 - Champion Alumni

Re: Discrepancy in Grand Total column total?

Kenny Elkington​,

Have you any update on this question?

Thanks,

-Geoff

Geoff_Krajeski1
Level 10 - Champion Alumni

Re: Discrepancy in Grand Total column total?

Kenny Elkington​,

Wondering if there may be any update on this?

Thanks!

Kenny_Elkington
Marketo Employee

Re: Discrepancy in Grand Total column total?

So I think what's happening here is that RCE is aware of the dataset and is aggregating based on the number of leads which have had a click, while excel isn't aware and it's just summing.  I'm not 100% on the specific behavior of that column in RCE, though.

Geoff_Krajeski1
Level 10 - Champion Alumni

Re: Discrepancy in Grand Total column total?

Kenny Elkington​,

I'd be happy to schedule some time next week to run through this with you.

Please let me know and I can provide some options so we can review!

Jim_Thao7
Level 9

Re: Discrepancy in Grand Total column total?

Could it be possible that some values changed in your spreadsheet, maybe incidentally?

The "Grand Total" when exported is no longer a formula, just a static value.  I would check to see that the actual values for the ~70 rows match up to what's in RCE in the Unique Clicks column.