Welcome to the community, @Susan_Stegemann! :grinning_face_with_big_eyes: I haven’t used Google Analytics before, so could you describe the data format that GA provides? Is it a simple CSV file, or something else? Or are you hoping to do the matching on the back end using tools like Zapier or Integromat? Also, is your editorial calendar in a free Airtable workspace, or in a Pro (or higher) workspace?
Welcome to the community, @Susan_Stegemann! :grinning_face_with_big_eyes: I haven’t used Google Analytics before, so could you describe the data format that GA provides? Is it a simple CSV file, or something else? Or are you hoping to do the matching on the back end using tools like Zapier or Integromat? Also, is your editorial calendar in a free Airtable workspace, or in a Pro (or higher) workspace?
It’s a simple csv. GA reports the data through relative URLs, but my editorial calendar has full URLs. I need to bulk edit one or the other to match them up.
Hi @Susan_Stegemann - you can create a new formula field in your GA table with formula:
https://www.oursite.com/ & {Path}
This should then match with your content table.
You might also what to create a link field between the two tables and copy and paste the formula value into this, which will then link the GA data to the content records for lookups, rollups etc.