# https://data-analytics.atlassian.net/wiki/spaces/DDPS/pages/1902116936/Ads+Data+-+Data+Spec#Ads-Ad-Set-(Google-Ad-Group)
# Test factors
# Required: startDate_endDate_userId
groupBys:        empty, groupByEqGroupByAdSet, groupByEqGroupByAgeBand, groupByEqGroupByArtist, groupByEqGroupByCampaign, groupByEqGroupByChartweek, groupByEqGroupByDate, groupByEqGroupByGender, groupByEqGroupByMonth, groupByEqGroupByObjective, groupByEqGroupByPlatform, groupByEqGroupByCategory, groupByEqGroupBySubCategory, groupByEqGroupByProject, groupByEqGroupByProvider, groupByEqGroupByRegion, groupByEqGroupByLinkUrl, groupByEqGroupByLinkType, groupByEqGroupByReferrerName, groupByEqGroupByReferrerDomain, groupByEqGroupByWeek, groupByEqGroupByPhase
artists:         empty, artistId
campaigns:       empty, campaignId, campaignIdEqCampaignIds
decibelLabels:   empty, decibelLabelId, decibelLabelIdEqDecibelLabelIds
dsps:            empty, dsp, dspEqDsps
isAssigned:      empty, isAssignedEqTrue, isAssignedEqFalse
isPending:       empty, isPendingEqTrue, isPendingEqFalse
referrerDomains: empty, referrerDomain, referrerDomainEqReferrerDomains
phases:          empty, phaseId, phaseIdEqPhaseIds
platforms:       empty, platform, platformEqPlatforms
projects:        empty, projectId, projectIdEqProjectIds
providers:       empty, providerId, providerIdEqProviderIds
subCategories:   empty, subCategoryId, subCategoryIdEqSubCategoryIds
countryCodes:    empty, countryCode, countryCodeEqCountryCodes
pagination:      empty, limitRange_cursor
limits:          empty, limit_offset
sortOrders:      empty, sortOrderEqDesc, sortOrderEqAsc
sortBys:         empty, sortByEqSortByMetricsFinance, sortByEqSortByMetricsGeneral, sortByEqSortByMetricsVideo, sortByEqSortByMetricsLinkfire, sortByEqSortByDimensionsPhase, sortByEqSortByDimensionsProject, sortByEqSortByDimensionsArtist, sortByEqSortByDimensionsCampaign

# Constraints
if [groupBys] in {"groupByEqGroupByAdSet","groupByEqGroupByAgeBand","groupByEqGroupByGender","groupByEqGroupByProvider"} then [sortBys] in {"empty","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo"};
if [groupBys] in {"groupByEqGroupByChartweek","groupByEqGroupByDate","groupByEqGroupByMonth","groupByEqGroupByObjective","groupByEqGroupByPlatform","groupByEqGroupByCategory","groupByEqGroupBySubCategory","groupByEqGroupByRegion","groupByEqGroupByWeek"} then [sortBys] in {"empty","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo","sortByEqSortByMetricsLinkfire"};
if [groupBys] in {"groupByEqGroupByLinkUrl","groupByEqGroupByLinkType","groupByEqGroupByReferrerName","groupByEqGroupByReferrerDomain"} then [sortBys] in {"empty","sortByEqSortByMetricsLinkfire"};
if [groupBys] = "groupByEqGroupByArtist" then [sortBys] in {"empty","sortByEqSortByDimensionsArtist","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo","sortByEqSortByMetricsLinkfire"};
if [groupBys] = "groupByEqGroupByCampaign" then [sortBys] in {"empty","sortByEqSortByDimensionsCampaign","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo","sortByEqSortByMetricsLinkfire"};
if [groupBys] = "groupByEqGroupByProject" then [sortBys] in {"empty","sortByEqSortByDimensionsProject","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo","sortByEqSortByMetricsLinkfire"};
if [groupBys] = "groupByEqGroupByPhase" then [sortBys] in {"empty","sortByEqSortByDimensionsPhase","sortByEqSortByMetricsFinance","sortByEqSortByMetricsGeneral","sortByEqSortByMetricsVideo","sortByEqSortByMetricsLinkfire"};
if [sortBys] <> "empty" then [sortOrders] in {"sortOrderEqDesc", "sortOrderEqAsc"};
if [countryCodes] in {"countryCode","countryCodeEqCountryCodes"} then [groupBys] in {"empty","groupByEqGroupByAdSet","groupByEqGroupByArtist","groupByEqGroupByCampaign","groupByEqGroupByChartweek","groupByEqGroupByDate","groupByEqGroupByMonth","groupByEqGroupByObjective","groupByEqGroupByPlatform","groupByEqGroupByCategory","groupByEqGroupBySubCategory","groupByEqGroupByProject","groupByEqGroupByRegion","groupByEqGroupByLinkUrl","groupByEqGroupByLinkType","groupByEqGroupByReferrerName","groupByEqGroupByReferrerDomain","groupByEqGroupByWeek","groupByEqGroupByPhase"};