Funnel keys on date
Most of the data in Funnel uses date as the primary key of the dataset. This means that each piece of information in the dataset is uniquely identified and organized based on the date it corresponds to. For more detailed information, refer to the following article: How Funnel treats dates.
Data that uses date as the primary key
Using the date as the main way to organize marketing data is usually the best choice. That is because most marketing activities, like ads or sales, happen on particular dates. So, using dates helps keep everything organized and easy to understand.
Date | Campaign Name | Campaign ID | Clicks | Impressions |
2024-01-21 | Sparkle and Shine Summer Sale | 1002150 | 4856 | 38645 |
2024-01-21 | FreshStart Fitness Challenge | 1005632 | 9587 | 65842 |
2024-01-22 | Sparkle and Shine Summer Sale | 1002150 | 3421 | 25846 |
2024-01-22 | Cozy Comfort Winter Warm-Up | 1003695 | 10512 | 78596 |
2024-01-23 | FreshStart Fitness Challenge | 1005632 | 9987 | 72548 |
Overwriting data that uses date as the primary key
When you are updating data where the date is the main way to identify it, you only have to send the data for the specific dates you want to change. For instance, if by the end of 2024-01-23, you had 10212 clicks and 77879 impressions, you just need to send data for that date. You do not need to send anything for 2024-01-21 or 2024-01-22.
Date | Campaign Name | Campaign ID | Clicks | Impressions |
2024-01-23 | FreshStart Fitness Challenge | 1005632 | 10212 | 77879 |
Data that does not use date as the primary key
There are specific situations where using the date as the primary key is not practical. This is particularly true for reference tables or datasets that do not rely on time-based information. For example, it is not ideal to use dates as primary keys for datasets containing lifetime data, keyword lists, statuses, or product features and attributes.
Keyword ID | Keyword Name | Search Volume | Competition Level |
12563 | Marketing | 10000 | High |
25634 | SEO | 8500 | Medium |
48593 | Social Media | 9200 | High |
32561 | Content | 7800 | Medium |
84576 | Advertising | 8800 | High |
Overwriting data that does not use date as the primary key
When updating data where the date is not the main way to identify it, you have to include all the data each time you make a change. For example, if you add a new keyword, you must resend the entire dataset, including the new keyword, rather than just sending the new addition.
Keyword ID | Keyword Name | Search Volume | Competition Level |
12563 | Marketing | 10000 | High |
25634 | SEO | 8500 | Medium |
48593 | Social Media | 9200 | High |
32561 | Content | 7800 | Medium |
84576 | Advertising | 8800 | High |
97548 | Conversion Optimization | 5400 | Low |
Mapping data that does not use date as a primary key to data that does use date as a primary key
The information stored in the lookup table or dateless dataset likely needs to be connected or associated with a dataset in Funnel where dates are the main identifiers. For more information on how to accomplish this, see the following article: How to use lookup tables when creating custom fields.
Viewing dateless data in Funnel
Because the data is not linked to a particular date, the selected date range in the Data Explorer does not affect what you see. Regardless of the date range chosen, you will see the entire dataset. To verify when the dataset was last updated, look at the LAST IMPORTED column within the Data Sources tab of your Funnel workspace. There will not be any IMPORT START DATE or IMPORT END DATE columns, even if dates are included in the dataset, because no specific dates are used for indexing.
How to request dateless data in Funnel
For a dateless dataset in Funnel, submit a data request. Make sure to specify in the request that the dataset should be without dates.