Cello Data Exports
Cello exports data on an automated basis to create your own reports or import into internal systems
Cello exports data on an automated basis to create your own reports or import into internal systems. These files can be downloaded in two ways:
- From the cello Portal by clicking Download in the upper right hand corner
- From the AWS S3 bucket
event_details_aggregates-all
The all aggregates files provides total event counts all time by product user for users who have activated (opened) Cello at least once.| Column | Details |
|---|---|
| productuserid | The user id of the referrer (provided by your product on boot) |
| R_Active | Total event count of user opening the Cello referral component |
| R_Sharing | Total event count of user clicking a share button in the referral component |
| R_Reward | Total event count of referrer being rewarded |
| NU_Views | Total event count of new user views* |
| NU_Views_Unique | Unique new user views based on anonymized browser attributes* |
| NU_Signups | Total event count of new user signups attributed to this referrer |
| NU_Purchases | Total event count of new user signups attributed to this referrer |
event_details_aggregates-daily
The all aggregates file provides total event counts aggregated by day and by product user for users who have activated (opened) Cello at least once.| Column | Details |
|---|---|
| productuserid | The user id of the referrer (provided by your product on boot) |
| R_Active | Total event count of user opening the Cello referral component |
| R_Sharing | Total event count of user clicking a share button in the referral component |
| R_Reward | Total event count of referrer being rewarded |
| NU_Views | Total event count of new user views* |
| NU_Views_Unique | Unique new user views based on anonymized browser attributes* |
| NU_Signups | Total event count of new user signups attributed to this referrer |
| NU_Purchases | Total event count of new user purchases attributed to this referrer |
conv_signups
The signup file contains all signups events based on attributed signups.| Column | Details |
|---|---|
| datetime | Timestamp of the signup, in ISO 8601 format with UTC designator |
| date | Day of the transaction, used for aggregation and trends |
| month | Month of the transaction, used for aggregation and trends |
| week | Week of the transaction, used for aggregation and trends, with Monday used as start of week |
| productuserid | The user id of the referrer (provided by your product) |
| campaign_ucc | The referral code (ucc) of the referrer used for attribution |
| newuserproductuserid | The user id of the new user that was referred (provided by your product) |
| status | Status of the signup, either Included or Excluded* |
conv_transactions
The transactions file contains all attributed transaction events with additional fields that Cello has added based on reward calculations.| Column | Details |
|---|---|
| datetime | Timestamp of the transaction, in ISO 8601 format with UTC designator |
| date | Date of the transaction, used for aggregation and trends |
| month | Month of the transaction, used for aggregation and trends |
| week | Week of the transaction, used for aggregation and trends, with Monday used as start of week |
| productuserid | The user id of the referrer (provided by your product) |
| campaign_ucc | The referral code (ucc) of the referrer used for attribution |
| newuserproductuserid | The user id of the new user that was referred (provided by your product) |
| amount | Amount of the transaction |
| currency | Currency of the transaction |
| interval | The interval of the transaction e.g. Yearly, Monthly, One Time |
| status | Status, for example whether the transaction was rewarded or invalid* |
| reward | Calculated reward amount for this transaction, based on your campaign* |
| reward_type | Type of reward for this transaction e.g. Percentage, Fixed* |
| reward_calc | Percentage or fixed amount used for rewarding, based on your campaign* |
conv_rewards
The rewards file contains all reward events for referrers based on attributed transactions.| Column | Details |
|---|---|
| datetime | Timestamp of the reward, in ISO 8601 format with UTC designator |
| date | Date of the transaction, used for aggregation and trends |
| month | Month of the transaction, used for aggregation and trends |
| week | Week of the transaction, used for aggregation and trends, with Monday used as start of week |
| productuserid | The user id of the referrer (provided by your product) |
| campaign_ucc | The referral code (ucc) of the referrer used for attribution |
| amount | Calculated amount of the reward, based on campaign rules* |
| currency | Original currency of the reward |
| interval | Interval of the reward e.g. monthly, one_time |
| invoice_status | Whether on not these rewards were excluded from invoices* |
| amount_referrer | Calculated amount for the referrer based in the referrer currency |
| currency_referrer | Currency of the referrer reward |
| xrate_referrer | Exchange rate used for conversion of referrer reward |
| amount_target | Reward in target currency, used for invoicing depending on customer setup |
| xrate_target | Exchange rate used to calculate target currency |
| amount_eur | Reward in EUR, used for invoicing depending on customer setup |
| xrate_eur | Exchange rate used to calculate EUR currency |
ignore_list
The ignore list file lists all of the specific users who are ignored. Cello, by default, ignores internal users of your company and Cello test events across all exports and dashboards in the portal. This behavior can be configured on demand.| Column | Details |
|---|---|
| productuserid | The user id of the ignored user (provided by your product) |
| ignore | Flag, usually 1 to indicate this user is ignored |