Hubspot Amount Changes When Deals Are Included

Hello,


I'm trying to make sense of our Hubspot data in Supermetrics.


If I create a table using the "Amount" metric to measure the summative value quoted for clients through different channels, I get different results depending on whether or not I include deal information.


For example, if I create a table measuring:

- Dimension: Original Source

- Metric: Amount


and add a summary row, I'll see the total amount as $29.238 million.


However, if I add the "Deals" metric, that total amount in the summary row will increase to more than $40 million.


Further, adding the "Deal Name" metric changes attribution. If I create a chart with the following fields:

- First Page seen

- Amount


The data only seems to change if I use a metric. If I add "Deal Name" as a dimension, the number says the same; however, if I add count of "Deal Names" as a metric, the sum of "Amount" will change again.


Why is the sum changing, and which form of data should I trust?

Login or Signup to post a comment