Tracking Code & UTM Summary

[VincentTh3]

Hello,
is there a quick way to export for a given Virtual Report Suite ALL of the existing Tracking Codes and UTMs info such as:

- Tracking Code
- utm-source

- utm-medium

- utm-campaign

- utm-content 

i'm interested to have this info in a nice table.
this would help a lot checking the existing UTMs and there various attributions for every single campaign

best,
Vincent

[bjoern__koth]

Hi @VincentTh3 

since you are talking about dimensions, meaning string values, for each of the above, you will have to specify a little what you envision ending up with.

In general, yes, you can have them exported separately with a couple of clicks by right-clicking on your table and selecting "Download items as csv", which will include up to 50.000 lines of values for that specific dimension.

You will likely have to create individual tables per dimension though.

[VincentTh3]

Hello Bjoern,

Thanks for your answer!

I would look for something like this: 

basically one line per Tracking code, summarizing the various utm components.

Greetings from Lausanne
Vincent

[Jennifer_Dungan]

Workspaces (at least in Adobe Analytics... CJA is a different story) don't support "Flat Tables".

However, you could create a Data Warehouse export that looks like your sample.

If you are using Tracking Code (keep in mind this has a 1 week attribution by default), you can create classification rules to extract each UTM into it's own classification, then you can use those classifications as columns.

So if your Tracking Code looks like "AB1|BC1|CD1|DE1", as long as you don't have column shifting like "AB1|CD1|DE1" where a missing "BC1" value would cause CD1 and DE1 to shift, simple Regex rules in classification builder can be used to parse out each value.

You would have to create classifications on your Tracking Code (or "Campaign"):

In your Classification Rule Builder, you would then set each position to the correct classification:

Then you can use these classification as part of your Workspaces or Data Warehouse exports (but again, if you need flat table, Data Warehouse is the way to go)

[VincentTh3]

Thank you Jennifer for the insights.

The real business challenge is like this: we have +30 websites and +30 VRS where we have UTMs

What is the best way to summarize the UTMs and Tracking Code in this context?

Also, regarding Regex, the issue is that we don't have all the time all of the elements. Indeed With +30 websites and many people involved in UTMs creation, we can't have 100% clean UTMs.
"So if your Tracking Code looks like "AB1|BC1|CD1|DE1", as long as you don't have column shifting like "AB1|CD1|DE1" where a missing "BC1" value would cause CD1 and DE1 to shift, simple Regex rules in classification builder can be used to parse out each value."

What would be your practical guidance there, to make sure we can seamlessly consolidate all UTMs info by tracking code across all websites?