Author Topic: Report on who joined the site when via what profile signup page (Read 2679 times)

alfred_nutile · October 19, 2007, 04:17:53 pm

Just trying to show who clicked on the signup for email list(s)
We have a couple.
The goal would be to show total who joined in the past 30 days?
I am looking around the db now.

lcdweb · October 20, 2007, 02:04:31 pm

On signup, do you add them to a group?
You have the option of automatically adding someone to a predefined group when they create a record via profile. I don't think there's a way to trace them back unless you've done that. (But I could be wrong).

-Brian

alfred_nutile · October 20, 2007, 03:44:34 pm

Well the thing is that unless you track the group total at the start of a month, you do not know how many joined at the end of a month?
So I was just hoping and trying to make this happen via a query or two.
Even worse it is a smart group so the query is harder as I want to make it dynamic.
So I am trying to take the info from the smart queries data ie
( `civicrm_group_contact-27,29,26,28,84,79,32,83,45,58,36,40,41,43,78,82,48,50,75,44,61,62,88,60,91,25`.group_id IN (27,29,26,28,84,79,32,83,45,58,36,40,41,43,78,82,48,50,75,44,61,62,88,60,91,25) AND `civicrm_group_contact-27,29,26,28,84,79,32,83,45,58,36,40,41,43,78,82,48,50,75,44,61,62,88,60,91,25`.status IN ("Added") )
And strip it down to 27,29,26,28,84,79,32,83,45,58,36,40,41,43,78,82,48,50,75,44,61,62,88,60,91,25
so I can then make some drupal module use this to cron job a report for the above.
Then if another group is added to the smart group no one has to add it to this report as well.
Guess there is a point where I need to start looking at the Civi API.

Deepak Srivastava · October 20, 2007, 09:45:08 pm

There doesn't seem to be a straight forward sol.

This is how, my approach would be:

1) Figure out how and where to insert extra piece of code in profile.

2) Use civicrm api/History.php (or another piece of code) to insert a activity history record, say /w following info:

a. activity_type="Profile Signup: $profileName"
b. entity_table=civicrm_contact
c. entity_id = contact_id
d. activity_date = current_date (signup date)
...

3) Let profile add the new signers to a group (a smart group).

4) Write a query based on the info added in step 2 and 3, to retrieve the required info.

(Again, this is just an approach

)

alfred_nutile · October 21, 2007, 05:31:10 am

I will use this to work off of this week. I figure since these are stand alone forms that I could some how add an extra bit somewhere.
Though I look forward to not having them be the standalone vesrsion once we are using drupal all the way.
But for now if I put the code as you suggest into the form then I just need to figure out how to make the post/get happen to do my code as well as the civicrm profile code.
Or maybe make the redirect page take some extra code too?
I just need to look at the civi code for this.
Or maybe I make a drupal account at the same time to track via the drupal account and then compare the account with the group to see who signed up when for which group.
Al

Deepak Srivastava · October 21, 2007, 09:42:05 am

Also you may need not write the query, since you can use the combination of smart-group and activity-history date fields in the Advanced-Search to get the desired result. And search anyway displays the count.

Or as you said you might succeed retrieving some information from drupal-account. May be you can figure out the way to calculate the exact date from "Member For" information displayed on "Drupal>>Administer>>User Management>>Users" page (provided the information is correct).

alfred_nutile · October 21, 2007, 07:44:32 pm

Maybe that is is too, the Membership part of this. Seems like I am getting a bit hackish there since it is really not to track this, but maybe it could be?
I may try that.
Al

CiviCRM Community Forums (archive)

News:

Author Topic: Report on who joined the site when via what profile signup page (Read 2679 times)

alfred_nutile

Report on who joined the site when via what profile signup page

lcdweb

Re: Report on who joined the site when via what profile signup page

alfred_nutile

Re: Report on who joined the site when via what profile signup page

Deepak Srivastava

Re: Report on who joined the site when via what profile signup page

alfred_nutile

Re: Report on who joined the site when via what profile signup page

Deepak Srivastava

Re: Report on who joined the site when via what profile signup page

alfred_nutile

Re: Report on who joined the site when via what profile signup page