Reporting & Analytics

AlbinP
Participant

Report include dates that are NOT in the date range

SOLVE

Hi community 🙂

 

I am looking to create a report that is plotting the people who became Subscriber, per week.

 

I created a report from a template, then set the following:

  1. Date property = "Became a subscriber date"
  2. Date range = "Custom date range > 2022-01-01 to 2022-12-31"
  3. Frequency = "Weekly"

However, the results are showing me contacts who became subscribers on 2020-11-02 (clearly out of the date range).

 

You can see the attached screenshots to see what I have so far.

 

Do you know what's going on? Did I do something wrong here?

 

Thank you in advance for your help 🙂

 

Screen Shot 2022-08-11 at 12.33.32 PM.png

0 Upvotes
2 Accepted solutions
Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Report include dates that are NOT in the date range

SOLVE

Hi @AlbinP 

 

You are plotting the data based on Contact Create Date rather than Became a Subscriber Date.

 

Hope this helps?

Phil Vallender | HubSpot Website Agency

View solution in original post

Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Report include dates that are NOT in the date range

SOLVE

Hi @AlbinP 

 

Correct, in your screenshot, Became a subscriber date is being used to filter the contacts that appear in the report. 


However, you also need to add Became a subscriber date to the data as a Selected property in Properties, then use this as the main value in the visualisation. 


Hope that helps?

Phil Vallender | HubSpot Website Agency

View solution in original post

4 Replies 4
Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Report include dates that are NOT in the date range

SOLVE

Hi @AlbinP 

 

You are plotting the data based on Contact Create Date rather than Became a Subscriber Date.

 

Hope this helps?

Phil Vallender | HubSpot Website Agency
AlbinP
Participant

Report include dates that are NOT in the date range

SOLVE

Hi Phil,

Thank you for your answer 🙂

 

So from what I understand, the graph is on the "Contact Create Date" no matter the value I am setting in the "Date property", right?

 

The "Date property" is just for filtering, and in no case being used for plotting?

0 Upvotes
Phil_Vallender
Solution
Most Valuable Member | Diamond Partner
Most Valuable Member | Diamond Partner

Report include dates that are NOT in the date range

SOLVE

Hi @AlbinP 

 

Correct, in your screenshot, Became a subscriber date is being used to filter the contacts that appear in the report. 


However, you also need to add Became a subscriber date to the data as a Selected property in Properties, then use this as the main value in the visualisation. 


Hope that helps?

Phil Vallender | HubSpot Website Agency
AlbinP
Participant

Report include dates that are NOT in the date range

SOLVE

Hi @Phil_Vallender 

That's perfectly clear! Thank you for your help on that 🙂

Cheers!