APIs & Integrations

bizEngineer
Member

form-integrations and analytics endpoint data do not match

I'm currently using the hubspot api to update lead information on my own crm website.

 

I use 2 different api endpoints:

1. https://api.hubapi.com/form-integrations/v1/submissions/forms to grab full form submissions.

2. https://api.hubapi.com/analytics/v2/reports/forms to quickly determine the number of form submissions for a given date.

 

However, there are certain forms that I have that when queried with 2. endpoint, the returned number of form submissions doesn't tally with the number of submissions that I get by manually counting them on the same date with 1. endpoint. 

 

Is there anyway I can get an accurate number of submissions given a specific date, without having to retrieve all the records from 1. endpoint and count them by myself?

0 Upvotes
3 Replies 3
WendyGoh
HubSpot Employee
HubSpot Employee

form-integrations and analytics endpoint data do not match

Hey @bizEngineer,

 

In order for me to further troubleshoot this, could you share with me the following:

 

1. The portal ID in question

2. An example of the inaccurate Form ID

3. The exact request url that you used for both endpoint

4. What's the specific date range that you're looking at

 

On my end, when I tried to get all form submission on the 27th May 2020 (GMT +8):

 

1. GET analytics/v2/reports/forms/total?start=1590508800000&end=1590595199000

Note that the return response for Form ID ce3xxx, returned 3 submissions

 

{
mappedBreakdown:109,
breakdown:"ce3xxx",
formViews:3,
visibles:3,
submissionsPerFormView:1,
submissions:3,
contactSubmissions:3,
interactions:3}

2. Next, I use GET form-integrations/v1/submissions/forms/ce3xxx and I'm able to see that the return response shows 3 form submissions on 27th May 2020.

0 Upvotes
bizEngineer
Member

form-integrations and analytics endpoint data do not match

Hello Wendy Goh,

 

These are the answers to the following questions:

 


1. The portal ID in question

2179333 

 

 


2. An example of the inaccurate Form ID


1cc08537-8388-4413-99cf-98b11d0573bb

 

 


3. The exact request url that you used for both endpoint


https://api.hubapi.com/form-integrations/v1/submissions/forms/1cc08537-8388-4413-99cf-98b11d0573bb?h... returns 2 submissions.

{
    "results": [
        {
            "submittedAt": 1590645981711,
            "values": [...],
            "pageUrl": "https://info.mcframe.com/053"
        },
        {
            "submittedAt": 1590643551892,
            "values": [...],
            "pageUrl": "https://info.mcframe.com/053"
        }
    ]
}


https://api.hubapi.com/analytics/v2/reports/forms/daily?hapikey=$hapikey&start=20200528&end=20200528&f=1cc08537-8388-4413-99cf-98b11d0573bb counts 1 submission.

{
    "2020-05-28": [
        {
            "breakdown": "1cc08537-8388-4413-99cf-98b11d0573bb",
            "formViews": 6,
            "submissionsPerFormView": 0.16666666666666666,
            "submissions": 1,
            "visibles": 6,
            "contactSubmissions": 1,
            "interactions": 1
        }
    ]
}

 


4. What's the specific date range that you're looking at


28th May 2020.

0 Upvotes
Willson
HubSpot Employee
HubSpot Employee

form-integrations and analytics endpoint data do not match

Hey @bizEngineer,

 

I'd be happy to jump in here! Taking a look at the submissions, the reason we're seeing this is due to one of the submissions coming from a filtered IP. This is identified by the label seen on the submission here.

This form submission came from an excluded IP address. It has been filtered from your form analytics

Form Submission data is separate to our Analytical data, therefore, we expect to see a discrepancy in the results when fetching from the Forms Submission endpoint to the Analytical endpoint.

 

To elaborate on the above, for analytical reporting purposes, any submission that comes from a Filtered IP will not be reflected in any reporting within HubSpot. You can read more about this IP Filtering here

I hope this helps!

Product Manager @ HubSpot
0 Upvotes