List and describe Activity types and acoustic data in civi
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	• DStrine
	Mar 11 2021, 10:48 PM

Description

Please use separate sheets in this spreadsheet to list and describe the types of Activites and the data types saved from acoustic:
https://docs.google.com/spreadsheets/d/1HpkiueLo6-c9ViPpgjPXa9wpIdCpGH7HpUaLD-oGl-I/edit#gid=0

DoD:

list of data types as they would appear in Searchkit
A nontechnical description of each data type

Event Timeline

• DStrine created this task.Mar 11 2021, 10:48 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 11 2021, 10:48 PM

• DStrine moved this task from Triage to Sprint +1 on the Fundraising-Backlog board.Mar 11 2021, 10:48 PM

• DStrine moved this task from Sprint +1 to Current Sprint on the Fundraising-Backlog board.Mar 16 2021, 7:57 PM

I've just copied the list from https://civicrm.wikimedia.org/civicrm/admin/options/activity_type?reset=1 into the spreadsheet

@DStrine how does that fit with what you need?

• DStrine added a project: Fundraising Sprint File Systems Stage Show.Mar 16 2021, 8:02 PM

• DStrine triaged this task as Medium priority.Mar 16 2021, 8:06 PM

That looks really good! Thanks! Now for the acoustic data :)

This is going to be super helpful for new users of searchkit and for our data retention conversations.

@DStrine I think what you want on the silverpop side is that we pull data back & store it in 4 tables

civicm_mailing - this holds the html etc of the mailings.
civicrm_mailing_stats - this holds aggregates for the mailings (number bounced etc)
civicrm_mailing_provider_data - this is the huge table with every response to a mailing
membership in remind me later group (and contacts added to CiviCRM)

the top 3 tables are not exposed in search-kit but there are no huge obstacles to adding them. Group membership is a little bit trickier (we've discussed that being missing before ) & a bigger task to address

Also

https://www.mediawiki.org/wiki/Fundraising_tech/CiviCRM#Data_transfer_between_CiviCRM_and_Acoustic_(aka_Watson_Campaign_Automation_Silverpop,_IBM_)

Eileenmcnaughton claimed this task.Mar 22 2021, 8:00 PM

Eileenmcnaughton moved this task from Backlog to Doing on the Fundraising Sprint File Systems Stage Show board.

• DStrine added a comment.Mar 22 2021, 8:06 PM

This comment was removed by • DStrine.

• DStrine closed this task as Resolved.Mar 22 2021, 8:09 PM

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mailing_id` int(10) unsigned NOT NULL,
`mailing_name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`recipients` int(10) unsigned DEFAULT NULL,
`delivered` int(10) unsigned DEFAULT NULL,
`bounced` int(10) unsigned DEFAULT NULL,
`blocked` int(10) unsigned DEFAULT NULL,
`suppressed` int(10) unsigned DEFAULT NULL,
`abuse_complaints` int(10) unsigned DEFAULT NULL,
`opened_total` int(10) unsigned DEFAULT NULL,
`opened_unique` int(10) unsigned DEFAULT NULL,
`unsubscribed` int(10) unsigned DEFAULT NULL,
`forwarded` int(10) unsigned DEFAULT NULL,
`clicked_total` int(10) unsigned DEFAULT NULL,
`clicked_unique` int(10) unsigned DEFAULT NULL,
`trackable_urls` int(10) unsigned DEFAULT NULL,

Eileenmcnaughton moved this task from Doing to Done on the Fundraising Sprint File Systems Stage Show board.Mar 30 2021, 7:53 PM

List and describe Activity types and acoustic data in civiClosed, ResolvedPublicActions

Description

Event Timeline

List and describe Activity types and acoustic data in civi
Closed, ResolvedPublic
Actions