Hello gurus!
I'm trying to build out some offline lead attribution modeling, and I'd like to feed it with a succinct report containing underlying data for Transactions. But the catch is, I really only want the single most relevant Transaction per deal related to the sales workflow, regardless of what Type it is.
That is, when I view results of a custom Transaction search, and I limit the Type to Opportunities, Quotes, and Sales Orders, I get every row related to the progression of a final order. Very specifically, for example, I'll get one row for the Quote and another row for the Sales Order - same 'Amount' on both. Obviously, the Quote becomes irrelevant once there's a corresponding Sales Order. I think..
Throw in Opportunities, and it makes matters worse. Lots of potential for double-counting.
I assume I don't want to focus solely on Sales Orders, since there may be several items at the Estimate stage. And I don't even yet fully understand Opportunities that do (or don't) have Estimates/Sales Orders attached to them.
I'd like a better understanding of the relationship between these Transaction Types, in the context of the entire sales workflow. As in, how the IDs are linked together - that kind of relational info. But that's secondary to simply getting some examples of how you guys are setting up your reports/searches for data export when you just want the underlying data of the one relevant Transaction per potential sale.
The information I find about all this online is way too high-level; it doesn't seem to go into the inter-relations, IDs, etc. Can ya help out? :D