{"section":"tutorials","requestedLocale":"en","requestedSlug":"gift-card-data-pipeline","locale":"en","slug":"gift-card-data-pipeline","path":"docs/en/tutorials/beta/vtex-data-pipeline-beta/gift-card-data-pipeline.md","branch":"main","content":"The `gift cards` dataset includes historical information on gift cards that have been created or modified. This dataset only provides information on gift cards created natively within VTEX, using the [Giftcard API](https://developers.vtex.com/docs/api-reference/giftcard-api).\n\n> ⚠️ Gift cards created through customized or external apps will not appear in this data model.\n\nThis section includes the following information:\n\n- [Gift card data characteristics](#gift-card-data-characteristics)  \n- [Table gift_cards_events_raw](#table-gift-cards-events-raw)  \n- [Analyses with gift cards](#analyses-with-gift-cards)  \n- [Correlations with other data](#correlations-with-other-data)  \n\n## Data Characteristics\n\n| **Characteristic** | **Description** |\n|:---:|:---:|\n| **Data source** | Obtained from information in the [Audit](/en/docs/tutorials/audit). |\n| **Availability** | VTEX Admin. |\n| **History** | Data is maintained for two years, starting in 2024 for customers already using the VTEX platform. |\n| **Minimum update interval** | One hour. |\n\n## Table: gift_cards_events_raw\n\nBelow are the fields that constitute the table:  \n\n| **Column Name** | **Column Type** | **Column Description** |\n|:---:|:---:|:---:|\n| account_name | character varying(255) | Name of the account related to the gift card operation. |\n| event_date | timestamp with time zone | Date and time of the given operation. |\n| operation | character varying(200) | Type of operation. |\n| subject_id | character varying(200) | Subtype of operation. |\n| author_id | character varying(1000) | Author of the operation. |\n| giftcardid | character varying(5000) | Id of the gift card used on the operation. Only available for operations `CREATE_GIFT_CARD` or `EDIT_GIFT_CARD`. |\n| giftcardvalue | character varying(5000) | Value of the gift card used on the operation. Only available for operations `CREATE_GIFT_CARD` or `EDIT_GIFT_CARD`. |\n| edit_initial_value | character varying(5000) | Initial value of the gift card, before the edit operation. Only available for operation `EDIT_GIFT_CARD`. |\n| edit_final_value | character varying(5000)\t | Final value of the gift card, after the edit operation. Only available for operation `EDIT_GIFT_CARD`. |\n| batch_id | character varying(100) | Identifier used when data is loaded into the table for quality control of data ingestion. |\n\n## Analyses with Gift Cards\n\nHere are some analyses you can perform with the gift cards table:  \n\n- **List of Created Gift Cards:** review the current list of created gift cards.  \n- **Audit Gift Card Information:** examine activities related to your gift cards, including identifying who created a specific gift card and viewing the edit history of a gift card.  \n\n## Correlations with Other Data\n\nGift card data is related to order data, providing a comprehensive analysis of purchases and sales. Here are some examples:  \n\n- **Most Used Gift Cards:** Combining this data model with [order](/en/docs/tutorials/prices-data-pipeline-beta) data, you can understand how gift cards are being utilized and monitor their usage.  \n- **Impact on Sales:** Similarly, combining with [order](/en/docs/tutorials/prices-data-pipeline-beta) data allows you to assess how gift cards influence sales.  \n\n### Discover other Datasets\n\n- [Catalog](/en/docs/tutorials/catalog-data-pipeline)\n- [Inventory](/en/docs/tutorials/inventory-data-pipeline-beta)\n- [Navigation](/en/docs/tutorials/navigation-data-pipeline)\n- [Payments](/en/docs/tutorials/payments)\n- [Orders](/en/docs/tutorials/orders-data-pipeline-beta)\n- [Promotions](/en/docs/tutorials/promotions)\n- [Bridge logs](/en/docs/tutorials/bridge-logs-data-pipeline)"}