search

RJMetrics / magenerator

Generate sample Magento store data
Open Software License 3.0
3 stars 1 forks source link

Add AdWords table #26

Open alexkleger opened 7 years ago

alexkleger commented 7 years ago

An AdWords integration, in combination with the ecommerce data, allows us to view ROI by campaign. This table should have the following fields:

created_at: random date campaign: campaign name - ideally the same source used to generate campaign names from the ecommerce data impressions: random number clicks: random number, never larger than impressions spend: random currency value

example data:

| created_at          | campaign          | impressions | clicks | spend |
|---------------------|-------------------|-------------|--------|-------|
| 2016-06-08 00:00:00 | Shopping Campaign | 10879       | 149    | 58.61 |
| 2016-09-28 00:00:00 | BOGO              | 8304        | 58     | 32.29 |
| 2016-10-02 00:00:0  | Cyber Monday      | 1922        | 211    | 50.58 |
| 2014-01-18 00:00:00 | Aloha Shirts      | 1697        | 30     | 21.45 |
| 2016-10-28 00:00:00 | March Madness     | 1602        | 42     | 31.64 |
alexkleger commented 7 years ago

https://github.com/RJMetrics/magenerator/issues/25 <-- for linking the campaigns together