Report business and products.

Marcelo Furlan

I need a report where the business comes out and the products related to that business. In the company in which I work we have different commission percentage per product and to calculate the commission I need to report all the businesses and the products of each business. Today it only has the business and the total of products. Does anyone have this problem? Any suggestions?

Leonardo Zimmermann

Hey, @Marcelo Furlan!

The easiest way to have that information is by pulling out reports for each product individually, right here:

You will be able to see to which deals each product is associated with and, if this makes your operation easier in case one deal has more than one product associated with it, you can cross data in one single spreadsheet once those individual reports are exported.

I hope this helps.

Emre Güneş

@Leonardo Zimmermann it might be usefull, when you have few products.

But I have a client with 100's of products.

How to get this for them?

From Parner meetings, I know "Products" are being worked right now. But can you check if Reporting is part of this improvements?

Thank you.

Antoine Bertheas

Hi,

I see that Emre didn't get an answer. I have exactly the same need, and I'm sure I'm not alone ;-)

I'm not going to do 50 exports every month to analyze my sales by product.

And in any case, the value of the product line is not included in the report: only the overall value of the business.

It's a basic CRM function, otherwise what's the point of entering a list of products?

Kind regards,

Antoine

BeccaT

Agree - we would love to be able to run a report which lists the value of the product added (by deal) and the date it was added

Amit Sarda (AmitSarda.xyz)

Coupler will help you export the data from Pipedrive to Google Sheets and Tableau or Looker Studio will help you build the reports you want.

I wrote an article covering this topic:

https://www.amitsarda.xyz/post/export-pipedrive-data-to-google-sheets