Below are the fields ChannelMix considers standard for the v_google_trends_keyword_country dataset. There is a 1 day lag and data is pulled every day for the previous day.
This dataset uses the "Interest by region" data that you see in Google Trends (see screenshot below).
Note: This dataset is not activatable since a Platform Support team member needs to configure the call with the keywords that are needed. Please provide the keywords that you would like to use in the ticket that you send through the Help Center.
|Report Date||Date||The date of the activity.|
|Geo||Dimension||The geographical filter. Defaults to "WORLD" for the keyword by country dataset.|
|Granularity||Dimension||One of COUNTRY, CITY, or DMA depending on the dataset configuration.|
|Geo Name||Dimension||The name of the targeted geographical area.|
|Keyword||Dimension||Search Term / Topic.|
|Rank||Dimension||The interest of the topic.|
|Report Start Date||Dimension||The start date of the data that was pulled.|
|Report End Date||Dimension||The end date of the data that was pulled.|
|Insert Date||Dimension||Internal use: when the row was inserted in the dataset.|
|ChannelMix Profile||Dimension||When needed, distinguishes between accounts - Contents defined by Alight.|