Setup CPA capture so advertisers can track customer acquisition costs

[hopsoft]

Feature Request

What problem does this solve

Several advertisers have requested pixel support to track customer acquisition against their ad spend. Of note is the requirement to support various stages of acquisition. For example,

1. Created Account
2. Performed a customer action
3. Performed another customer action

Describe the solution you'd like

An API and/or a pixel that that advertisers can use in their products to notify CodeFund of customer activity. Note that this will maintain our focus on privacy and will not include any user PII .

This will likely warrant new database table similar to the following structure.

acquisitions
- impression_id
- property_id
- campaign_id
- creative_id
- template
- theme
- country_code
- acquisition_stage (free form text value defined by the advertiser)
- counter (to track how many times the pixel was fired)
- created_at
- updated_at

Note that this is simply a brainstorm, the actual implementation is at liberty to change this recommendation as needed.

Reporting

Acquisition data needs to be added to various reports both in Metabase and in the UI. The ideal solution should not require changes to the impressions or daily_summaries tables.

Spend	Impressions	Clicks	Acquisitions 1	Acquisitions 2	Acquisitions 3
1,000	10,000,000	30,000	1000	500	100