{"id":770,"date":"2024-10-16T15:04:29","date_gmt":"2024-10-16T13:04:29","guid":{"rendered":"https:\/\/www.lemlist.com\/academy\/?p=770"},"modified":"2024-10-16T15:04:43","modified_gmt":"2024-10-16T13:04:43","slug":"use-lemlist-api-for-reporting","status":"publish","type":"post","link":"https:\/\/academy.lemlist.com\/academy\/api\/api-use-cases\/use-lemlist-api-for-reporting\/","title":{"rendered":"Use lemlist API for reporting"},"content":{"rendered":"\n

Use lemlist API for reporting<\/h2>\n\n\n\n

Many companies have their own reporting system.<\/p>\n\n\n\n

Some use BI tools to visualize everything in one place, while others prefer to centralize data in Google Sheets.<\/p>\n\n\n\n

Agencies we work with often send automated campaign reports directly via email.<\/p>\n\n\n\n

If you want to use the lemlist API<\/strong> for reporting, there are two main ways:<\/p>\n\n\n\n

1<\/span>
Get campaign stats programmatically<\/strong><\/div><\/div>\n\n\n\n
2<\/span>
Use the activity webhook to store data in your database<\/strong><\/div><\/div>\n\n\n\n

This helps you build scalable reports and track important metrics like:<\/p>\n\n\n\n

    \n
  • Campaign performance:<\/strong>\n
      \n
    • Emails sent<\/li>\n\n\n\n
    • Open rates<\/li>\n\n\n\n
    • Reply rates<\/li>\n\n\n\n
    • Bounce rates<\/li>\n\n\n\n
    • Breakdowns by users, teams, or sending domain<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
        \n
      • Sender disconnection:\n
          \n
        • Disconnections by email<\/li>\n\n\n\n
        • Disconnections by domain<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n

          Monitoring sender disconnections is crucial because it usually happens when inboxes are marked as spam. If you notice many disconnections in a short time, it’s a good idea to rest the domain.<\/p>\n\n\n\n

          Example: How GetScalability uses lemlist API<\/h2>\n\n\n\n

          Victor Alexandrian’s team at GetScalability, an agency with over 30 active clients, uses Metabase to visualize their cold outreach activities. Centralizing data in one place helps them:<\/p>\n\n\n\n

            \n
          • See which leads need enrichment<\/li>\n\n\n\n
          • Identify top-performing campaigns<\/li>\n\n\n\n
          • Build dashboards and analytics for clients<\/li>\n<\/ul>\n\n\n\n
            \"\"\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n

            Here\u2019s how they do it:<\/p>\n\n\n\n

            1<\/span>
            They use the lemlist API webhook<\/strong> to receive real-time activity updates.<\/div><\/div>\n\n\n\n
            2<\/span>
            Data is collected using Stitch.<\/strong><\/div><\/div>\n\n\n\n
            3<\/span>
            The data is stored in Snowflake.<\/strong><\/div><\/div>\n\n\n\n
            4<\/span>
            Everything is visualized in Metabase.<\/strong><\/div><\/div>\n\n\n\n

            This process allows them to share real-time views and reports with clients, improving transparency and efficiency.<\/p>\n","protected":false},"excerpt":{"rendered":"

            Use lemlist API for reporting Many companies have their own reporting system. Some use BI tools to visualize everything in one place, while others prefer to centralize data in Google Sheets. Agencies we work with often send automated campaign reports directly via email. If you want to use the lemlist API for reporting, there are […]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[59],"tags":[],"class_list":["post-770","post","type-post","status-publish","format-standard","hentry","category-api-use-cases"],"acf":[],"_links":{"self":[{"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/posts\/770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/comments?post=770"}],"version-history":[{"count":1,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/posts\/770\/revisions"}],"predecessor-version":[{"id":772,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/posts\/770\/revisions\/772"}],"wp:attachment":[{"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/media?parent=770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/categories?post=770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/academy.lemlist.com\/academy\/wp-json\/wp\/v2\/tags?post=770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}