# Wher can I access a database table for Campaign Stats

**URL:** <https://integration.keap.com/t/wher-can-i-access-a-database-table-for-campaign-stats/36092>\
**Category:** API Q&A\
**Created:** [April 4, 2018, 7:17pm UTC](https://integration.keap.com/t/wher-can-i-access-a-database-table-for-campaign-stats/36092 "2018-04-04T19:17:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rob\_Provenzano](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@Rob\_Provenzano](https://integration.keap.com/u/Rob_Provenzano)\
**Post date:** [April 4, 2018, 7:17pm UTC](https://integration.keap.com/t/wher-can-i-access-a-database-table-for-campaign-stats/36092/1 "2018-04-04T19:17:25Z")

</div>

We are using Clicdata to aggregate abd report variuos company KPI’s. I need to bele to acess campaign stats from Infusionsoft, but am not sure which table they are stored in. Is there a description of database shcema anywhere to help with this?

---

<div class="post-metadata">

**Author:** ![TomScott](https://sea1.discourse-cdn.com/flex019/user_avatar/integration.keap.com/tomscott/32/67_2.png) [@TomScott](https://integration.keap.com/u/TomScott)\
**Post date:** [April 5, 2018, 4:54pm UTC](https://integration.keap.com/t/wher-can-i-access-a-database-table-for-campaign-stats/36092/2 "2018-04-05T16:54:58Z")

</div>

What kind of statistics are you looking for?

The REST API has basic information about Campaigns, including the number of active Contacts in them:  
[https://developer.infusionsoft.com/docs/rest/#!/Campaign/getCampaignUsingGET](https://developer.infusionsoft.com/docs/rest/#!/Campaign/getCampaignUsingGET)

The XML-RPC API has more historical data that we haven’t made available in the REST API yet, and you can also create reports and run them to generate resultsets:  
[https://developer.infusionsoft.com/docs/xml-rpc/#search](https://developer.infusionsoft.com/docs/xml-rpc/#search)

---

<div class="post-metadata">

**Author:** ![Rob\_Provenzano](https://avatars.discourse-cdn.com/v4/letter/r/4da419/32.png) [@Rob\_Provenzano](https://integration.keap.com/u/Rob_Provenzano)\
**Post date:** [April 5, 2018, 5:36pm UTC](https://integration.keap.com/t/wher-can-i-access-a-database-table-for-campaign-stats/36092/3 "2018-04-05T17:36:24Z")

</div>

Hi Ton, I just need the emails sent, open rates, and click rates from a specific campaign. The same thing you report inside of an Infusionsoft campaign, I just need it in an external dashboard so a broader group can see the results.

For instance, this is number of appointments booked based on a tag being applied, pulled right from Infusionsoft :

 ![](https://us1.discourse-cdn.com/flex019/uploads/infusionsoft1/original/2X/6/6a3c352176e273f15893fdb7b26830d5c084c9f0.jpg)