Products sales analysis

Options
Alexis Muntaner
Alexis Muntaner Member Posts: 3
Name Dropper First Comment Photogenic First Anniversary

Hi there,

After talking to your help team, it appears that there is no possibility to export products sales in an Excel document to analyse it.

Indeed, we are using Pipedrive to realise quotes and sales, we have more than 600 products and no possibility to analyse products sales quantity over time...

Could you imagine a possibility for exporting sales of every products so that we could analyse it by date, quantity, margin...?

Sincerely,

Alexis

2
2 votes

Active · Last Updated

Comments

  • Amit Sarda (AmitSarda.xyz)
    Options

    Try using Coupler or Flatly.

  • Alexis Muntaner
    Alexis Muntaner Member Posts: 3
    Name Dropper First Comment Photogenic First Anniversary
    Options

    Thanks for your answer, will try!

  • Mathias Brask
    Mathias Brask Member Posts: 51
    Photogenic 5 Likes Name Dropper First Comment
    Options

    Actually it seems like the product part of Pipedrive could need some assistance in general.

    For example it is possible inside a deal to link to products, and also on visiting a product, seing who "bought it", but when going to company-overview, it is not possible to see which products they bought. :/


    Seems like a odd limitation. Also we tried fixing this problem by creating a custom field "relational" so each product could be linked with an organization. That solves the problem half, since we can now filter the products down, but still not see them from an organizational view.

    @Mike van der Valk any input on this?

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,072 PIPEDRIVE TEAM
    First Anniversary 5 Likes 5 LOLs First Answer
    Options

    Hi @Mathias Brask

    Thanks for sharing. We're currently putting a team in 2023 to take on Products and make huge improvements there. I'll pass on this thread to the team working on it to take into account while prioritising the improvements.

    Thanks for the tag!

  • Alexis Muntaner
    Alexis Muntaner Member Posts: 3
    Name Dropper First Comment Photogenic First Anniversary
    Options

    Hi @Mike van der Valk,

    That is a really great news! Could you please let us know when this will be available?

    Do you think the team will improve products sales analysis? It would be really really great if Pipedrive would let the possibility of export in Excel (or other) all the products sales (and not only deals) during a period and which make appears quantity, price, margin... so we can really analyse sales during this period and compare it to an other period!

    Thank you very much and have a great day!

  • Amit Sarda (AmitSarda.xyz)
    Amit Sarda (AmitSarda.xyz) Member Posts: 1,565
    5 Likes First Anniversary First Answer 5 Up Votes
    edited November 2022 #7
    Options

    @Alexis Muntaner

    If you'd like this today, Flatly and Coupler (maybe) will allow you to export this data.

  • Jess Stacey
    Jess Stacey Pipedrive Team Posts: 38 PIPEDRIVE TEAM
    5 Likes First Anniversary Name Dropper First Comment
    Options

    Hi @Mathias Brask and @Alexis Muntaner,

    Thanks for your feedback, it's been added to our Products research so we can prioritise these improvements in future. As Mike mentioned we are investing to improve Products in 2023 and are currently working to prioritise the feature enhancements. If you'd like to give more feedback in a customer interview please let me know and I'll set up a quick call 🙂

    Cheers,

    Jess

  • Anna_Gogol
    Anna_Gogol Member Posts: 11
    First Comment Name Dropper Photogenic
    Options

    Even though Coupler.io has already been mentioned here, I'd like to add more value.

    With Coupler.io you can extract the following data from Pipedrive:

    • Deals;
    • Persons;
    • Organizations;
    • Activities;
    • Files;
    • Leads;
    • Call logs;
    • Products

    to Excel, Google Sheets and BigQuery automatically on a desired schedule.

    To learn more details, please follow Pipedrive to Excel integration link.

    Also Coupler.io offers a free 14-Days test-drive to try the tool out and to check if it fits your needs.

  • Alfa Pack Ukraine
    Options


    @Mike van der Valk It’s 2024, and there are still no filters for the product; there is no way to analyze them - which product was sold most often, which was the most expensive product for the period, etc.

  • Mike van der Valk
    Mike van der Valk Pipedrive Team Posts: 3,072 PIPEDRIVE TEAM
    First Anniversary 5 Likes 5 LOLs First Answer
    Options

    Hi @Alfa Pack Ukraine we actually have filters, view by and measure by options already inside different deal reports in our Insights reporting area.

    Some examples were they are currently already live:

    • deals report has the possibility to filter by product;
    • view by has the opportunity to view by product;
    • measure by has the opportunity to measure by product value;

    Next to that we're exploring some potential updates of product reporting at the moment but it hasn't made it officially on the roadmap yet. Hope this helps 🙏🏻