| Field |
Data type |
Possible values |
Specification |
| rvu_brand |
String |
money, uswitch, bankrate |
specific values as defined |
| click_ref |
|
Supplied as utm parameter by RVU |
Supplied as utm parameter by RVU |
| click_time |
Date Time |
yyyy-mm-dd hh:mm:ss |
ISO date- UTC timezone (+0 GMT) |
| status |
String |
N/A |
|
| sales_id |
String |
N/A |
Your unique reference for each individual sale |
| transaction_time |
Date Time |
yyyy-mm-dd hh:mm:ss |
ISO date- UTC timezone (+0 GMT) |
| rvu_commission (if applicable) |
Decimal |
amount |
CPA amount agreed for each Campaign. Please do not include any £ or commas in this cell |
💡Note: depending on the product area we may request additional fields to help with our understanding of performance e.g. loan amount.
The importance of click_ref
In order to get funnel performance data for each user/lead we send via the API, we pass along a unique tracking ID (we refer to this as click_ref) in the API request. We need the funnel performance report to include our click_ref for us to be able to join the data on our end.
The report
Format: we are happy to discuss what options are easiest and can usually support any format which already exists including:
- Via an automated CSVs to an email ID
- Via a shared Google sheet
- File drops in S3 bucket
Cadence: daily (ideally before 9am)
