Collect MI using Zapier
- or -
Post a project like this$$
- Posted:
- Proposals: 1
- Remote
- #1461557
- Expired
Description
Experience Level: Intermediate
Analysis tool: Excel
Description of analysis: I'm running a regular newsletter to around 4,000 respondents using Active Campaign.
I need to record certain MI using Zapier to a Google Spreadsheet. Each week it records who clicked on which stories and who their account manager is.
I would like an easy way for this spreadsheet to be able to tell me
1. For each account manager, who read what stories for a specific period
2. For each individual, what stories they read for a specific period
I expect it to involve a pivot table of some kind. It needs to be easy for a non-technical admin person to use. Or recommendations of a different way to achieve this. For data protection purposes, I need someone inside the EU, ideally the UK.
Extra notes:
Description of analysis: I'm running a regular newsletter to around 4,000 respondents using Active Campaign.
I need to record certain MI using Zapier to a Google Spreadsheet. Each week it records who clicked on which stories and who their account manager is.
I would like an easy way for this spreadsheet to be able to tell me
1. For each account manager, who read what stories for a specific period
2. For each individual, what stories they read for a specific period
I expect it to involve a pivot table of some kind. It needs to be easy for a non-technical admin person to use. Or recommendations of a different way to achieve this. For data protection purposes, I need someone inside the EU, ideally the UK.
Extra notes:
Simon R.
100% (60)Projects Completed
97
Freelancers worked with
64
Projects awarded
35%
Last project
19 May 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies